public List <OPDHistoryModel> GetHistoryByPatientId(Guid?id) { try { List <OPDHistoryModel> list = new List <OPDHistoryModel>(); using (var db = new HMSEntities()) { Guid?patientId = db.OPDHistories.Find(id).PatientId; list = db.OPDHistories.AsEnumerable().Where(t => t.PatientId == patientId && t.Status.Name == OPD_STATUS.Done.ToString()).OrderByDescending(t => t.InTime) .Select(t => new OPDHistoryModel() { Id = t.Id, PatientId = t.PatientId, PatientName = t.PatientDetail != null ? t.PatientDetail.FullName : "", CasePaperNumber = t.PatientDetail != null ? t.PatientDetail.CasePaperNumber : "", Sequence = t.Sequence, InTime = t.InTime, OutTime = t.OutTime, IsCharity = t.IsCharity, IsLabCharity = t.IsLabCharity, ConsultingDoctorId = t.ConsultingDoctorId, DoctorNames = t.DoctorDetail.FullName, IsECG = t.IsECG.HasValue ? t.IsECG : false, IsXRAY = t.IsXRAY.HasValue ? t.IsXRAY : false, StatusId = t.StatusId, StatusName = t.Status != null ? t.Status.Name : "", Amount = t.Amount, PaidAmount = t.PaidAmount, DueAmount = t.DueAmount, TotalAmount = t.TotalAmount, LabTestingAmount = t.LabTestingAmount, ECGAmount = t.ECGAmount, XRAYAmount = t.XRAYAmount, NumberofXRAY = t.NumberofXRAY.HasValue ? t.NumberofXRAY : 0, ThirdPartyLabId = t.ThirdPartyLabId, ThirdPartyLabAmoumt = t.ThirdPartyLabAmoumt, ReceivedBy = t.ReceivedBy, Diagnose = t.Diagnose, Madicines = t.Madicines, CreatedBy = t.CreatedBy, ModifiedBy = t.ModifiedBy, PatientDetails = PatientDetail.SetModel(t.PatientDetail) }).ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public OPDHistoryModel GetById(Guid id) { try { OPDHistoryModel model = new OPDHistoryModel(); using (var db = new HMSEntities()) { OPDHistory entity = db.OPDHistories.Find(id); if (entity != null) { model.Id = entity.Id; model.PatientId = entity.PatientId; model.PatientName = entity.PatientDetail != null ? entity.PatientDetail.FullName : ""; model.CasePaperNumber = entity.PatientDetail != null ? entity.PatientDetail.CasePaperNumber : ""; model.Sequence = entity.Sequence; model.InTime = entity.InTime; model.OutTime = entity.OutTime; model.IsCharity = entity.IsCharity; model.IsLabCharity = entity.IsLabCharity; model.IsECG = entity.IsECG.HasValue ? entity.IsECG : false; model.IsXRAY = entity.IsXRAY.HasValue ? entity.IsXRAY : false; model.StatusId = entity.StatusId; model.StatusName = entity.Status != null ? entity.Status.Name : ""; model.Amount = entity.Amount; model.PaidAmount = entity.PaidAmount; model.DueAmount = entity.DueAmount; model.TotalAmount = entity.TotalAmount; model.LabTestingAmount = entity.LabTestingAmount; model.ECGAmount = entity.ECGAmount; model.XRAYAmount = entity.XRAYAmount; model.NumberofXRAY = entity.NumberofXRAY.HasValue ? entity.NumberofXRAY : 0; model.ReceivedBy = entity.ReceivedBy; model.ConsultingDoctorId = entity.ConsultingDoctorId; model.ThirdPartyLabId = entity.ThirdPartyLabId; model.ThirdPartyLabAmoumt = entity.ThirdPartyLabAmoumt; model.Diagnose = entity.Diagnose; model.Madicines = entity.Madicines; model.CreatedBy = entity.CreatedBy; model.ModifiedBy = entity.ModifiedBy; model.PatientDetails = PatientDetail.SetModel(entity.PatientDetail); } } return(model); } catch (Exception ex) { throw ex; } }