public List<tb_patient> FindAllPatients() { using (ModelEntities database = new ModelEntities()) { return database.tb_patient.ToList(); } }
public List<tb_profession> FindAllProfession() { using (ModelEntities database = new ModelEntities()) { return database.tb_profession.ToList(); } }
public tb_patient FindPatientByCode(String code) { using (ModelEntities database = new ModelEntities()) { return database.tb_patient.SingleOrDefault(p => p.PatientID == code); } }
public List<tb_patient> FindPatientByAddress(String address, bool exact) { using (ModelEntities database = new ModelEntities()) { if (!exact) return database.tb_patient.Where(p => p.Address.Contains(address)).ToList(); else return database.tb_patient.Where(p => p.Address.Equals(address)).ToList(); } }
public bool UpdatePatient(tb_patient _patient) { using (ModelEntities database = new ModelEntities()) { tb_patient patient = database.tb_patient.SingleOrDefault(p => p.PatientID == _patient.PatientID); patient.FullName = _patient.FullName; patient.Birthday = _patient.Birthday; patient.Address = _patient.Address; patient.Gender = _patient.Gender; patient.MobilePhone = _patient.MobilePhone; patient.Email = _patient.Email; patient.ProfessionID = _patient.tb_profession.ProfessionID; patient.Marital = _patient.Marital; patient.Note = _patient.Note; database.SaveChanges(); return true; } }
private PatientModelManage() { dataContext = new ModelEntities(); }
public bool RemovePatient(string patientID) { using (ModelEntities database = new ModelEntities()) { tb_patient patient = database.tb_patient.SingleOrDefault(p => p.PatientID == patientID); database.tb_patient.Remove(patient); database.SaveChanges(); return true; } }
public List<tb_patient> FindPatientsByManyConds(String name, String address, String gender, String age, String time) { using (ModelEntities database = new ModelEntities()) { var query = database.tb_patient.AsQueryable(); if (name != null && !name.Equals("")) query = query.Where(p => p.FullName.Contains(name)); if (address != null && !address.Equals("")) query = query.Where(p => p.Address.Contains(address)); if (gender != null && !gender.Equals("")) query = query.Where(p => p.Gender.Equals(gender)); switch (age.ToString()) { case "<5": query = query.Where(p => p.Birthday >= DbFunctions.AddYears(DateTime.Now, -5)); break; case "5-10": query = query.Where(p => p.Birthday >= DbFunctions.AddYears(DateTime.Now, -10) && p.Birthday <= DbFunctions.AddYears(DateTime.Now, -5)); break; case "10-15": query = query.Where(p => p.Birthday >= DbFunctions.AddYears(DateTime.Now, -15) && p.Birthday <= DbFunctions.AddYears(DateTime.Now, -10)); break; case "15-30": query = query.Where(p => p.Birthday >= DbFunctions.AddYears(DateTime.Now, -30) && p.Birthday <= DbFunctions.AddYears(DateTime.Now, -15)); break; case "30-60": query = query.Where(p => p.Birthday >= DbFunctions.AddYears(DateTime.Now, -60) && p.Birthday <= DbFunctions.AddYears(DateTime.Now, -30)); break; case ">60": query = query.Where(p => p.Birthday <= DbFunctions.AddYears(DateTime.Now, -60)); break; } return query.ToList(); } }
public List<tb_patient> FindPatientByName(String name, bool exact) { using (ModelEntities database = new ModelEntities()) { if (!exact) return database.tb_patient.Where(p => p.FullName.Contains(name)).ToList(); else return database.tb_patient.Where(p => p.FullName.Equals(name)).ToList(); } }
public List<tb_patient> FindPatientByMobile(String mobile, bool exact) { using (ModelEntities database = new ModelEntities()) { if (!exact) return database.tb_patient.Where(p => p.MobilePhone.Contains(mobile)).ToList(); else return database.tb_patient.Where(p => p.MobilePhone.Equals(mobile)).ToList(); } }
public List<tb_patient> FindPatientByCode(String code, bool exact) { List<tb_patient> list = null; using (ModelEntities database = new ModelEntities()) { if (!exact) list = database.tb_patient.Where(p => p.PatientID.Contains(code)).ToList(); else { list = new List<tb_patient>(); list.Add(database.tb_patient.SingleOrDefault(p => p.PatientID == code)); } return list; } }