public bool insertsales(salesBLL s, out int salesID)
{
bool isSuccess = false;
salesID = -1;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO tbl_transactions (type,dea_cust_id,grandTotal,transaction_date,tax,discount,added_by) VALUES(@type,@custid,@grandTotal,@salesdate,@gst,@discount,@added_by);select @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@type", "Sales");
cmd.Parameters.AddWithValue("@custid", s.custid);
cmd.Parameters.AddWithValue("@grandtotal", s.grandtotal);
cmd.Parameters.AddWithValue("@salesdate", s.salesdate);
cmd.Parameters.AddWithValue("@gst", s.gst);
cmd.Parameters.AddWithValue("@discount", s.discount);
cmd.Parameters.AddWithValue("@added_by", 8);
con.Open();
//open connection
object o = cmd.ExecuteScalar();
if (o != null)
{
isSuccess = true;
salesID = int.Parse(o.ToString());
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
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");
}
}
