private bool IsExist(PatientDetailModel model)
{
try
{
Expression <Func <PatientDetail, bool> > predicate = null;
using (var db = new HMSEntities())
{
/* Build Predicate according to Create or Update */
if (!model.Id.HasValue)
{
predicate = o => o.IsActive == true && o.CasePaperNumber == model.CasePaperNumber && o.IsDeleted == false;//for Create Record
}
else
{
predicate = o => o.Id != model.Id && o.CasePaperNumber == model.CasePaperNumber && o.IsActive == true && o.IsDeleted == false;//for Update Record Record
}
/* return is Exist or not */
if (db.PatientDetails.Any(predicate))
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool saveData()
{
try
{
PatientDetailModel model = assignModel();
if (model != null)
{
if (this.currentUserId.HasValue)
{
return(service.Update(assignModel()));
}
else
{
return(service.Create(assignModel()));
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
Utility.ErrorLog.Logging("Dashboard", ex.Message.ToString(), ex.StackTrace.ToString());
return(false);
}
}
public List <PatientDetailModel> GetGenericReport(Expression <Func <PatientDetail, bool> > predicate)
{
try
{
List <PatientDetailModel> list = new List <PatientDetailModel>();
using (var db = new HMSEntities())
{
var data = db.PatientDetails.Where(t => t.IsDischarged == true).Where(predicate).OrderBy(t => t.CreatedOn).ToList();
foreach (PatientDetail t in data)
{
PatientDetailModel model = new PatientDetailModel();
model.Id = t.Id;
model.FullName = t.FullName;
model.Address = t.Address;
model.CasePaperNumber = t.CasePaperNumber;
model.Gender = t.Gender;
model.PhoneNumber = t.PhoneNumber;
model.MobileNumber = t.MobileNumber;
model.Age = t.Age;
model.IsAdmitted = t.IsAdmitted;
model.AdmittedDate = t.AdmittedDate;
model.IsDischarged = t.IsDischarged;
model.DischargedDate = t.DischargedDate;
model.RefferedDoctor = t.RefferedDoctor;
model.RefferedDoctorName = t.DoctorDetail.FullName;
model.CasePaperIssuedDate = t.CasePaperIssuedDate;
model.CasePaperExpiryDate = t.CasePaperExpiryDate;
model.WardNumberId = t.WardNumberId;
model.WardName = t.WardDetail != null ? t.WardDetail.Name : string.Empty;
model.RoomNumber = t.RoomNumber;
model.RoomTypeId = t.RoomTypeId;
model.RoomTypeName = t.RoomType != null ? t.RoomType.Name : string.Empty;
model.DepartmentId = t.DepartmentId;
model.DepartmentName = t.Department != null ? t.Department.Name : string.Empty;
model.AadharCard = t.AadharCard;
model.PanCard = t.PanCard;
model.IsActive = t.IsActive;
model.IsDeleted = t.IsDeleted;
model.CreatedOn = t.CreatedOn;
model.CreatedBy = t.CreatedBy;
model.ModifiedOn = t.ModifiedOn;
model.ModifiedBy = t.ModifiedBy;
model.IPDBillAmount = t.IPDHistories.Any(o => o.PatientId == t.Id) ? t.IPDHistories.FirstOrDefault(o => o.PatientId == t.Id).TotalAmount : 0.00M;
model.ReceivedBy = t.IPDHistories.Any(o => o.PatientId == t.Id) ? t.IPDHistories.FirstOrDefault(o => o.PatientId == t.Id).ReceivedBy : null;
model.ReceivedName = model.ReceivedBy.HasValue ? UserDetail.GetNameById(model.ReceivedBy.Value) : string.Empty;
list.Add(model);
}
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> Details(int id)
{
var patientDetailModel = new PatientDetailModel
{
Patient = await _patientService.GetByIdAsync(id),
PatientNotes = await _patientNoteService.GetByPatientIdAsync(id)
};
return(View(patientDetailModel));
}
public bool CreateOPD(PatientDetailModel model)
{
try
{
PatientDetail entity = new PatientDetail();
return(entity.CreateOPD(model));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(PatientDetailModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
PatientDetail entity = db.PatientDetails.Find(model.Id);
entity.FullName = model.FullName;
entity.Address = model.Address;
entity.CasePaperNumber = model.CasePaperNumber;
entity.Gender = model.Gender;
entity.PhoneNumber = model.PhoneNumber;
entity.MobileNumber = model.MobileNumber;
entity.Age = model.Age;
entity.IsAdmitted = model.IsAdmitted;
entity.AdmittedDate = model.AdmittedDate;
entity.IsDischarged = model.IsDischarged;
entity.DischargedDate = model.DischargedDate;
entity.RefferedDoctor = model.RefferedDoctor;
entity.CasePaperIssuedDate = model.CasePaperIssuedDate;
entity.WardNumberId = model.WardNumberId;
entity.RoomNumber = model.RoomNumber;
entity.RoomTypeId = model.RoomTypeId;
entity.DepartmentId = model.DepartmentId;
entity.AadharCard = model.AadharCard;
entity.PanCard = model.PanCard;
entity.ModifiedOn = DateTime.Now;
entity.ModifiedBy = UserDetailSession.Id;
db.SaveChanges();
if (entity.IsDischarged.Value)
{
isSaved = CreateIPDHistory(entity.Id, model.IPDBillAmount);
}
isSaved = true;
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public PatientDetailModel GetById(Guid id)
{
try
{
PatientDetailModel model = new PatientDetailModel();
using (var db = new HMSEntities())
{
PatientDetail entity = db.PatientDetails.Find(id);
if (entity != null)
{
model.Id = entity.Id;
model.FullName = entity.FullName;
model.Address = entity.Address;
model.CasePaperNumber = entity.CasePaperNumber;
model.Gender = entity.Gender;
model.PhoneNumber = entity.PhoneNumber;
model.MobileNumber = entity.MobileNumber;
model.Age = entity.Age;
model.IsAdmitted = entity.IsAdmitted;
model.AdmittedDate = entity.AdmittedDate;
model.IsDischarged = entity.IsDischarged;
model.DischargedDate = entity.DischargedDate;
model.RefferedDoctor = entity.RefferedDoctor;
model.RefferedDoctorName = entity.DoctorDetail != null ? entity.DoctorDetail.FullName : "";
model.CasePaperIssuedDate = entity.CasePaperIssuedDate;
model.CasePaperExpiryDate = entity.CasePaperExpiryDate;
model.WardNumberId = entity.WardNumberId;
model.WardName = entity.WardDetail != null ? entity.WardDetail.Name : "";
model.RoomNumber = entity.RoomNumber;
model.RoomTypeId = entity.RoomTypeId;
model.RoomTypeName = entity.RoomType != null ? entity.RoomType.Name : "";
model.DepartmentId = entity.DepartmentId;
model.DepartmentName = entity.Department != null ? entity.Department.Name : "";
model.AadharCard = entity.AadharCard;
model.PanCard = entity.PanCard;
model.IsActive = entity.IsActive;
model.IsDeleted = entity.IsDeleted;
model.CreatedOn = entity.CreatedOn;
model.CreatedBy = entity.CreatedBy;
model.ModifiedOn = entity.ModifiedOn;
model.ModifiedBy = entity.ModifiedBy;
model.IPDBillAmount = GetIPDHistory(model.Id);
}
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="parameter"></param>
public void Execute(object parameter)
{
PatientDetailModel patientDetail = parameter as PatientDetailModel;
PatientDetailModel patient = new PatientManager().Search(patientDetail.Id);
if (patient == null)
{
MessageBox.Show("Patient with this ID does not exist !");
}
else
{
patientDetail.Id = patient.Id;
patientDetail.Name = patient.Name;
}
}
/// <summary>
///
/// </summary>
/// <param name="parameter"></param>
public void Execute(object parameter)
{
PatientManager patientManager = new PatientManager();
PatientDetailModel patientDetail = parameter as PatientDetailModel;
if (patientManager.Add(new PatientDetailModel {
Id = patientDetail.Id, Name = patientDetail.Name
}))
{
MessageBox.Show("Patient Add Successful !");
}
else
{
MessageBox.Show("Patient with this ID already exists !");
}
}
public bool UpdateCasePaperDate(PatientDetailModel model)
{
using (var db = new HMSEntities())
{
PatientDetail entity = db.PatientDetails.Find(model.Id);
TimeSpan ts = DateTime.Now.Date - entity.CasePaperExpiryDate.Value.Date;
if (ts.TotalDays > 0)
{
entity.CasePaperIssuedDate = DateTime.Now;
entity.CasePaperExpiryDate = DateTime.Now.AddMonths(2);
entity.ModifiedBy = UserDetailSession.Id;
entity.ModifiedOn = DateTime.Now;
db.SaveChanges();
return(true);
}
}
return(false);
}
private void FillFormData(Guid?id)
{
try
{
PatientDetailModel model = service.GetById(id.Value);
if (model != null)
{
PatientDetails frm = new PatientDetails(model.Id);
frm.dtpIssueDate.Enabled = true;
frm.txtCasePaper.Text = model.CasePaperNumber;
frm.dtpIssueDate.Value = model.CasePaperIssuedDate.Value;
frm.txtFullName.Text = model.FullName;
frm.txtAadharcard.Text = model.AadharCard;
frm.txtPanCard.Text = model.PanCard;
frm.chkIsDischarged.Checked = model.IsDischarged.HasValue ? model.IsDischarged.Value : false;
frm.txtDepartment.Text = model.RoomNumber;
frm.txtMobileNumber.Text = model.MobileNumber;
frm.txtPhoneNumber.Text = model.PhoneNumber;
frm.txtAge.Text = Convert.ToString(model.Age);
frm.txtAddress.Text = model.Address;
setGender(ref frm, model.Gender.Value);
frm.ddlDepartment.SelectedValue = model.DepartmentId.HasValue ? model.DepartmentId : Guid.Empty;
frm.ddlRefDoctor.SelectedValue = model.RefferedDoctor.HasValue ? model.RefferedDoctor : Guid.Empty;
frm.dtpInTime.Enabled = false;
frm.chkCharity.Enabled = false;
frm.chkLabCharity.Enabled = false;
frm.chkXRay.Enabled = false;
frm.chkECG.Enabled = false;
frm.txtDischargeAmount.Text = Convert.ToString(model.IPDBillAmount);
frm.ShowDialog();
if (isSubmited)
{
Search();
}
isSubmited = false;
}
}
catch (Exception ex)
{
isSubmited = false;
Utility.ErrorLog.Logging("Patient List", ex.InnerException.ToString(), ex.StackTrace.ToString());
}
}
private PatientDetailModel assignModel()
{
try
{
PatientDetailModel model = new PatientDetailModel();
model.Id = this.currentUserId;
model.CasePaperNumber = txtCasePaper.Text;
model.FullName = txtFullName.Text;
model.CasePaperIssuedDate = dtpIssueDate.Value;
model.AadharCard = txtAadharcard.Text;
model.PanCard = txtPanCard.Text;
model.IsDischarged = chkIsDischarged.Checked;
model.RoomNumber = txtDepartment.Text;
model.RefferedDoctor = new Guid(ddlRefDoctor.SelectedValue.ToString());
model.MobileNumber = txtMobileNumber.Text;
model.PhoneNumber = txtPhoneNumber.Text;
model.DepartmentId = new Guid(ddlDepartment.SelectedValue.ToString());
model.Address = txtAddress.Text;
model.Age = Convert.ToInt32(txtAge.Text);
model.Gender = getGender();
model.OPDHistory = new OPDHistoryModel();
model.OPDHistory.InTime = dtpInTime.Value;
//model.OPDHistory.Amount = Convert.ToDecimal(txtOPDAmount.Text);
//model.OPDHistory.LabTestingAmount = 0.00M;
//model.OPDHistory.TotalAmount = model.OPDHistory.Amount;
//model.OPDHistory.PaidAmount = model.OPDHistory.PayingAmount;
//model.OPDHistory.DueAmount = model.OPDHistory.Amount - model.OPDHistory.PayingAmount;
model.OPDHistory.IsCharity = chkCharity.Checked;
model.OPDHistory.IsLabCharity = chkLabCharity.Checked;
model.OPDHistory.IsECG = chkECG.Checked;
model.OPDHistory.XRAYAmount = chkXRay.Checked ? lookupService.GetRatesByType("XRAY").Rate *Convert.ToDecimal(txtNumberOfXRay.Text) : 0.00M;
model.OPDHistory.NumberofXRAY = txtNumberOfXRay.Text != string.Empty ? Convert.ToInt32(txtNumberOfXRay.Text) : 0;
model.OPDHistory.IsXRAY = chkXRay.Checked;
model.IPDBillAmount = txtDischargeAmount.Text != string.Empty ? Convert.ToDecimal(txtDischargeAmount.Text) : 0.00M;
model.IsOldPatient = chkOldPatient.Checked;
model.OPDHistory.ConsultingDoctorId = new Guid(ddlConsulting.SelectedValue.ToString());
return(model);
}
catch (Exception ex)
{
Utility.ErrorLog.Logging("Patient Details", ex.Message.ToString(), ex.StackTrace.ToString());
return(null);
}
}
public void AddPatientDetailsToDb(PatientDetailModel p_Details)
{
return;
SqlConnection conn = new SqlConnection("Server = demosql001.cc4mi4fhf4fo.ap-southeast-2.rds.amazonaws.com; Database = WHADemo; User Id = whadevfe; Password = 4MeW3%T7JxMA;");
SqlCommand cmd = new SqlCommand("POBPatientSave", conn);
////string connectionString = "Data Source=DESKTOP-SK0EJ1N;Initial Catalog=testdatabase;Integrated Security=True";
//SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
//SqlCommand cmd = new SqlCommand("INSERT INTO Persons;", conn);
//cmd.CommandType = CommandType.StoredProcedure;
//SqlCommandBuilder.DeriveParameters(cmd);
foreach (SqlParameter p in cmd.Parameters)
{
PersonalDetailsDict.Add(p.ParameterName, p_Details.CountryID);
Console.WriteLine(p.ParameterName);
}
}
public bool CreateOPD(PatientDetailModel model)
{
try
{
bool isSaved = false;
using (var db = new HMSEntities())
{
bool isExpire = UpdateCasePaperDate(model);
OPDHistoryModel historyEntity = new OPDHistoryModel();
historyEntity.PatientId = model.Id;
historyEntity.InTime = DateTime.Now;
historyEntity.IsCharity = false;
historyEntity.IsLabCharity = false;
historyEntity.IsECG = false;
historyEntity.IsXRAY = false;
historyEntity.CasePaperNumber = model.CasePaperNumber;
//historyEntity.Amount = isExpire ? OPDRate.GetRatesByType("New").Rate : OPDRate.GetRatesByType("FollowUP").Rate;
//historyEntity.DueAmount = isExpire ? OPDRate.GetRatesByType("New").Rate : OPDRate.GetRatesByType("FollowUP").Rate;
historyEntity.ECGAmount = 0.00M;
historyEntity.XRAYAmount = 0.00M;
historyEntity.ThirdPartyLabAmoumt = 0.00M;
historyEntity.ConsultingDoctorId = new DoctorDetail().GetName("SIR");
historyEntity.TotalAmount = historyEntity.PaidAmount = historyEntity.LabTestingAmount = Convert.ToDecimal(0.00);
historyEntity.PatientDetails = new PatientDetailModel();
historyEntity.PatientDetails = model;
historyEntity.NumberofXRAY = 0;
isSaved = new OPDHistory().Create(historyEntity, isExpire ? 0 : 1);
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Create(PatientDetailModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
PatientDetail entity = new PatientDetail();
entity.FullName = model.FullName;
entity.Address = model.Address;
entity.CasePaperNumber = model.CasePaperNumber;
entity.Gender = model.Gender;
entity.PhoneNumber = model.PhoneNumber;
entity.MobileNumber = model.MobileNumber;
entity.Age = model.Age;
entity.IsAdmitted = model.IsAdmitted;
entity.AdmittedDate = model.AdmittedDate;
entity.IsDischarged = model.IsDischarged.HasValue ? model.IsDischarged : false;
entity.DischargedDate = model.DischargedDate;
entity.RefferedDoctor = model.RefferedDoctor;
entity.CasePaperIssuedDate = model.CasePaperIssuedDate;
entity.CasePaperExpiryDate = model.CasePaperIssuedDate.HasValue ? model.CasePaperIssuedDate.Value.AddMonths(2) : model.CasePaperExpiryDate;
entity.WardNumberId = model.WardNumberId;
entity.RoomNumber = model.RoomNumber;
entity.RoomTypeId = model.RoomTypeId;
entity.DepartmentId = model.DepartmentId;
entity.AadharCard = model.AadharCard;
entity.PanCard = model.PanCard;
entity.IsActive = true;
entity.IsDeleted = false;
entity.CreatedOn = DateTime.Now;
entity.CreatedBy = UserDetailSession.Id;
entity.ModifiedOn = DateTime.Now;
db.PatientDetails.Add(entity);
db.SaveChanges();
if (!entity.IsDischarged.Value)
{
if (model.OPDHistory != null)
{
OPDHistory historyEntity = new OPDHistory();
model.OPDHistory.PatientId = entity.Id;
model.OPDHistory.CasePaperNumber = model.CasePaperNumber;
model.OPDHistory.ECGAmount = (model.OPDHistory.IsECG.Value) ? OPDRate.GetRatesByType("ECG").Rate : 0.00M;
model.OPDHistory.XRAYAmount = model.OPDHistory.XRAYAmount;
int isFollowUp = 0;
if (model.IsOldPatient && model.CasePaperIssuedDate.Value.Date < DateTime.Now.Date)
{
isFollowUp = 1;
}
isSaved = historyEntity.Create(model.OPDHistory, isFollowUp);
}
}
else
{
isSaved = CreateIPDHistory(entity.Id, model.IPDBillAmount);
}
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
//[EnableCors("MyPolicy")]
public IActionResult AddPatientDetailsToDb([FromBody] rawdata rawdata)
{
var P_Details = new PatientDetailModel();
P_Details.POBPatientID = rawdata.POBPatientID;
P_Details.PatientID = rawdata.PatientID;
P_Details.FirstName = rawdata.FirstName;
P_Details.LastName = rawdata.LastName;
P_Details.MiddleNames = rawdata.MiddleNames;
P_Details.Email = rawdata.Email;
P_Details.Title = rawdata.Title;
P_Details.Gender = rawdata.Gender;
P_Details.DateOfBirth = rawdata.DateOfBirth;
P_Details.Height = rawdata.Height;
P_Details.WeightKg = rawdata.WeightKg;
P_Details.BMI = rawdata.BMI;
P_Details.Handedness = rawdata.Handedness;
P_Details.Mobile = rawdata.Mobile;
P_Details.StreetAddressID = rawdata.StreetAddressID;
P_Details.FamilyDoctor = rawdata.FamilyDoctor;
P_Details.LastVisit = rawdata.LastVisit;
P_Details.WhyLastVisit = rawdata.WhyLastVisit;
P_Details.CountryID = rawdata.CountryID;
P_Details.CreateUserID = rawdata.CreateUserID;
P_Details.KnownAsCode = rawdata.KnownAsCode;
P_Details.FreeSearch = rawdata.FreeSearch;
P_Details.OnboardCode = rawdata.OnboardCode;
P_Details.SelectedEntityType = rawdata.SelectedEntityType;
P_Details.PreviousWorkCompClaim = rawdata.PreviousWorkCompClaim;
P_Details.PreviousWorkCompClaimDetails = rawdata.PreviousWorkCompClaimDetails;
PatientDetailsService.AddPatientDetailsToDb(P_Details);
var P_Emp_Details = new PatientEmploymentModel();
P_Emp_Details.POBPatientEmploymentID = rawdata.POBPatientEmploymentID;
P_Emp_Details.POBPatientID = rawdata.POBPatientID;
P_Emp_Details.CreateDate = rawdata.CreateDate;
P_Emp_Details.CreateUserID = rawdata.CreateUserID;
P_Emp_Details.CurrentPosition = rawdata.CurrentPosition;
P_Emp_Details.EmpStartDate = rawdata.EmpStartDate;
P_Emp_Details.EmpDepartment = rawdata.EmpDepartment;
P_Emp_Details.CurrentDutiesID = rawdata.CurrentDutiesID;
P_Emp_Details.EmploymentStatusID = rawdata.EmploymentStatusID;
P_Emp_Details.OccupationID = rawdata.OccupationID;
PatientEmploymentService.AddPatienEmploymentToDb(P_Emp_Details);
var P_Loc_Details = new PatientLocationModel();
P_Loc_Details.AddressID = rawdata.AddressID;
P_Loc_Details.Line1 = rawdata.Line1;
P_Loc_Details.Line2 = rawdata.Line2;
P_Loc_Details.Suburb = rawdata.Suburb;
P_Loc_Details.StateID = rawdata.StateID;
P_Loc_Details.PostCode = rawdata.PostCode;
P_Loc_Details.AddressRegion = rawdata.AddressRegion;
P_Loc_Details.LogUserID = rawdata.LogUserID;
PatientLocationService.AddLocationToDB(P_Loc_Details);
return(Ok());
}
