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);
}
}