protected void Page_Load(object sender, EventArgs e) { Site1 master = Master as Site1; master.Update_Tabs_Visibility(Session["Role"] as string); if (!this.IsPostBack) { BindGrid(); } }
public void Button1_Click(object sender, EventArgs e) { string username = TextUserName.Text; string password = TextPassword.Text; Console.WriteLine(username + " " + password); SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=AIP;Trusted_Connection=true;"); SqlCommand cmd = new SqlCommand("select UserName, Id, Role from [Registration/Login] where UserName=@username and Password=@password", con); cmd.Parameters.AddWithValue("@username", TextUserName.Text); cmd.Parameters.AddWithValue("@password", TextPassword.Text); con.Open(); string output = ""; SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { output = output + dataReader.GetValue(0) + "</br>"; Session["UserId"] = dataReader.GetValue(1); Session["Role"] = dataReader.GetValue(2); // this.Master.Update_Tabs_Visibility(Session["Role"] as string); Site1 master = Master as Site1; master.Update_Tabs_Visibility(Session["Role"] as string); } con.Close(); Label3.Text = "WELCOME " + output; if (output == "") { Label3.Text = "Invalid Username or password"; } string role = Session["Role"] as string; if (role.Equals("Admin")) { Response.Redirect("~/AutoDefaults.aspx"); } else if (role.Equals("User")) { Response.Redirect("~/Transactions.aspx"); } }
protected void BindGrid() { Site1 master = Master as Site1; master.Update_Tabs_Visibility(Session["Role"] as string); SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=AIP;Trusted_Connection=true;"); SqlCommand cmd = new SqlCommand("select * from dbo.TransactionsDetails where User_Id = " + Session["UserId"], con); con.Open(); SqlDataAdapter sda = new SqlDataAdapter(cmd); SqlDataReader rdr = cmd.ExecuteReader(); GridView1.DataSource = rdr; GridView1.DataBind(); con.Close(); }