public static List <cBenhanDO> Getdsbenhan2(string MABACSI, string MABENHNHAN, int MAXACNHAN)
{
List <cBenhanDO> dsbenhan = new List <cBenhanDO>();
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
var query = from ads in ds.tbHOSOKHAMBENHs
join ads1 in ds.tbBENHNHANs on ads.MABENHNHAN equals ads1.MABENHNHAN
where ads.MAKHAMBENH == MABENHNHAN && ads.MAXACNHAN == MAXACNHAN && ads.MABACSY == MABACSI
select new { ads, ads1 };
foreach (var row in query)
{
cBenhanDO dss = new cBenhanDO();
dss.MABENHAN = row.ads.MAKHAMBENH;
dss.MABENHNHAN = row.ads.MABENHNHAN;
dss.MABACSY = row.ads.MABACSY;
dss.HOTEN = row.ads1.HO + " " + row.ads1.TEN;
dss.TUOI = row.ads.TUOI.ToString();
dss.GIOITINH = row.ads.GIOITINH;
dss.NGAYDK = row.ads.NGAYDK.Value;
dss.GIODK = row.ads.GIODK.Value.ToString().Substring(9);
dsbenhan.Add(dss);
}
return(dsbenhan);
}
}
public static List <cDonThuocMauChiTietDO> Getdsdonthuocmau(string MADONTHUOCMAU, string MABACSY)
{
List <cDonThuocMauChiTietDO> dsbenhan = new List <cDonThuocMauChiTietDO>();
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
var query = from ads in ds.tbDONTHUOCMAUs
join ads1 in ds.tbDONTHUOCMAUCHITIETs on ads.MADONTHUOCMAU equals ads1.MADONTHUOCMAU
join ads2 in ds.tbTHUOCs on ads1.MATHUOC equals ads2.MATHUOC
where ads.MADONTHUOCMAU == MADONTHUOCMAU && ads.MABACSY == MABACSY
select new { ads, ads1, ads2 };
foreach (var row in query)
{
cDonThuocMauChiTietDO dss = new cDonThuocMauChiTietDO();
dss.STT = row.ads1.STT;
dss.MADONTHUOCMAU1 = row.ads1.MADONTHUOCMAU;
dss.MATHUOC = row.ads1.MATHUOC;
dss.TENTHUONGMAI = row.ads2.TENTHUONGMAI;
dss.SOLUONG = row.ads1.SOLUONG.ToString();
dss.SOLANDUNG = row.ads1.SOLANDUNG.ToString();
dss.SOLUONGDUNG = row.ads1.SOLUONGDUNG.ToString();
dss.DONVI = row.ads2.DONVI;
dss.DONVIDUNG = row.ads2.DONVIDUNG;
dss.CACHDUNG = row.ads2.CACHDUNG;
dss.GHICHU = row.ads2.GHICHU;
dsbenhan.Add(dss);
}
return(dsbenhan);
}
}
public static List <cBenhnhanDO> Getdsbenhnhan(string NGAYHIENTAI)
{
List <cBenhnhanDO> dsbenhan = new List <cBenhnhanDO>();
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
var query = from ads in ds.tbBENHNHANs
where ads.STT.Substring(0, 5) == NGAYHIENTAI
select ads;
foreach (var row in query)
{
cBenhnhanDO dss = new cBenhnhanDO();
dss.MABENHNHAN = row.MABENHNHAN;
dss.STT = row.STT;
dss.TEN = row.TEN;
dss.HO = row.HO;
dss.HOTEN = row.HO + "" + row.TEN;
dss.NGAYSINH = row.NGAYSINH;
dss.TUOI = row.TUOI;
dss.TRANGTHAI = row.TRANGTHAI.Value;
dss.NGAYTAO = row.NGAYTAO.Value;
dsbenhan.Add(dss);
}
return(dsbenhan);
}
}
public static List <cThuocDO> GetListMedicine1(Boolean Trangthai)
{
List <cThuocDO> dsMedicine = new List <cThuocDO>();
using (DB_HMS_Entities dk = new DB_HMS_Entities())
{
var query = from ds in dk.tbTHUOCs
where ds.TRANGTHAI == Trangthai
select ds;
foreach (var row in query)
{
cThuocDO ds = new cThuocDO();
ds.MATHUOC = row.MATHUOC;
ds.TENTHUONGMAI = row.TENTHUONGMAI;
ds.TENBIETDUOC = row.TENBIETDUOC;
ds.CACHDUNG = row.CACHDUNG;
ds.DONVI = row.DONVI;
ds.DONVIDUNG = row.DONVIDUNG;
ds.GHICHU = row.GHICHU;
ds.TRANGTHAI = row.TRANGTHAI.Value;
dsMedicine.Add(ds);
}
return(dsMedicine);
}
}
public static string GetPassword(string Manhanvien)
{
using (DB_HMS_Entities Pass = new DB_HMS_Entities())
{
var query = (from u in Pass.tbNHANVIENs
where u.MANHANVIEN == Manhanvien
select u).First();
return(query.MATKHAU);
}
}
public static void UpdateStaffGroup(string MaNhomNhanVien, string TenNhomNhanVien, string MoTa, bool TrangThai)
{
using (DB_HMS_Entities Group = new DB_HMS_Entities())
{
var query = (from u in Group.tbNHOMNGUOIDUNGs where u.MANHOMNDN == MaNhomNhanVien select u).First();
query.TENNHOMND = TenNhomNhanVien;
query.MOTA = MoTa;
query.TRANGTHAI = TrangThai;
Group.SaveChanges();
}
}
public static void DeleteDonthuocchitiet(string MADONTHUOCMAU, string MABACSI, string MATHUOC)
{
using (DB_HMS_Entities dk = new DB_HMS_Entities())
{
var query = (from c in dk.tbDONTHUOCMAUCHITIETs
where c.MADONTHUOCMAU == MADONTHUOCMAU && c.MABACSI == MABACSI && c.MATHUOC == MATHUOC
select c).First();
dk.DeleteObject(query);
dk.SaveChanges();
}
}
public static void UpdatePassword(string Manhanvien, string Password)
{
using (DB_HMS_Entities Grp = new DB_HMS_Entities())
{
var query = (from u in Grp.tbNHANVIENs
where u.MANHANVIEN == Manhanvien
select u).First();
query.MATKHAU = ToMD5(ToMD5(ToMD5(Password)));
Grp.SaveChanges();
}
}
/// <summary>
/// Hàm delete 1 quốc gia ở database
/// </summary>
/// <param name="maquocgia"></param>
public static void DeleteBenhtheopk(string MABENH, string MAPHONGKHAM)
{
using (DB_HMS_Entities dk = new DB_HMS_Entities())
{
var query = (from c in dk.tbBENHPHONGKHAMs
where c.MABENH == MABENH && c.MAPHONGKHAM == MAPHONGKHAM
select c).First();
dk.DeleteObject(query);
dk.SaveChanges();
}
}
/// <summary>
/// Thêm bệnh theo phòng khám vào database
/// </summary>
/// <param name="MABENH"></param>
/// <param name="MANHOMBENH"></param>
/// <param name="TENBENHTA"></param>
/// <param name="TENBENHTV"></param>
/// <param name="MOTA"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void InsertBentheopk(string MABENH, string MAPHONGKHAM, DateTime NGAYTAO)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbBENHPHONGKHAM pk = new tbBENHPHONGKHAM();
pk.MABENH = MABENH;
pk.MAPHONGKHAM = MAPHONGKHAM;
pk.NGAYTAO = NGAYTAO;
ds.AddTotbBENHPHONGKHAMs(pk);
ds.SaveChanges();
}
}
public static void UpdateBacsivaobenhan(string MABENHAN, string MABACSY)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.MABACSY = MABACSY;
ds.SaveChanges();
}
}
public static void UpdateMaxacnhan(string MABENHAN, int MAXACNHAN)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.MAXACNHAN = MAXACNHAN;
ds.SaveChanges();
}
}
public static void DeleteFunctionofGroup(string MaNhomNhanVien)
{
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = from u in lst.tbTINHNANGNHOMNDs where u.MANHOMND == MaNhomNhanVien select u;
foreach (var row in query)
{
lst.DeleteObject(row);
}
lst.SaveChanges();
}
}
/// <summary>
/// Cập nhật bệnh vào database
/// </summary>
/// <param name="MABENH"></param>
/// <param name="MANHOMBENH"></param>
/// <param name="TENBENHTA"></param>
/// <param name="TENBENHTV"></param>
/// <param name="MOTA"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void UpdateTrangthai(string MABENHAN, int TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.TRANGTHAI = TRANGTHAI;
ds.SaveChanges();
}
}
public static void InsertFunctionofGroup(string MaNhomNhanVien, string MaTinhNang)
{
using (DB_HMS_Entities Group = new DB_HMS_Entities())
{
tbTINHNANGNHOMND lst = new tbTINHNANGNHOMND();
lst.MATINHNANG = MaTinhNang;
lst.MANHOMND = MaNhomNhanVien;
lst.NGAYTAO = DateTime.Today;
Group.AddTotbTINHNANGNHOMNDs(lst);
Group.SaveChanges();
}
}
/// <summary>
/// Them moi phong kham vao entities
/// </summary>
/// <param name="MAPHONGKHAM"></param>
/// <param name="TENPHONG"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void Insertphongkham(string MAPHONGKHAM, string TENPHONG, DateTime NGAYTAO, Boolean TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbPHONGKHAM pk = new tbPHONGKHAM();
pk.MAPHONGKHAM = MAPHONGKHAM;
pk.TENPHONG = TENPHONG;
pk.NGAYTAO = NGAYTAO;
pk.TRANGTHAI = TRANGTHAI;
ds.AddTotbPHONGKHAMs(pk);
ds.SaveChanges();
}
}
public static void InsertDonthuocmau(string MADONTHUOCMAU, string MABACSI, DateTime NGAYTAO, Boolean TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbDONTHUOCMAU pk = new tbDONTHUOCMAU();
pk.MADONTHUOCMAU = MADONTHUOCMAU;
pk.MABACSY = MABACSI;
pk.NGAYTAO = NGAYTAO;
pk.TRANGTHAI = TRANGTHAI;
ds.AddTotbDONTHUOCMAUs(pk);
ds.SaveChanges();
}
}
public static void InsertToathuoc(string MABENHAN, string MATHUOC, string SOLUONG, string SOLANDUNG, string SOLUONGDUNG, DateTime NGAYTAO)
{
using (DB_HMS_Entities dk = new DB_HMS_Entities())
{
tbKETOATHUOC sl = new tbKETOATHUOC();
sl.MABENHAN = MABENHAN;
sl.SOLUONG = Int32.Parse(SOLUONG);
sl.SOLANDUNG = Int32.Parse(SOLANDUNG);
sl.SOLUONGDUNG = Int32.Parse(SOLUONGDUNG);
sl.NGAYTAO = NGAYTAO;
dk.SaveChanges();
}
}
public static void InsertStaffGroup(string MaNhomNhanVien, string TenNhomNhanVien, string MoTa, bool TrangThai)
{
using (DB_HMS_Entities Group = new DB_HMS_Entities())
{
tbNHOMNGUOIDUNG lst = new tbNHOMNGUOIDUNG();
lst.MANHOMNDN = MaNhomNhanVien;
lst.TENNHOMND = TenNhomNhanVien;
lst.MOTA = MoTa;
lst.TRANGTHAI = TrangThai;
Group.AddTotbNHOMNGUOIDUNGs(lst);
Group.SaveChanges();
}
}
/// <summary>
/// cap nhat phong kham vao entities
/// </summary>
/// <param name="MAPHONGKHAM"></param>
/// <param name="TENPHONG"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void Updatephongkham(string MAPHONGKHAM, string TENPHONG, DateTime NGAYTAO, Boolean TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbPHONGKHAM pk = new tbPHONGKHAM();
var query = (from dss in ds.tbPHONGKHAMs
where dss.MAPHONGKHAM == MAPHONGKHAM
select dss).First();
query.TENPHONG = TENPHONG;
query.NGAYTAO = NGAYTAO;
query.TRANGTHAI = TRANGTHAI;
ds.SaveChanges();
}
}
/// <summary>
/// Thêm nhóm bệnh vào database
/// </summary>
/// <param name="MABENH"></param>
/// <param name="MANHOMBENH"></param>
/// <param name="TENBENHTA"></param>
/// <param name="TENBENHTV"></param>
/// <param name="MOTA"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void InsertNhombenh(string MANHOMBENH, string TENNHOMBENH, string MOTA, DateTime NGAYTAO, Boolean TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbNHOMBENH pk = new tbNHOMBENH();
pk.MANHOMBENH = MANHOMBENH;
pk.TENNHOMBENH = TENNHOMBENH;
pk.MOTA = MOTA;
pk.NGAYTAO = NGAYTAO;
pk.TRANGTHAI = TRANGTHAI;
ds.AddTotbNHOMBENHs(pk);
ds.SaveChanges();
}
}
public static cThuocDO Getthongtinthuoc(string MATHUOC)
{
cThuocDO st = new cThuocDO();
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = (from u in lst.tbTHUOCs where u.MATHUOC == MATHUOC select u).First();
st.CACHDUNG = query.CACHDUNG;
st.DONVI = query.DONVI;
st.DONVIDUNG = query.DONVIDUNG;
st.GHICHU = query.GHICHU;
return(st);
}
}
/// <summary>
/// get mã bệnh án
/// </summary>
/// <returns></returns>
public static string Getmabenhan()
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
string mabenhan = null;
var query = (from dss in ds.tbSINHLIEUx
orderby dss.MABENHAN descending
select dss).Skip(0).Take(1);
foreach (var row in query)
{
mabenhan = row.MABENHAN;
}
return(mabenhan);
}
}
public static string GetIDByClinicName(string Name)
{
Name = Name.ToLower();
cPhongKhamDO group = new cPhongKhamDO();
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = from u in lst.tbPHONGKHAMs where u.TENPHONG == Name select u;
foreach (var row in query)
{
group.MAPHONGKHAM = row.MAPHONGKHAM;
}
}
return(group.MAPHONGKHAM);
}
public static string GetNameByClinicID(string ID)
{
ID = ID.ToLower();
cPhongKhamDO group = new cPhongKhamDO();
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = from u in lst.tbPHONGKHAMs where u.MAPHONGKHAM == ID select u;
foreach (var row in query)
{
group.TENPHONG = row.TENPHONG;
}
}
return(group.TENPHONG);
}
public static string Getmathuoc()
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
string mathuoc = null;
var query = (from dss in ds.tbTHUOCs
orderby dss.MATHUOC descending
select dss).Skip(0).Take(1);
foreach (var row in query)
{
mathuoc = row.MATHUOC;
}
return(mathuoc);
}
}
/// <summary>
/// Lay ma phong kham tu entities
/// </summary>
/// <returns></returns>
public static string Getmaphongkham()
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
string maphongkham = null;
var query = (from dss in ds.tbPHONGKHAMs
orderby dss.MAPHONGKHAM descending
select dss).Skip(0).Take(1);
foreach (var row in query)
{
maphongkham = row.MAPHONGKHAM;
}
return(maphongkham);
}
}
public static string GetStaffID()
{
using (DB_HMS_Entities Staff = new DB_HMS_Entities())
{
string StaffID = null;
var query = (from u in Staff.tbNHANVIENs
orderby u.MANHANVIEN descending
select u).Skip(0).Take(1);
foreach (var row in query)
{
StaffID = row.MANHANVIEN;
}
return(StaffID);
}
}
public static string GetIDByGroupName(string Name)
{
Name = Name.ToLower();
cNhomNhanVienDO group = new cNhomNhanVienDO();
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = from u in lst.tbNHOMNGUOIDUNGs where u.TENNHOMND == Name select u;
foreach (var row in query)
{
group.MANHOMNHANVIEN = row.MANHOMNDN;
}
}
return(group.MANHOMNHANVIEN);
}
/// <summary>
/// Cập nhật nhóm bệnh xuống database
/// </summary>
/// <param name="MANHOMBENH"></param>
/// <param name="TENNHOMBENH"></param>
/// <param name="MOTA"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void UpdateNhombenh(string MANHOMBENH, string TENNHOMBENH, string MOTA, DateTime NGAYTAO, Boolean TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbNHOMBENH pk = new tbNHOMBENH();
var query = (from dss in ds.tbNHOMBENHs
where dss.MANHOMBENH == MANHOMBENH
select dss).First();
query.TENNHOMBENH = TENNHOMBENH;
query.MOTA = MOTA;
query.NGAYTAO = NGAYTAO;
query.TRANGTHAI = TRANGTHAI;
ds.SaveChanges();
}
}
