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