public bool DeleteNguoiDungByID(int IDNguoiDung) { DataClassesDataContext data = new DataClassesDataContext(Connection); NguoiDung nguoiDung = data.NguoiDungs.Where(i => i.IDNguoiDung == IDNguoiDung).SingleOrDefault(); data.NguoiDungs.DeleteOnSubmit(nguoiDung); try { data.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool DeleteBenhNhanByID(string IDBenhNhan) { DataClassesDataContext data = new DataClassesDataContext(Connection); BenhNhan BenhNhan = data.BenhNhans.Where(i => i.ID == IDBenhNhan).SingleOrDefault(); data.BenhNhans.DeleteOnSubmit(BenhNhan); try { data.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool DeleteNhomNDByID(int ID) { DataClassesDataContext dataContext = new DataClassesDataContext(Connection); NhomND listPQNhom = dataContext.NhomNDs.Where(i => i.IDNhomND == ID).SingleOrDefault(); if (listPQNhom != null) { dataContext.NhomNDs.DeleteOnSubmit(listPQNhom); try { dataContext.SubmitChanges(); return true; } catch (Exception) { return false; } } else return true; }
public bool DeletePQNhomByIDNhom(int IDNhomND) { DataClassesDataContext dataContext = new DataClassesDataContext(Connection); List<PQNhom> listPQNhom = dataContext.PQNhoms.Where(i => i.IDNhomND == IDNhomND).ToList(); if (listPQNhom.Count > 0 && listPQNhom != null) { dataContext.PQNhoms.DeleteAllOnSubmit(listPQNhom); try { dataContext.SubmitChanges(); return true; } catch (Exception) { return false; } } else return true; }
public bool UpdateNhomND(NhomND nhomND) { DataClassesDataContext data = new DataClassesDataContext(Connection); NhomND NDOld = data.NhomNDs.Where(i => i.IDNhomND == nhomND.IDNhomND).SingleOrDefault(); NDOld.IsAdminGroup = nhomND.IsAdminGroup; NDOld.Madv = nhomND.Madv; NDOld.MoTa = nhomND.MoTa; NDOld.Parent = nhomND.Parent; try { data.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool UpdateNguoiDung(NguoiDung nguoiDung) { DataClassesDataContext data = new DataClassesDataContext(Connection); NguoiDung NDOld = data.NguoiDungs.Where(i => i.IDNguoiDung == nguoiDung.IDNguoiDung).SingleOrDefault(); NDOld.Active = nguoiDung.Active; NDOld.DiaChi = nguoiDung.DiaChi; NDOld.DienThoai = nguoiDung.DienThoai; NDOld.Email = nguoiDung.Email; NDOld.IDNhomND = nguoiDung.IDNhomND; NDOld.IsAdmin = nguoiDung.IsAdmin; NDOld.KhoRole = nguoiDung.KhoRole; NDOld.MatKhau = nguoiDung.MatKhau; NDOld.Mapb = nguoiDung.Mapb; NDOld.TenDangNhap = nguoiDung.TenDangNhap; NDOld.TenHienThi = nguoiDung.TenHienThi; try { data.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool UpdateBenhNhan(BenhNhan BenhNhan) { DataClassesDataContext data = new DataClassesDataContext(Connection); BenhNhan NDOld = data.BenhNhans.Where(i => i.ID == BenhNhan.ID).SingleOrDefault(); NDOld.DiaChi = BenhNhan.DiaChi; NDOld.ID = BenhNhan.ID; NDOld.NgayKhamLanDau = BenhNhan.NgayKhamLanDau; NDOld.NgaySinh = BenhNhan.NgaySinh; NDOld.SoDT = BenhNhan.SoDT; NDOld.TenBN = BenhNhan.TenBN; try { data.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool InsertPQNhom(PQNhom pqNhom) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.PQNhoms.InsertOnSubmit(pqNhom); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
public bool InsertNhomND(NhomND nhomND) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.NhomNDs.InsertOnSubmit(nhomND); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
public bool InsertNguoiDung(NguoiDung nguoiDung) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.NguoiDungs.InsertOnSubmit(nguoiDung); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
// public bool InsertListCTBenhNhanSnapShot(List<CTBenhNhanSnapShot> listCTBenhNhanSnapShot) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.CTBenhNhanSnapShots.InsertAllOnSubmit(listCTBenhNhanSnapShot); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
// public bool InsertListCTBenhNhanConditionVertebral(List<CTBenhNhanConditionVertebral> listCTBenhNhanConditionVertebral) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.CTBenhNhanConditionVertebrals.InsertAllOnSubmit(listCTBenhNhanConditionVertebral); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
public bool InsertCTBenhNhanMRIImage(CTBenhNhanMRIImage CTBenhNhanMRIImage) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.CTBenhNhanMRIImages.InsertOnSubmit(CTBenhNhanMRIImage); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
public bool InsertCTBenhNhanConditionDicsJoint(CTBenhNhanConditionDicsJoint CTBenhNhanDicsJoint) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.CTBenhNhanConditionDicsJoints.InsertOnSubmit(CTBenhNhanDicsJoint); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }
public bool InsertBenhNhan(BenhNhan BenhNhan) { DataClassesDataContext data = new DataClassesDataContext(Connection); data.BenhNhans.InsertOnSubmit(BenhNhan); try { data.SubmitChanges(); return true; } catch (Exception e) { return false; } }