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