public ActionResult SaveInsuranceDetails(InsuranceCard card) { var opdENtry = db.OpdRegisters.Find(card.OPDNo); opdENtry.TariffId = card.SchemeId; db.SaveChanges(); //Get the first Item with word Consultation var Consultation = opdENtry.BillServices.FirstOrDefault(e => e.Service.ServiceName.ToLower().Contains("consultation")); if (Consultation != null) { //Get Id of the service from ServicePrices var ServicePrice = db.ServicesPrices. FirstOrDefault(e => e.ServiceId == Consultation.Service.Id && e.TariffId == card.SchemeId); if (ServicePrice != null) { //Get the Company From Scheme var Company = db.Tariffs.Find(card.SchemeId).Company; //Get Insurance Prices var IPrice = db.InsurancePrices.FirstOrDefault(e => e.CompanyId == Company.Id && e.ServicesPrice.ServiceId == ServicePrice.ServiceId); if (IPrice != null) { Consultation.Price = IPrice.Price; } } } //re price all unpaid bill services foreach (var unpaid in opdENtry.BillServices.Where(e => !e.Paid)) { hs.ApplyAward(unpaid.Id); } card.DateAdded = DateTime.Now; db.InsuranceCards.Add(card); db.SaveChanges(); var billItems = db.BillServices.Where(e => e.OPDNo == card.OPDNo).ToList(); return(PartialView("~/Views/Registration/ProvisionalBillServices.cshtml", billItems)); }
public int IPDSaveInsuranceDetails(InsuranceCard card) { var opdENtry = db.OpdRegisters.Find(card.OPDNo); opdENtry.TariffId = card.SchemeId; db.SaveChanges(); card.DateAdded = DateTime.Now; db.InsuranceCards.Add(card); db.SaveChanges(); return(1); //var billItems = db.BillServices.Where(e => e.OPDNo == card.OPDNo).ToList(); //return PartialView("~/Views/Registration/ProvisionalBillServices.cshtml", billItems); }