private void StockUpdate(String PaymentType) { Stock stock = new Stock(); int Current_Invoice_No = 0; decimal Current_Stock_Balance = 0.0m; SqlDataReader sdr = stock.GetMaxInvoiceNo(); try { sdr.Read(); Current_Invoice_No = sdr.GetInt32(0); sdr.Close(); } catch { } int y = 0; int x = 0; int z = 0; int Invoce_No = Current_Invoice_No + 1; InvoiceNumber = Invoce_No.ToString(); for (int i = 0; i < dataGridViewAll.Rows.Count; ++i) { decimal sum = Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[7].Value); decimal netdiscountline = (Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[5].Value) * Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[6].Value)); decimal sumoriginal = (Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[3].Value) * Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[6].Value)); SqlDataReader sdr1 = stock.GetStockBalance(Convert.ToInt32(dataGridViewAll.Rows[i].Cells[8].Value)); try { sdr1.Read(); Current_Stock_Balance = sdr1.GetDecimal(0); sdr1.Close(); decimal Quantity = Convert.ToDecimal(dataGridViewAll.Rows[i].Cells[6].Value); x = stock.InsertTransaction(Invoce_No, Convert.ToInt32(dataGridViewAll.Rows[i].Cells[8].Value), Quantity, "Customer_Invoice", 0, sumoriginal, netdiscountline, sum, Current_Stock_Balance, (Current_Stock_Balance - Quantity), Properties.Settings.Default.username, DateTime.Parse("1900-01-01"), "0"); if (x > 0) { y = stock.UpdateStockBalance(Convert.ToInt32(dataGridViewAll.Rows[i].Cells[8].Value), Quantity * -1); } } catch { } } z = stock.InsertIvoice(Invoce_No, decimal.Parse(textBoxTotal.Text), decimal.Parse(textBoxNetDiscount.Text), decimal.Parse(textBoxtTlLineDiscount.Text), 0.0m, DateTime.Now, decimal.Parse(textBoxPaidAmount.Text), decimal.Parse(textBoxVoucherAmount.Text), decimal.Parse(textBoxBalanceAmount.Text)); TotalAmount = textBoxTotal.Text; DiscountAmount = textBoxNetDiscount.Text; LineDiscountAmount = textBoxtTlLineDiscount.Text; DateTimeInvoice = DateTime.Now.ToString(); PaidAmount = textBoxPaidAmount.Text; Balance = textBoxBalanceAmount.Text; if (z > 0) { Voucher voucher = new Voucher(); for (int i = 0; i < dataGridViewVoucher.Rows.Count; ++i) { voucher.updateVoucher(Convert.ToInt32(dataGridViewVoucher.Rows[i].Cells[0].Value), Invoce_No); } } if (x > 0 && y > 0 && z > 0) { BillPrint bp = new BillPrint(); bp.Show(); //MessageBox.Show(" Successfully Added"); dataGridViewAll.Rows.Clear();; textBoxQuantity.Clear(); dataGridViewAll.Text = ""; textBoxSelling.Clear(); comboBoxCatID.Text = ""; textBoxTotal.Clear(); textBoxNetDiscountP.Clear(); textBoxNetDiscount.Clear(); textBoxtTlLineDiscountP.Clear(); textBoxtTlLineDiscount.Clear(); textBoxDueAmount.Clear(); textBoxInvoice.Clear(); textBoxPaidAmount.Clear(); textBoxBalanceAmount.Clear(); textBoxVoucherAmount.Clear(); textBoxBarCode.Clear(); textBoxVoucherNo.Clear(); dataGridViewVoucher.Rows.Clear(); if (labelVoucherVisible.Text != "1") { button21_Click(null, null); } } }
public void sendPrintDetails() { string time = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); try { if (pay_methd_lbl.Text != ".......................") { string insertquery = "INSERT INTO sales(inv_id,numberOfItems,pay_method,total,payment,balance) VALUES (@inv_id,@numberOfItems,@pay_method,@total,@payment,@balance)"; MySqlCommand cmd = new MySqlCommand(insertquery, conn); cmd.Parameters.AddWithValue("@inv_id", invoceno_lbl.Text); cmd.Parameters.AddWithValue("@numberOfItems", itemQty_lbl.Text); cmd.Parameters.AddWithValue("@pay_method", pay_methd_lbl.Text); cmd.Parameters.AddWithValue("@total", total_lbl.Text); cmd.Parameters.AddWithValue("@payment", payment_lbl.Text); cmd.Parameters.AddWithValue("@balance", balance_lbl.Text); conn.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Bill is processing...", "POS Info", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); BillPrint pr = new BillPrint(); pr.name_lblb.Text = "Company Name" + "\n" + "Address Line 1" + "\n" + "Address Line 2" + "\n" + "Phone Number"; pr.invo_no_lbl.Text = "Invoice No : " + invoceno_lbl.Text; //make line, pr.AddNewLabel("", 0, 0, 90, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel("____________________________________", 0, 316, 90, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleCenter;// Anchor = (AnchorStyles.Left & AnchorStyles.Right); pr.AddNewLabel("", 0, 0, 90, pr.C = pr.C + 1).TextAlign = ContentAlignment.MiddleCenter; /////string text, int left, int width, int top, int x pr.AddNewLabel("Item", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft; pr.AddNewLabel("P x Q", 110, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel("Rs.", 210, 90, pr.C * 20, pr.C = pr.C + 1).TextAlign = ContentAlignment.MiddleRight; //make line, pr.AddNewLabel("", 0, 0, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel("____________________________________", 0, 316, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleCenter;// Anchor = (AnchorStyles.Left & AnchorStyles.Right); pr.AddNewLabel("", 0, 0, pr.C * 20, pr.C = pr.C + 1).TextAlign = ContentAlignment.MiddleCenter; for (int i = 0; i < sales_gride.RowCount; i++) { pr.AddNewLabel(sales_gride.Rows[i].Cells[3].Value.ToString(), 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft; pr.AddNewLabel(sales_gride.Rows[i].Cells[4].Value.ToString() + " x " + sales_gride.Rows[i].Cells[5].Value.ToString(), 110, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel(sales_gride.Rows[i].Cells[6].Value.ToString(), 210, 90, pr.C * 20, pr.C = pr.C + 1).TextAlign = ContentAlignment.MiddleRight; } //for space /*pr.AddNewLabel("", 8); * pr.AddNewLabel2("", 100, 120); * pr.AddNewLabel1("", 200, 120); */ //make line, pr.AddNewLabel("", 0, 0, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel("____________________________________", 0, 316, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleCenter;// Anchor = (AnchorStyles.Left & AnchorStyles.Right); pr.AddNewLabel("", 0, 0, pr.C * 20, pr.C = pr.C + 1).TextAlign = ContentAlignment.MiddleCenter; /////string text, int left, int width, int top, int x //set name pr.AddNewLabel("No of Items", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft; pr.AddNewLabel("Pay Method", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft;; pr.AddNewLabel("Total", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft;; pr.AddNewLabel("Payment", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft;; pr.AddNewLabel("Balance", 8, 90, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleLeft;; //set value pr.AddNewLabel(itemQty_lbl.Text, 210, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleRight; pr.AddNewLabel(pay_methd_lbl.Text, 210, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleRight; pr.AddNewLabel(total_lbl.Text, 210, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleRight; pr.AddNewLabel(payment_lbl.Text, 210, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleRight; pr.AddNewLabel(balance_lbl.Text, 210, 90, pr.B * 20, pr.B = pr.B + 1).TextAlign = ContentAlignment.MiddleRight; //set text pr.AddNewLabel("===========++++++++++++++==========", 0, 316, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel(time, 0, 316, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; pr.AddNewLabel("Thank You Come Again...", 0, 316, pr.A * 20, pr.A = pr.A + 1).TextAlign = ContentAlignment.MiddleCenter; //set space pr.panel1.Height = pr.panel1.Height + 40; pr.Height = pr.panel1.Height + 20; // show print form pr.Show(); pr.printDocument1.Print(); autoID(); allclear(); } else { MessageBox.Show("Please select payment method...", "POS Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }