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();
}