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);
}
