public void savePatient(PatientEntity obj) { try { using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer()) { EDMX.tblPatient pat = new EDMX.tblPatient { Id = obj.PatientId, LastName = obj.LastName, FirstName = obj.FirstName, MiddleName = obj.MiddleName, FacilityID = obj.FacilityId, Active = obj.Active, DateCreated = obj.DateCreated, DateUpdated = obj.DateUpdated }; db.tblPatients.Add(pat); db.SaveChanges(); } } catch (Exception ex) { ErrorLogging.Log(ex, this.Name, "Method Save Patient"); MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void updatePatient(PatientEntity obj) { try { using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer()) { EDMX.tblPatient pat = db.tblPatients.Where(x => x.Id == obj.PatientId).FirstOrDefault(); pat.LastName = obj.LastName; pat.FirstName = obj.FirstName; pat.MiddleName = obj.MiddleName; pat.FacilityID = obj.FacilityId; pat.Active = obj.Active; pat.DateCreated = obj.DateCreated; pat.DateUpdated = obj.DateUpdated; db.SaveChanges(); } } catch (Exception ex) { ErrorLogging.Log(ex, this.Name, "Method Update Patient"); MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public PatientEntity searchPatientByID(int patientID) { PatientEntity obj = new PatientEntity(); try { using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer()) { EDMX.tblPatient pat = db.tblPatients.FirstOrDefault(x => x.Id == patientID); if (pat != null) { obj.PatientId = pat.Id; obj.FacilityId = pat.FacilityID; obj.FacilityName = pat.tblFacility.Name; obj.LastName = pat.LastName; obj.FirstName = pat.FirstName; obj.MiddleName = pat.MiddleName; obj.Active = pat.Active; obj.DateCreated = pat.DateCreated; obj.DateUpdated = pat.DateUpdated; } else { obj = null; } } } catch (Exception ex) { ErrorLogging.Log(ex, this.Name, "Method Search Patient By ID"); MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); obj = null; } return(obj); }