using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class EditData : System.Web.UI.Page
{
    connection objconn = new connection();
    OleDbConnection conn;
    string userid;
    protected void Page_Load(object sender, EventArgs e)
    {
      conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Domains\nid.edu\db\database.mdb;Persist Security Info=True");        
       // conn=objconn.getconn();
        if (Session["Userid"] == "" || Session["Userid"]==null)
        {
            Response.Redirect("index.aspx");
        }
        if (!IsPostBack)
        {
            filldata();
        }
       

    }
    protected void filldata()
    {
        userid=Session["Userid"].ToString();
        conn.Open();
        OleDbCommand cmd = new OleDbCommand("select * from MemberMaster where userid='" + userid + "'", conn);
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        dap.Fill(dt);
        lblYearOfGraduation.Text = dt.Rows[0].ItemArray[0].ToString();       
        lblDiscipline.Text = dt.Rows[0].ItemArray[2].ToString();
        txtLastName.Text = dt.Rows[0].ItemArray[3].ToString();
        txtFirstName.Text = dt.Rows[0].ItemArray[4].ToString();
        txth_add1.Text=dt.Rows[0].ItemArray[6].ToString();
        txth_add2.Text = dt.Rows[0].ItemArray[7].ToString();
        txth_add3.Text = dt.Rows[0].ItemArray[8].ToString();
        txth_city.Text = dt.Rows[0].ItemArray[9].ToString();
        txth_pincode.Text = dt.Rows[0].ItemArray[10].ToString();
        txth_state.Text = dt.Rows[0].ItemArray[11].ToString();
        txth_country.Text = dt.Rows[0].ItemArray[12].ToString();
        txth_phone.Text = dt.Rows[0].ItemArray[14].ToString();
        txtBus_Title.Text = dt.Rows[0].ItemArray[15].ToString();
        txtbus_org.Text = dt.Rows[0].ItemArray[16].ToString();
        txtb_add1.Text = dt.Rows[0].ItemArray[17].ToString();
        txtb_add2.Text = dt.Rows[0].ItemArray[18].ToString();
        txtb_add3.Text = dt.Rows[0].ItemArray[19].ToString();
        txtb_city.Text = dt.Rows[0].ItemArray[20].ToString();
        txtb_pincode.Text = dt.Rows[0].ItemArray[21].ToString();
        txtb_state.Text = dt.Rows[0].ItemArray[22].ToString();
        txtb_country.Text = dt.Rows[0].ItemArray[23].ToString();
        txtb_phone.Text = dt.Rows[0].ItemArray[25].ToString();
        txtb_fax.Text = dt.Rows[0].ItemArray[28].ToString();         
        lblEmail.Text=dt.Rows[0].ItemArray[30].ToString();     
        


        conn.Close();


    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (Session["Userid"] == "" || Session["Userid"] == null)
        {
            Response.Redirect("index.aspx");
        }
        conn.Open();
        OleDbCommand cmd1 = new OleDbCommand("Update membermaster set first_name='" + txtFirstName.Text + "',last_name='" + txtLastName.Text + "',bus_title='" + txtBus_Title.Text + "',Organisatn='" + txtbus_org.Text + "',bus_add1='" + txtb_add1.Text + "',bus_add2='" + txtb_add2.Text + "',bus_add3='" + txtb_add3.Text + "',bus_city='" + txtb_city.Text + "',bus_citycd='" + txtb_pincode.Text + "',bus_state='" + txtb_state.Text + "',bus_county='" + txtb_country.Text + "',bus_phone='" + txtb_phone.Text + "',bus_fax='" + txtb_fax.Text + "',hm_add1='" + txth_add1.Text + "',hm_add2='" + txth_add2.Text + "',hm_add3='" + txth_add3.Text + "',hm_city='"+ txth_city.Text +"',hm_city_cd='"+ txth_pincode.Text +"',hm_state='"+ txth_state.Text +"',hm_country='"+ txth_country.Text +"',hm_phone='"+ txth_phone.Text +"' where userid='" + lblEmail.Text + "'", conn);
        cmd1.ExecuteNonQuery();
        conn.Close();
        //OleDbCommand cmd1 = new OleDbCommand("Update membermaster set first_name='" + txtFirstName.Text + "',last_name='" + txtLastName.Text + "',bus_title='" + txtBus_Title.Text + "',Organisatn='" + txtbus_org.Text + "',bus_add1='" + txtb_add1.text + "',bus_add2='" + txtb_add2.Text + "',bus_add3='" + txtb_add3.Text + "',bus_city='" + txtb_city.Text + "',bus_citycd='" + txtb_pincode.Text +"',bus_state=");
    }

    protected void lnkbtnlogout_Click(object sender, EventArgs e)
    {
        Session.Clear();
        Session["Userid"] = "";
        Response.Redirect("index.aspx");
    }
}