public bool insertsalesdetails(salesdetailsBLL st)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO tbl_transaction_detail(product_id,rate,qty,total,dea_cust_id,added_date,added_by) VALUES(@productid,@rate,@qty,@total,@custid,@addeddate,@added_by)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@productid", st.productid);
cmd.Parameters.AddWithValue("@rate", st.rate);
cmd.Parameters.AddWithValue("@qty", st.qty);
cmd.Parameters.AddWithValue("@total", st.total);
cmd.Parameters.AddWithValue("@custid", st.custid);
cmd.Parameters.AddWithValue("@addeddate", st.addeddate);
cmd.Parameters.AddWithValue("@added_by", 8);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(isSuccess);
}
public void save()
{
salesBLL sales = new salesBLL();
string cname = txtName.Text;
if (cname != "")
{
customerBLL c = cDAL.getCustomerIdFromName(cname);
sales.salesdate = dtpBillDate.Value;
sales.custid = c.id;
sales.grandtotal = decimal.Parse(txtGrandTotal.Text);
sales.gst = decimal.Parse(txtGst.Text);
sales.discount = decimal.Parse(txtDiscount.Text);
sales.salesdetails = salesdt;
bool isSuccess = false;
// using (TransactionScope scope = new TransactionScope())
{
int salesid = -1;
bool b = s.insertsales(sales, out salesid);
for (int i = 0; i < salesdt.Rows.Count; i++)
{
salesdetailsBLL sdb = new salesdetailsBLL();
string productName = salesdt.Rows[i][1].ToString();
productBLL p = pDAL.GetProductIDFromName(productName);
sdb.productid = p.id;
sdb.rate = decimal.Parse(salesdt.Rows[i][2].ToString());
sdb.qty = decimal.Parse(salesdt.Rows[i][3].ToString());
sdb.total = Math.Round(decimal.Parse(salesdt.Rows[i][4].ToString()), 2);
sdb.custid = c.id;
sdb.addeddate = dtpBillDate.Value;
if (b == true)
{
bool x = pDAL.DecreaseProduct(sdb.productid, sdb.qty);
}
bool y = sd.insertsalesdetails(sdb);
isSuccess = b && y;
}
if (isSuccess == true)
{
//scope.Complete();
MessageBox.Show("Transaction Completed");
clear();
}
else
{
MessageBox.Show("Transaction Failed");
}
}
}
else
{
MessageBox.Show("Please Select Customer Details");
}
}
