private void PrintPreviewInvoice() { DVPrintPreviewDialog.Document = DVPprintDocument; DVPrintPreviewDialog.ShowDialog(); }
private void btnIn_Click(object sender, EventArgs e) { DVPrintPreviewDialog.Document = DVPrintDocument; DVPrintPreviewDialog.ShowDialog(); }
private void BtnPrint_Click(object sender, EventArgs e) { if (dgv1.Rows.Count <= 2) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 450); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 3) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 500); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 4) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 550); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 5) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 575); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 6) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 600); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 7) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 625); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 8) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 650); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 9) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 675); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 10) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 700); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 11) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 725); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 12) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 750); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 13) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 775); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 14) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 800); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 16) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 850); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 17) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 875); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 18) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 900); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 19) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 925); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 20) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 950); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 21) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 975); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 22) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1000); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 23) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1025); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 24) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1050); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 25) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1075); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 26) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1100); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 27) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1125); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 28) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1150); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 29) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1175); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 30) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1200); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 31) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1225); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 32) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1250); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 33) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1275); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 34) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1300); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 35) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1325); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 36) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1350); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 37) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1375); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 38) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1400); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 39) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1425); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else if (dgv1.Rows.Count <= 40) { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, 1450); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } else { DVPrintDocument.DefaultPageSettings.PaperSize = new PaperSize("", 400, DVPrintDocument.DefaultPageSettings.PaperSize.Height); DVPrintDocument.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); } // if (dgv1.Rows.Count == 0) { const string message = "Transaction can't be completed because there is no item selected for sale."; const string caption = "Transaction Error"; var result = MessageBox.Show(message, caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); } else if (dgv1.Rows.Count > 40) { const string message = "Transaction can't be completed on more than 40 items.\n" + "Please select less than 40 items for transaction."; const string caption = "Transaction Limit"; var result = MessageBox.Show(message, caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { int invoiceid3 = invoiceid2; string itemname; string itemqty; string itemprice; double itempricewithGST; double GST; double GStunit = 0.17; string billtotal = TotalAmount.Text; string totalqty = TotalQty.Text; double totalGSTcalcualtion = Convert.ToDouble(TotalAmount.Text) * GStunit; double totalAmountwithGST = Convert.ToDouble(TotalAmount.Text) + totalGSTcalcualtion; double discount = Convert.ToDouble(discountpercentageForAmount); double singleitemcollectiveamount; SqlConnection con = new SqlConnection(Helper.con); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "delete from Bill where InvioceID ='" + invoiceid3 + "'"; cmd.ExecuteNonQuery(); string Custname = "Valuable Customer"; string CustContact = "***********"; string OrderType = "Food Item"; string OrderCategory = "Food"; SqlCommand cmd4; cmd4 = new SqlCommand("update Customer set CustName = '" + Custname + "', Contact = '" + CustContact + "', OrderTime = '" + DateTime.Now.ToShortTimeString() + "', OrderDate = '" + DateTime.Now.Date + "' where CustID = '" + CUSTID + "' ", con); cmd4.ExecuteNonQuery(); SqlCommand cmd5; cmd5 = new SqlCommand("update Orders set CustID = '" + CUSTID + "', OrderType = '" + OrderType.ToString() + "', OrderCategory = '" + OrderCategory.ToString() + "', Ordertime = '" + DateTime.Now.ToShortTimeString() + "', OrderDate = '" + DateTime.Now.Date + "' ", con); cmd5.ExecuteNonQuery(); SqlCommand cmd6; for (int i = 0; i < dgv1.Rows.Count; i++) { itemname = Convert.ToString(dgv1.Rows[i].Cells[4].Value); itemqty = Convert.ToString(dgv1.Rows[i].Cells[5].Value); itemprice = Convert.ToString(dgv1.Rows[i].Cells[6].Value); singleitemcollectiveamount = Convert.ToDouble(dgv1.Rows[i].Cells[7].Value); GST = Convert.ToDouble(dgv1.Rows[i].Cells[7].Value) * GStunit; itempricewithGST = Convert.ToDouble(dgv1.Rows[i].Cells[7].Value) + GST; cmd6 = new SqlCommand("insert into Bill values ('" + invoiceid2 + "','" + CUSTID + "','" + ORDERID + "','" + CUSTNAME + "','" + itemname.ToString() + "','" + itemqty.ToString() + "','" + itemprice.ToString() + "','" + singleitemcollectiveamount.ToString() + "','" + itempricewithGST.ToString() + "','" + DateTime.Now.ToShortTimeString() + "','" + DateTime.Now.Date + "','" + totalqty.ToString() + "','" + ActualAmount.Text.ToString() + "','" + billtotal.ToString() + "','" + totalAmountwithGST.ToString() + "','" + discount.ToString() + "')", con); cmd6.ExecuteNonQuery(); } SqlCommand cmd7; cmd7 = new SqlCommand("insert into EditedBill values ('" + invoiceid2 + "')", con); cmd7.ExecuteNonQuery(); con.Close(); } if ((DVPrintPreviewDialog != null)) { DVPrintPreviewDialog = new PrintPreviewDialog(); ((Form)DVPrintPreviewDialog).WindowState = FormWindowState.Maximized; } DVPrintPreviewDialog.Document = DVPrintDocument; DVPrintPreviewDialog.Show(); //Edit_Invoice_Print edit_Invoice_Print = new Edit_Invoice_Print(); //edit_Invoice_Print.Show(); }
private void print() { DVPrintPreviewDialog.Document = DVPrintDocument; DVPrintPreviewDialog.ShowDialog(); }