Пример #1
0
        public static LookupModel GetRatesByType(string type)
        {
            try
            {
                LookupModel model = new LookupModel();
                using (var db = new HMSEntities())
                {
                    OPDRate entity = db.OPDRates.FirstOrDefault(t => t.IsActive == true && t.IsDeleted != true && t.Type == type && t.IsDefault == true);
                    if (entity != null)
                    {
                        model.Id         = entity.Id;
                        model.Name       = entity.Type;
                        model.Rate       = entity.Rate;
                        model.IsFlag     = entity.IsDefault;
                        model.IsActive   = entity.IsActive;
                        model.IsDeleted  = entity.IsDeleted;
                        model.CreatedOn  = entity.CreatedOn;
                        model.CreatedBy  = entity.CreatedBy;
                        model.ModifiedOn = entity.ModifiedOn;
                        model.ModifiedBy = entity.ModifiedBy;
                    }
                }

                return(model);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #2
0
        public LookupModel GetById(Guid id)
        {
            try
            {
                LookupModel model = new LookupModel();
                using (var db = new HMSEntities())
                {
                    OPDRate entity = db.OPDRates.Find(id);
                    if (entity != null)
                    {
                        model.Id         = entity.Id;
                        model.Name       = entity.Type;
                        model.Rate       = entity.Rate;
                        model.IsFlag     = entity.IsDefault;
                        model.IsActive   = entity.IsActive;
                        model.IsDeleted  = entity.IsDeleted;
                        model.CreatedOn  = entity.CreatedOn;
                        model.CreatedBy  = entity.CreatedBy;
                        model.ModifiedOn = entity.ModifiedOn;
                        model.ModifiedBy = entity.ModifiedBy;
                    }
                }

                return(model);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #3
0
        public bool Update(LookupModel model)
        {
            try
            {
                bool isSaved = false;

                if (!IsExist(model))
                {
                    using (var db = new HMSEntities())
                    {
                        //UpdateAllSequence(model.Id, model.Sequence.Value, model.PerentId);
                        OPDRate entity = db.OPDRates.Find(model.Id);
                        entity.Type       = model.Name;
                        entity.Rate       = (!model.Rate.HasValue) ? 0.00M : model.Rate;
                        entity.IsDefault  = true;
                        entity.ModifiedOn = DateTime.Now;
                        entity.ModifiedBy = UserDetailSession.Id;

                        db.SaveChanges();

                        isSaved = true;
                    }
                }


                return(isSaved);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #4
0
        public bool Create(LookupModel model)
        {
            try
            {
                bool isSaved = false;

                if (!IsExist(model))
                {
                    using (var db = new HMSEntities())
                    {
                        OPDRate entity = new OPDRate();

                        entity.Type      = model.Name;
                        entity.Rate      = (!model.Rate.HasValue) ? 0.00M : model.Rate;
                        entity.IsDefault = model.IsFlag;
                        entity.IsActive  = true;
                        entity.IsDeleted = false;
                        entity.CreatedOn = DateTime.Now;
                        entity.CreatedBy = UserDetailSession.Id;

                        db.OPDRates.Add(entity);
                        db.SaveChanges();

                        isSaved = true;
                    }
                }


                return(isSaved);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 public static decimal?isFollowUpCheck(Guid?id)
 {
     using (var db = new HMSEntities())
     {
         if (UpdateCasePaperDate(id))
         {
             return(OPDRate.GetRatesByType("New").Rate);
         }
         else
         {
             return(OPDRate.GetRatesByType("FollowUP").Rate);
         }
     }
 }
        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;
            }
        }
Пример #7
0
        public bool Create(OPDHistoryModel model, int isFollowUp = 0)
        {
            try
            {
                bool isSaved = false;

                if (!IsExist(model.CasePaperNumber))
                {
                    using (var db = new HMSEntities())
                    {
                        OPDHistory entity = new OPDHistory();
                        entity.PatientId          = model.PatientId;
                        entity.Sequence           = getLastSerial();
                        entity.InTime             = model.InTime;
                        entity.OutTime            = model.OutTime;
                        entity.IsCharity          = model.IsCharity.HasValue ? model.IsCharity : false;
                        entity.IsLabCharity       = model.IsLabCharity;
                        entity.ConsultingDoctorId = model.ConsultingDoctorId;
                        entity.IsECG      = model.IsECG.HasValue ? model.IsECG : false;
                        entity.IsXRAY     = model.IsXRAY.HasValue ? model.IsXRAY : false;
                        entity.StatusId   = Status.GetStatus(t => t.Name == OPD_STATUS.Waiting.ToString()).FirstOrDefault().Id;
                        entity.IsFollowUp = isFollowUp;
                        if (!entity.IsCharity.Value)
                        {
                            if (isFollowUp == 0)
                            {
                                entity.Amount = OPDRate.GetRatesByType("New").Rate;
                            }
                            else if (isFollowUp == 1)
                            {
                                entity.Amount = OPDRate.GetRatesByType("FollowUP").Rate;
                            }
                        }
                        else
                        {
                            entity.Amount           = 0.00M;
                            entity.LabTestingAmount = 0.00M;
                            entity.XRAYAmount       = 0.00M;
                            entity.ECGAmount        = 0.00M;
                        }
                        model.PayingAmount         = entity.Amount;
                        entity.PaidAmount          = entity.Amount;
                        entity.DueAmount           = model.ECGAmount + model.XRAYAmount; //model.DueAmount != null ? model.DueAmount : Convert.ToDecimal(0.00);
                        entity.TotalAmount         = entity.Amount + model.ECGAmount + model.XRAYAmount;
                        entity.LabTestingAmount    = model.LabTestingAmount != null ? model.LabTestingAmount : Convert.ToDecimal(0.00);
                        entity.ECGAmount           = model.ECGAmount.HasValue ? model.ECGAmount : 0.00M;
                        entity.XRAYAmount          = model.XRAYAmount.HasValue ? model.XRAYAmount : 0.00M;
                        entity.NumberofXRAY        = model.NumberofXRAY.HasValue ? model.NumberofXRAY : 0;
                        entity.ThirdPartyLabId     = model.ThirdPartyLabId;
                        entity.ThirdPartyLabAmoumt = model.ThirdPartyLabAmoumt.HasValue ? model.ThirdPartyLabAmoumt : 0.00M;
                        entity.ReceivedBy          = model.ReceivedBy;
                        entity.Diagnose            = model.Diagnose;
                        entity.Madicines           = model.Madicines;
                        entity.CreatedBy           = UserDetailSession.Id;

                        db.OPDHistories.Add(entity);
                        db.SaveChanges();
                        model.Id = entity.Id;
                        List <OPDHistoryUpdateModel> listUpdateModel = new List <OPDHistoryUpdateModel>();
                        listUpdateModel = OPDHistoryModifications(model);
                        OPDHistoryUpdate opdHistoryUpdate = new OPDHistoryUpdate();
                        opdHistoryUpdate.Create(listUpdateModel);
                        isSaved = true;
                    }
                }


                return(isSaved);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }