public string InvoiceCheck(string xmlMessage) { string result = "<UpdateData>" + "<Result>False</Result>" + "<Description></Description></UpdateData>"; string logID = Guid.NewGuid().ToString(); try { FileLogger.WriteLog(logID + "|Start:" + xmlMessage, 1, "", "InvoiceCheck"); if (Helper.CheckAuthCode("UpdateData", xmlMessage))//数据校验通过 { InvoiceHelper obj = new InvoiceHelper(); result = obj.InvoiceCheck(xmlMessage); } } catch (Exception err) { result = "<UpdateData>" + "<Result>False</Result>" + "<Description>" + err.Message + "</Description></UpdateData>"; } FileLogger.WriteLog(logID + "|End:" + result, 1, "", "InvoiceCheck"); return(result); }
void CreateInvoiceHelper() { var actions = CreateInvoiceEditActions(); var dataSource = ViewModel.CreateInvoiceDataSource(); this.invoiceHelper = new InvoiceHelper(spreadsheetControl1.Document, dataSource, actions); }
public void Load() { textBoxMaNhap.Text = invoice.ID.ToString(); textBoxTongTien.Text = ExtensionHelper.ChangeToCurrency(invoice.Cost.ToString()); textBoxNguoiMua.Text = invoice.NameCustomer; textBoxNguoiBan.Text = invoice.NameManager; TextBoxNgayNhap.Text = invoice.Time_Of_Purchase.Day.ToString(); TextBoxThangNhap.Text = invoice.Time_Of_Purchase.Month.ToString(); TextBoxNamNhap.Text = invoice.Time_Of_Purchase.Year.ToString(); // initialize the width of columns foreach (ColumnHeader column in listViewDetail.Columns) { column.Width = -2; } //listViewDetail.Columns[listViewDetail.Columns.Count - 1].Width = 0; ///// List <MedicineInvoiceDetail> details = InvoiceHelper.FindMedicineInvoiceDetails(invoice.ID); int i = 0; foreach (var item in details) { ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.Name_Medicine, item.Amount.ToString(), ExtensionHelper.ChangeToCurrency(item.Cost.ToString()) }); listViewDetail.Items.Add(listViewItem); i++; } }
public ActionResult PrintInvoiceV(int id, int hbId) { var invObj = InvoiceHelper.GetInvoiceInfoNew(hbId, id, false); ///return new Rotativa.ViewAsPdf("PrintInvoiceV", invObj) { FileName = "TestViewAsPdf.pdf" }; return(View(invObj)); }
/** * Performs a test by generating an invoice PDF using IronPDf. **/ private static async Task TestInvoiceAsync() { // generate invoice data var invoice = InvoiceHelper.GenerateRandomInvoice(10); // load templates var pageTemplate = await File.ReadAllTextAsync("Templates/Invoice.html"); var rowTemplate = await File.ReadAllTextAsync("Templates/InvoiceRow.html"); Handlebars.RegisterTemplate("positionRow", rowTemplate); // compile templates var template = Handlebars.Compile(pageTemplate); var result = template(invoice); // render to PDF using (var renderer = new HtmlToPdf { PrintOptions = { FirstPageNumber = 1, Footer = new SimpleHeaderFooter { DrawDividerLine = true, RightText = "Page {page} of {total-pages}" } } }) { var baseUri = new Uri(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Templates")); var pdf = await renderer.RenderHtmlAsPdfAsync(result, baseUri); pdf.SaveAs(_targetFilePath); } }
void CreateInvoiceHelper() { OrderCollections collections = new OrderCollections(); EditActions actions = new EditActions(); if (unitOfWork != null) { actions.ActivateEditor = () => { var activeSheet = AssociatedObject.ActiveWorksheet; if (activeSheet.Name == CellsHelper.InvoiceWorksheetName && activeSheet.CustomCellInplaceEditors.GetCustomCellInplaceEditors(activeSheet.Selection).Any()) { AssociatedObject.OpenCellEditor(XtraSpreadsheet.CellEditorMode.Edit); } }; actions.CloseEditor = () => { if (AssociatedObject.IsCellEditorActive) { AssociatedObject.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Cancel); } }; actions.GetCustomerStores = x => LoadCustomerStores(x); actions.CreateOrderItem = () => unitOfWork.OrderItems.Create(false); actions.AddOrderItem = x => { unitOfWork.OrderItems.Add(x); }; actions.RemoveOrderItem = x => { unitOfWork.OrderItems.Remove(x); }; actions.IsDefaultActions = false; collections = CreateOrderCollections(); } invoiceHelper = new InvoiceHelper(AssociatedObject.Document, new Tuple <OrderCollections, Order>(collections, order), actions); }
public async Task <IActionResult> GetPupms(string pumpNo, string branchCode) { var result = await Task.Run(() => { try { string errorMessage = string.Empty; var pumpsList = new InvoiceHelper().GetPumps(pumpNo, branchCode); dynamic expando = new ExpandoObject(); expando.PumpsList = pumpsList.Select(x => new { ID = x.PumpId, TEXT = x.PumpNo }); return(Ok(new APIResponse() { status = APIStatus.PASS.ToString(), response = expando })); } catch (Exception ex) { return(Ok(new APIResponse() { status = APIStatus.FAIL.ToString(), response = ex.Message })); } }); return(result); }
public async Task <List <ImportOutput> > CreateInvoices(List <UrenCSV> records, bool createInZoho) { List <Invoice> invoices = new(); List <ImportOutput> outputs = new(); var klantRecords = records.GroupBy(s => s.Klant); var sprintNumber = applicationSettings.SprintNumber; var invoiceDate = DateTime.Parse(applicationSettings.InvoiceDate); foreach (var klantItem in klantRecords) { if (applicationSettings.CustomerNamesWhichShouldBeGroupedByWorkOrderNumber.Contains(klantItem.Key.ToLower())) { var werkbonRecords = klantItem.GroupBy(s => s.Werkbonnummer); invoices.AddRange(CreateInvoices(sprintNumber, invoiceDate, klantItem.Key, werkbonRecords)); } else { invoices.Add(CreateInvoice(sprintNumber, invoiceDate, klantRecords.Where(s => s.Key == klantItem.Key).SelectMany(group => group).ToList(), klantItem.Key)); } } // Check the hours if (InvoiceHelper.GetQuantity(invoices) == applicationSettings.TotalAmountOfHours) { if (createInZoho) { foreach (var item in invoices) { ImportOutput output = new ImportOutput { Invoice = item }; try { output.InvoiceResponse = await SubmitInvoice(item); } catch (Exception ex) { output.InvoiceResponse = new InvoiceResponse { Code = -1, Message = ex.Message }; } outputs.Add(output); } } } if (outputs.Any()) { System.IO.File.WriteAllText(this.applicationSettings.OutputFile, JsonSerializer.Serialize(outputs)); } return(outputs); }
public ActionResult AddInvoice(int hbId, int invId = 0) { ViewBag.PaymentTerm = ListCommonHelper.GetPaymentTerm("en").Where(x => x.Key < 6).ToList(); ViewBag.CurrencyList = ListCommonHelper.GetCurrencyList(); var invObj = InvoiceHelper.GetInvoiceInfoNew(hbId, invId); return(View(invObj)); }
public ActionResult ViewInvoicePartial(int id, int hbId) { Session["invId"] = id; Session["hbId"] = hbId; var invObj = InvoiceHelper.GetInvoiceInfoNew(hbId, id, false); return(PartialView("~/Views/Invoice/_ViewInvoice.cshtml", invObj)); }
public bool RegisterStockshort(TblStockshortMaster stockshort, List <TblStockshortDetails> stockshortDetails) { try { //invoice.IsSalesReturned = false; //invoice.IsManualEntry = false; using (Repository <TblStockshortMaster> repo = new Repository <TblStockshortMaster>()) { //add voucher typedetails var user = repo.TblUser.Where(x => x.UserName == stockshort.UserName).FirstOrDefault(); var shift = repo.TblShift.Where(x => x.UserId == user.UserId).FirstOrDefault(); var _branch = GetBranches(stockshort.BranchCode).ToArray().FirstOrDefault(); var shiftid = repo.TblShift.Where(x => x.UserId == stockshort.UserId).FirstOrDefault(); stockshort.BranchCode = _branch.BranchCode; stockshort.BranchName = _branch.BranchName; stockshort.ServerDate = DateTime.Now; stockshort.StockshortDate = stockshort.StockshortDate; stockshort.StockshortNo = stockshort.StockshortNo; stockshort.ShiftId = shift.ShiftId; stockshort.UserId = user.UserId; stockshort.UserName = stockshort.UserName; stockshort.EmployeeId = -1; stockshort.Narration = stockshort.Narration; repo.TblStockshortMaster.Add(stockshort); repo.SaveChanges(); foreach (var stockshorts in stockshortDetails) { var _product = new InvoiceHelper().GetProducts(stockshorts.ProductCode).FirstOrDefault(); var operatorStockshortId = GetStockshortlist(stockshort.StockshortNo).FirstOrDefault(); #region StockIssueDetails stockshorts.StockshortMasterId = operatorStockshortId.StockshortMasterId; stockshorts.StockshortDetailsDate = DateTime.Now; stockshorts.ProductId = _product.ProductId; stockshorts.ProductCode = stockshorts.ProductCode; stockshorts.ProductName = stockshorts.ProductName; stockshorts.HsnNo = stockshorts.HsnNo; stockshorts.Rate = stockshorts.Rate; stockshorts.Qty = stockshorts.Qty; stockshorts.BatchNo = stockshorts.BatchNo; stockshorts.UnitId = Convert.ToDecimal(_product.UnitId); stockshorts.UnitName = stockshorts.UnitName; stockshorts.TotalAmount = Convert.ToDecimal(stockshorts.TotalAmount); repo.TblStockshortDetails.Add(stockshorts); repo.SaveChanges(); #endregion { } } } return(true); } catch (Exception ex) { throw ex; } }
public bool RegisterStocksexcess(TblStockExcessMaster stockexcessMaster, List <TblStockExcessDetails> stockexcessDetails) { try { using (Repository <TblStockshortMaster> repo = new Repository <TblStockshortMaster>()) { //add voucher typedetails var user = repo.TblUser.Where(x => x.UserName == stockexcessMaster.UserName).FirstOrDefault(); var shift = repo.TblShift.Where(x => x.UserId == user.UserId).LastOrDefault(); var _branch = GetBranches(stockexcessMaster.BranchCode).ToArray().FirstOrDefault(); var shiftid = repo.TblShift.Where(x => x.UserId == stockexcessMaster.UserId).FirstOrDefault(); stockexcessMaster.BranchCode = _branch.BranchCode; stockexcessMaster.BranchName = _branch.BranchName; stockexcessMaster.ServerDate = DateTime.Now; stockexcessMaster.StockExcessDate = stockexcessMaster.StockExcessDate; stockexcessMaster.StockExcessNo = stockexcessMaster.StockExcessNo; stockexcessMaster.ShiftId = shift.ShiftId; stockexcessMaster.UserId = user.UserId; stockexcessMaster.UserName = stockexcessMaster.UserName; stockexcessMaster.EmployeeId = -1; stockexcessMaster.Narration = stockexcessMaster.Narration; repo.TblStockExcessMaster.Add(stockexcessMaster); repo.SaveChanges(); foreach (var item in stockexcessDetails) { var _product = new InvoiceHelper().GetProducts(item.ProductCode).FirstOrDefault(); var operatorStockexcessId = GetStockexcesslist(stockexcessMaster.StockExcessNo).FirstOrDefault(); #region StockIssueDetails item.StockExcessMasterId = operatorStockexcessId.StockExcessMasterId; item.StockExcessDetailsDate = DateTime.Now; item.ProductId = _product.ProductId; item.ProductCode = item.ProductCode; item.ProductName = item.ProductName; item.HsnNo = item.HsnNo; item.Rate = item.Rate; item.Qty = item.Qty; item.BatchNo = item.BatchNo; item.UnitId = Convert.ToDecimal(_product.UnitId); item.UnitName = item.UnitName; item.TotalAmount = Convert.ToDecimal(item.TotalAmount); repo.TblStockExcessDetails.Add(item); repo.SaveChanges(); #endregion { } } } return(true); } catch (Exception ex) { throw ex; } }
protected decimal GetBasketSubtotal() { decimal basketTotal = 0; foreach (BasketItem bi in _DisplayedBasketItems) { basketTotal += (InvoiceHelper.GetInvoiceExtendedPrice(bi)); } return(basketTotal); }
protected decimal GetBasketGSTtotal() { decimal gstTotal = 0; foreach (BasketItem bi in _DisplayedBasketItems) { gstTotal += (InvoiceHelper.GetGSTPrice(bi)); } return(gstTotal); }
protected decimal GetBasketGrandtotal() { decimal grandTotal = 0; foreach (BasketItem bi in _DisplayedBasketItems) { grandTotal += (InvoiceHelper.GetInvoiceExtendedPrice(bi) * (decimal)1.1); } return(grandTotal); }
public ActionResult Delete(string id) { try { InvoiceHelper.Delete(id); return(RedirectToAction("Index")); } catch (Exception ex) { return(RedirectToAction("Index", new { message = ex.Message })); } }
public decimal GetProductQty(string branchCode, string productCode) { try { var data = new InvoiceHelper().GetProductQty(branchCode, productCode); return((decimal)data); } catch (Exception ex) { throw ex; } }
protected decimal GetBasketSubtotal() { decimal basketTotal = 0; IList <BasketItem> displayItems = BasketHelper.GetDisplayItems(AbleContext.Current.User.Basket, true, true); foreach (BasketItem bi in displayItems) { basketTotal += InvoiceHelper.GetInvoiceExtendedPrice(bi); } return(basketTotal); }
public IHttpActionResult GetNext(int id, bool cancel = false) { try { InvoiceHelper helper = new InvoiceHelper(); Invoice entity = helper.NextStep(UnitOfWork, id, cancel); return(Ok(Factory.Create(entity))); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Delete(int invId, string deleteReason) { #region Check Rights bool hasRights = false; hasRights = AdminHelper.CheckUserAction(ScreenEnum.InvoiceList, ActionEnum.Delete); if (!hasRights) { return(Json("You are UnAuthorized to do this action", JsonRequestBehavior.AllowGet)); } #endregion string isDeleted = InvoiceHelper.Delete(invId, deleteReason); return(Json(isDeleted, JsonRequestBehavior.AllowGet)); }
public InvoiceMasterModel GetInvoices(decimal businessId, int invoiceTypeId) { InvoiceMasterModel result = new InvoiceMasterModel(); List <InvoicePartyModel> Invoices = InvoiceApiServices.Instance.getPartyInvoices(businessId, invoiceTypeId); List <TaxCodeModel> TaxCodes = InvoiceApiServices.Instance.getTaxCodes(businessId); List <TransectionModel> PartyTransections = new List <TransectionModel>(); if (invoiceTypeId == (int)ObjectEnum.SalesInvoice || invoiceTypeId == (int)ObjectEnum.PurchaseInvoice) { PartyTransections = InvoiceApiServices.Instance.getPartyTransections(businessId, invoiceTypeId); } List <Attachment> attachments = InvoiceApiServices.Instance.getAttachmentsByBusiness(businessId); result.Invoices = InvoiceHelper.getInvoiceApiModel(Invoices, PartyTransections, TaxCodes, attachments, invoiceTypeId); return(result); }
public TblPurchaseInvoiceDetail GetProductDeatilsSectionRcd(string branchCode, string productCode) { try { var _invoiceHelper = new InvoiceHelper(); var _product = _invoiceHelper.GetProducts(productCode).FirstOrDefault(); // var invoceDetails = new TblInvoiceDetail(); var purchaseDetail = new TblPurchaseInvoiceDetail(); purchaseDetail.UnitId = Convert.ToDecimal(_product.UnitId ?? 0); purchaseDetail.UnitName = _product.UnitName; purchaseDetail.TaxStructureCode = Convert.ToDecimal(_product.TaxStructureCode ?? 0); purchaseDetail.TaxStructureId = Convert.ToDecimal(_product.TaxStructureId ?? 0); purchaseDetail.TaxGroupCode = _product.TaxGroupCode; purchaseDetail.TaxGroupId = Convert.ToDecimal(_product.TaxGroupId ?? 0); //purchaseDetail.TaxGroupName = _product.TaxGroupName; if (_product.TaxStructureCode != null) { var taxStructure = _invoiceHelper.GetTaxStructure(Convert.ToDecimal(_product.TaxStructureCode)); purchaseDetail.Sgst = taxStructure.Sgst; purchaseDetail.Cgst = taxStructure.Sgst; purchaseDetail.Igst = taxStructure.Igst; purchaseDetail.TotalGst = taxStructure.TotalGst; purchaseDetail.ServerDateTime = DateTime.Now; } purchaseDetail.Rate = _invoiceHelper.GetProductRate(branchCode, productCode); purchaseDetail.HsnNo = Convert.ToDecimal(_product.HsnNo ?? 0); // purchaseDetail.AvailStock = Convert.ToDecimal(_invoiceHelper.GetProductQty(branchCode, productCode) ?? 0); // purchaseDetail.ProductCode = _product.ProductCode; // purchaseDetail.ProductGroupCode = Convert.ToDecimal(_product.ProductGroupCode ?? 0); // purchaseDetail.ProductGroupId = Convert.ToDecimal(_product.ProductGroupId ?? 0); purchaseDetail.ProductId = _product.ProductId; purchaseDetail.ProductCode = _product.ProductCode; purchaseDetail.ProductName = _product.ProductName; return(purchaseDetail); } catch (Exception ex) { throw ex; } }
public ActionResult AddNewPartial(InvoiceDetailModel model) { if (ModelState.IsValid) { try { if (SessionHelper.Invoice != null) { if (SessionHelper.Invoice.InvoiceDetail != null && SessionHelper.Invoice.InvoiceDetail.Count() > 0) { model.Id = SessionHelper.Invoice.InvoiceDetail.LastOrDefault().Id + 1; } else { model.Id = 1; } } else { model.Id = 1; } if (model.ItemId == null && model.InvoiceSourceId == null) { ViewData["EditError"] = "Either Invoice Source or Item is required."; } else if (model.ItemId != null && model.InvoiceSourceId != null) { ViewData["EditError"] = "Only Invoice Source or Item can be entered at a time."; } else { InvoiceHelper.Insert(model); } } catch (Exception e) { ViewData["EditError"] = e.Message; } } else { ViewData["EditError"] = "Please, correct all errors."; } return(PartialView("_Detail", InvoiceHelper.GetInvoiceDetail())); }
public void TestSaveMultipleInvoice() { List <Invoice> invoices = InvoiceHelper.CreateInvoices(150, 35); var mock = new Mock <IRepository <Invoice> >(); mock.Setup(repo => repo.SaveChanges()); mock.Setup(repo => repo.GetQuery()).Returns(invoices.AsQueryable); var invoiceDataAccess = new InvoiceDataAccess(mock.Object, null); invoices.ForEach(invoiceDataAccess.SaveInvoice); invoices.ForEach(i => { Invoice repoInvoice = invoiceDataAccess.LoadInvoice(i.Id); InvoiceHelper.ValidateInvoice(i, repoInvoice); }); }
public IHttpActionResult GetNext(int id, bool cancel = false) { try { int agentId = UnitOfWork.Invoices.Get(id).Agent.Id; if (Identity.HasNotAccess(agentId)) { return(Unauthorized()); } InvoiceHelper helper = new InvoiceHelper(); Invoice entity = helper.NextStep(UnitOfWork, id, cancel); return(Ok(Factory.Create(entity))); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void TestSaveInvoice() { Invoice invoice = InvoiceHelper.CreateInvoices(1, 5)[0]; var mock = new Mock <IRepository <Invoice> >(); mock.Setup(repo => repo.SaveChanges()); mock.Setup(repo => repo.GetQuery()).Returns(new List <Invoice> { invoice }.AsQueryable); var invoiceDataAccess = new InvoiceDataAccess(mock.Object, null); invoiceDataAccess.SaveInvoice(invoice); Invoice repoInvoice = invoiceDataAccess.LoadInvoice(invoice.Id); InvoiceHelper.ValidateInvoice(invoice, repoInvoice); }
private void btnCreateCustomsInvoice_Click(object sender, EventArgs e) { if (txtInvoiceNumber.Text.Trim() == "") { MessageBox.Show("Please enter an Invoice number"); return; } if (txtNumberOfCases.Text.Trim() == "") { MessageBox.Show("Please enter Number of Cases"); return; } if (txtTotalWeight.Text.Trim() == "") { MessageBox.Show("Please enter Weight"); return; } try { int salesOrder = Convert.ToInt32(txtInvoiceNumber.Text.Trim()); } catch (InvalidCastException) { MessageBox.Show("Please enter numbers only in the Invoice number textbox"); return; } try { InvoiceHelper invoiceHelper = new InvoiceHelper(SessionManager.NewQBSession()); Invoice invoice = invoiceHelper.Populate(txtInvoiceNumber.Text); ExcelExportCanadaCustomsInvoice exporter = new ExcelExportCanadaCustomsInvoice(invoice, Convert.ToDouble(txtTotalWeight.Text), Convert.ToInt64(txtNumberOfCases.Text)); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error in Program", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public ActionResult ManageOrder(int id, byte orderFrom) { if (orderFrom == 1) { ViewBag.OperationType = "Export"; } else { ViewBag.OperationType = "Import"; } ViewBag.OperationId = id; var invList = InvoiceHelper.GetInvoiceListForOper(id); var hbList = HouseBillHelper.GetHBList(id, orderFrom, true); ViewBag.OperationCode = hbList.FirstOrDefault().OperationCode; ViewBag.HbList = hbList; return(View(invList)); }
public ActionResult Edit(string id, long currencyId, long periodId) { InvoiceModel model = InvoiceHelper.GetInvoice(id); SessionHelper.Calendar = CalendarHelper.GetCalendar(ReceivablePeriodHelper.GetReceivablePeriod(periodId.ToString()).CalendarId.ToString()); SessionHelper.PrecisionLimit = CurrencyHelper.GetCurrency(currencyId.ToString()).Precision; model.InvoiceDetail = InvoiceHelper.GetInvoiceDetail(id); model.CurrencyId = currencyId; model.SOBId = SessionHelper.SOBId; model.PeriodId = periodId; CustomerModel customer = CustomerHelper.GetCustomer(model.CustomerId.ToString()); CustomerSiteModel customerSite = CustomerHelper.GetCustomerSite(model.CustomerSiteId.ToString()); ///TODO: Plz check the code. model.Customers = new List <SelectListItem>(); model.Customers.Add(new SelectListItem { Value = customer.Id.ToString(), Text = customer.CustomerName }); model.CustomerSites = new List <SelectListItem>(); model.CustomerSites.Add(new SelectListItem { Value = customerSite.Id.ToString(), Text = customerSite.SiteName }); model.Currencies = CurrencyHelper.GetCurrencyList(SessionHelper.SOBId); //model.Periods = CalendarHelper.GetCalendarsList(SessionHelper.SOBId); model.Periods = ReceivablePeriodHelper.GetPeriodList(SessionHelper.SOBId); SessionHelper.Invoice = model; return(View(model)); }
public ActionResult DeletePartial(InvoiceDetailModel model) { if (ModelState.IsValid) { try { InvoiceModel invoice = SessionHelper.Invoice; InvoiceHelper.DeleteInvoiceDetail(model); SessionHelper.Invoice = invoice; IList <InvoiceDetailModel> invoiceDetail = InvoiceHelper.GetInvoiceDetail(); return(PartialView("_Detail", invoiceDetail)); } catch (Exception e) { ViewData["EditError"] = e.Message; } } else { ViewData["EditError"] = "Please, correct all errors."; } return(PartialView("_Detail")); //return PartialView("_Detail", InvoiceHelper.GetInvoiceDetail()); }