protected void Update_Click(object sender, EventArgs e)
{
long max_autono = mc.GetMaxAutono();
string userid = Session["Userid"].ToString();
string query = "update USER_DETAILS set autono=" + max_autono + ",name='" + Name.Text + "',email='" + Email.Text + "',mob='" + Mobile.Text + "',address='" + Address.Text + "',city='" + City.Text + "',pin='" + Pin.Text + "',aadhar='" + Aadhar.Text + "',gender='" + Gender.Text + "',dob='" + DOB.Text + "',religion='" + Religion.SelectedValue.ToString() + "',qualification='" + Education.SelectedValue.ToString() + "' where userid='" + userid + "'";
try
{
con.ExecuteNonQuery(query);
mc.Update_ACTIVITIES("UPDATE");
Response.Redirect("Default.aspx");
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Registration", "alert('Error');", true);
}
}
protected void BtnRegis_Click(object sender, EventArgs e)
{
long max_autono = mc.GetMaxAutono() + 1;
string query = "insert into USER_DETAILS values('" + max_autono + "','" + UserId.Text + "','" + Name.Text + "','" + Password.Text + "','" + Email.Text + "','" + Contact.Text + "','" + Address.Text + "','" + City.Text + "','" + Pin.Text + "','" + Aadhar.Text + "','" + Gender.Text + "','" + DOB.Text + "','" + Religion.SelectedValue.ToString() + "','" + Education.SelectedValue.ToString() + "','NORMALUSER')";
try
{
con.ExecuteNonQuery(query);
Session["UserId"] = UserId.Text;
mc.Update_ACTIVITIES("REGISTRATION");
//ClientScript.RegisterStartupScript(this.GetType(), "Registration", "alert('Data Inserted Successfully');", true);
Response.Redirect("Login.aspx");
// ClientScript.RegisterStartupScript(this.GetType(), "Registration", "alert('Data Inserted Successfully');", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Registration", "alert(" + ex.Message + ");", true);
UserId.Focus();
}
}