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!"; }