private void btnSave_Click(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(this.billToAdd.Text) && !String.IsNullOrWhiteSpace(this.deliveryToAdd.Text) && !String.IsNullOrWhiteSpace(this.txtTax.Text) && !String.IsNullOrWhiteSpace(this.txtFright.Text))
{
BillData billData = new BillData();
billData.BillToAdd = this.billToAdd.Text;
billData.DeliveryToAdd = this.deliveryToAdd.Text;
billData.InvoiceNo = Convert.ToInt64(this.lblInvoiceNo.Text);
billData.yourRefNo = this.yourRefNo.Text;
billData.ourRefNo = this.ourRefNo.Text;
billData.tax = Convert.ToDouble(this.txtTax.Text);
billData.freight = Convert.ToDouble(this.txtFright.Text);
BillItems billItms;
List <BillItems> lstBillItms = new List <BillItems>();
foreach (DataGridViewRow dgR in dataGridView1.Rows)
{
if (!String.IsNullOrWhiteSpace(Convert.ToString(dgR.Cells["ItmDescription"].Value)) && !String.IsNullOrWhiteSpace(Convert.ToString(dgR.Cells["Quantity"].Value)) && !String.IsNullOrWhiteSpace(Convert.ToString(dgR.Cells["Quantity"].Value)))
{
billItms = new BillItems();
billItms.ItmDescription = Convert.ToString(dgR.Cells["ItmDescription"].Value);
billItms.Quantity = Convert.ToDouble(dgR.Cells["Quantity"].Value);
billItms.Rate = Convert.ToDouble(dgR.Cells["Quantity"].Value);
lstBillItms.Add(billItms);
}
}
billData.billItms = lstBillItms;
DataAccess dataAcc = new DataAccess();
if (dataAcc.SaveData(billData))
{
this.lblInvoiceNo.Text = dataAcc.getInvoiceNumber();
MessageBox.Show("Bill Saved Successfuly");
}
}
}
public bool SaveData(BillData billData)
{
bool chkBool = false;
Int64 chkflag = 0;
SqlConnection con = new SqlConnection(conStr);
try
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("BillToAdd", billData.BillToAdd),
new SqlParameter("DeliverytoAdd", billData.DeliveryToAdd),
new SqlParameter("InvoiceNo", billData.InvoiceNo),
new SqlParameter("yourRefNo", billData.yourRefNo),
new SqlParameter("ourRefNo", billData.ourRefNo),
new SqlParameter("tax", billData.tax),
new SqlParameter("freight", billData.freight),
new SqlParameter("billID", SqlDbType.BigInt, Int32.MaxValue),
};
SqlCommand com = new SqlCommand("InBillMst", con);
com.Parameters.AddRange(para);
com.Parameters["billID"].Direction = ParameterDirection.Output;
com.CommandType = CommandType.StoredProcedure;
con.Open();
chkflag = com.ExecuteNonQuery();
if (chkflag > 0)
{
chkflag = Convert.ToInt64(com.Parameters["billID"].Value);
if (chkflag > 0)
{
//Loop insert for bill details.
foreach (BillItems BillItm in billData.billItms)
{
para = new SqlParameter[] {
new SqlParameter("BillId", chkflag),
new SqlParameter("ItmDescription", BillItm.ItmDescription),
new SqlParameter("Quantity", BillItm.Quantity),
new SqlParameter("Rate", BillItm.Rate)
};
com = new SqlCommand("InBillDetail", con);
com.Parameters.AddRange(para);
com.CommandType = CommandType.StoredProcedure;
com.ExecuteNonQuery();
}
}
chkBool = true;
}
con.Close();
}
catch (Exception ex)
{
chkBool = false;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(chkBool);
}
