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 adminedit : System.Web.UI.Page
{
    connection objconn = new connection();
    OleDbConnection conn;
    string userid;
    string no;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Userid"] == "" || Session["Userid"] == null)
        {
            Response.Redirect("index.aspx");
        }
        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 (!IsPostBack)
        {
            filldata();
        }

        
    }
    protected void filldata()
    {
       no= Request.QueryString["no"];
      //  userid = Session["Userid"].ToString();
        conn.Open();
        OleDbCommand cmd = new OleDbCommand("select * from MemberMaster where id=" + no + "", 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();
        txtpassword.Text = dt.Rows[0].ItemArray[36].ToString();
        txtUserEmail.Text = dt.Rows[0].ItemArray[39].ToString();

        conn.Close();


    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        
        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 + "',[password]='" + txtpassword.Text + "',emailid2='" + txtUserEmail.Text + "' where id =" + Request.QueryString["no"] + "", 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");
    }
    protected void btnback_Click(object sender, EventArgs e)
    {
        Response.Redirect("adminuser.aspx");
    }
}