public void UpdatePKDK(DTO_PKDaKhoa pkdk) { using (var context = new SQLServerDBContext()) { context.Entry(pkdk).State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateCTBaoCaoDoanhThu(DTO_CTBaoCaoDoanhThu cTBaoCaoDoanhThu) { using (var context = new SQLServerDBContext()) { context.Entry(cTBaoCaoDoanhThu).State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateBCDoanhThu(DTO_BCDoanhThu bc) { using (var context = new SQLServerDBContext()) { context.Entry(bc).State = EntityState.Modified; context.SaveChanges(); } }
public void LoadNPCTBaoCaoDoanhThu(DTO_BCDoanhThu bCDoanhThu) { using (var context = new SQLServerDBContext()) { context.BaoCaoDoanhThu.Attach(bCDoanhThu); var entry = context.Entry(bCDoanhThu); entry.Collection(bc => bc.DS_CTBaoCaoDoanhThu).Load(); } }
public bool UpdateInfo(DTO_BenhNhan bn) { using (var context = new SQLServerDBContext()) { try { context.Entry(bn).State = EntityState.Modified; context.SaveChanges(); return(true); } catch (Exception e) { throw e; } } }
public bool LoadNPPKDaKhoa(DTO_PKChuyenKhoa pKChuyenKhoa) { try { using (var context = new SQLServerDBContext()) { context.PKChuyenKhoa.Attach(pKChuyenKhoa); var entry = context.Entry(pKChuyenKhoa); entry.Reference(p => p.PhieuKhamDaKhoa).Load(); return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL_PKCHUYENKHOA] {e.Message}"); return(false); } }
public void UpdateThamSo(List <DTO_ThamSo> thamSo) { using (var context = new SQLServerDBContext()) { try { foreach (var ts in thamSo) { context.Entry(ts).State = EntityState.Modified; } context.SaveChanges(); } catch (Exception e) { throw e; } } }
public bool LoadNPCachDung(DTO_CTDonThuoc ctDonThuoc) { try { using (var context = new SQLServerDBContext()) { context.CT_DonThuoc.Attach(ctDonThuoc); var entry = context.Entry(ctDonThuoc); entry.Reference(p => p.CachDung).Load(); return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL CTDonThuoc] {e.Message}"); return(false); } }
public bool LoadNP_DSPKCK(DTO_PKDaKhoa pKDaKhoa) { try { using (var context = new SQLServerDBContext()) { context.PKDaKhoa.Attach(pKDaKhoa); var entry = context.Entry(pKDaKhoa); entry.Collection(p => p.DS_PKhamChuyenKhoa).Load(); return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR LOADNP_DSPKCK] {e.Message}"); return(false); } }
public bool LoadNPBenhNhan(DTO_HoaDon hoaDon) { try { using (var context = new SQLServerDBContext()) { context.HoaDon.Attach(hoaDon); var entry = context.Entry(hoaDon); entry.Reference(p => p.BenhNhan).Load(); return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL HOADON] {e.Message}"); return(false); } }
public bool LoadNPGroup(DTO_NhanVien nhanVien) { try { using (var context = new SQLServerDBContext()) { context.NhanVien.Attach(nhanVien); var entry = context.Entry(nhanVien); //if (!entry.Reference(p => p.Nhom).IsLoaded) entry.Reference(p => p.Nhom).Load(); return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL NHANVIEN] {e.Message}"); return(false); } }
public bool LoadNP_PhieuNhapThuoc(DTO_CTPhieuNhapThuoc cTPhieuNhapThuoc) { try { using (var context = new SQLServerDBContext()) { context.CTPhieuNhapThuoc.Attach(cTPhieuNhapThuoc); var entry = context.Entry(cTPhieuNhapThuoc); if (!entry.Reference(p => p.PhieuNhapThuoc).IsLoaded) { entry.Reference(p => p.PhieuNhapThuoc).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL CTPHIEUNHAPTHUOC] {e.Message}"); return(false); } }
public bool LoadNP_DSPKDK(DTO_BenhNhan bn) { try { using (var context = new SQLServerDBContext()) { context.BenhNhan.Attach(bn); var entry = context.Entry(bn); if (!entry.Collection(p => p.DS_PKDaKhoa).IsLoaded) { entry.Collection(p => p.DS_PKDaKhoa).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR LOADNP_DSPKDK] {e.Message}"); return(false); } }
public bool LoadNPThuoc(DTO_CTHDThuoc cTHDThuoc) { try { using (var context = new SQLServerDBContext()) { context.CTHoaDdonThuoc.Attach(cTHDThuoc); var entry = context.Entry(cTHDThuoc); if (!entry.Reference(p => p.Thuoc).IsLoaded) { entry.Reference(p => p.Thuoc).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL BENH] {e.Message}"); return(false); } }
public bool LoadNPBenhNhan(DTO_PKDaKhoa pKDaKhoa) { try { using (var context = new SQLServerDBContext()) { context.PKDaKhoa.Attach(pKDaKhoa); var entry = context.Entry(pKDaKhoa); if (!entry.Reference(p => p.BenhNhan).IsLoaded) { entry.Reference(p => p.BenhNhan).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL_PKDAKHOA] {e.Message}"); return(false); } }
public bool LoadNPNhanVien(DTO_Account acc) { try { using (var context = new SQLServerDBContext()) { context.Account.Attach(acc); var entry = context.Entry(acc); if (!entry.Reference(p => p.NhanVien).IsLoaded) { entry.Reference(p => p.NhanVien).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL ACCOUNT] {e.Message}"); return(false); } }
public bool LoadNP_DSCTDonThuoc(DTO_DonThuoc donThuoc) { try { using (var context = new SQLServerDBContext()) { context.DonThuoc.Attach(donThuoc); var entry = context.Entry(donThuoc); if (!entry.Collection(p => p.DS_CTDonThuoc).IsLoaded) { entry.Collection(p => p.DS_CTDonThuoc).Load(); } return(true); } } catch (Exception e) { Debug.WriteLine($"[ERRROR DAL DonThuoc] {e.Message}"); return(false); } }