public string GetHoTen(EC_DangNhap etli)
{
return(cn.LayGiaTri("SELECT B.HoLot+' '+B.Ten as HoTen FROM DangNhap A inner join NhanVien B on A.MaNV= B.MaNV Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'"));
}
public void DeleteUser(EC_DangNhap etli)
{
cn.ThucThiSQL("DELETE FROM DangNhap where ID=" + etli.ID);
}
public string GetQuyen(EC_DangNhap etli)
{
return(cn.LayGiaTri("SELECT Quyen FROM DangNhap Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'"));
}
public DataTable GetLogin(EC_DangNhap etli)
{
return(cn.LayDuLieu("SELECT * FROM DangNhap Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'"));
}
public void AddUser(EC_DangNhap etli)
{
cn.ThucThiSQL(@"INSERT INTO DangNhap (TaiKhoan, MatKhau, Quyen, MaNV)
VALUES ('" + etli.TaiKhoan + "','" + etli.MatKhau + "'," + etli.Quyen + "," + etli.MaNV + ")");
}
public void DeleteUser(EC_DangNhap etli)
{
SQL.DeleteUser(etli);
}
public string GetHoTen(EC_DangNhap etli)
{
return(SQL.GetHoTen(etli));
}
public void AddUser(EC_DangNhap etli)
{
SQL.AddUser(etli);
}
public DataTable GetLogin(EC_DangNhap etli)
{
return(SQL.GetLogin(etli));
}
//xóa dữ liệu
public void XoaDuLieu(EC_DangNhap et)
{
cn.ThucThiCauLenhSQL(@"DELETE from DangNhap where TenTaiKhoan=N'" + et.TenDangNhap + "'");
}
//sửa dữ liệu
public void SuaDuLieu(EC_DangNhap et)
{
cn.ThucThiCauLenhSQL(@"UPDATE DangNhap SET MatKhau =N'" + et.MatKhau + "', Quyen =N'" + et.PhanQuyen + "' where TenTaiKhoan=N'" + et.TenDangNhap + "'");
}
//Hàm thêm dữ liệu
public void ThemDuLieu(EC_DangNhap et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO DangNhap(TenTaiKhoan, MatKhau, Quyen))
VALUES (N'" + et.TenDangNhap + "',N'" + et.MatKhau + "',N'" + et.PhanQuyen + "')");
}
