public bool Check_Login(ref tbl.tblAdmin ad)
{
string sql = "SELECT COUNT (*) FROM ADMINS WHERE " +
"USERNAME = '******' COLLATE SQL_Latin1_General_CP1_CS_AS " +
"AND PASSWORD = '******' COLLATE SQL_Latin1_General_CP1_CS_AS";
SqlConnection con = dc.getConnect();
da = new SqlDataAdapter(sql, con);
con.Open();
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
sql = "SELECT ADMIN_ID FROM ADMINS WHERE USERNAME = '******' COLLATE SQL_Latin1_General_CP1_CS_AS";
da = new SqlDataAdapter(sql, con);
DataTable dad = new DataTable();
da.Fill(dad);
ad.ADMIN_ID = dad.Rows[0][0].ToString();
con.Close();
return(true);
}
con.Close();
return(false);
}
public Admin_Control(tbl.tblAdmin ad)
{
InitializeComponent();
Admin = ad;
txtAdUsername.Text = ad.USERNAME;
txtAdUsername.Show();
}
private void button1_Click(object sender, EventArgs e)
{
BUS.AdminBLL admin = new BUS.AdminBLL();
if (Check_Fill() == true)
{
tbl.tblAdmin ad = new tbl.tblAdmin("", txtUsername.Text, txtPassword.Text);
if (admin.Check_Login(ref ad) == true)
{
this.Hide();
PRE.Admin_Control sad = new PRE.Admin_Control(ad);
sad.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("The username or password is incorrect !!!");
}
}
}
public bool UpdateAdmin(tbl.tblAdmin ad)
{
string sql = "UPDATE ADMINS SET USERNAME = @USERNAME, PASSWORD = @PASSWORD WHERE ADMIN_ID = @ADMIN_ID COLLATE SQL_Latin1_General_CP1_CS_AS ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@ADMIN_ID", SqlDbType.VarChar).Value = ad.ADMIN_ID;
cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar).Value = ad.USERNAME;
cmd.Parameters.Add("@PASSWORD", SqlDbType.VarChar).Value = ad.PASSWORD;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
private void btnChangeUsername_Click(object sender, EventArgs e)
{
if (Check_Username_Fill())
{
tbl.tblAdmin ad = new tbl.tblAdmin(Admin_Control.Admin.ADMIN_ID, txtNewUsername.Text, Admin_Control.Admin.PASSWORD);
BUS.AdminBLL admin = new BUS.AdminBLL();
if (txtUsername.Text != Admin_Control.Admin.USERNAME)
{
MessageBox.Show("Username is not correct!!!", "Error");
}
else
if (admin.UpdateAdmin(ad) == false)
{
MessageBox.Show("Can not change username !!!", "Error");
}
else
{
MessageBox.Show("Successfully!!!");
Admin_Control.Admin.USERNAME = ad.USERNAME;
Clear_All();
}
}
}
private void btnChangePassword_Click(object sender, EventArgs e)
{
if (Check_Pass_Fill())
{
tbl.tblAdmin ad = new tbl.tblAdmin(Admin_Control.Admin.ADMIN_ID, Admin_Control.Admin.USERNAME, txtNewPassword.Text);
BUS.AdminBLL admin = new BUS.AdminBLL();
if (txtPassword.Text != Admin_Control.Admin.PASSWORD)
{
MessageBox.Show("Password is not correct!!!", "Error");
}
else
if (admin.UpdateAdmin(ad) == false)
{
MessageBox.Show("Can not change password !!!", "Error");
}
else
{
MessageBox.Show("Successfully!!!");
Admin_Control.Admin.PASSWORD = ad.PASSWORD;
Clear_All();
}
}
}
public bool Check_Login(ref tbl.tblAdmin ad)
{
return(dalAd.Check_Login(ref ad));
}
public bool UpdateAdmin(tbl.tblAdmin ad)
{
return(dalAd.UpdateAdmin(ad));
}
