public int AddStockDetails_Insert_Update_Delete(BAL_StockDetails bstockdet) { try { con.Open(); cmd = new SqlCommand("SP_StockDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Flag", 1); cmd.Parameters.AddWithValue("@DomainID", bstockdet.DomainID); cmd.Parameters.AddWithValue("@ProductID", bstockdet.ProductID); cmd.Parameters.AddWithValue("@BrandID", bstockdet.BrandID); cmd.Parameters.AddWithValue("@ProductCatID", bstockdet.ProductCatID); cmd.Parameters.AddWithValue("@ModelID", bstockdet.ModelID); cmd.Parameters.AddWithValue("@ColorId", bstockdet.ColorId); cmd.Parameters.AddWithValue("@Products123", bstockdet.Products1234); cmd.Parameters.AddWithValue("@AvilableQty", bstockdet.AvilableQty); cmd.Parameters.AddWithValue("@SaleQty", bstockdet.SaleQty); cmd.Parameters.AddWithValue("@NewQty", bstockdet.NewQty); cmd.Parameters.AddWithValue("@FinalPrice", bstockdet.FinalPrice); cmd.Parameters.AddWithValue("@HaveInsurance", bstockdet.Insurance); cmd.Parameters.AddWithValue("@Warranty", bstockdet.Warranty); cmd.Parameters.AddWithValue("@S_Status", bstockdet.S_Status ); cmd.Parameters.AddWithValue("@C_Date", bstockdet.C_Date); int i = cmd.ExecuteNonQuery(); return i; } catch (Exception) { throw; } finally { con.Close(); } }
public int AddStockDetailsUp_Insert_Update_Delete(BAL_StockDetails bstockdetup) { try { con.Open(); cmd = new SqlCommand("SP_StockDetailsUpdate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Flag", 1); cmd.Parameters.AddWithValue("@id", bstockdetup.SID); //cmd.Parameters.AddWithValue("@Products123", bstockdetup.Products123); //cmd.Parameters.AddWithValue("@AvilableQty", bstockdetup.AvilableQty); cmd.Parameters.AddWithValue("@NewQty", bstockdetup.NewQty); cmd.Parameters.AddWithValue("@FinalPrice", bstockdetup.FinalPrice); cmd.Parameters.AddWithValue("@S_Status", bstockdetup.S_Status); cmd.Parameters.AddWithValue("@C_Date", bstockdetup.C_Date); int i = cmd.ExecuteNonQuery(); return i; } catch (Exception) { throw; } finally { con.Close(); } }
public int AddQtyStockDetails_Insert_Update_Delete(BAL_StockDetails bqtystockdet) { try { con.Open(); cmd = new SqlCommand("SP_AddQtyStockDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Flag", 1); cmd.Parameters.AddWithValue("@id", bqtystockdet.SID); cmd.Parameters.AddWithValue("@AvilableQty", bqtystockdet.AvilableQty); int i = cmd.ExecuteNonQuery(); return i; } catch (Exception) { throw; } finally { con.Close(); } }