public int SaveHospital(HealthFacilityModel model) { using (var db = new HMISDBContext()) { var trans = db.Database.BeginTransaction(); try { if (model != null && !string.IsNullOrEmpty(model.HFMISCode)) { var HealthFacility = db.HealthFacilityDetails.Where(a => a.HFMISCode == model.HFMISCode).FirstOrDefault(); if (string.IsNullOrEmpty(HealthFacility.HFMISCode)) { var UpdatedHealthFacility = this._mapper.Map <HealthFacilityModel, HealthFacilityDetail>(model, HealthFacility); db.Entry(UpdatedHealthFacility).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } } else { var NewHF = this._mapper.Map <HealthFacilityDetail>(model); NewHF.HFMISCode = NewHF.DivisionCode + NewHF.DistrictCode + NewHF.TehsilCode; db.HealthFacilityDetails.AddAsync(NewHF); } db.SaveChanges(); trans.Commit(); return(1); } catch (Exception ex) { trans.Rollback(); return(-1); } } }
public object DeleteHealthFacility(string HFMISCode) { try { using (var db = new HMISDBContext()) { var HealthFacility = db.HealthFacilityDetails.Where(a => a.HFMISCode == HFMISCode).FirstOrDefault(); if (HealthFacility != null && HealthFacility.HFMISCode == HFMISCode) { db.HealthFacilityDetails.Remove(HealthFacility); db.SaveChanges(); } } return(true); } catch (Exception) { throw; } }
public int SavePatient(PatientRegistrationDTO model) { int Result = 0; using (var db = new HMISDBContext()) { var trans = db.Database.BeginTransaction(); try { if (model != null && !string.IsNullOrEmpty(model.CNIC)) { var PatientData = db.PatientRegistrations.Where(a => a.ID == model.id).FirstOrDefault(); if (PatientData != null) { var UpdatedHealthFacility = this._mapper.Map <PatientRegistrationDTO, PatientRegistration>(model, PatientData); db.Entry(UpdatedHealthFacility).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } else { var CurrentDate = DateTime.Now; var NewPatient = this._mapper.Map <PatientRegistration>(model); db.PatientRegistrations.AddAsync(NewPatient); } } else { Result = -1; } db.SaveChanges(); trans.Commit(); Result = 1; } catch (Exception ex) { trans.Rollback(); Result = -1; } return(Result); } }
public int AddPatientVitals(PatientVitalsDTO model) { int Result = 0; using (var db = new HMISDBContext()) { var trans = db.Database.BeginTransaction(); try { var CurrentDate = DateTime.Now; var PatientVital = this._mapper.Map <PatientVital>(model); db.PatientVitals.AddAsync(PatientVital); db.SaveChanges(); trans.Commit(); Result = 1; } catch (Exception ex) { trans.Rollback(); Result = -1; } return(Result); } }