public bool insertDummySalesDetails(DummySalesDetailsBLL ds)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
//inserting transaction details
string sql = "INSERT INTO DummySales_Transactions_Details (Product_ID,Cust_ID,Product_Name,Unit,Qty,Rate,Dicount_Per,GST_Type,GST_Per,Total) VALUES(@Product_ID,@Cust_ID,@Product_Name,@Unit,@Qty,@Rate,@Discount_Per,@GST_Type,@GST_Per,@Total)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Invoice_No", 1);
cmd.Parameters.AddWithValue("@Product_ID", ds.Product_ID);
cmd.Parameters.AddWithValue("@Cust_ID", ds.Cust_ID);
cmd.Parameters.AddWithValue("@Product_Name", ds.Product_Name);
cmd.Parameters.AddWithValue("@Unit", ds.Unit);
cmd.Parameters.AddWithValue("@Qty", ds.Qty);
cmd.Parameters.AddWithValue("@Rate", ds.Rate);
cmd.Parameters.AddWithValue("@Discount_Per", ds.Discount_Per);
cmd.Parameters.AddWithValue("@GST_Type", ds.GST_Type);
cmd.Parameters.AddWithValue("@GST_Per", ds.GST_Per);
cmd.Parameters.AddWithValue("@Total", ds.Total);
//Unit,Qty,Rate,Discount_Per,GST_Type,GST_Per,Total
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()
{
string sname = textCust_Name.Text;
if (comboTransactionType.Text != "")
{
if (sname != "")
{
if (dgvAddedProducts.Rows.Count != 0)
{
customerBLL c = cDAL.getCustomerIdFromName(sname);
decimal subTotal, totalDiscount, totalSgst, totalCgst, totalIgst, grandTotal;
string type = comboTransactionType.Text;
decimal.TryParse(textSubTotal.Text, out subTotal);
decimal.TryParse(textSubDiscount.Text, out totalDiscount);
decimal.TryParse(textSgst.Text, out totalSgst);
decimal.TryParse(textCgst.Text, out totalCgst);
decimal.TryParse(textIgst.Text, out totalIgst);
decimal.TryParse(textGrandTotal.Text, out grandTotal);
challanBLL.Transaction_Type = type;
challanBLL.Cust_ID = c.Cust_ID;
challanBLL.Sub_Total = subTotal;
challanBLL.TDiscount = totalDiscount;
challanBLL.TSGST = totalSgst;
challanBLL.TCGST = totalCgst;
challanBLL.TIGST = totalIgst;
challanBLL.Grand_Total = grandTotal;
challanBLL.DummySalesDetails = salesDT;
bool isSuccess = false;
// using (TransactionScope scope = new TransactionScope())//
{
int salesid = -1;
bool b = challanDAL.insertDummySales(challanBLL, out salesid);
for (int i = 0; i < salesDT.Rows.Count; i++)
{
DummySalesDetailsBLL cdBLL = new DummySalesDetailsBLL();
string productName = salesDT.Rows[i][1].ToString();
ProductMasterBLL p = ProductMasterDAL.GetProductIDFromName(productName);
cdBLL.Product_ID = p.Product_ID;
cdBLL.Cust_ID = c.Cust_ID;
cdBLL.Product_Name = salesDT.Rows[i][1].ToString();
cdBLL.Unit = salesDT.Rows[i][2].ToString();
cdBLL.Qty = Math.Round(decimal.Parse(salesDT.Rows[i][3].ToString()), 2);
cdBLL.Rate = Math.Round(decimal.Parse(salesDT.Rows[i][4].ToString()), 2);
cdBLL.Discount_Per = Math.Round(decimal.Parse(salesDT.Rows[i][6].ToString()), 2);
cdBLL.GST_Type = salesDT.Rows[i][7].ToString();
cdBLL.GST_Per = Math.Round(decimal.Parse(salesDT.Rows[i][8].ToString()), 2);
cdBLL.Total = Math.Round(decimal.Parse(salesDT.Rows[i][9].ToString()), 2);
bool y = DummySalesDetailsDAL.insertDummySalesDetails(cdBLL);
isSuccess = b && y;
isSuccess = true;
}
isSuccess = b;
if (isSuccess == true)
{
//scope.Complete();
MessageBox.Show("Transaction Completed");
//clear();
}
else
{
MessageBox.Show("Transaction Failed");
}
}
}
else
{
MessageBox.Show("Please Add product Details");
}
}
else
{
MessageBox.Show("Please Select Customer Details");
}
}
else
{
MessageBox.Show("Please Select Purchase Type GST OR NOGST");
}
}