public DataTable DangNhap(TaiKhoanPublic User)
{
DataTable dt = new DataTable();
cmd.CommandText = $"select * from TAI_KHOAN where TenDangNhap = '{User.TENDANGNHAP}'and MatKhau = '{User.MATKHAU}'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
con.CloseConn();
}
return(dt);
}
void ganDuLieu(TaiKhoanPublic sppublic)
{
sppublic.TENDANGNHAP = tbtendangnhap.Text.Trim();
sppublic.TENTAIKHOAN = tbtentaikhoan.Text.Trim();
sppublic.MATKHAU = tbmatkhau.Text.Trim();
sppublic.QUYEN = tbquyen.Text.Trim();
}
public TaiKhoanPublic DangNhap(TaiKhoanPublic User)
{
TaiKhoanPublic UserA = new TaiKhoanPublic();
try
{
DataTable DT = tkdal.DangNhap(User);
if (DT.Rows.Count > 0)
{
try
{
UserA.TENDANGNHAP = DT.Rows[0].Field <string>("TenDangNhap");
UserA.QUYEN = DT.Rows[0].Field <string>("Quyen");
UserA.TENTAIKHOAN = DT.Rows[0].Field <string>("TenTaiKhoan");
}
catch (Exception ex)
{
throw ex;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(UserA);
}
private void btlogin_Click(object sender, EventArgs e)
{
TaiKhoanPublic UserA = null;
try
{
TaiKhoanPublic UserB = new TaiKhoanPublic();
UserB.TENDANGNHAP = tbtendangnhap.Text;
UserB.MATKHAU = tbmatkhau.Text;
TaiKhoanBUS User = new TaiKhoanBUS();
UserA = User.DangNhap(UserB);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (UserA.TENTAIKHOAN != null)
{
QLBanHang FQL = new QLBanHang(UserA, this.Show);
FQL.Show();
this.Hide();
}
else
{
MessageBox.Show("Sai ten dang nhap hoac mat khau");
}
}
}
public DonHang(TaiKhoanPublic Tài_khoản)
{
InitializeComponent();
this.Tài_khoản = Tài_khoản;
Tải_Dữ_Liệu();
Liên_Kết();
}
public bool suaTaiKhoan(TaiKhoanPublic tk)
{
cmd.CommandText = "update TAI_KHOAN set TenTaiKhoan = '" + tk.TENTAIKHOAN + "', MatKhau = '" + tk.MATKHAU + "', Quyen = '" + tk.QUYEN + "' where TenDangNhap= '" + tk.TENDANGNHAP + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
}
finally
{
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool themTaiKhoan(TaiKhoanPublic tk)
{
cmd.CommandText = "insert into TAI_KHOAN(TenDangNhap, TenTaiKhoan, MatKhau, Quyen) values ('" + tk.TENDANGNHAP + "','" + tk.TENTAIKHOAN + "','" + tk.MATKHAU + "','" + tk.QUYEN + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
}
finally
{
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool suaMatKhau(TaiKhoanPublic tk, string MatKhauMoi)
{
cmd.CommandText = $"update TAI_KHOAN set MatKhau = '{MatKhauMoi }' where TenDangNhap= '{ tk.TENDANGNHAP }' and MatKhau = '{ tk.MATKHAU}'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
int numbersOfRow = 0;
try
{
con.OpenConn();
numbersOfRow = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
string mex = ex.Message;
}
finally
{
cmd.Dispose();
con.CloseConn();
}
return(Convert.ToBoolean(numbersOfRow));
}
public QLBanHang(TaiKhoanPublic User, HienThiDangNhap ConTroHam)
{
this.User = User;
HamHienThiDangNhap = ConTroHam;
InitializeComponent();
}
public bool suaMatKhau(TaiKhoanPublic tk, string MatKhauMoi)
{
return(tkdal.suaMatKhau(tk, MatKhauMoi));
}
public bool suaTaiKhoan(TaiKhoanPublic tk)
{
return(tkdal.suaTaiKhoan(tk));
}
public bool themTaiKhoan(TaiKhoanPublic tk)
{
return(tkdal.themTaiKhoan(tk));
}
public DoiMatKhau(TaiKhoanPublic User)
{
this.User = User;
InitializeComponent();
}
