public int SelectBLL(adminProps a)
{
adminDAL A = new adminDAL();
int i = A.SelectDAL(a);
return(i);
}
protected void Button1_Click1(object sender, EventArgs e)
{
adminProps a = new adminProps();
a.Username = TextBox1.Text;
a.Password = TextBox2.Text;
adminBLL A = new adminBLL();
int b = A.SelectBLL(a);
if (b > 0)
{
Session["username"] = TextBox1.Text;
Response.Redirect("AdminPortal.aspx");
}
else
{
if (TextBox1.Text.Equals("") && TextBox2.Text.Equals(""))
{
Label1.Text = "Write Username and Password First";
}
else if (TextBox1.Text.Equals(""))
{
Label1.Text = "Write Username First";
}
else if (TextBox2.Text.Equals(""))
{
Label1.Text = "Write Password First";
}
else
{
Label1.Text = "Incorrect Username or Password";
}
}
}
public int UpdateBLL(adminProps a)
{
adminDAL A = new adminDAL();
int i = A.UpdateDAL(a);
return(i);
}
public int InsertBLL(adminProps a)
{
adminDAL A = new adminDAL();
int i = A.InsertDAL(a);
return(i);
}
public int UpdateDAL(adminProps a)
{
connection();
query = "Update admin set Email ='" + a.Email + "',Password = '******',Gender = '" + a.Gender + "' where Username = '******'";
cmd = new SqlCommand(query, con);
int rs = cmd.ExecuteNonQuery();
con.Close();
return(rs);
}
public int InsertDAL(adminProps a)
{
connection();
query = "Insert into admin values('" + a.Username + "','" + a.Email + "','" + a.Password + "','" + a.Gender + "')";
cmd = new SqlCommand(query, con);
int rs = cmd.ExecuteNonQuery();
con.Close();
return(rs);
}
public int SelectDAL(adminProps a)
{
connection();
query = "Select * from admin where Username='******' and Password= '******'";
adapter = new SqlDataAdapter(query, con);
DataTable tb = new DataTable();
int v = adapter.Fill(tb);
if (tb.Rows.Count == 4)
{
}
return(v);
}
protected void Button2_Click(object sender, EventArgs e)
{
adminProps a = new adminProps();
a.Username = TextBox1.Text;
a.Email = TextBox5.Text;
a.Password = TextBox3.Text;
a.Gender = DropDownList1.Text;
adminBLL A = new adminBLL();
A.UpdateBLL(a);
TextBox1.Text = "";
TextBox5.Text = "";
TextBox3.Text = "";
Label1.Text = "Admin data is updated successfully!";
}
