public ActionResult DisplayCommission()
        {
            PatientTestModel model = new PatientTestModel();

            model.GetCBCommissionViewModelList = pro.GetCommissionDetailsFromCB();
            return(View(model));
        }
        public ActionResult GetPatientDetailsByName(string id)
        {
            PatientTestModel model = new PatientTestModel();

            model.PatientInformationModelList = pro.getPatientDetailByName(id);
            return(PartialView("PatientListView", model));
        }
        //[CustomAuthorize(Roles = "PathologyAdmin, PathologyCreate,PathologyView,  superadmin, admin")]
        public ActionResult Index()
        {
            PatientTestModel model = new PatientTestModel();

            model.PatientTestModelList = pro.PopulatePatientTestList(4);
            return(View(model));
        }
        public ActionResult ShowDoctorCommissionDetails()
        {
            PatientTestModel model = new PatientTestModel();

            model.DoctorCommissionRptViewModelList = pro.GetDoctorCommissionReports();
            return(View(model));
        }
        //[CustomAuthorize(Roles = "PathologyAdmin, PathologyCreate,PathologyView,  superadmin, admin")]
        public ActionResult Create(string ipValue)
        {
            PatientTestModel model = new PatientTestModel();
            EHMSEntities     ent   = new EHMSEntities();

            //int departmentId = 0;
            //int DropDownListDepartmentId = Convert.ToInt32(deptId);

            //if (DropDownListDepartmentId == 1001)//emergency
            //{
            //    model.DepartmentID = 1001;
            //    if (ipValue != null && ipValue != "" && (pro.CheckEmergencyIdExistOrNot(Convert.ToInt32(ipValue)) != false))
            //    {
            //        model.PatientInformationModel = pro.GetPatientBasicInformationFromEmergency(Convert.ToInt32(ipValue)).FirstOrDefault();
            //    }

            //}
            //else
            //{
            if (ipValue != null && ipValue != "" && (pro.CheckOpdIdExistOrNot(Convert.ToInt32(ipValue)) != false))
            {
                model.PatientInformationModel = pro.GetPatientBasicInformationFromOpd(Convert.ToInt32(ipValue), 4).FirstOrDefault();
            }

            // }

            model.PathoSectionModelList = pro.GetPathoSections();
            //added by bibek
            tempList.Clear();
            model.PathoOtherTestModelCBList = pro.GetOtherTestList();
            //model.PathoTestModelList = pro.GetPathoTestSectionWise(1);
            model.PatientID = Convert.ToInt32(ipValue);

            return(View(model));
        }
        public ActionResult GetPatientInformation(string DepartmentID, string ipValue)
        {
            PatientTestModel model = new PatientTestModel();

            model.PatientInformationModel = pro.GetPatientBasicInformation(Convert.ToInt32(ipValue), 4).FirstOrDefault();
            return(RedirectToAction("Create", model));
        }
        public ActionResult PatientTestResult(int id, int PatientTestID, string DeptID)
        {
            PatientTestModel model = new PatientTestModel();

            //string DropDownListDepartmentId = DeptID;

            //if (DropDownListDepartmentId == "Emergency")//emergency
            //{
            //    model.DepartmentID = 1001;
            //    if (id != 0 && (pro.CheckEmergencyIdExistOrNot(Convert.ToInt32(id)) != false))
            //    {
            //        model.PatientInformationModel = pro.GetPatientBasicInformationFromEmergency(Convert.ToInt32(id)).FirstOrDefault();
            //    }

            //}
            //else
            //{
            if (id != 0 && (pro.CheckOpdIdExistOrNot(Convert.ToInt32(id)) != false))
            {
                model.PatientInformationModel = pro.GetPatientBasicInformationFromOpd(Convert.ToInt32(id), 4).FirstOrDefault();
            }

            //}

            model.TestCheckBoxListModelList = pro.getPatientTestForPrint(PatientTestID);
            model.TotalAmount   = pro.getPatientTestPaymentForPrint(PatientTestID).FirstOrDefault().TotalAmount;
            model.Discount      = pro.getPatientTestPaymentForPrint(PatientTestID).FirstOrDefault().Discount;
            model.PayableAmount = pro.getPatientTestPaymentForPrint(PatientTestID).FirstOrDefault().PayableAmount;
            return(View("PrintPatientTest", model));
        }
        public ActionResult DetailOfBillPaidTest(int id, string billno, string dept, int BillnumberInt)
        {
            PatientTestModel model = new PatientTestModel();

            model = pro.getDetailBillPaidTestModelList("Patho", billno, id, BillnumberInt);

            return(View(model));
        }
        public ActionResult BillPaidTest()
        {
            PatientTestModel model = new PatientTestModel();

            //model = pro.getBillPaidTestModelList("Patho");
            model = pro.getBillPaidTestModelListById("Patho", 1006);
            return(View(model));
        }
        public ActionResult ViewCommissionDetails(int id)
        {
            PatientTestModel model = new PatientTestModel();

            model.GetPathoCommDetailsViewModelList       = pro.GetCommissionDetailsByBillNo(id);
            model.ObjGetPathoCommDetailsViewModel.BillNo = id;
            return(View(model));
        }
 public ActionResult DetailOfBillPaidTest(PatientTestModel model)
 {
     if (ModelState.IsValid)
     {
         //insert into patienttest
         pro.InsertPatientFromDetail(model);
     }
     return(RedirectToAction("BillPaidTest"));
 }
Exemple #12
0
 public PatientTestModel getBillPaidTestModelListById(string DeptName, int DeptId)
 {
     using (EHMSEntities ent = new EHMSEntities())
     {
         PatientTestModel model = new PatientTestModel();
         model.BillPaidTestModelList = ent.Database.SqlQuery <BillPaidTestModel>("getBillCounterListOthers '" + DeptName + "', '" + DeptId + "'").ToList();
         return(model);
     }
 }
Exemple #13
0
        public List <DoctorCommissionRptViewModel> GetDoctorCommissionReports()
        {
            PatientTestModel model = new PatientTestModel();

            using (EHMSEntities ent = new EHMSEntities())
            {
                //int DepartmentId = 1006;
                return(ent.Database.SqlQuery <DoctorCommissionRptViewModel>("GetCommissionDoctorwiseReports ").ToList());
            }
        }
Exemple #14
0
 public PatientTestModel getDetailBillPaidTestModelList(string DeptName, string BillNo, int PatientID, int billNumberInt)
 {
     using (EHMSEntities ent = new EHMSEntities())
     {
         PatientTestModel model = new PatientTestModel();
         model.PatientInformationModel   = GetPatientBasicInformationFromOpd(PatientID, 1000).FirstOrDefault();
         model.TestCheckBoxListModelList = ent.Database.SqlQuery <TestCheckBoxListModel>("getDetailBillTest '" + PatientID + "', '" + billNumberInt + "'").ToList();
         return(model);
     }
 }
 public ActionResult Edit(int id, int PatientTestID, PatientTestModel model)
 {
     if (ModelState.IsValid)
     {
         //edit
         pro.Update(model, id, PatientTestID);
         return(RedirectToAction("Index"));
     }
     return(View(model));
 }
Exemple #16
0
        public void InsertPatientFromDetail(PatientTestModel model)
        {
            using (EHMSEntities ent = new EHMSEntities())
            {
                if (model.ReferDoctorID == 1009)
                {
                    model.ReferDoctorID = 20;//Default doctor Id
                }
                var objInsertPatientTest = new PatientTest()
                {
                    //insert into patienttest
                    PatientID            = model.PatientInformationModel.EmergencyMasterId,
                    DepartmentID         = model.PatientInformationModel.DepartmentID,
                    ReferDoctorID        = model.ReferDoctorID,
                    TestRegistrationDate = model.TestRegistrationDate,
                    Status = true
                };
                ent.PatientTests.Add(objInsertPatientTest);
                ent.SaveChanges();


                foreach (var item in model.TestCheckBoxListModelList)
                {
                    var objInsertPatientDetail = new PatientTestDetail()
                    {
                        //insert into patientdetail
                        PatientTestID  = objInsertPatientTest.PatientTestID,
                        PatientID      = model.PatientInformationModel.EmergencyMasterId,
                        DepartmentID   = model.PatientInformationModel.DepartmentID,
                        SectionID      = item.SectionId,
                        TestID         = item.TestId,
                        TestDate       = item.TestDate,
                        TestTime       = item.TestTime,
                        DeliveryDate   = item.DeliveryDate,
                        DeliveryStatus = false
                    };
                    ent.PatientTestDetails.Add(objInsertPatientDetail);
                    //ent.SaveChanges();

                    // update status in centralized billing
                    //var objtoUpdateCentralizedBilling = ent.CentralizedBilling.Where(x => x.BillNumber == item.BillNumber && x.ItemID == item.TestId && x.PatientId == model.PatientInformationModel.EmergencyMasterId);
                    //foreach (var item2 in objtoUpdateCentralizedBilling)
                    //{
                    //    item2.Status = false;
                    //}
                    int BillNumberInt = Convert.ToInt32(item.BillNo);
                    var objtoUpdateCentralizedBilling = ent.CentralizedBillingDetails.Where(x => x.BillNo == BillNumberInt && x.Status == true);
                    foreach (var item2 in objtoUpdateCentralizedBilling)
                    {
                        item2.Status = false;
                    }
                    ent.SaveChanges();
                }
            }
        }
        //[CustomAuthorize(Roles = "PathologyAdmin, PathologyCreate, superadmin, admin")]
        public ActionResult Edit(int id, int PatientTestID)
        {
            PatientTestModel model = new PatientTestModel();

            model = pro.PopulatePatientTestMasterForEdit(PatientTestID).FirstOrDefault();
            //department Static
            model.PatientInformationModel   = pro.GetPatientBasicInformationFromOpd(id, 4).FirstOrDefault();
            model.TestCheckBoxListModelList = pro.PopulatePatientTestForEdit(PatientTestID);
            model.PathoSectionModelList     = pro.GetPathoSections();
            return(View(model));
        }
        public ActionResult SampleCollectedIndex(string LabNubmer)
        {
            PatientTestModel model = new PatientTestModel();
            int LabNumberInt       = Convert.ToInt32(0);

            if (!string.IsNullOrEmpty(LabNubmer))
            {
                bool result = int.TryParse(LabNubmer, out LabNumberInt);
                if (result)
                {
                    LabNumberInt = Convert.ToInt32(LabNubmer);
                }
            }

            model.SampleCollectedViewModelList = pro.GetSampleCollectedList(LabNumberInt);
            return(View(model));
        }
        public ActionResult Create(PatientTestModel model)
        {
            if (model.PatientInformationModel != null)
            {
                if (ModelState.IsValid)
                {
                    pro.Insert(model);
                }
                model.PathoSectionModelList = pro.GetPathoSections();

                // return RedirectToAction("PrintPatientTest",model);
                return(View("PrintPatientTest", model));
            }
            else
            {
                return(RedirectToAction("Create"));
            }
        }
Exemple #20
0
        public bool InsertPathoCommissionDetails(PatientTestModel model)
        {
            using (EHMSEntities ent = new EHMSEntities())
            {
                foreach (var item in model.AddMoreParticularsViewModelList)
                {
                    var Obj = new CommissionDetaislByType()
                    {
                        AccountHeadId       = 1234,
                        Amount              = item.CommissionAmout,
                        BillNo              = model.ObjGetPathoCommDetailsViewModel.BillNo,
                        CommissionDate      = DateTime.Now,
                        commissionDetailsId = 1006,
                        CommissionTypeId    = 1,
                        CommissionTypeName  = "Doctor Commission",
                        CreatedBy           = Utility.GetCurrentLoginUserId(),
                        Status              = true,
                        DoctorId            = item.DoctorId,
                        CreatedDate         = DateTime.Now,
                        Remarks             = "fine",
                        JvStatus            = false
                    };
                    ent.CommissionDetaislByTypes.Add(Obj);
                }
                ent.SaveChanges();

                //Update commissionDetails Table

                var ObjResult = ent.CommissionDetails.Where(x => x.DepartmentId != 1005 && x.BillNumber == model.ObjGetPathoCommDetailsViewModel.BillNo && x.Status == false);
                if (ObjResult.Count() > 0)
                {
                    foreach (var item in ObjResult)
                    {
                        item.Status = true;
                    }
                    ent.SaveChanges();
                }
            }



            return(true);
        }
Exemple #21
0
        public void Update(PatientTestModel model, int id, int PatientTestID)
        {
            using (EHMSEntities ent = new EHMSEntities())
            {
                DateTime dt = model.TestRegistrationDate.Date;
                // var objToSavePatientTest = ent.PatientTest.Where(x => x.PatientID == model.PatientInformationModel.EmergencyMasterId && x.TestRegistrationDate==model.TestRegistrationDate).FirstOrDefault();
                var objToSavePatientTest = ent.PatientTests.Where(x => x.PatientTestID == PatientTestID && x.TestRegistrationDate == model.TestRegistrationDate).FirstOrDefault();
                AutoMapper.Mapper.Map(model, objToSavePatientTest);
                ent.Entry(objToSavePatientTest).State = System.Data.EntityState.Modified;
                //needed TestDate in Where clause
                var dataTestToDelete = ent.PatientTestDetails.Where(x => x.PatientTestID == PatientTestID && x.TestDate == model.TestRegistrationDate).ToList();
                foreach (var item in dataTestToDelete)
                {
                    var objTestToDelete = ent.PatientTestDetails.Where(x => x.PatientTestID == PatientTestID && x.TestDate == model.TestRegistrationDate).FirstOrDefault();
                    ent.PatientTestDetails.Remove(objTestToDelete);
                    ent.SaveChanges();
                }
                //insert test..
                foreach (var item in model.TestCheckBoxListModelList)
                {
                    if (item.isSelected == true)
                    {
                        model.PatientTestDetailModel = new PatientTestDetailModel();
                        var objToSavePatientTestDetails = AutoMapper.Mapper.Map <PatientTestDetailModel, PatientTestDetail>(model.PatientTestDetailModel);
                        objToSavePatientTestDetails.PatientID      = model.PatientInformationModel.EmergencyMasterId;
                        objToSavePatientTestDetails.PatientTestID  = objToSavePatientTest.PatientTestID;
                        objToSavePatientTestDetails.DepartmentID   = model.PatientInformationModel.DepartmentID;
                        objToSavePatientTestDetails.SectionID      = item.SectionId;
                        objToSavePatientTestDetails.TestID         = item.TestId;
                        objToSavePatientTestDetails.TestDate       = (DateTime)item.DeliveryDate;
                        objToSavePatientTestDetails.TestTime       = item.TestTime;
                        objToSavePatientTestDetails.DeliveryDate   = item.DeliveryDate;
                        objToSavePatientTestDetails.Amount         = (decimal)item.Price;
                        objToSavePatientTestDetails.Discount       = 0;
                        objToSavePatientTestDetails.TotalAmount    = (decimal)item.Price - 0;
                        objToSavePatientTestDetails.DeliveryStatus = false;
                        ent.PatientTestDetails.Add(objToSavePatientTestDetails);
                    }
                }

                ent.SaveChanges();
            }
        }
Exemple #22
0
        public void Insert(PatientTestModel model)
        {
            using (EHMSEntities ent = new EHMSEntities())
            {
                int PatientDepartmentId     = 0;
                var GetSourceIdFromOpdEmrID = 0;
                if (model.DepartmentID == 1000)//opd
                {
                    //get user original departmentId
                    var patientDeptId = ent.OpdMasters.Where(m => m.OpdID == model.PatientInformationModel.EmergencyMasterId).FirstOrDefault().DepartmentId;
                    PatientDepartmentId     = Convert.ToInt32(patientDeptId);
                    GetSourceIdFromOpdEmrID = ent.GL_LedgerMaster.Where(m => m.SourceID == model.PatientInformationModel.EmergencyMasterId && m.DepartmentID == PatientDepartmentId).Select(m => m.LedgerMasterID).FirstOrDefault();
                }
                else if (model.DepartmentID == 1001)//emergency
                {
                    var patientDeptId = ent.OpdMasters.Where(m => m.OpdID == model.PatientInformationModel.EmergencyMasterId).FirstOrDefault().DepartmentId;
                    PatientDepartmentId     = Convert.ToInt32(patientDeptId);
                    GetSourceIdFromOpdEmrID = ent.GL_LedgerMaster.Where(m => m.SourceID == model.PatientInformationModel.EmergencyMasterId && m.DepartmentID == PatientDepartmentId).Select(m => m.LedgerMasterID).FirstOrDefault();
                }
                else//ipd
                {
                    var patientDeptId = ent.OpdMasters.Where(m => m.OpdID == model.PatientInformationModel.EmergencyMasterId).FirstOrDefault().DepartmentId;
                    PatientDepartmentId     = Convert.ToInt32(patientDeptId);
                    GetSourceIdFromOpdEmrID = ent.GL_LedgerMaster.Where(m => m.SourceID == model.PatientInformationModel.EmergencyMasterId && m.DepartmentID == PatientDepartmentId).Select(m => m.LedgerMasterID).FirstOrDefault();
                }


                var objTosavePatientTest = AutoMapper.Mapper.Map <PatientTestModel, PatientTest>(model);
                objTosavePatientTest.PatientID            = model.PatientInformationModel.EmergencyMasterId;
                objTosavePatientTest.TestRegistrationDate = DateTime.Now;
                objTosavePatientTest.ReferDoctorID        = model.ReferDoctorID;
                objTosavePatientTest.DepartmentID         = PatientDepartmentId;
                objTosavePatientTest.Status = true;
                ent.PatientTests.Add(objTosavePatientTest);
                ent.SaveChanges();


                //ent.SaveChanges();

                foreach (var item in model.TestCheckBoxListModelList)
                {
                    //if (item.isSelected == true)
                    //{

                    model.PatientTestDetailModel = new PatientTestDetailModel();
                    var objToSavePatientTestDetails = AutoMapper.Mapper.Map <PatientTestDetailModel, PatientTestDetail>(model.PatientTestDetailModel);
                    objToSavePatientTestDetails.PatientID     = model.PatientInformationModel.EmergencyMasterId;
                    objToSavePatientTestDetails.PatientTestID = objTosavePatientTest.PatientTestID;
                    //objToSavePatientTestDetails.DepartmentID = model.DepartmentID;
                    objToSavePatientTestDetails.DepartmentID = PatientDepartmentId;
                    objToSavePatientTestDetails.SectionID    = item.SectionId;
                    objToSavePatientTestDetails.TestID       = item.TestId;
                    objToSavePatientTestDetails.TestDate     = DateTime.Now;
                    //objToSavePatientTestDetails.TestTime = item.TestTime;
                    //objToSavePatientTestDetails.DeliveryDate = item.DeliveryDate;
                    objToSavePatientTestDetails.Amount         = (decimal)item.Price;
                    objToSavePatientTestDetails.Discount       = item.DiscountPer;
                    objToSavePatientTestDetails.TotalAmount    = (decimal)item.Price - item.DiscountPer;
                    objToSavePatientTestDetails.DeliveryStatus = false;
                    ent.PatientTestDetails.Add(objToSavePatientTestDetails);

                    //for times
                    if (item.Tim > 1)
                    {
                        for (int i = 0; i < item.Tim - 1; i++)
                        {
                            var objTosavePatientTestforTim = AutoMapper.Mapper.Map <PatientTestModel, PatientTest>(model);
                            objTosavePatientTestforTim.PatientID            = model.PatientInformationModel.EmergencyMasterId;
                            objTosavePatientTestforTim.TestRegistrationDate = DateTime.Now;
                            objTosavePatientTestforTim.ReferDoctorID        = model.ReferDoctorID;
                            objTosavePatientTestforTim.DepartmentID         = PatientDepartmentId;
                            objTosavePatientTestforTim.Status = true;
                            ent.PatientTests.Add(objTosavePatientTestforTim);

                            model.PatientTestDetailModel = new PatientTestDetailModel();
                            var objToSavePatientTestDetailsForTim = AutoMapper.Mapper.Map <PatientTestDetailModel, PatientTestDetail>(model.PatientTestDetailModel);
                            objToSavePatientTestDetailsForTim.PatientID     = model.PatientInformationModel.EmergencyMasterId;
                            objToSavePatientTestDetailsForTim.PatientTestID = objTosavePatientTestforTim.PatientTestID;
                            //objToSavePatientTestDetails.DepartmentID = model.DepartmentID;
                            objToSavePatientTestDetailsForTim.DepartmentID = PatientDepartmentId;
                            objToSavePatientTestDetailsForTim.SectionID    = item.SectionId;
                            objToSavePatientTestDetailsForTim.TestID       = item.TestId;
                            objToSavePatientTestDetailsForTim.TestDate     = DateTime.Now;
                            //objToSavePatientTestDetails.TestTime = item.TestTime;
                            //objToSavePatientTestDetails.DeliveryDate = item.DeliveryDate;
                            objToSavePatientTestDetailsForTim.Amount         = (decimal)item.Price;
                            objToSavePatientTestDetailsForTim.Discount       = item.DiscountPer;
                            objToSavePatientTestDetailsForTim.TotalAmount    = (decimal)item.Price - item.DiscountPer;
                            objToSavePatientTestDetailsForTim.DeliveryStatus = false;
                            ent.PatientTestDetails.Add(objToSavePatientTestDetailsForTim);
                            ent.SaveChanges();
                        }
                    }


                    // }
                }
                //added by Gopal on April 4 2014-Centralized Billing
                int    BillNumberInt = Utility.GetMaxBillNumberFromDepartment("Hospital", 1);
                string BillNumberStr = "BL-" + BillNumberInt.ToString();
                foreach (var item in model.TestCheckBoxListModelList)
                {
                    //Rate
                    var objCentralizedBilling = new CentralizedBilling()
                    {
                        AccountHeadId       = 15,
                        Amount              = (decimal)item.Rate,
                        AmountDate          = DateTime.Now,
                        PaymentType         = "Cash",
                        Narration1          = item.TestName,
                        DepartmentName      = "Patho",
                        SubDepartmentId     = PatientDepartmentId,
                        BillNumber          = BillNumberStr,
                        LedgerMasterId      = GetSourceIdFromOpdEmrID,
                        PatientId           = model.PatientInformationModel.EmergencyMasterId,
                        PatientLogId        = HospitalManagementSystem.Utility.getPatientLogID(model.PatientInformationModel.EmergencyMasterId),
                        JVStatus            = false,
                        CreatedBy           = Utility.GetCurrentLoginUserId(),
                        CreatedDepartmentId = Utility.GetCurrentUserDepartmentId(),
                        CreatedDate         = DateTime.Now,
                        Remarks             = "NA",
                        Status              = true,
                        PaidOnPaid          = true,
                        Narration2          = item.Tim.ToString(),
                        ItemID              = item.TestId
                    };
                    ent.CentralizedBillings.Add(objCentralizedBilling);

                    //item wise tax
                    objCentralizedBilling = new CentralizedBilling()
                    {
                        AccountHeadId       = 16,
                        Amount              = (decimal)item.TaxAmount,
                        AmountDate          = DateTime.Now,
                        PaymentType         = "Cash",
                        Narration1          = item.TestName,
                        DepartmentName      = "Patho",
                        SubDepartmentId     = PatientDepartmentId,
                        BillNumber          = BillNumberStr,
                        LedgerMasterId      = GetSourceIdFromOpdEmrID,
                        PatientId           = model.PatientInformationModel.EmergencyMasterId,
                        PatientLogId        = HospitalManagementSystem.Utility.getPatientLogID(model.PatientInformationModel.EmergencyMasterId),
                        JVStatus            = false,
                        CreatedBy           = Utility.GetCurrentLoginUserId(),
                        CreatedDepartmentId = Utility.GetCurrentUserDepartmentId(),
                        CreatedDate         = DateTime.Now,
                        Remarks             = "NA",
                        Status              = true,
                        PaidOnPaid          = true,
                        Narration2          = item.Tim.ToString(),
                        ItemID              = item.TestId
                    };
                    ent.CentralizedBillings.Add(objCentralizedBilling);
                    //item wise discount
                    objCentralizedBilling = new CentralizedBilling()
                    {
                        AccountHeadId       = 22,
                        Amount              = (decimal)item.DiscountPer,
                        AmountDate          = DateTime.Now,
                        PaymentType         = "Cash",
                        Narration1          = item.TestName,
                        DepartmentName      = "Patho",
                        SubDepartmentId     = PatientDepartmentId,
                        BillNumber          = BillNumberStr,
                        LedgerMasterId      = GetSourceIdFromOpdEmrID,
                        PatientId           = model.PatientInformationModel.EmergencyMasterId,
                        PatientLogId        = HospitalManagementSystem.Utility.getPatientLogID(model.PatientInformationModel.EmergencyMasterId),
                        JVStatus            = false,
                        CreatedBy           = Utility.GetCurrentLoginUserId(),
                        CreatedDepartmentId = Utility.GetCurrentUserDepartmentId(),
                        CreatedDate         = DateTime.Now,
                        Remarks             = "NA",
                        Status              = true,
                        PaidOnPaid          = true,
                        Narration2          = item.Tim.ToString(),
                        ItemID              = item.TestId
                    };
                    ent.CentralizedBillings.Add(objCentralizedBilling);
                }
                //update Bill Number
                SetupHospitalBillNumber billNumber = (from x in ent.SetupHospitalBillNumbers
                                                      where x.DepartmentName == "Hospital" && x.FiscalYearId == 1
                                                      select x).First();
                billNumber.BillNumber = billNumber.BillNumber + 1;



                //update vouchernumber
                //SetupVoucherNumber vouchernumber = (from x in ent.SetupVoucherNumber
                //                                    where x.DepartmentID == 1002 && x.FiscalYear == 1
                //                                    select x).First();
                //vouchernumber.VoucherNo = vouchernumber.VoucherNo + 1;



                ent.SaveChanges();
            }
        }
        public ActionResult PopulateTestDetail(string ipValue, string ipTestID, string ipid, string ipDept, string tim, string disin, string amt, string userid)
        {
            PatientTestModel model = new PatientTestModel();

            if (string.IsNullOrWhiteSpace(ipid) == false && string.IsNullOrWhiteSpace(ipDept) == false)
            {
                //int DropDownListDepartmentId = Convert.ToInt32(ipDept);

                //if (DropDownListDepartmentId == 1001)//emergency
                //{
                //    model.DepartmentID = 1001;
                //    if (ipid != null && ipid != "" && (pro.CheckEmergencyIdExistOrNot(Convert.ToInt32(ipid)) != false))
                //    {
                //        model.PatientInformationModel = pro.GetPatientBasicInformationFromEmergency(Convert.ToInt32(ipid)).FirstOrDefault();
                //    }

                //}
                //else
                //{
                if (ipid != null && ipid != "" && (pro.CheckOpdIdExistOrNot(Convert.ToInt32(ipid)) != false))
                {
                    model.PatientInformationModel = pro.GetPatientBasicInformationFromOpd(Convert.ToInt32(ipid), 4).FirstOrDefault();
                }

                //}
            }
            if (string.IsNullOrWhiteSpace(ipValue) == false)
            {
                string Valuenew  = ipValue.Trim();
                int    BracIndex = ipValue.IndexOf('{') + 1;
                int    TotalLen  = ipValue.IndexOf('}') - 1;
                int    Len       = ipValue.Length;
                int    toval     = Len - BracIndex;
                string value     = ipValue.Substring(BracIndex, toval - 1);
                int    aa        = value.IndexOf('^') + 1;
                int    bb        = value.Length;
                int    lenth     = bb - aa;
                string str       = value.Substring(aa, lenth);
                foreach (var itemL in tempList)
                {
                    if (ipValue == itemL.TestName)
                    {
                        TempData["failed"] = "Test Name already exists";
                        model.TestCheckBoxListModelList = tempList;
                        return(View("Create", model));
                    }
                }
                model.TestCheckBoxListModelList = pro.getTestDetailTestIDWise(str, disin, amt, tim, userid);

                foreach (var item in model.TestCheckBoxListModelList)
                {
                    tempList.Add(item);
                }
            }
            if (string.IsNullOrWhiteSpace(ipTestID) == false && string.IsNullOrWhiteSpace(ipValue) == true)
            {
                //for patientinformation
                if (string.IsNullOrWhiteSpace(ipid) == false && string.IsNullOrWhiteSpace(ipDept) == false)
                {
                    //int DropDownListDepartmentId = Convert.ToInt32(ipDept);

                    //if (DropDownListDepartmentId == 1001)//emergency
                    //{
                    //    model.DepartmentID = 1001;
                    //    if (ipid != null && ipid != "" && (pro.CheckEmergencyIdExistOrNot(Convert.ToInt32(ipid)) != false))
                    //    {
                    //        model.PatientInformationModel = pro.GetPatientBasicInformationFromEmergency(Convert.ToInt32(ipid)).FirstOrDefault();
                    //    }

                    //}
                    //else
                    //{
                    if (ipid != null && ipid != "" && (pro.CheckOpdIdExistOrNot(Convert.ToInt32(ipid)) != false))
                    {
                        model.PatientInformationModel = pro.GetPatientBasicInformationFromOpd(Convert.ToInt32(ipid), 4).FirstOrDefault();
                    }

                    // }
                }
                //
                var itemToRemove = tempList.Single(x => x.TestId == Convert.ToInt32(ipTestID));
                tempList.Remove(itemToRemove);
            }
            model.PatientID = (Convert.ToInt32(ipid));
            model.TestCheckBoxListModelList = tempList;
            return(View("Create", model));
        }
        public ActionResult DoctroCommissionIndex()
        {
            PatientTestModel model = new PatientTestModel();

            return(View(model));
        }
 public ActionResult ViewCommissionDetails(PatientTestModel model)
 {
     pro.InsertPathoCommissionDetails(model);
     //return View(model);
     return(RedirectToAction("DisplayCommission"));
 }