static void Main(string[] args)
{
Console.WriteLine("Prepare for test.. Press one key");
Console.ReadKey();
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
StreamReader sr = new StreamReader(@"C:\logo\58mmWidth.prn");
Image newImage = Image.FromFile(@"c:\logo\logo.bmp");
//var BytesValue = ImageToByteArray(newImage);
//var BytesValue = ReadAllBytes(@"c:\photo\logo.bmp");
byte[] BytesValue = Encoding.ASCII.GetBytes("Sier Group 1 22 333 4444");
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Sier Group 1 22 333 4444\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Sier Group 1 22 333 4444\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontC());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth4());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Sier Group 1 22 333 4444\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
BytesValue = PrintExtensions.AddBytes(BytesValue, CutPage());
PrinterUtility.PrintExtensions.Print(BytesValue, "COM7");
Console.WriteLine("Hope it went well.. Bye");
Console.ReadKey();
//Printer printer = new Printer("Thermal Printer");
//printer.TestPrinter();
//printer.FullPaperCut();
//printer.PrintDocument();
}
void footerekle(DataGridView tbl)
{
if (Genesis.yaziciMM == 80)
{
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth4());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("* * * * * *" + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("RAPOR SONU" + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("* * * * * *" + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Right());
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth3());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("Toplam: " + string.Format("{0:#,##0.00}", geneltoplamal(tbl)) + " TL" + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
degerbit = PrintExtensions.AddBytes(degerbit, obje.Separator());
//degerbit = PrintExtensions.AddBytes(degerbit, CutPage());
}
else if (Genesis.yaziciMM == 58)
{
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth2());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("* * * * * *" + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("RAPOR SONU" + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("* * * * * *" + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Right());
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("Toplam: " + string.Format("{0:#,##0.00}", geneltoplamal(tbl)) + " TL" + slashn + slashn + slashn + slashn));
//degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
//degerbit = PrintExtensions.AddBytes(degerbit, obje.Separator());
//degerbit = PrintExtensions.AddBytes(degerbit, CutPage());
}
}
private void PrintInvoice(OrderViewModel MyOrderModel)
{
var BytesValue = Encoding.ASCII.GetBytes(string.Empty);
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(MyOrderModel.FirstName + " " + MyOrderModel.LastName + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(MyOrderModel.Email + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(MyOrderModel.Phone + "\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth4());
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(MyOrderModel.Phone));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Invoice\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Order No. : " + MyOrderModel.OrderId.ToString() + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Date : " + DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss") + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Itm Qty Size Attr\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
for (int index = 0; index < MyOrderModel.cartwishlist.Count; index++)
{
BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9}\n", MyOrderModel.cartwishlist[index].ProductName, MyOrderModel.cartwishlist[index].quantity, MyOrderModel.cartwishlist[index].Size, MyOrderModel.cartwishlist[index].Attributes));
}
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Total\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("288.00\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleHeight6());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.BarCode.Code128("12345"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.QrCode.Print("12345", PrinterUtility.Enums.QrCodeSize.Grande));
//BytesValue = PrintExtensions.AddBytes(BytesValue, "-------------------Thank you for coming------------------------\n");
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, CutPage());
PrinterUtility.PrintExtensions.Print(BytesValue, System.Configuration.ConfigurationManager.AppSettings["PrinterPath"].ToString());
}
void headerekle()
{
if (Genesis.yaziciMM == 80)
{
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth3());
degerbit = PrintExtensions.AddBytes(degerbit, obje.FontSelect.FontA());
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(ConvertTurkishChars(sirket).Trim() + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth2());
degerbit = PrintExtensions.AddBytes(degerbit, obje.FontSelect.FontB());
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(ConvertTurkishChars(a1).Trim() + slashn + ConvertTurkishChars(a2).Trim() + slashn + ConvertTurkishChars(a3).Trim() + slashn + "Tel: " + ConvertTurkishChars(tel).Trim() + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Left());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(" Tarih: " + tarih.Substring(0, 10) + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(" Saat: " + tarih.Substring(11, 5) + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("Fis No: " + faturano + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
degerbit = PrintExtensions.AddBytes(degerbit, obje.Separator());
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth2());
}
else if (Genesis.yaziciMM == 58)
{
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth2());
degerbit = PrintExtensions.AddBytes(degerbit, obje.FontSelect.SpecialFontA());
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(ConvertTurkishChars(sirket).Trim() + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
//degerbit = PrintExtensions.AddBytes(degerbit, obje.FontSelect.FontB());
//degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Center());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(ConvertTurkishChars(a1).Trim() + slashn + ConvertTurkishChars(a2).Trim() + slashn + ConvertTurkishChars(a3).Trim() + slashn + "Tel: " + ConvertTurkishChars(tel).Trim() + slashn + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, obje.Alignment.Left());
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(" Tarih: " + tarih.Substring(0, 10) + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes(" Saat: " + tarih.Substring(11, 5) + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("Fis No: " + faturano + slashn));
degerbit = PrintExtensions.AddBytes(degerbit, Encoding.ASCII.GetBytes("--------------------------------" + slashn));
//degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.Nomarl());
//degerbit = PrintExtensions.AddBytes(degerbit, obje.Separator());
//degerbit = PrintExtensions.AddBytes(degerbit, obje.CharSize.DoubleWidth2());
}
}
private byte[] GenerateReceipt(Receipt receipt)
{
var togLogoPath = System.AppDomain.CurrentDomain.BaseDirectory + "\\Images\\tog-logo.png";
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var BytesValue = Encoding.ASCII.GetBytes(string.Empty);
BytesValue = PrintExtensions.AddBytes(BytesValue, ImageToByteArray(togLogoPath));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth6());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("TOG Connection Pte Ltd\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("201 Victoria Street .#05-04\n\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("SINGAPORE - 188067\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Phone: 66341967\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("E-mail: [email protected]\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("GST Reg No: 201229862H\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue,
Encoding.ASCII.GetBytes($"Bill No: {receipt.BillNo} Date: {receipt.CreatedDate.ToString("dd/MM/yyyy")}\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue,
Encoding.ASCII.GetBytes($"Cashier: {receipt.CashierName} Couter: {receipt.CounterName}\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("No Itm Qty Net Total\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
if (receipt.Items.Any())
{
foreach (var item in receipt.Items)
{
BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0}{1,-40}{2,6}{3,9}{4,9:N2}\n",
item.No, item.Name, item.Quantity, item.Price, item.Amount));
}
}
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes($" Total Amount: {receipt.TotalAmount}\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes($" (GST S$ {receipt.GTSAmount} Inclusive)\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes($" Net Qty: {receipt.NetQuantity} Net Total: {receipt.NetTotal}\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue,
Encoding.ASCII.GetBytes($"Retain Your Receipt for Exchange within {receipt.ExchangeDayQuantity} Days For Selected Items Only!Thanks!Please Come again\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleHeight6());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.BarCode.Code128("12345"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.QrCode.Print("12345", PrinterUtility.Enums.QrCodeSize.Grande));
BytesValue = PrintExtensions.AddBytes(BytesValue, "-------------------Thank you for coming------------------------\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, CutPage());
return(BytesValue);
}
private void printing()
{
PrinterUtility.EscPosEpsonCommands.EscPosEpson tempObj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var bytesValue = tempObj.CharSize.DoubleWidth6();
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Center());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.FontSelect.FontC());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Dahab Cafe\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.Nomarl());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth4());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Invoice\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth2());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Date: " + DateTime.Now.ToString() + "\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Table Number: " + selectedTarabyza + "\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Item Quantity Net Total\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
double totalPrice = 0.0;
int selectedTarabezaIndex = 0;
for (int i = 0; i < salaManager.liveOrders.Count; i++)
{
if (salaManager.liveOrders[i].tarabyza == selectedTarabyza)
{
selectedTarabezaIndex = i;
// salaManager.liveOrders[i]
foreach (var drink in salaManager.liveOrders[i].drinks)
{
double drinkTotalPrice = double.Parse(drink.Value.amount.ToString()) * double.Parse(drink.Value.price);
bytesValue = PrintExtensions.AddBytes(bytesValue, string.Format("{0, -40}{1, 6}{2, 9}{3, 9:N2}\n", drink.Value.name, drink.Value.amount, drink.Value.price, drinkTotalPrice.ToString()));
totalPrice += drinkTotalPrice;
}
break;
}
}
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Right());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Price : " + salaManager.liveOrders[selectedTarabezaIndex].price.ToString() + "\n"));
//bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes(totalPrice.ToString() + "\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Tax : " + salaManager.liveOrders[selectedTarabezaIndex].taxPrice + "\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Service : " + salaManager.liveOrders[selectedTarabezaIndex].servicePrice + "\n"));
if (salaManager.liveOrders[selectedTarabezaIndex].discount != 0)
{
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Discount : " + salaManager.liveOrders[selectedTarabezaIndex].discount.ToString() + "\n"));
//bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Total After Discount : " + salaManager.liveOrders[selectedTarabezaIndex].totalPrice + "\n"));
//bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes((totalPrice + "\n"));
}
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Total : " + salaManager.liveOrders[selectedTarabezaIndex].totalPrice + "\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Center());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("-------Thanks for Coming-------\n\n\n\n\n\n"));
//bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Mina w Mahoraaaaa\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes(CutPage()));
byte[] openDrawer = new byte[5]
{
(byte)27,
(byte)112,
(byte)0,
(byte)25,
(byte)250
};
bytesValue = PrintExtensions.AddBytes(bytesValue, openDrawer);
// PrinterUtility.PrintExtensions.Print(bytesValue, Cafe_Template.Properties.Settings.Default.PrinterPath);
try
{
PrinterUtility.PrintExtensions.Print(bytesValue, DataManager.printerPath);
}
catch
{
MessageBox.Show("برجاء فحص الطابعة");
}
}
private void sell()
{
//throw new NotImplementedException();
try
{
if (textBoxTotalAmount.Text != "" && textBoxBalance.Text != "" && textBoxCash.Text != "" || textBox2.Text != "")
{
getreceiptno();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[0].Value != null)
{
//float available = 0,totalqty;
available = Convert.ToInt32(textBox1.Text);
//sold = Convert.ToInt32(textBoxQuantity.Text);
totalqty = available - qty;
getCreditno();
sqlconnectionclass getstatus = new sqlconnectionclass();
DR = getstatus.ReadDB("select count(*) from stockin where productno='" + row.Cells[0].Value + "'");
if (DR.HasRows)
{
DR.Read(); if (Convert.ToInt32(DR[0]) > 0)
{
status = 0;
}
else
{
status = 1;
}
}
string insertsale = "INSERT INTO [Sales]([ProductNo],[sqty],[sprice],[totalcost],[VAT],[credit_customerID],[credit_no],[unknown],[receiptno],[date])VALUES('" + row.Cells[0].Value + "','" + row.Cells[3].Value + "','" + row.Cells[2].Value + "','" + row.Cells[5].Value + "','" + row.Cells[4].Value + "','" + cust_id + "','" + nextcreditno + "','" + status + "','" + ReceiptNo + "','" + System.DateTime.Now + "')";
new sqlconnectionclass().WriteDB(insertsale);
string insertstockcard = "INSERT INTO [Stockcard]([ProductNo] ,[Transaction_Date],[Naration] ,[Qty_in] ,[Qty_out],[Lacation],[System_User],[New_Stock],[Available_Stock],[DateReport],[Timereport]) VALUES('" + row.Cells[0].Value + "','" + System.DateTime.Now + "','Sale of ''" + productname + "','" + '0' + "','" + row.Cells[3].Value + "','Store','" + Form1.UserName + "','" + totalqty + "','" + textBox1.Text + "','" + System.DateTime.Now + "','" + System.DateTime.Now + "')";
new sqlconnectionclass().WriteDB(insertstockcard);
if (radioButton2.Checked == true)
{
string insertcredit = "INSERT INTO credit_sales([credit_no],[credit_customerID],[amount],[description],[user],[date])values('" + nextcreditno + "','" + cust_id + "','" + txtcreditsales.Text + "','being sales of''" + productname + "','" + Form1.UserName + "','" + System.DateTime.Now.ToShortDateString() + "')";
new sqlconnectionclass().WriteDB(insertcredit);
creditbalance();
totalbal = Convert.ToInt32(txtcreditsales.Text);
bal2 = bal + totalbal;
string insertgledger = "INSERT INTO [GLedger]([credit_customerID],[Debit],[Balance],[Date],[user],[Naration])values('" + cust_id + "','" + txtcreditsales.Text + "','" + bal2 + "','" + System.DateTime.Now + "','" + Form1.UserName + "','Being sales of''" + productname + "')";
new sqlconnectionclass().WriteDB(insertgledger);
}
}
}
//if(){}
/*****======================Begin Print=====================*****/
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var BytesValue = Encoding.ASCII.GetBytes(string.Empty);
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth2());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("JOMAT GENERAL HARDWARE\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Dealers in: Hardware e.g Iron sheets, Cement,\n Plywood, Paints, Glassmart, Supply of general\nbuilding materials etc.\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("P.O. BOX 4, NGONG\nNGONG RD-KISERIAN, MATASIA SHOPPING CENTRE\nTEL: 0721-283-402/0724-477-792\nKRA PIN.:A001204489T \n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("RECEIPT\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Receipt No : " + ReceiptNo + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Date : " + System.DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss", CultureInfo.InvariantCulture) + "\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("PIN. :A001204489T \n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(" Item Qty U. Price VAT Total\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(" Name KES KES KES\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
foreach (DataGridViewRow dgv in dataGridView1.Rows)
{
BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-19}{1,9}{2,9}{3,10}{4,16:N2}\n", dgv.Cells[1].Value, dgv.Cells[3].Value, dgv.Cells[2].Value, dgv.Cells[4].Value, dgv.Cells[5].Value));
}
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9:N2}\n", "item 1", 12, 11, 144.00));
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9:N2}\n", "item 2", 12, 11, 144.00));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Total: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(textBoxTotalAmount.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Cash: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(textBoxCash.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Change: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(textBoxBalance.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth2());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Mpesa Till No 524049\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.BarCode.Code128("12345"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.QrCode.Print("12345", PrinterUtility.Enums.QrCodeSize.Grande));
BytesValue = PrintExtensions.AddBytes(BytesValue, "Goods Once sold cannot be returned\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "You're served by " + Form1.UserName + "\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, "Designed by Amtech Technologies\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "Website: www.amtechafrica.com Email: [email protected]\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "------Thank you for shopping with us-------\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, CutPage());
//PrinterUtility.PrintExtensions.Print(BytesValue, EasyPOS.Properties.Settings.Default.printerpath);
if (File.Exists(".\\tmpPrint.print"))
{
File.Delete(".\\tmpPrint.print");
}
File.WriteAllBytes(".\\tmpPrint.print", BytesValue);
RawPrinterHelper.SendFileToPrinter("Generic / Text Only", ".\\tmpPrint.print");
try
{
File.Delete(".\\tmpPrint.print");
}
catch
{
}
/******END PRINT & Begin collection**********/
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj1 = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var BytesValue1 = Encoding.ASCII.GetBytes(string.Empty);
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.CharSize.DoubleWidth2());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.FontSelect.FontA());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes("JOMAT GENERAL HARDWARE\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.CharSize.Nomarl());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes("Collection RECEIPT\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.CharSize.Nomarl());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Alignment.Right());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes("Receipt No : " + ReceiptNo + "\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes("Date: " + System.DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss", CultureInfo.InvariantCulture) + "\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes(" Item Qty U. Price VAT Total\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes(" Name KES KES KES\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Separator());
foreach (DataGridViewRow dgv in dataGridView1.Rows)
{
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, string.Format("{0,-19}{1,9}{2,9}{3,10}{4,16:N2}\n", dgv.Cells[1].Value, dgv.Cells[3].Value, dgv.Cells[2].Value, dgv.Cells[4].Value, dgv.Cells[5].Value));
}
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Alignment.Right());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Separator());
//BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes("Total: "));
//BytesValue1 = PrintExtensions.AddBytes(BytesValue1, Encoding.ASCII.GetBytes(textBoxTotalAmount.Text + "\n"));
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj.Lf());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, "Signed:.............................................\n");
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Alignment.Center());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, "You're served by " + Form1.UserName + "\n");
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj.Separator());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, "Designed by Amtech Technologies\n");
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, "Website: www.amtechafrica.com Email: [email protected]\n");
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, obj1.Alignment.Left());
BytesValue1 = PrintExtensions.AddBytes(BytesValue1, CutPage());
if (File.Exists(".\\tmpPrint1.print"))
{
File.Delete(".\\tmpPrint1.print");
}
File.WriteAllBytes(".\\tmpPrint1.print", BytesValue1);
RawPrinterHelper.SendFileToPrinter("Generic / Text Only", ".\\tmpPrint1.print");
try
{
File.Delete(".\\tmpPrint1.print");
}
catch
{
}
/*********END collector copy****************/
textBoxTotalAmount.Text = "0"; textBoxCash.Text = "0"; textBoxBalance.Text = "0";
}
else
{
MessageBox.Show("Enter Cash Amount");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void buttonPay_Click(object sender, EventArgs e)
{
string paymode = "";
if (radioButton1.Checked == true)
{
paymode = "Cash";
}
else if (radioButton2.Checked == true)
{
paymode = "Cheque";
}
string pay = "INSERT INTO [creditPayment]([credit_customerID],[BussinessName],[paymentmode],[amount],[balance],[description],[chequeno],[datepay],[duedate],[date],[user])VALUES('" + pid + "','" + cmbBusinessname.Text + "','" + paymode + "','" + textBoxAmount.Text + "','" + txtRemaining.Text + "','Payment of Credit','" + textBoxChequeNo.Text + "','" + datePay.Text + "','" + Duedate.Text + "','" + System.DateTime.Now + "','" + Form1.UserName + "')";
new sqlconnectionclass().WriteDB(pay);
string gledger = "INSERT INTO [GLedger]([credit_customerID],[Credit],[Balance],[Date],[user],[Naration])VALUES('" + pid + "','" + textBoxAmount.Text + "','" + txtRemaining.Text + "','" + System.DateTime.Now + "','" + Form1.UserName + "','Credit Payment')";
new sqlconnectionclass().WriteDB(gledger);
MessageBox.Show("success");
/*****======================Begin Print=====================*****/
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var BytesValue = Encoding.ASCII.GetBytes(string.Empty);
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth2());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("JOMAT GENERAL HARDWARE\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Dealers in: Hardware e.g Iron sheets, Cement,\n Plywood, Paints, Glassmart, Supply of general\nbuilding materials etc.\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("P.O. BOX 4, NGONG\nNGONG RD-KISERIAN, MATASIA SHOPPING CENTRE\nTEL: 0721-283-402/0724-477-792\nKRA PIN.:A001204489T \n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("CREDIT PAYMENT RECEIPT\n"));
// BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
// BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Receipt No : " + ReceiptNo + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Date : " + System.DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss", CultureInfo.InvariantCulture) + "\n"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("PIN. :A001204489T \n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(" MEMBER NAME TOTAL Balance CASH Paid REMAINING\n"));
////BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(" Name KES KES KES\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
//foreach (DataGridViewRow dgv in dataGridView1.Rows)
//{
BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,19}{1,9}{2,10}{3,16:N2}\n", cmbBusinessname.Text, balancetxt.Text, textBoxAmount.Text, txtRemaining.Text));
//}
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9:N2}\n", "item 1", 12, 11, 144.00));
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9:N2}\n", "item 2", 12, 11, 144.00));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Total Balance: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(balancetxt.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Cash: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(textBoxAmount.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Remaining: "));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(txtRemaining.Text + "\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.DoubleWidth2());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Mpesa Till No 524049\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.CharSize.Nomarl());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.FontSelect.FontA());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.BarCode.Code128("12345"));
//BytesValue = PrintExtensions.AddBytes(BytesValue, obj.QrCode.Print("12345", PrinterUtility.Enums.QrCodeSize.Grande));
// BytesValue = PrintExtensions.AddBytes(BytesValue, "Goods Once sold cannot be returned\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "You're served by " + Form1.UserName + "\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, "Designed by Amtech Technologies\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "Website: www.amtechafrica.com Email: [email protected]\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, "------Thank you for shopping with us-------\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, CutPage());
//PrinterUtility.PrintExtensions.Print(BytesValue, EasyPOS.Properties.Settings.Default.printerpath);
if (File.Exists(".\\tmpPrint.print"))
{
File.Delete(".\\tmpPrint.print");
}
File.WriteAllBytes(".\\tmpPrint.print", BytesValue);
RawPrinterHelper.SendFileToPrinter("Generic / Text Only", ".\\tmpPrint.print");
try
{
File.Delete(".\\tmpPrint.print");
}
catch
{
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
Anu_Order order = new Anu_Order();
order.Anu_Order_Id = lblBillNo.Text;
order.Anu_Order_OrderDate = Convert.ToDateTime(lblBillDate.Text);
var uurn = "";
long unique = 1;
var MaxUNIQUE = (from a in _context.Anu_Orders select a).AsEnumerable().Max(p => p.Anu_Order_URNNo);
if (MaxUNIQUE != 0)
{
unique = Convert.ToInt64(MaxUNIQUE) + 1;
}
uurn = unique.ToString("00000");
order.Anu_Order_URNNo = Convert.ToInt32(uurn);
order.Anu_Order_TotalQty = TotalQty;
order.Anu_Order_Status = Status.Paid;
order.Anu_Order_TotalAmount = Total;
order.Anu_Order_Mode = Mode.Cash;
order.Anu_Order_IsActive = true;
order.Anu_Order_Createdby = SessionMgr.UserId;
order.Anu_Order_CreatedDate = DateTime.Now;
_context.Anu_Orders.Add(order);
_context.SaveChanges();
var cart = _context.Anu_Carts.ToList();
foreach (var item in cart)
{
var odid = "";
long urn = 1;
var MaxURN = (from a in _context.Anu_Order_Details select a).AsEnumerable().Max(p => p.Anu_Order_Detail_Id.Split('-')[1]);
if (MaxURN != null)
{
urn = Convert.ToInt64(MaxURN) + 1;
}
odid = "AGPODD/" + DateTime.Now.Month + "/" + DateTime.Now.Year + "-" + urn.ToString("0000");
Anu_Order_Detail orderdetail = new Anu_Order_Detail();
orderdetail.Anu_Order_Detail_Id = odid;
orderdetail.Anu_Order_Id = order.Anu_Order_Id;
orderdetail.Anu_Order_Detail_Discount = Convert.ToDecimal(lblDiscount.Text);
orderdetail.Anu_Order_Detail_Qty = item.Anu_cart_Qty;
orderdetail.Anu_Order_Detail_Rate = item.Anu_cart_Rate;
orderdetail.Anu_Product_Id = item.Anu_Product_Id;
orderdetail.Anu_Order_Detail_Type = item.Anu_cart_Type;
orderdetail.Anu_Order_Detail_Subtotal = SubTotal;
orderdetail.Anu_Order_Detail_ReceivedAmount = Convert.ToDecimal(txtReceived.Text.Trim());
orderdetail.Anu_Order_Detail_RemainingAmount = Convert.ToDecimal(lblRemain.Text);
_context.Anu_Order_Details.Add(orderdetail);
_context.SaveChanges();
var stock = _context.Anu_Stocks.Include(a => a.stdetail).Where(a => a.Anu_Product_Id.Contains(item.Anu_Product_Id)).SingleOrDefault();
stock.Anu_Stock_Qty = stock.Anu_Stock_Qty - Convert.ToDecimal(item.Anu_cart_Qty);
_context.SaveChanges();
Anu_Cart crt = _context.Anu_Carts.Find(item.Anu_Cart_Id);
_context.Anu_Carts.Remove(crt);
_context.SaveChanges();
}
prdCombo.SelectedIndex = 0;
txtCat.Text = "";
txtQty.Text = "";
txtRate.Text = "";
lblStock.Text = "";
lblGSt.Text = "";
TypeCombo.SelectedIndex = 0;
////PrintReceipt(lblBillNo.Text);
////printTest();
//Printdoc();
var orderdetails = from a in _context.Anu_Order_Details.Include(aaa => aaa.order).Include(ad => ad.product)
where (a.Anu_Order_Id.Contains(lblBillNo.Text))
select a;
decimal TotalAmt = _context.Anu_Orders.Where(a => a.Anu_Order_Id == lblBillNo.Text).Select(a => a.Anu_Order_TotalAmount).SingleOrDefault();
PrinterUtility.EscPosEpsonCommands.EscPosEpson obj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var BytesValue = GetLogo(@"C:\Banner.png");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Cash Bill\n"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Invoice no.'" + lblBillNo.Text));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Date.'" + orderdetails.FirstOrDefault().order.Anu_Order_OrderDate));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Item Qty Amount"));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40},{1,6},{2,9},{3,9:N2}\n", "item 1", 12, 11, 144.00));
//BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40},{1,6},{2,9},{3,9:N2}\n", "item 1", 12, 11, 144.00));
foreach (var item in orderdetails)
{
BytesValue = PrintExtensions.AddBytes(BytesValue, string.Format("{0,-40}{1,6}{2,9}{3,9:N2}\n", item.product.Anu_Product_Name, item.Anu_Order_Detail_Qty, item.Anu_Order_Detail_Rate));
}
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Right());
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes("Total"));
BytesValue = PrintExtensions.AddBytes(BytesValue, Encoding.ASCII.GetBytes(TotalAmt.ToString()));
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Separator());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Lf());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Center());
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.BarCode.Code128("12345"));
BytesValue = PrintExtensions.AddBytes(BytesValue, "-------------------Thanking you------------------\n");
BytesValue = PrintExtensions.AddBytes(BytesValue, obj.Alignment.Left());
BytesValue = PrintExtensions.AddBytes(BytesValue, Cutpage());
BytesValue = PrintExtensions.AddBytes(BytesValue, Anugraha.Properties.Settings.Default.PrinterName);
Init();
//printTest();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void getDailyReport()
{
DataManager.loadOrdersData();
if (typeOfReport == "")
{
MessageBox.Show("يجب اختيار نوع التقرير");
return;
}
string dateOfReport = "";
if (checkValideData())
{
if (typeOfReport == "daily")
{
dateOfReport = dayCombo.Text + "/" + monthCombo.Text + "/" + yearCombo.Text;
}
}
if (typeOfReport == "daily")
{
var orders = DataManager.orders.Where(item => item.Key == dateOfReport).Select(i => i.Value);
if (orders.Count() == 0)
{
MessageBox.Show("لا يوجد تقارير");
return;
}
PrinterUtility.EscPosEpsonCommands.EscPosEpson tempObj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
var bytesValue = tempObj.CharSize.DoubleWidth6();
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Center());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.FontSelect.FontC());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Dahab Cafe\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.Nomarl());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth4());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Report\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth2());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Date Table Total\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
double totalPrice = 0.0;
foreach (var dayOrder in orders)
{
foreach (var order in dayOrder)
{
bytesValue = PrintExtensions.AddBytes(bytesValue, string.Format("{0, -40}{1, 6}{2, 9}\n", order.date.ToString(), order.tarabyza, order.totalPrice.ToString()));
totalPrice += order.totalPrice;
}
}
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Right());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Total Price : " + totalPrice.ToString() + "\n\n\n\n\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes(CutPage()));
// PrinterUtility.PrintExtensions.Print(bytesValue, Cafe_Template.Properties.Settings.Default.PrinterPath);
try
{
PrintExtensions.Print(bytesValue, DataManager.printerPath);
}
catch
{
MessageBox.Show("برجاء فحص الطابعة");
}
var items = StatisticsCalculator.drinksCalculation(dateOfReport);
tempObj = new PrinterUtility.EscPosEpsonCommands.EscPosEpson();
bytesValue = Encoding.ASCII.GetBytes("");
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Center());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.FontSelect.FontC());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Dahab Cafe\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.Nomarl());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth4());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Report\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.CharSize.DoubleWidth2());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("Item Count\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
foreach (var item in items)
{
bytesValue = PrintExtensions.AddBytes(bytesValue, string.Format("{0, -40}{1, 6}\n", item.Key, item.Value.ToString()));
}
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Center());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Separator());
bytesValue = PrintExtensions.AddBytes(bytesValue, tempObj.Alignment.Left());
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes("\n\n\n\n\n\n"));
bytesValue = PrintExtensions.AddBytes(bytesValue, Encoding.ASCII.GetBytes(CutPage()));
// PrinterUtility.PrintExtensions.Print(bytesValue, Cafe_Template.Properties.Settings.Default.PrinterPath);
try
{
PrintExtensions.Print(bytesValue, DataManager.printerPath);
}
catch
{
MessageBox.Show("برجاء فحص الطابعة");
}
}
}
