public int InsertData(DECustomerReturn customerReturn) { int int_Result = 0; DALProductInStore obj_DALProductInStore = new DALProductInStore(); DALProduct obj_DALProduct = new DALProduct(); DEProductInStore productInStore = new DEProductInStore(); productInStore.Product_Id = customerReturn.Product_Id; DEProduct product = new DEProduct(); product.Product_Id = customerReturn.Product_Id; obj_DALProduct.LoadProductRow(product); SqlConnection SqlCon = new SqlConnection(SqlConjunction.DataConn); try { if (SqlCon.State != ConnectionState.Open) { SqlCon.Open(); } } catch (SqlException ex) { Console.WriteLine(ex); } SqlTransaction tn = SqlCon.BeginTransaction(); { try { this.InsertData(customerReturn, SqlCon, tn); int int_NoOfUnitsSale = 0; if (customerReturn.isCarton == true) { int_NoOfUnitsSale = (customerReturn.Qty * product.NoOfUnitsPerCarton); } else { int_NoOfUnitsSale = customerReturn.Qty; } DataTable dt_ProductInStoreTemp = obj_DALProductInStore.LoadProductInStoreTableByProductId(productInStore, SqlCon, tn); if (dt_ProductInStoreTemp.Rows.Count > 0) { int int_NoOfUnitsInStore = Convert.ToInt32(dt_ProductInStoreTemp.Rows[0][0].ToString()); productInStore.NoOfUnits = (int_NoOfUnitsInStore + int_NoOfUnitsSale); obj_DALProductInStore.UpdateData(productInStore, SqlCon, tn); } else { productInStore.NoOfUnits = (int_NoOfUnitsSale * (-1)); obj_DALProductInStore.InsertData(productInStore, SqlCon, tn); } tn.Commit(); int_Result = 1; } catch (Exception ex) { tn.Rollback(); int_Result = 0; throw (ex); } finally { obj_DALProductInStore = null; SqlCon.Close(); tn.Dispose(); } return(int_Result); } }
public int InsertData(DEStockIn stockIn) { int int_Result = 0; DALProductInStore obj_DALProductInStore = new DALProductInStore(); DEProductInStore productInStore = new DEProductInStore(); productInStore.Product_Id = stockIn.Product_Id; SqlConnection SqlCon = new SqlConnection(SqlConjunction.DataConn); try { if (SqlCon.State != ConnectionState.Open) { SqlCon.Open(); } } catch (SqlException ex) { Console.WriteLine(ex); } SqlTransaction tn = SqlCon.BeginTransaction(); { try { this.InsertData(stockIn, SqlCon, tn); DataTable dt_TempNoOfUnitProductStockIn = this.LoadNoOfUnitsOfProductStockIn(stockIn, SqlCon, tn); if (dt_TempNoOfUnitProductStockIn.Rows.Count > 0) /// no of units of product stock in ရလာမယ္ { int int_NoOfUnits = Convert.ToInt32(dt_TempNoOfUnitProductStockIn.Rows[0][0].ToString()); DataTable dt_ProductInStoreTemp = obj_DALProductInStore.LoadProductInStoreTableByProductId(productInStore, SqlCon, tn); if (dt_ProductInStoreTemp.Rows.Count > 0) { int int_NoOfUnitsInStore = Convert.ToInt32(dt_ProductInStoreTemp.Rows[0][0].ToString()); productInStore.NoOfUnits = (int_NoOfUnits + int_NoOfUnitsInStore); obj_DALProductInStore.UpdateData(productInStore, SqlCon, tn); } else { productInStore.NoOfUnits = int_NoOfUnits; obj_DALProductInStore.InsertData(productInStore, SqlCon, tn); } } tn.Commit(); int_Result = 1; } catch (Exception ex) { tn.Rollback(); int_Result = 0; throw (ex); } finally { obj_DALProductInStore = null; SqlCon.Close(); tn.Dispose(); } return(int_Result); } }