private void BtnPrintClick(object sender, EventArgs e) { if (_depositList == null) { return; } if (_depositList.Count == 0) { return; } if (dgvDeposit.CurrentRow == null) { return; } _deposit = _depositList[dgvDeposit.CurrentRow.Index]; if (_deposit == null) { return; } _depositItemList = _depositService.GetDepositItems(_deposit.DepositId); var saleItemList = _saleOrderService.GetSaleItems(_depositItemList); var printInvoice = new PrintInvoice(); printInvoice.ExcelInvoicePrintingHandler( AppContext.Counter.ReceiptPrinter, Application.StartupPath + @"\" + Resources.ConstDepositExcelFile, string.Empty, _deposit.FkCustomer.CustomerName, _deposit.FkCustomer.CustomerName, _deposit.DepositNumber, (DateTime)_deposit.DepositDate, _deposit.Discount, _deposit.AmountPaidInt, 0, saleItemList, true); }
public void TestExcel() { //var excelApplication = new Application(); //var _WorkBook = excelApplication.Workbooks.Open( // @"d:\20100429.xlsx", // 0, // false, // 5, // "comin", // "", // false, // XlPlatform.xlWindows, // "", // true, // false, // 0, // true, // false, // false); ////excelApplication.Visible = true; ////_WorkBook.PrintPreview(true); //try //{ // _WorkBook.PrintOut( // 1, // 1, // 1, // false, // "HP Color LaserJet 2600n (Network)", // false, // false, // ""); //} //catch (Exception exception) //{ // MessageBox.Show(exception.Message); //} //finally //{ // excelApplication.Workbooks.Close(); //} var saleItemBindingList = new BindingList<SaleItem> { CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem(), CreateSaleItem() }; var printReceipt = new PrintInvoice(); printReceipt.ExcelInvoicePrintingHandler( "EPSON LQ-300+ /II ESC/P 2", @"D:\users\ysakal\private\point of sales\ezpos\source code\bin\Debug\invoice-sale.xlsx", string.Empty, "Customer", "Address", "InvoiceNumber", DateTime.Now, 10, 5, 10, saleItemBindingList, false); Assert.AreEqual(1, 1, "Test performed"); }
private void InvoicePrinting( Customer customer, string invoiceNumber, DateTime invoiceDate, float discountPercentage, float depositAmount, float paidAmount, float returnAmount, bool isDeposit) { bool issueReceipt; var issueReceiptStr = AppContext.IssueReceipt; bool.TryParse(issueReceiptStr, out issueReceipt); if(!issueReceipt) return; var receiptTemplate = AppContext.ReceiptTemplate; if (string.IsNullOrEmpty(receiptTemplate)) receiptTemplate = Resources.ConstReceiptTemplate1; if (receiptTemplate.Equals(Resources.ConstReceiptTemplate1)) { //Print double amountSold = paidAmount - returnAmount; //amountSold = amountSold/(1 - discountPercentage/100); var printReceipt = new PrintReceipt { InvoiceNumber = invoiceNumber, Cashier = AppContext.User.LogInName, PrintDate = DateTime.Now.ToString("dd/MM/yyyy HH:mm", AppContext.CultureInfo), Counter = AppContext.Counter.CounterName, CustomerInfo = ((string.IsNullOrEmpty(customer.CustomerName) ? string.Empty : customer.CustomerName) + (string.IsNullOrEmpty(customer.PhoneNumber) ? string.Empty : " | " + customer.PhoneNumber)), AmountSold = amountSold.ToString("N", AppContext.CultureInfo), AmountPaid = (paidAmount).ToString("N", AppContext. CultureInfo), AmountReturn = returnAmount.ToString("N", AppContext.CultureInfo), Discount = (discountPercentage + " %"), //AmountSubTotal = // ((saleOrder.AmountSoldInt * 100) / (100 - discountPercentage)).ToString("N", // AppContext // . // CultureInfo), AmountSubTotal = (((paidAmount - returnAmount) * 100) / (100 - discountPercentage)).ToString("N", AppContext . CultureInfo), BindingListObj = _saleItemBindingList }; printReceipt.InializeReceiptPrinting(); //var fileName = Resources.ConstReceiptExcelFile; //printReceipt.PrintReceiptHandler( // Application.StartupPath + @"\" + fileName, // string.Empty); } else { var fileName = isDeposit ? Resources.ConstDepositExcelFile : Resources.ConstSaleExcelFile; //Print var printInvoice = new PrintInvoice(); printInvoice.ExcelInvoicePrintingHandler( AppContext.Counter.ReceiptPrinter, Application.StartupPath + @"\" + fileName, string.Empty, customer.CustomerName, customer.Address, invoiceNumber, invoiceDate, discountPercentage, depositAmount, paidAmount, _saleItemBindingList, isDeposit); } }
private void BtnPrintClick(object sender, EventArgs e) { if (_depositList == null) return; if (_depositList.Count == 0) return; if (dgvDeposit.CurrentRow == null) return; _deposit = _depositList[dgvDeposit.CurrentRow.Index]; if (_deposit == null) return; _depositItemList = _depositService.GetDepositItems(_deposit.DepositId); var saleItemList = _saleOrderService.GetSaleItems(_depositItemList); var printInvoice = new PrintInvoice(); printInvoice.ExcelInvoicePrintingHandler( AppContext.Counter.ReceiptPrinter, Application.StartupPath + @"\" + Resources.ConstDepositExcelFile, string.Empty, _deposit.FkCustomer.CustomerName, _deposit.FkCustomer.CustomerName, _deposit.DepositNumber, (DateTime)_deposit.DepositDate, _deposit.Discount, _deposit.AmountPaidInt, 0, saleItemList, true); }