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();
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
try
{
if (RememberMe.Checked == true)
{
Response.Cookies["Userid"].Value = UserId.Text;
Response.Cookies["Password"].Value = Password.Text;
Response.Cookies["Userid"].Expires = DateTime.Now.AddDays(15);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(15);
}
else
{
Response.Cookies["Userid"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
}
string query = "Select * from USER_DETAILS where USERID='" + UserId.Text + "' AND PASSWORD='******'";
SqlDataReader dr;
// dr = con.getreader("select * from employee_registration where emp_id='" + TextBox1.Text + "' and emp_password='******'");
dr = con.Getreader(query);
//ClientScript.RegisterStartupScript(this.GetType(), "Login Error", string.Format("alert('{0}');", LoginErrorMessage.ToString().Replace("'", "\\'")), true);
// ClientScript.RegisterStartupScript(this.GetType(), "Login Error", "alert('Error Message');", true);
if (dr.Read())
{
if (dr.HasRows)
{
// String dyc = con.Decrypt(dr.GetValue(1).ToString());
string dyc = dr["PASSWORD"].ToString();
if (dyc == Password.Text)
{
Session["UserId"] = dr.GetValue(1).ToString();
Session["UserName"] = dr["NAME"].ToString();
Session["UserType"] = dr["USERTYPE"].ToString();
mc.Update_ACTIVITIES("LOGIN");
Response.Redirect("Default.aspx");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Login Error", "alert('Invalid User Name Or password');", true);
Response.Write("<b> Invalid User Name Or password </b>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Login Error", "alert('Invalid User Name Or password');", true);
Response.Write("<b> Invalid User Name Or password </b>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Login Error", string.Format("alert('{0}');", LoginErrorMessage.ToString().Replace("'", "\\'")), true);
ClientScript.RegisterStartupScript(this.GetType(), "Login Error1", "alert('Invalid User Name Or password');", true);
Response.Write("<b> Invalid User Name Or password </b>");
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Login Error", string.Format("alert('{0}" + ex.ToString() + "');", LoginErrorMessage.ToString().Replace("'", "\\'")), true);
}
}