/// <summary> /// Load report data from DB /// </summary> /// <param name="pickedMonth"></param> /// <param name="pickedYear"></param> private bool LoadReport(int pickedMonth, int pickedYear) { DS_DoanhThu.Clear(); using (var dc = new QLPM_ModelDataContext()) { if (CanGetReport && PickedMonth > 0 && PickedYear > 0) { var total = (from hd in dc.HOADONs where hd.PHIEUKHAMBENH.NgayKham.Month == pickedMonth && hd.PHIEUKHAMBENH.NgayKham.Year == pickedYear select hd).Sum(x => x.TienKham + x.TienThuoc); (from hd in dc.HOADONs where hd.PHIEUKHAMBENH.NgayKham.Month == pickedMonth && hd.PHIEUKHAMBENH.NgayKham.Year == pickedYear group hd by hd.PHIEUKHAMBENH.NgayKham into g select new DOANHTHUNGAY { Ngay = g.Key, SoBenhNhan = g.Count(), DoanhThu = g.Sum(i => i.TienKham + i.TienThuoc) }).ToList().ForEach(x => { x.TiLe = Math.Round((double)(x.DoanhThu / total) * 100, 1); DS_DoanhThu.Add(x); }); } } return(DS_DoanhThu.Count != 0 ? true : false); }
/// <summary> /// Getting data from DB /// </summary> private void GetData() { using (var dc = new QLPM_ModelDataContext()) { dc.NHANVIENs.Select(x => x).ToList().ForEach(x => DS_NV.Add(x)); } }
/// <summary> /// Getting data from DB /// </summary> /// <returns></returns> private void ReadList(DateTime datePicked) { if (DS_KhamBenh.Count == 0) { // Getting data from DB (if exists) using (var dc = new QLPM_ModelDataContext()) { var query = (from pk in dc.PHIEUKHAMBENHs where pk.NgayKham == datePicked select pk.Ma_BenhNhan).ToList(); if (query.Count > 0) { foreach (var item in query) { DS_KhamBenh.Add((BENHNHAN)(from bn in dc.HOSOBENHNHANs where bn.Ma_BenhNhan == item select bn).FirstOrDefault()); } } } ViewSource = (CollectionView)CollectionViewSource.GetDefaultView(DS_KhamBenh); } else { ViewSource = (CollectionView)CollectionViewSource.GetDefaultView(DS_KhamBenh); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { using (var dc = new QLPM_ModelDataContext()) { return(dc.BENHs.Single(x => x.Ma_Benh == value.ToString()).TenBenh); } }
/// <summary> /// Load report data from DB /// </summary> /// <param name="pickedMonth"></param> /// <param name="pickedYear"></param> /// <returns></returns> private bool LoadReport(int pickedMonth, int pickedYear) { DS_DungThuoc.Clear(); using (var dc = new QLPM_ModelDataContext()) { if (CanGetReport && PickedMonth1 > 0 && PickedYear1 > 0) { (from pk in dc.CT_PHIEUKHAMBENHs where pk.PHIEUKHAMBENH.NgayKham.Month == pickedMonth && pk.PHIEUKHAMBENH.NgayKham.Year == pickedYear group pk by new { pk.THUOC.TenThuoc, pk.Ma_Thuoc } into g select new SUDUNGTHUOC { Ma_Thuoc = g.Key.Ma_Thuoc, TenThuoc = g.Key.TenThuoc, SoLanDung = g.Count() }).ToList().ForEach(x => { x.SoLuong = dc.CT_PHIEUKHAMBENHs.Where(y => y.Ma_Thuoc == x.Ma_Thuoc).Sum(z => z.SoLuong); x.TenDonVi = dc.THUOCs.Single(y => x.Ma_Thuoc == y.Ma_Thuoc).DONVI.TenDonVi; DS_DungThuoc.Add(x); }); } } return(DS_DungThuoc.Count != 0 ? true : false); }
/// <summary> /// Add a CT_PHIEUKHAM to DB /// </summary> /// <param name="ct"></param> public static void AddPill(CT_PHIEUKHAMBENH ct) { using (var dc = new QLPM_ModelDataContext()) { dc.CT_PHIEUKHAMBENHs.InsertOnSubmit(ct); dc.SubmitChanges(); } }
/// <summary> /// Delete a HOADON /// </summary> /// <param name="pk"></param> public static void RemoveHoaDon(PHIEUKHAM pk) { using (var dc = new QLPM_ModelDataContext()) { dc.HOADONs.DeleteOnSubmit(dc.HOADONs.Single(hd => hd.Ma_PhieuKham == pk.Ma_PhieuKham)); dc.SubmitChanges(); } }
/// <summary> /// Remove a benhnhan obj from database /// </summary> /// <param name="bn"></param> public static void RemoveBenhNhan(BENHNHAN bn) { using (var dc = new QLPM_ModelDataContext()) { dc.HOSOBENHNHANs.DeleteOnSubmit((HOSOBENHNHAN)bn); dc.SubmitChanges(); } }
/// <summary> /// Add a new benhnhan obj to database /// </summary> /// <param name="bn">BenhNhan</param> public static void AddBenhNhan(BENHNHAN bn) { using (var dc = new QLPM_ModelDataContext()) { dc.HOSOBENHNHANs.InsertOnSubmit((HOSOBENHNHAN)bn); dc.SubmitChanges(); } }
/// <summary> /// Delete a CT_PHIEUKHAM from DB /// </summary> /// <param name="ct"></param> public static void RemovePill(CT_PHIEUKHAMBENH ct) { using (var dc = new QLPM_ModelDataContext()) { dc.CT_PHIEUKHAMBENHs.DeleteOnSubmit(ct); dc.SubmitChanges(); } }
/// <summary> /// Get the limit of patients in a day from db /// </summary> /// <returns></returns> public static int GetMaximumPatientToday() { using (var dc = new QLPM_ModelDataContext()) { return((from ts in dc.THAMSOs select ts.SLBenhNhan).FirstOrDefault()); } }
/// <summary> /// Get the examination fee from db /// </summary> /// <returns></returns> public static decimal GetExaminationFee() { using (var dc = new QLPM_ModelDataContext()) { return((from ts in dc.THAMSOs select ts.TienKham).FirstOrDefault()); } }
/// <summary> /// Saving a new NV to DB /// </summary> /// <param name="nv"></param> public void SaveNewNV(NHANVIEN nv) { using (var dc = new QLPM_ModelDataContext()) { dc.NHANVIENs.InsertOnSubmit(nv); dc.SubmitChanges(); } }
/// <summary> /// Save new data to DB /// </summary> /// <param name="hoso"></param> public void SaveNewHoSo(HOSOBENHNHAN hoso) { using (var dc = new QLPM_ModelDataContext()) { dc.HOSOBENHNHANs.InsertOnSubmit(hoso); dc.SubmitChanges(); } }
/// <summary> /// Load list of profiles from DB /// </summary> private void LoadDS_HoSo() { using (var dc = new QLPM_ModelDataContext()) { (from hs in dc.HOSOBENHNHANs select hs).ToList().ForEach(x => DS_HoSo.Add(x)); } ViewSource = (CollectionView)CollectionViewSource.GetDefaultView(DS_HoSo); }
private void LoadLists() { using (var dc = new QLPM_ModelDataContext()) { dc.THUOCs.Select(x => x).ToList().ForEach(x => DS_Thuoc.Add(x)); dc.CACHDUNGs.Select(x => x).ToList().ForEach(x => DS_CachDung.Add(x)); } ViewSource.Refresh(); }
/// <summary> /// Getting data from DB, criteria: maBenhNhan /// </summary> /// <param name="maBenhNhan"></param> private void ReadList(string maBenhNhan) { using (var dc = new QLPM_ModelDataContext()) { (from pk in dc.PHIEUKHAMBENHs where pk.Ma_BenhNhan == maBenhNhan select pk).ToList().ForEach(x => DS_PhieuKham.Add((PHIEUKHAM)x)); } }
/// <summary> /// Getting data from DB, criteria: date.today /// </summary> /// <returns></returns> private void ReadList(DateTime datePicked) { DS_PhieuKham.Clear(); // Getting data from DB (if exists) using (var dc = new QLPM_ModelDataContext()) { (from pk in dc.PHIEUKHAMBENHs where pk.NgayKham == datePicked select pk).ToList().ForEach(x => DS_PhieuKham.Add((PHIEUKHAM)x)); } }
/// <summary> /// Remove a PHIEUKHAMBENH from DB /// </summary> /// <param name="bn"></param> public static void RemovePhieuKham(BENHNHAN bn) { using (var dc = new QLPM_ModelDataContext()) { var phieukham = dc.PHIEUKHAMBENHs.Single(pk => pk.Ma_BenhNhan == bn.Ma_BenhNhan && pk.NgayKham == DateTime.Today); dc.CT_PHIEUKHAMBENHs.DeleteAllOnSubmit(dc.CT_PHIEUKHAMBENHs.Where(ctpk => ctpk.Ma_PhieuKham == phieukham.Ma_PhieuKham)); dc.PHIEUKHAMBENHs.DeleteOnSubmit(phieukham); dc.SubmitChanges(); } }
/// <summary> /// Getting diseases from DB /// </summary> private void ReadDiseases() { using (var dc = new QLPM_ModelDataContext()) { (from b in dc.BENHs select b).ToList().ForEach(x => { DS_Benh.Add(x); }); } }
private void GetBills() { DS_HoaDon.Clear(); using (var dc = new QLPM_ModelDataContext()) { (from hd in dc.HOADONs where hd.PHIEUKHAMBENH.NgayKham == DateTime.Today select hd).ToList().ForEach(x => DS_HoaDon.Add((CTHOADON)x)); } }
/// <summary> /// Create a new PHIEUKHAMBENH after add a BENHNHAN to DSKHAMBENH /// </summary> /// <param name="bn"></param> public static void AddPhieuKham(BENHNHAN bn) { using (var dc = new QLPM_ModelDataContext()) { var pk = new PHIEUKHAMBENH(); pk.Ma_PhieuKham = GetNewID(pk); pk.Ma_BenhNhan = bn.Ma_BenhNhan; pk.NgayKham = DateTime.Today; dc.PHIEUKHAMBENHs.InsertOnSubmit(pk); dc.SubmitChanges(); } }
/// <summary> /// Load Data from DB /// </summary> /// <param name="maBenhNhan"></param> private void GetData(string maBenhNhan) { using (var dc = new QLPM_ModelDataContext()) { dc.PHIEUKHAMBENHs.Where(x => x.Ma_BenhNhan == maBenhNhan).ToList().ForEach(x => { DS_PhieuKham.Add(new CTTRACUU() { PhieuKham = (PHIEUKHAM)x, HoaDon = (CTHOADON)(x.HOADONs.Single(y => y.Ma_PhieuKham == x.Ma_PhieuKham)) }); }); } }
/// <summary> /// Load lists /// </summary> private void LoadLists() { if (CanGetReport) { ListMonth1.Clear(); ListYear1.Clear(); using (var dc = new QLPM_ModelDataContext()) { (from m in dc.CT_PHIEUKHAMBENHs group m by m.PHIEUKHAMBENH.NgayKham.Month into g select g.Key).ToList().ForEach(x => ListMonth1.Add(x)); (from m in dc.CT_PHIEUKHAMBENHs group m by m.PHIEUKHAMBENH.NgayKham.Year into g select g.Key).ToList().ForEach(x => ListYear1.Add(x)); } } }
private void GetResultBySymtom(string trieuChung) { using (var dc = new QLPM_ModelDataContext()) { var query = (from pk in dc.PHIEUKHAMBENHs join bn in dc.HOSOBENHNHANs on pk.Ma_BenhNhan equals bn.Ma_BenhNhan join be in dc.BENHs on pk.Ma_Benh equals be.Ma_Benh where pk.TrieuChung == trieuChung select new { pk.Ma_PhieuKham, bn.Ma_BenhNhan, bn.Hoten, pk.NgayKham, be.TenBenh, pk.TrieuChung }).ToList(); ViewSource = (CollectionView)CollectionViewSource.GetDefaultView(query); } }
/// <summary> /// Getting all the records from DB /// </summary> private void GetList() { LookUpList = new ObservableCollection <RECORD>(); using (var dc = new QLPM_ModelDataContext()) { (from pk in dc.PHIEUKHAMBENHs join bn in dc.HOSOBENHNHANs on pk.Ma_BenhNhan equals bn.Ma_BenhNhan join be in dc.BENHs on pk.Ma_Benh equals be.Ma_Benh select new RECORD { Ma_BenhNhan = bn.Ma_BenhNhan, HoTen = bn.Hoten, NgayKham = pk.NgayKham, TenBenh = be.TenBenh, TrieuChung = pk.TrieuChung }).ToList().ForEach(x => LookUpList.Add(x)); ViewSource = (CollectionView)CollectionViewSource.GetDefaultView(LookUpList); } }
/// <summary> /// Add a HOADON to DB /// </summary> /// <param name="pk"></param> public static void AddHoaDon(PHIEUKHAM pk) { using (var dc = new QLPM_ModelDataContext()) { if (dc.HOADONs.Any(x => x.Ma_PhieuKham == pk.Ma_PhieuKham)) { var hd = dc.HOADONs.Single(x => x.Ma_PhieuKham == pk.Ma_PhieuKham); if (pk.DONTHUOC.Count > 0) { foreach (var item in pk.DONTHUOC) { hd.TienThuoc += item.SoLuong * item.DonGia; } } dc.SubmitChanges(); } else { var hd = new HOADON(); hd.Ma_HoaDon = GetNewID(hd); hd.Ma_PhieuKham = pk.Ma_PhieuKham; hd.TienKham = (from ts in dc.THAMSOs select ts.TienKham).FirstOrDefault(); if (pk.DONTHUOC.Count > 0) { foreach (var item in pk.DONTHUOC) { hd.TienThuoc += item.SoLuong * item.DonGia; } } dc.HOADONs.InsertOnSubmit(hd); dc.SubmitChanges(); } } }
/// <summary> /// Read the script from an Ma_PhieuKham /// </summary> /// <param name="ma_PhieuKham"></param> /// <returns></returns> private ObservableCollection <CT_DONTHUOC> ReadScript(string ma_PhieuKham) { var donthuoc = new ObservableCollection <CT_DONTHUOC>(); using (var dc = new QLPM_ModelDataContext()) { (from ctpk in dc.CT_PHIEUKHAMBENHs join t in dc.THUOCs on ctpk.Ma_Thuoc equals t.Ma_Thuoc join cd in dc.CACHDUNGs on ctpk.Ma_CachDung equals cd.Ma_CachDung where ctpk.Ma_PhieuKham == ma_PhieuKham select new CT_DONTHUOC() { Ma_PhieuKham = ctpk.Ma_PhieuKham, Ma_Thuoc = ctpk.Ma_Thuoc, TenThuoc = t.TenThuoc, Ma_CachDung = ctpk.Ma_CachDung, TenCachDung = cd.TenCachDung, DonGia = ctpk.DonGia, GhiChu = ctpk.GhiChu }).ToList().ForEach(x => donthuoc.Add(x)); } return(donthuoc); }
/// <summary> /// Get a new ID depends on type of the object /// </summary> /// <typeparam name="T">Type of object</typeparam> /// <param name="obj">Object to be getting a new ID</param> /// <returns></returns> public static string GetNewID <T>(T obj) { var ID = ""; using (var dc = new QLPM_ModelDataContext()) { switch (obj.GetType().Name) { case "HOSOBENHNHAN": if (dc.HOSOBENHNHANs.Count() == 0) { ID = "P000"; } else { ID = "P" + (int.Parse(dc.HOSOBENHNHANs.ToArray().Last().Ma_BenhNhan.Substring(1)) + 1).ToString("000"); } break; case "BENH": if (dc.BENHs.Count() == 0) { ID = "D000"; } else { ID = "D" + (int.Parse(dc.BENHs.ToArray().Last().Ma_Benh.Substring(1)) + 1).ToString("000"); } break; case "NHANVIEN": if (dc.NHANVIENs.Count() == 0) { ID = "E000"; } else { ID = "E" + (int.Parse(dc.NHANVIENs.ToArray().Last().Ma_NV.Substring(1)) + 1).ToString("000"); } break; case "HOADON": if (dc.HOADONs.Count() == 0) { ID = "B000"; } else { ID = "B" + (int.Parse(dc.HOADONs.ToArray().Last().Ma_HoaDon.Substring(1)) + 1).ToString("000"); } break; case "PHIEUKHAMBENH": if (dc.PHIEUKHAMBENHs.Count() == 0) { ID = "R000"; } else { ID = "R" + (int.Parse(dc.PHIEUKHAMBENHs.ToArray().Last().Ma_PhieuKham.Substring(1)) + 1).ToString("000"); } break; case "PHIEUNHAP": if (dc.PHIEUNHAPTHUOCs.Count() == 0) { ID = "I000"; } else { ID = "I" + (int.Parse(dc.PHIEUNHAPTHUOCs.ToArray().Last().Ma_PhieuNhap.Substring(1)) + 1).ToString("000"); } break; case "THUOC": if (dc.THUOCs.Count() == 0) { ID = "P000"; } else { ID = "P" + (int.Parse(dc.THUOCs.ToArray().Last().Ma_Thuoc.Substring(1)) + 1).ToString("000"); } break; case "DONVI": if (dc.DONVIs.Count() == 0) { ID = "U000"; } else { ID = "U" + (int.Parse(dc.DONVIs.ToArray().Last().Ma_DonVi.Substring(1)) + 1).ToString("000"); } break; case "CACHDUNG": if (dc.CACHDUNGs.Count() == 0) { ID = "T000"; } else { ID = "T" + (int.Parse(dc.CACHDUNGs.ToArray().Last().Ma_CachDung.Substring(1)) + 1).ToString("000"); } break; default: break; } } return(ID); }