public bool insertpurchase(purchaseBLL p, out int purchaseID)
{
bool isSuccess = false;
purchaseID = -1;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO Purchase_Transactions (Transaction_Type,Sup_ID,Sub_Total,TDiscount,TSGST,TCGST,TIGST,Grand_Total) VALUES(@Transaction_Type,@sup_id,@subTotal,@totalDiscount,@totalSgst,@totalCgst,@totalIgst,@grandTotal);select @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, con);
//add parameteres values
cmd.Parameters.AddWithValue("@Transaction_Type", p.Transaction_Type);
cmd.Parameters.AddWithValue("@sup_id", p.Sup_ID);
cmd.Parameters.AddWithValue("@subTotal", p.Sub_Total);
cmd.Parameters.AddWithValue("@totalDiscount", p.TDiscount);
cmd.Parameters.AddWithValue("@totalSgst", p.TSGST);
cmd.Parameters.AddWithValue("@totalCgst", p.TCGST);
cmd.Parameters.AddWithValue("@totalIgst", p.TIGST);
cmd.Parameters.AddWithValue("@grandTotal", p.Grand_Total);
con.Open();
object o = cmd.ExecuteScalar();
if (o != null)
{
isSuccess = true;
purchaseID = int.Parse(o.ToString());
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(isSuccess);
}
public void save()
{
purchaseBLL purchaseBLL = new purchaseBLL();
string sname = textSupplierName.Text;
if (comboPurchaseType.Text != "")
{
if (sname != "")
{
if (dgvAddedProducts.Rows.Count != 0)
{
SupplierMasterBLL s = smDAL.getSuplierIdFromName(sname);
decimal subTotal, totalDiscount, totalSgst, totalCgst, totalIgst, grandTotal;
string type = comboPurchaseType.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);
purchaseBLL.Transaction_Type = type;
purchaseBLL.Sup_ID = s.SupplierID;
purchaseBLL.Sub_Total = subTotal;
purchaseBLL.TDiscount = totalDiscount;
purchaseBLL.TSGST = totalSgst;
purchaseBLL.TCGST = totalCgst;
purchaseBLL.TIGST = totalIgst;
purchaseBLL.Grand_Total = grandTotal;
purchaseBLL.PurchaseDetails = purchasedt;
bool isSuccess = false;
// using (TransactionScope scope = new TransactionScope())
// int purchaseid = -1; already declaraed at the top as a global variable
bool b = purchaseDAL.insertpurchase(purchaseBLL, out purchaseid);
for (int i = 0; i < purchasedt.Rows.Count; i++)
{
purchasedetailsBLL pdBLL = new purchasedetailsBLL();
stockBLL stockBLL = new stockBLL();
string productName = purchasedt.Rows[i][1].ToString();
ProductMasterBLL p = ProductMasterDAL.GetProductIDFromName(productName);
pdBLL.Purchase_ID = purchaseid;
pdBLL.Product_ID = p.Product_ID;
pdBLL.Sup_ID = s.SupplierID;
pdBLL.Product_Name = purchasedt.Rows[i][1].ToString();
pdBLL.Unit = purchasedt.Rows[i][2].ToString();
pdBLL.Qty = Math.Round(decimal.Parse(purchasedt.Rows[i][3].ToString()), 2);
pdBLL.Rate = Math.Round(decimal.Parse(purchasedt.Rows[i][4].ToString()), 2);
pdBLL.Discount_Per = Math.Round(decimal.Parse(purchasedt.Rows[i][6].ToString()), 2);
pdBLL.GST_Type = purchasedt.Rows[i][7].ToString();
pdBLL.GST_Per = Math.Round(decimal.Parse(purchasedt.Rows[i][8].ToString()), 2);
pdBLL.Total = Math.Round(decimal.Parse(purchasedt.Rows[i][9].ToString()), 2);
int Product_id = p.Product_ID;
stockBLL.Product_Id = Product_id;
stockBLL.Quantity = Math.Round(decimal.Parse(purchasedt.Rows[i][3].ToString()), 2);
stockBLL.Unit = purchasedt.Rows[i][2].ToString();
bool y = pdetailsDAL.insertpurchasedetails(pdBLL);
if (y == true)
{
stockBLL Padded = stockDAL.CheakeProductAddedOrNot(Product_id);
//MessageBox.Show("Product is added",Padded.Product_Id.ToString());
if (Product_id == Padded.Product_Id)
{
bool x = stockDAL.Update(stockBLL);
}
else
{
bool z = stockDAL.InsertStockNewProduct(stockBLL);
}
}
isSuccess = b && y;
isSuccess = true;
}
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");
}
}
