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