public static bool SuaTHUOC(THUOC bnDTO)
{
string sTruyVan = string.Format("update THUOC set TenThuoc= N'{0}', DonViTinh=N'{1}', Gia={2} where MaThuoc='{3}'", bnDTO.TenThuoc1, bnDTO.DonViTinh1, bnDTO.Gia1, bnDTO.Mathuoc1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public bool KiemTraTonTai(BACSI bnDTO)
{
string sTruyVan = string.Format("SELECT MaBS from BACSI WHERE TenDangNhap =N'{0}' AND TinhTrangTonTai = '1'", bnDTO.TenDangNhap1); // MaBN tu dong tang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool kq = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (kq == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public static bool Sua(float TienKham)
{
string sTruyVan = string.Format("update QUIDINH set TienKham = N'{0}'", TienKham);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public static bool XoaTHUOC(THUOC bnDTO)
{
DataTable dt = TaoBang(bnDTO);
if (dt != null)
{
DuyetBang(dt);
}
String sTruyVan = string.Format("update THUOC set TinhTrangTonTai = '0' where MaThuoc ='{0}'", bnDTO.Mathuoc1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// Them PHIEUKHAM
public static bool ThemPHIEUKHAM(PHIEUKHAM bnDTO)
{
// tao cau truy van
// string sTruyVan = @"insert into PHIEUKHAM(MaBN,TenBN) value"; -- them mot vai thanh phan vao bang
string sTruyVan = string.Format("insert into PHIEUKHAM values ('{0}','{1}',N'{2}',N'{3}',N'{4}', '1')", bnDTO.MaNV1, bnDTO.MaBN1, bnDTO.NgayKham1, bnDTO.TrieuChung1, bnDTO.KetQua1);// them day du thong tin cua bang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// sua benh nhan
public bool SuaBacSi(BACSI bnDTO)
{
string sTruyVan = string.Format("update BACSI set TenBS = N'{0}', TenDangNhap = N'{1}', MatKhau = N'{2}' , Loai = '{3}' where MaBS= N'{4}'", bnDTO.TenBS1, bnDTO.TenDangNhap1, bnDTO.Matkhau, bnDTO.Loai1, bnDTO.MaBS1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public bool XoaPhieKham(int x)
{
String sTruyVan = string.Format("update PHIEUKHAM set TinhTrangTonTai = '0' where MaPK ='{0}'", x);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public static bool ThemKetQuaVaoPhieuKham(PHIEUKHAM DTO)
{
string sTruyVan = string.Format("update PHIEUKHAM set KetQua = N'{0}' where MaPK={1}", DTO.KetQua1, DTO.MaPK1);
Con = DataProvider_1.KetNoi();
try
{
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public bool ThemBacSi(BACSI bnDTO)
{
// tao cau truy van
// string sTruyVan = @"insert into BENHNHAN(MaBN,TenBN) value"; -- them mot vai thanh phan vao bang
/* string sTruyVan = string.Format("insert into BENHNHAN values ('{0}',N'{1}','{2}',N'{3}',{4},N'{5}')", bnDTO.MaBN1, bnDTO.TenBN1, bnDTO.NgaySinh1, bnDTO.DiaChi1, bnDTO.DienThoai1, bnDTO.GioiTinh1);*/ // them day du thong tin cua bang
string sTruyVan = string.Format("insert into BACSI values (N'{0}', N'{1}', N'{2}', '{3}', '1')", bnDTO.TenBS1, bnDTO.TenDangNhap1, bnDTO.Matkhau, bnDTO.Loai1); // MaBN tu dong tang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool kq = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (kq == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// Them THUOC
public static bool ThemTHUOC(THUOC bnDTO)
{
// tao cau truy van
// string sTruyVan = @"insert into THUOC(MaBN,TenBN) value"; -- them mot vai thanh phan vao bang
string sTruyVan = string.Format("insert into THUOC values (N'{0}',N'{1}','{2}', '1')", bnDTO.TenThuoc1, bnDTO.DonViTinh1, bnDTO.Gia1, bnDTO.TinhTrangTonTai1); // them day du thong tin cua bang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
// DataProvider_1.DongKetNoi(Con);
}
public static bool ThemVaoCTTT(CTTT DTO)
{
string sTruyVan = string.Format("insert into CTTT values ('{0}','{1}','{2}','{3}',N'{4}')", DTO.MaPK1, DTO.MaPK1, DTO.SoLuong1, DTO.DonGia1, DTO.CachDung1); // MaBN tu dong tang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// xoa thuoc
public static bool XoaCTTT(string x)
{
String sTruyVan = string.Format("update CTTT set TrangThai = '0' where TenThuoc =N'{0}'", x);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// Sua PHIEUKHAM
public static bool SuaPHIEUKHAM(PHIEUKHAM pkDTO)
{
// tao cau truy van
// string sTruyVan = @"insert into PHIEUKHAM(MaBN,TenBN) value"; -- them mot vai thanh phan vao bang
string sTruyVan = string.Format("update PHIEUKHAM set MaNV=N'{0}' , MaBN=N'{1}' , NgayKham=N'{2}' , TrieuChung=N'{3}' where MaPK='{4}'", pkDTO.MaNV1, pkDTO.MaBN1, pkDTO.NgayKham1, pkDTO.TrieuChung1, pkDTO.MaPK1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public static bool KiemTraTonTai(BENHNHAN bnDTO)
{
string sTruyVan = string.Format("SELECT MaBN from BENHNHAN WHERE TrangThai = '1' and (TenBN like N'{0}') and (NgaySinh = N'{1}' and (DienThoai = '{2}' and GioiTinh = N'{3}'))", bnDTO.TenBN1, bnDTO.NgaySinh1, bnDTO.DienThoai1, bnDTO.GioiTinh1); // MaBN tu dong tang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// xoa benh nhan
public static bool XoaBenhNhan(BENHNHAN bnDTO)
{
String sTruyVan = string.Format("update BENHNHAN set TrangThai = '0' where MaBN ='{0}'", bnDTO.MaBN1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// sua benh nhan
public static bool SuaBenhNhan(BENHNHAN bnDTO)
{
string sTruyVan = string.Format("update BENHNHAN set TenBN = N'{0}', NgaySinh=N'{1}', DiaChi=N'{2}', DienThoai='{3}', GioiTinh=N'{4}' where MaBN={5}", bnDTO.TenBN1, bnDTO.NgaySinh1, bnDTO.DiaChi1, bnDTO.DienThoai1, bnDTO.GioiTinh1, bnDTO.MaBN1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// xoa benh nhan
public static bool XoaCTTT(CTTT CTTTDTO)
{
String sTruyVan = string.Format("delete from CTTT where MaBN ='{0}'", CTTTDTO.MaPK1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
public bool XoaNHANVIEN(NHANVIEN bnDTO)
{
DataTable dt = TaoBang(bnDTO);
if (dt != null)
{
DuyetBang(dt);
}
string sTruyVan = string.Format("update NHANVIEN set TrangThai = '0' where MaNV= N'{0}'", bnDTO.MaNV1);
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool KetQua = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong truy van
DataProvider_1.DongKetNoi(Con);
if (KetQua == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}
// ham kiem tra ton tai
public static bool KiemTraTonTai(THUOC bnDTO)
{
string sTruyVan = string.Format("SELECT MaThuoc from THUOC WHERE TenThuoc =N'{0}' AND TinhTrangTonTai = '1'", bnDTO.TenThuoc1); // MaBN tu dong tang
Con = DataProvider_1.KetNoi();
try
{
// thuc thi truy van
bool kq = DataProvider_1.ThucThiTruyVanNonQuery(sTruyVan, Con);
// dong ket noi
DataProvider_1.DongKetNoi(Con);
if (kq == true)
{
DataTable dt = DataProvider_1.LayDataTable(sTruyVan, Con);
DataProvider_1.DongKetNoi(Con);
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
DataProvider_1.DongKetNoi(Con);
return(false);
}
}