public int Edit_InvoiceMaster(InvoiceMaster _user) { SqlParameter[] param = { new SqlParameter("@InvoiceId", _user.InvoiceId), /* new SqlParameter("@InvoiceNo", _user.InvoiceNo), * new SqlParameter("@CompanyId", _user.CompanyId), * new SqlParameter("@CreatedDate", _user.CreatedDate), * new SqlParameter("@CustomerName", _user.CustomerName), * new SqlParameter("@Address", _user.Address), * new SqlParameter("@PhoneNo", _user.PhoneNo), * new SqlParameter("@EmailId", _user.EmailId), * new SqlParameter("@SubTotalAmount", _user.SubTotalAmount), * new SqlParameter("@TaxName1", _user.TaxName1), * new SqlParameter("@TaxRate1", _user.TaxRate1), * new SqlParameter("@TaxName2", _user.TaxName2), * new SqlParameter("@TaxRate2", _user.TaxRate2), * new SqlParameter("@DiscountRate", _user.DiscountRate), * new SqlParameter("@AdditionCharge", _user.AdditionCharge), * new SqlParameter("@NetAmount", _user.NetAmount), * new SqlParameter("@Comment", _user.Comment), * new SqlParameter("@SalePersonName", _user.SalePersonName), */ new SqlParameter("@PaymentStatus", _user.PaymentStatus) /*, * new SqlParameter("@LastUpdateDate", _user.LastUpdateDate), */ }; return(_da.Execute("Update_InvoiceMaster", param)); }
public void AddInvoice(IInvoice invoice) { InvoiceMaster master = new InvoiceMaster { InvoiceId = invoice.InvoiceId, InvoiceName = invoice.InvoiceName, IsActive = invoice.IsActive }; _invoiceDbContext.InvoiceMaster.Add(master); foreach (var rule in invoice.Rules) { var rd = new RuleDetails { RuleValue = rule.RuleValue, InvoiceId = master.InvoiceId, ParameterId = rule.ParameterId, IsActive = rule.IsActive }; _invoiceDbContext.RuleDetails.Add(rd); } _invoiceDbContext.SaveChanges(); }
// GET: InvoiceMasters/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var companyId = Convert.ToInt32(Session["CompanyID"]); InvoiceMaster invoiceMaster = db.InvoiceMasters.Where(x => x.Company_Id == companyId && x.invoice_no == id).FirstOrDefault(); foreach (var item in invoiceMaster.InvoiceDetails) { TempData["P_" + item.Product.Id] = AvailableQuantity(item.Product.Id); } if (invoiceMaster == null) { return(HttpNotFound()); } var CompanyId = Convert.ToInt32(Session["CompanyID"]); ViewBag.invoice_no = invoiceMaster.invoice_no; ViewBag.customer_id = new SelectList(db.Customers.Where(x => x.Company_Id == CompanyId), "Id", "CustomerName"); ViewBag.product_id = db.Products.Where(x => x.Company_Id == CompanyId).ToList(); var year_id = Session["FinancialYearID"]; var year = db.FinancialYears.Find(year_id); ViewBag.StartYear = year.StartDate.ToString("dd-MMM-yyyy"); ViewBag.EndYear = year.EndDate.ToString("dd-MMM-yyyy"); return(View(invoiceMaster)); }
public DataTable SA_SelectInvoice(InvoiceMaster _user) { SqlParameter[] param = { }; return(_da.GetFromDataTable("SA_Select_Invoice", param)); }
// function to add invoice and corresponding rules to database public void AddInvoice(InvoicePostModel invoicePostModel) { //get invoice details from InvoicePostModel and save to database InvoiceMaster invoiceMaster = new InvoiceMaster() { invoiceName = invoicePostModel.invoiceName, //convert boolean isActive in InvoicePostModel to byte isActive for InvoiceMaster isActive = invoicePostModel.isActive ? Convert.ToByte(1) : Convert.ToByte(0) }; tariffContext.InvoiceMaster.Add(invoiceMaster); //get each rule from InvoicePostModel and save to database with invoiceId from above saved invoice foreach (Rule rule in invoicePostModel.ruleList) { RuleDetails ruleDetails = new RuleDetails() { invoiceId = invoiceMaster.invoiceId, parameterId = Convert.ToInt32(rule.parameterId), ruleValue = rule.ruleValue, //convert boolean isActive in InvoicePostModel for each rule to byte isActive for RuleDetails isActive = rule.isActive ? Convert.ToByte(1) : Convert.ToByte(0) }; tariffContext.RuleDetails.Add(ruleDetails); } tariffContext.SaveChanges(); }
public int Update(InvoiceModel model) { Mapper.CreateMap <InvoiceModel, InvoiceMaster>(); InvoiceMaster objUser = Dbcontext.InvoiceMasters.SingleOrDefault(m => m.IID == model.IID); objUser = Mapper.Map(model, objUser); return(Dbcontext.SaveChanges()); }
public DataTable SA_SelectInvoiceStatus(InvoiceMaster _user) { SqlParameter[] param = { new SqlParameter("@PaymentStatus", _user.PaymentStatus) }; return(_da.GetFromDataTable("SA_Select_InvoiceStatus", param)); }
public DataTable SelectInvoiceById(InvoiceMaster _user) { SqlParameter[] param = { new SqlParameter("@InvoiceId", _user.InvoiceId) }; return(_da.GetFromDataTable("Select_InvoiceById", param)); }
public ActionResult Edit(InvoiceMaster invoiceMaster, List <InvoiceDetail> nInvoiceDetails, string deleted_items) { var ditems = deleted_items.Split(',').Where(s => s != String.Empty).ToList(); if (ModelState.IsValid) { try { invoiceMaster.created_at = DateTime.Now; //db.Entry(invoiceMaster.InvoiceDetails).State = EntityState.Unchanged; db.Entry(invoiceMaster).State = EntityState.Modified; foreach (var item in invoiceMaster.InvoiceDetails) { db.Entry(item).State = EntityState.Modified; } db.SaveChanges(); if (nInvoiceDetails != null) { foreach (var item in nInvoiceDetails) { item.created_at = DateTime.Now; item.invoice_id = invoiceMaster.Id; db.InvoiceDetails.Add(item); } db.SaveChanges(); } if (ditems.Count() > 0) { foreach (var item in ditems) { var a = Convert.ToInt32(item); var id = db.InvoiceDetails.Where(x => x.Id == a).FirstOrDefault(); if (id != null) { db.InvoiceDetails.Remove(id); } } db.SaveChanges(); } } catch { } return(RedirectToAction("Index")); } var CompanyId = Convert.ToInt32(Session["CompanyID"]); ViewBag.invoice_no = invoiceMaster.invoice_no; ViewBag.customer_id = new SelectList(db.Customers.Where(x => x.Company_Id == CompanyId), "Id", "CustomerName"); ViewBag.product_id = db.Products.Where(x => x.Company_Id == CompanyId).ToList(); return(View(invoiceMaster)); }
public ActionResult DeleteConfirmed(int id) { var companyId = Convert.ToInt32(Session["CompanyID"]); InvoiceMaster invoiceMaster = db.InvoiceMasters.Where(x => x.Company_Id == companyId && x.invoice_no == id).FirstOrDefault(); db.InvoiceMasters.Remove(invoiceMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IActionResult> Create([Bind("ClienteId")] InvoiceMaster master) { master.InvoiceDetalles = invoiceDetalles; master.FechaFactura = DateTime.Now; _context.InvoiceMaster.Add(master); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public DataTable SA_SelectInvoiceDate(InvoiceMaster _user, DateTime StartDate, DateTime EndDate) { SqlParameter[] param = { new SqlParameter("@PaymentStatus", _user.PaymentStatus), new SqlParameter("@StartDate", StartDate), new SqlParameter("@EndDate", EndDate) }; return(_da.GetFromDataTable("SA_Select_InvoiceDate", param)); }
public IActionResult Create() { ViewData["Clientes"] = new SelectList(_context.Clientes, "Id", "Nombre"); ViewData["Articulos"] = new SelectList(_context.Articulos, "Id", "Name"); _master = new InvoiceMaster() { InvoiceDetalles = invoiceDetalles is null ? new List <InvoiceDetalle>() : invoiceDetalles }; return(View(_master)); }
public Object SaveInvoice(dynamic data) { InvoiceMaster invoiceMaster = JsonConvert.DeserializeObject <InvoiceMaster>(data.ToString()); _invoiceLogic.AddorUpdate(invoiceMaster); return(new { success = true, InvoiceMaster = new { Record = invoiceMaster, TotalRecords = 1 }, InvoiceDetails = new { Record = invoiceMaster.InvoiceDetails, TotalRecords = invoiceMaster.InvoiceDetails.Count } }); }
//function to edit invoice details public void EditInvoice(int id, InvoiceMaster invoiceMaster) { tariffContext.Entry(invoiceMaster).State = EntityState.Modified; try { tariffContext.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } }
public int Insert(InvoiceModel model) { try { Mapper.CreateMap <InvoiceModel, InvoiceMaster>(); InvoiceMaster objUser = Mapper.Map <InvoiceMaster>(model); Dbcontext.InvoiceMasters.Add(objUser); return(Dbcontext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public InvoiceModel getByID(int id) { try { Mapper.CreateMap <InvoiceMaster, InvoiceModel>(); InvoiceMaster objCityMaster = Dbcontext.InvoiceMasters.Where(m => m.IID == id).SingleOrDefault(); InvoiceModel objCityItem = Mapper.Map <InvoiceModel>(objCityMaster); return(objCityItem); } catch (Exception ex) { throw ex; } }
// GET: InvoiceMasters/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var companyId = Convert.ToInt32(Session["CompanyID"]); InvoiceMaster invoiceMaster = db.InvoiceMasters.Where(x => x.Company_Id == companyId && x.invoice_no == id).FirstOrDefault(); if (invoiceMaster == null) { return(HttpNotFound()); } return(View(invoiceMaster)); }
public bool DeleteByID(int id) { try { Mapper.CreateMap <InvoiceMaster, InvoiceModel>(); InvoiceMaster objCityMaster = Dbcontext.InvoiceMasters.Where(m => m.IID == id).SingleOrDefault(); Dbcontext.InvoiceMasters.Remove(objCityMaster); Dbcontext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public ActionResult Create(InvoiceMaster invoice) { if (ModelState.IsValid) { invoice.created_at = DateTime.Now; db.InvoiceMasters.Add(invoice); db.SaveChanges(); return(RedirectToAction("Index")); } var CompanyId = Convert.ToInt32(Session["CompanyID"]); ViewBag.customer_id = new SelectList(db.Customers.Where(x => x.Company_Id == CompanyId), "Id", "CustomerName"); ViewBag.product_id = db.Products.Where(x => x.Company_Id == CompanyId).ToList(); return(View()); }
public IActionResult EditInvoiceMaster([FromRoute] int id, [FromBody] InvoiceMaster invoiceMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != invoiceMaster.invoiceId) { return(BadRequest()); } tariffService.EditInvoice(id, invoiceMaster); return(NoContent()); }
public InvoiceViewModel(int PageMode) { try { Mode = PageMode; if (pxy == null) { pxy = new DataServiceClient(); } objInvoiceMaster = new InvoiceMaster(); lstStatus = new ObservableCollection <Lookup>(); lstInvoiceProduct = new ObservableCollection <InvoiceProduct>(); lstVendor = new ObservableCollection <VendorMaster>(); lstProduct = new ObservableCollection <ProductList>(); lstSearch = new ObservableCollection <Search> { new Search { ID = 1, Desc = "InvoiceNo" }, new Search { ID = 2, Desc = "OrderID" } }; searchMode = 2; lstVendor = pxy.GetVendorList(); lstProduct = pxy.GetProductList(); lstStatus = pxy.GetSubLookupList(Const.InvoiceStatus); cmdSearch = new DelegateCommand <object>(cmdSearch_Execute, cmdSearch_CanExecute); cmdSave = new DelegateCommand <object>(cmdSave_Execute, cmdSave_CanExecute); cmdClear = new DelegateCommand <object>(cmdClear_Execute); cmdAdd = new DelegateCommand <object>(cmdAdd_Execute, canExecute); cmdDelete = new DelegateCommand <object>(cmdDelete_Execute, canExecute); cmdGST = new DelegateCommand <object>(cmdGST_Execute); ModeAction(); IsCSGST = false; IsIGST = false; } catch (FaultException ex) { UIHelper.ShowErrorMessage(ex.Message); } }
public InvoiceMaster CommitAction(Boolean iscommit, int id) { InvoiceMaster q = (from invmstr in cntxt.InvoiceMasters where invmstr.InvoicemasterID == id select invmstr).FirstOrDefault(); q.IsCommited = true; foreach (InvoiceDetail element in q.InvoiceDetails.ToList()) { Product p = cntxt.Products.Find(element.ProductId); p.IsDelivered = true; p.IsAvailable = false; p.DeliveredQty = element.Qty; } cntxt.SaveChanges(); return(q); }
public ActionResult SinglePrint(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var companyId = Convert.ToInt32(Session["CompanyID"]); InvoiceMaster invoiceMaster = db.InvoiceMasters.Where(x => x.CompanyId == companyId && x.invoice_no == id).FirstOrDefault(); if (invoiceMaster != null) { string footer = String.Format("--footer-center \"E & O.E. - Subject to Jaipur Jurisdiction only - For {0}\"", invoiceMaster.Company.Name); PrinterModel pm = new PrinterModel() { No = invoiceMaster.invoice_no, Company = invoiceMaster.Company, CreatedOn = (invoiceMaster.created_on.HasValue) ? invoiceMaster.created_on.Value : DateTime.Now, Customer = invoiceMaster.Customer.CustomerName, ShowTotal = true, Discount = (invoiceMaster.discount.HasValue) ? invoiceMaster.discount.Value : 0, Gross = invoiceMaster.gross_amount, NetTotal = invoiceMaster.net_amount, Items = invoiceMaster.InvoiceDetails.Select(x => new PrinterItem() { Particular = x.Product.ProductName, Pcs = x.quantity, Rate = x.sale_rate }) .ToList() }; return(new ViewAsPdf("SinglePrint", pm) { PageSize = Rotativa.Options.Size.A4, CustomSwitches = footer }); } return(HttpNotFound()); }
private void cmdSave_Execute(object obj) { try { if (Mode == PageMode.Add || Mode == PageMode.Modify) { UpdateValues(); if (pxy.InsertUpdateInvoice(objInvoiceMaster, Global.UserID, Mode)) { UIHelper.ShowMessage("Data Saved Successfully"); objInvoiceMaster = new InvoiceMaster(); } } else if (Mode == PageMode.Delete) { if (pxy.DeleteInvoice(InvoiceNo)) { UIHelper.ShowMessage("Data Deleted Successfully"); objInvoiceMaster = new InvoiceMaster(); } } else if (Mode == PageMode.Browse) { var InvoiceProduct = objInvoiceMaster.lstInvoiceProduct.FirstOrDefault(p => p.Status != 2); if (InvoiceProduct == null) { UIHelper.ShowErrorMessage("Returned Invoice!"); return; } Views.GenReports win = new Views.GenReports(InvoiceNo, InvoiceProduct.InvoiceDate); win.ShowDialog(); } } catch (FaultException ex) { UIHelper.ShowErrorMessage(ex.Message); } }
private void CallAllRecurringInvoice() { this.objRecurringMasterDT = this.objRecurringMasterBll.GetAllActiveTodayRecurring(); if (this.objRecurringMasterDT.Rows.Count <= 0) { return; } for (int index = 0; index < this.objRecurringMasterDT.Rows.Count; ++index) { int iRecurringID = int.Parse(this.objRecurringMasterDT.Rows[index]["RecurringID"].ToString()); int num1 = int.Parse(this.objRecurringMasterDT.Rows[index]["CompanyID"].ToString()); int num2 = int.Parse(this.objRecurringMasterDT.Rows[index]["ClientID"].ToString()); int iFrequencyID = int.Parse(this.objRecurringMasterDT.Rows[index]["HowOften"].ToString()); DateTime dtNextDate = DateTime.Parse(this.objRecurringMasterDT.Rows[index]["NextDate"].ToString()); string str1 = this.objRecurringMasterDT.Rows[index]["RemainingInvoice"].ToString(); bool bRecurringActive = true; string s; try { s = int.Parse(str1.Trim()).ToString(); } catch (Exception ex) { s = "-1"; } this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(iFrequencyID); if (this.objFrequencyMasterDT.Rows.Count > 0) { int num3 = int.Parse(this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString()); dtNextDate = dtNextDate.AddDays((double)num3); } string sRemainingInvoice; switch (s) { case "-1": sRemainingInvoice = "infinite"; break; default: sRemainingInvoice = (int.Parse(s) - 1).ToString(); if (sRemainingInvoice == "0") { bRecurringActive = false; break; } break; } this.objRecurringMasterBll.UpdateForSentInvoice(iRecurringID, sRemainingInvoice, dtNextDate, bRecurringActive); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByCompanyID(num1); string str2 = this.objInvoiceMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : InvoiceMaster.NextNum(this.objInvoiceMasterDT.Rows[this.objInvoiceMasterDT.Rows.Count - 1]["InvoiceNumber"].ToString()); int num4 = this.objInvoiceMasterBll.AddInvoice(str2, iRecurringID); this.objRecurringItemDetailDT = this.objRecurringItemDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringItemDetailDT.Rows.Count > 0) { this.objInvoiceItemDetailBll.AddInvoiceItem(num4, iRecurringID); } this.objRecurringTaskDetailDT = this.objRecurringTaskDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringTaskDetailDT.Rows.Count > 0) { this.objInvoiceTaskDetailBll.AddInvoiceTask(num4, iRecurringID); } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(num2); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.SendMail(this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(), str2, num4, num2, num1); } } }
public void Update(InvoiceMaster invoiceMaster) { throw new NotImplementedException(); }
private void InvoiceMaster_Click(object sender, RoutedEventArgs e) { InvoiceMaster invMaster = new InvoiceMaster(); invMaster.ShowDialog(); }
public InvoiceMaster AddorUpdate(InvoiceMaster master) { _invoiceMasterRepository.AddOrUpdate(master); _invoiceMasterRepository.SaveChanges(); return(master); }
public dynamic ToDBCampAdmission(CampAdmission CampAdmission) { if (CampAdmission.Patient_Name != null || CampAdmission.Patient_Name != "") { var mrNo = ""; var uin = ""; var aadNo = ""; var ipano = ""; var ipno = ""; var invno = ""; var patientClass = ""; var statusDesc = Context.State_Master.Where(x => x.State_Name == CampAdmission.C_StateDesc).Select(x => x.State_Code).FirstOrDefault(); CampAdmission.StateCode = statusDesc; var CountryDesc = Context.Country_Master.Where(x => x.Country_Name == CampAdmission.C_CountryDesc).Select(x => x.Country_Code).FirstOrDefault(); CampAdmission.ContryCode = CountryDesc; var Districtcodes = Context.District_Master.Where(x => x.District_Name == CampAdmission.C_DistrictDesc).Select(x => x.District_Code).FirstOrDefault(); CampAdmission.DistrictCode = Districtcodes; var talukcodes = Context.Taluk_Master.Where(x => x.Taluk_Name == CampAdmission.C_TalukDesc).Select(x => x.Taluk_Code).FirstOrDefault(); CampAdmission.Taluk_Code = talukcodes; if (CampAdmission.IsCOTChecked == "Y") { CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.COTCharges).FirstOrDefault(); } else if (CampAdmission.IsMATChecked == "Y") { CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.MATCharges).FirstOrDefault(); } mrNo = GenerateRunningCtrlNo("MR_NO_CAMP", CampAdmission.Site_ID); uin = GenerateRunningCtrlNo("UIN", CampAdmission.Site_ID); CampAdmission.mr_no = mrNo; CampAdmission.uin = uin; if (CampAdmission.IDProof_Desc == "Aadhar Card") { aadNo = CampAdmission.IDProof_Code; } //if (CampAdmission.bedCharges > 0) //{ // ipano = GenerateRunningCtrlNo("CIPA_NO", CampAdmission.Site_ID); // patientClass = "SITE03"; //} //else if (CampAdmission.bedCharges == 0) //{ ipano = GenerateRunningCtrlNo("FIPA_NO", CampAdmission.Site_ID); patientClass = "SITE02"; // } ipno = GenerateRunningCtrlNo("CAMP_IP_NO ", CampAdmission.Site_ID); CampAdmission.ipno = ipno; invno = GenerateRunningCtrlNo("INVOICE_NO", CampAdmission.Site_ID); var icpl = new Ip_Camp_Place(); icpl.mr_no = mrNo; icpl.ipa_no = ipano; icpl.Admission_place = CampAdmission.Admission_Place; icpl.Sysdate = DateTime.Now; Context.ip_camp_place.Add(icpl); var ipadmissions = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).FirstOrDefault(); if (ipadmissions != null) { ipadmissions.LAST_ALLOCATION -= 1; Context.Entry(ipadmissions).State = EntityState.Modified; } var isOPeXists = Context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == patientClass).Count(); var opvd = Context.Op_Visit_Datewise.Where(x => x.Patient_Class == patientClass && x.Date == DateTime.Now.Date).FirstOrDefault(); var opvdw = new OpVisitDatewise(); opvdw.Patient_Class = patientClass; opvdw.Date = DateTime.Now.Date; opvdw.New = 0; opvdw.Old = 0; opvdw.Week_Day = (int)DateTime.Now.DayOfWeek; if (isOPeXists > 0) { //Context.Op_Visit_Datewise.Update(opvdw); if (opvd != null) { opvd.Admission += 1; Context.Entry(opvd).State = EntityState.Modified; } } //else if (isOPeXists == 0) //{ // Context.Op_Visit_Datewise.Add(opvdw); //} var PRM = new PatientRegistrationMaster(); PRM.MR_NO = mrNo; PRM.IP_NO = ipno; PRM.Patient_Class = patientClass; PRM.Patient_Name = CampAdmission.Patient_Name; PRM.Next_Of_Kin = $"{CampAdmission.Next_Of_Kin_Prefix},{CampAdmission.Next_Of_Kin_Suffix}"; PRM.Date_Of_Birth = CampAdmission.Patient_DOB; PRM.Sex = CampAdmission.Gender; PRM.Door = CampAdmission.Door; PRM.Street_Locality = CampAdmission.Street; PRM.Pincode = CampAdmission.Pincode; PRM.Town_City = CampAdmission.City; PRM.Taluk = CampAdmission.Taluk_Code; PRM.District = CampAdmission.DistrictCode; PRM.State = CampAdmission.StateCode; PRM.Country = CampAdmission.ContryCode; PRM.Phone = CampAdmission.Phone_No; PRM.Registered_Date = DateTime.Now; PRM.Last_Visit_Date = DateTime.Now; PRM.AadhaarNo = CampAdmission.Master.AadhaarNo; PRM.Base_Unit = "LC15"; PRM.Last_Unit_Visited = "LC15"; PRM.Visit_Number = 1; PRM.Sysdate = DateTime.Now; PRM.UIN = uin; //PRM.AadhaarNo = aadNo; PRM.SiteId = CampAdmission.Site_ID; Context.Patient_Registration_Master.Add(PRM); var PRD = new PatientRegistrationDetail(); PRD.MR_NO = mrNo; PRD.Allocation_Code = "LC15"; PRD.Visit_Date = DateTime.Now; PRD.Visit_Number = 1; PRD.Category_Code = "CATC002"; PRD.Type_Code = "PTY001"; PRD.Instance_Code = "INSC001"; PRD.Speciality_Code = "SPC001"; PRD.Sysdate = DateTime.Now; PRD.Allocation_Code = "LC007"; PRD.Camp_Code = CampAdmission.Camp_Code; PRD.UIN = uin; PRD.SiteId = CampAdmission.Site_ID; Context.Patient_Registration_Detail.Add(PRD); var LM = new MRLocationMaster(); LM.MR_NO = mrNo; LM.Location_Code = "LC15"; LM.Patient_Name = CampAdmission.Patient_Name; LM.Town_City = CampAdmission.City; LM.UIN = uin; LM.SiteId = 1; Context.MR_Location_Master.Add(LM); var PS = new PatientStatus(); PS.Visit_Date = DateTime.Now; PS.MR_NO = mrNo; PS.Assign_Doctor = "N"; PS.UIN = uin; //PS.PurposeId = Convert.ToInt32( CampAdmission.Camp_Code); PS.PurposeId = 42; PS.SiteId = CampAdmission.Site_ID; Context.Patient_Status.Add(PS); if (CampAdmission.History.Count() > 0) { foreach (var item in CampAdmission.History.ToList()) { var PH = new PatientHistory(); PH.UIN = uin; PH.MR_NO = mrNo; PH.PatientHistoryDescription = item.PatientHistoryDescription; PH.DurationMonth = item.DurationMonth; PH.DurationYear = item.DurationYear; PH.CreatedUTC = DateTime.Now; PH.CreatedBy = Convert.ToInt32(CampAdmission.Operator_ID); PH.SiteId = CampAdmission.Site_ID; Context.PatientHistory.AddRange(PH); } } var IDPD = new IDProofDtl(); IDPD.UIN = uin; IDPD.MR_NO = mrNo; IDPD.PROOF_TYPE = CampAdmission.IDProof_Code; IDPD.PROOF_NO = CampAdmission.IDProof_Desc; IDPD.CASTE_CODE = Convert.ToString(CampAdmission.Caste_Code); Context.IDProof_Dtl.Add(IDPD); var IPSD = new IpSurgeryDtl(); IPSD.Ipa_No = ipano; IPSD.Surgery_Code = CampAdmission.Surgery_Code; IPSD.Surgery_Type_Code = "T"; IPSD.Anaesthesia = "AN002"; IPSD.Doctor_Code = "401"; IPSD.Eye = CampAdmission.Eye_Code; IPSD.Surgery_Date = DateTime.Now.Date; IPSD.Surgery_Approval = "Y"; IPSD.Surgery_Done = "N"; IPSD.SiteId = CampAdmission.Site_ID; IPSD.UIN = uin; Context.Ip_Surgery_Dtl.Add(IPSD); var IPAcc = new IPAccount(); IPAcc.Ipa_No = ipano; IPAcc.Mr_No = mrNo; IPAcc.Status = "ADM"; IPAcc.System = DateTime.Now; IPAcc.Ip_No = ipno; IPAcc.Siteid = CampAdmission.Site_ID; IPAcc.Uin = uin; PRM.IPAccountIC = new List <IPAccount>() { IPAcc }; var IPA = new IPAdmission(); IPA.Ipa_No = ipano; IPA.Ip_No = ipno; IPA.Mr_No = mrNo; IPA.Surgery_Code = CampAdmission.Surgery_Code; IPA.Surgery_Type_Code = "T"; IPA.Admission_Date = DateTime.Now; IPA.Room_Type = "FREETYPE7"; IPA.Room_No = CampAdmission.Room_No; IPA.Expected_Discharge_Date = DateTime.Now.AddDays(2); IPA.Doctor_Code = "401"; IPA.Category_Code = "CATC002"; IPA.Anesthesia = "AN002"; IPA.Discharge_Status = "ADM"; IPA.Eye = CampAdmission.Eye_Code; //IPA.Ipa_No = ipno; IPA.Room_Type2 = null; IPA.Lens_Code = CampAdmission.Lens_Code; IPA.Operator_Code = CampAdmission.Operator_ID; IPA.Camp_Code = CampAdmission.Camp_Code; IPA.UIN = uin; IPA.SiteId = CampAdmission.Site_ID; PRM.IPAdmissionIC = new List <IPAdmission>() { IPA }; if (CampAdmission.bedCharges > 0) { var IM = new InvoiceMaster(); IM.Invoice_No = invno; IM.Invoice_Date = DateTime.Now; IM.Invoice_Value = float.Parse(CampAdmission.bedCharges.ToString()); IM.Invoice_Received_Value = float.Parse(CampAdmission.bedCharges.ToString()); IM.Module_Code = "MOD4"; IM.SiteId = CampAdmission.Site_ID; IM.UIN = uin; IM.MR_NO = mrNo; PRM.Invoice_Master = new List <InvoiceMaster>() { IM }; var accDtl = new IpAccountDtl(); if (CampAdmission.bedCharges > 0) { accDtl.Ipa_Sl_No = Convert.ToInt32(GenerateRunningCtrlNo("IPA_SL_NO", CampAdmission.Site_ID)); accDtl.Ipa_No = ipano; accDtl.Cash_Flow_Code = "501"; accDtl.Tinvoice_No = invno; accDtl.Sysdate = DateTime.Now; accDtl.Date = DateTime.Now.Date; accDtl.Cost_Value = Convert.ToDecimal(CampAdmission.bedCharges); accDtl.UIN = uin; accDtl.SiteId = CampAdmission.Site_ID; Context.Ip_Account_Dtl.Add(accDtl); } var cashPaid = new CashPaid(); if (CampAdmission.bedCharges > 0) { cashPaid.Operator_Code = CampAdmission.Operator_ID; cashPaid.Module_Code = "MOD4"; cashPaid.MR_NO = mrNo; cashPaid.IPA_NO = ipano; cashPaid.Receipt_NO = GenerateRunningCtrlNo("FRES_RECEIPT_NO", CampAdmission.Site_ID); cashPaid.Fees_Paid = Convert.ToDouble(CampAdmission.bedCharges); cashPaid.Date = DateTime.Now.Date; cashPaid.Transaction_Code = "RECPT"; cashPaid.Category_Code = "CATC001"; cashPaid.Sysdate = DateTime.Now; cashPaid.OP_IP_Flag = "IP"; cashPaid.Paymode_Code = "PC001"; cashPaid.Outstanding = "N"; cashPaid.Invoice_No = invno; cashPaid.UIN = uin; cashPaid.SiteId = CampAdmission.Site_ID; Context.Cash_Paid.Add(cashPaid); } } } try { if (Context.SaveChanges() > 0) { return new { Success = true, name = CampAdmission.Patient_Name, eyes = CampAdmission.Eye_Code, taluks = CampAdmission.C_TalukDesc, DistrictDesc = CampAdmission.C_DistrictDesc, StateDesc = CampAdmission.C_StateDesc, CountryDesc = CampAdmission.C_CountryDesc, MRNO = CampAdmission.mr_no, UIN = CampAdmission.uin, Siteid = CampAdmission.Site_ID, campcodes = CampAdmission.Camp_Code, campnames = Context.CAMP_MASTER.Where(x => x.CAMP_CODE == CampAdmission.Camp_Code).Select(x => x.CAMP_NAME).FirstOrDefault(), ages = CampAdmission.Age, sex = CampAdmission.Gender, kins = CampAdmission.Next_Of_Kin_Suffix, room = CampAdmission.Room_No, town = CampAdmission.City, numer = CampAdmission.Phone_No, ipnos = CampAdmission.ipno, VacantBed = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.LAST_ALLOCATION).FirstOrDefault(), Endrange = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.END_RANGE).FirstOrDefault(), } } ; } catch (Exception ex) { Console.WriteLine(ex); } return(new { Success = false, message = "Details not saved!" }); }