public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1_Bill rpt = new CrystalReport1_Bill();
rpt.Site = this.Site;
return(rpt);
}
private void btnSell_Click(object sender, EventArgs e)
{
try
{
noOfAllQty = 0;//All Quantity Start Zero
epCash.Clear();
epSubTotal.Clear();
epTotal.Clear();
if (txtCash.Text != "0.00" && txtTotal.Text != "0.00" && txtSubTotal.Text != "0.00")
{
if (decimal.Parse(txtCash.Text) >= decimal.Parse(txtTotal.Text))
{
SqlDataReader dr = objInvo.checkExistInvoice(lblInvoiceNo.Text);
if (!dr.Read())
{
//COPY tblInvoiceItems VALUE TO tblInvoBillItem
String copyData = "INSERT INTO tblInvoBillItem SELECT * FROM tblInvoiceItems";
SqlCommand cmd = new SqlCommand(copyData, ConnectionDB.connection());
cmd.ExecuteNonQuery();
//TOTAL ALL QUANTITY CALCULATE
String sql = "SELECT noOfQty FROM tblInvoiceItems";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
string qty = ns.Rows[i]["noOfQty"].ToString();
noOfAllQty += int.Parse(qty);
}
//INSERT INVOICE DETAILS
objInvo.newInvoce(
lblInvoiceNo.Text,
DateTime.Today,
lblSel.Text,
decimal.Parse(txtSubTotal.Text),
decimal.Parse(txtTax.Text),
decimal.Parse(txtTotal.Text),
noOfAllQty,
decimal.Parse(txtCash.Text),
decimal.Parse(txtChange.Text)
);
//SELL ITEM REMOVE STOCK
String isql = "SELECT * FROM tblInvoiceItems";
SqlDataAdapter iget = new SqlDataAdapter(isql, ConnectionDB.connection());
DataTable idt = new DataTable();
iget.Fill(idt);
for (int i = 0; i < idt.Rows.Count; i++)
{
int nowAllQty = 0;
//decimal subtotal = 0.0M;
string item_no = idt.Rows[i]["ItmNo"].ToString();
int noOfQuantity = int.Parse(idt.Rows[i]["noOfQty"].ToString());
string csql = "SELECT * FROM tbl_Item WHERE itemNo='" + item_no + "'";
SqlCommand cmdi = new SqlCommand(csql, ConnectionDB.connection());
SqlDataReader dr1 = cmdi.ExecuteReader();
while (dr1.Read() == true)
{
int stock_noOfQty = int.Parse(dr1["noOfQty"].ToString());
decimal old_OneQtySellPrice = decimal.Parse(dr1["OneQtySellPrice"].ToString());
//now stock item
nowAllQty = stock_noOfQty - noOfQuantity;
//stock update
objInvo.update_Quntity(item_no, nowAllQty);
//success
picBxSucc.Visible = true;
lblSucc.Visible = true;
picBxNotSucc.Visible = false;
lblNotSucc.Visible = false;
//reset();
}
}
}
billPrint();
btnSell.Enabled = false;
//frmFinalBill frmBill = new frmFinalBill();
//frmBill.ShowDialog();
CrystalReport1_Bill objCrystal = new CrystalReport1_Bill();
objCrystal.PrintToPrinter(1, false, 0, 0);
btnSell.Enabled = true;
reset();
}
else
{
MessageBox.Show("Please fully payement!", "BILL ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
if (txtCash.Text == "0.00")
{
epCash.SetError(txtCash, "Can not be null.");
}
if (txtTotal.Text == "0.00")
{
epSubTotal.SetError(txtSubTotal, "Can not be null.");
}
if (txtSubTotal.Text == "0.00")
{
epTotal.SetError(txtTotal, "Can not be null.");
}
picBxSucc.Visible = false;
lblSucc.Visible = false;
picBxNotSucc.Visible = true;
lblNotSucc.Visible = true;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}