protected void Button1_Click(object sender, EventArgs e)
{
DAOClassUser n = new DAOClassUser();
string n1 = TextBox1.Text;
DataSet p = n.check(n1);
GridView1.DataSource = p;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
DAOClassUser n = new DAOClassUser();
SqlCommand cmd1 = n.SignUpUser(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox5.Text);
try
{
cmd1.ExecuteNonQuery();
Response.Redirect("Login.aspx");
}
catch (SqlException se)
{
Console.WriteLine(se.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
name1 = Session["userid"].ToString();
Console.WriteLine(name1);
}
catch (Exception es)
{
Console.WriteLine(es.Message);
}
DAOClassUser n = new DAOClassUser();
DataSet ds = n.DashBoardDetails(name1);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
DAOClassUser n = new DAOClassUser();
Users u = new Users();
SqlCommand cmd = n.LoginUser(TextBox1.Text, TextBox2.Text);
try
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
u.U_Id1 = Convert.ToInt32(dr[0]);
u.Email_Id1 = dr[1].ToString();
u.Passwrd1 = dr[2].ToString();
u.Roles1 = dr[3].ToString();
u.Names1 = dr[4].ToString();
u.Phoneno1 = dr[5].ToString();
u.Addres1 = dr[6].ToString();
if (u.Roles1 == "User")
{
Session["userid"] = u.U_Id1;
Response.Redirect("DashBoard.aspx");
}
if (u.Roles1 == "officer")
{
Response.Redirect("officer.aspx?id=" + u.U_Id1);
}
if (u.Roles1 == "inspector")
{
Response.Redirect("inspector.aspx?id=" + u.U_Id1);
}
if (u.Roles1 == "Authorizer")
{
Response.Redirect("Authorizer.aspx?id=" + u.U_Id1);
}
}
}
catch (SqlException se)
{
Console.WriteLine(se.Message);
}
}
