/// <summary> /// Service method to get all patients /// </summary> /// <returns>Data table</returns> public DataTable GetAll() { using (var context = new FHIRDbContext()) { IList <PatientEntity> patients = context.Patients.Where(i => i.SoftDelete == false).ToList(); return(patients.ToDataTable <PatientEntity>()); } }
/// <summary> /// Service method to create patient /// </summary> /// <param name="patient">patient model</param> /// <returns>true or false</returns> public bool Create(PatientEntity patient) { using (var context = new FHIRDbContext()) { context.Patients.Add(patient); return(context.SaveChanges() > 0); } }
/// <summary> /// Method to delete a patient /// </summary> /// <param name="id">patient id</param> /// <returns>true / false</returns> public bool DeletefromDB(int id) { using (var context = new FHIRDbContext()) { var patient = context.Patients.Find(id); context.Patients.Remove(patient); return(context.SaveChanges() > 0); } }
/// <summary> /// Service method to update patient /// </summary> /// <param name="patient">patient</param> /// <returns>true / false</returns> public bool Update(PatientEntity patient) { using (var context = new FHIRDbContext()) { context.Patients.Attach(patient); context.Entry(patient).State = EntityState.Modified; return(context.SaveChanges() > 0); } }
/// <summary> /// Service method to search records by multiple parameters /// </summary> /// <param name="filter">filter string</param> /// <returns>Data table</returns> public DataTable Search(string filter) { using (var context = new FHIRDbContext()) { List <PatientEntity> patients = context.Patients.Where(i => (i.Name.Contains(filter) && i.SoftDelete == false)) .ToList(); return(patients.ToDataTable <PatientEntity>()); } }
/// <summary> /// Method to soft delete a patient /// </summary> /// <param name="id">patient id</param> /// <returns>true / false</returns> public bool Delete(int id) { using (var context = new FHIRDbContext()) { var patient = context.Patients.Find(id); patient.SoftDelete = true; context.Patients.Attach(patient); context.Entry(patient).State = EntityState.Modified; return(context.SaveChanges() > 0); } }
/// <summary> /// Service method to get patient by Id /// </summary> /// <param name="id">patient id</param> /// <returns>Data row</returns> public DataRow GetById(int id) { using (var context = new FHIRDbContext()) { PatientEntity membership = context.Patients .Where(i => i.Id == id) .SingleOrDefault(); return(membership.ToDataRow <PatientEntity>()); } }
/// <summary> /// Service method to batch create patient /// </summary> /// <param name="patient">patient list</param> /// <returns>true or false</returns> public bool BatchCreate(List <PatientEntity> patientlist) { using (var context = new FHIRDbContext()) { try { foreach (var row in patientlist) { context.Patients.Add(row); } return(context.SaveChanges() > 0); } catch (Exception ex) { return(false); } } }