public bool AddMStockItemsNutrition(MStockItemsNutrition mstockitemsnutrition)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMStockItemsNutrition";
cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsnutrition.PkSrNo);
// cmd.Parameters.AddWithValue("@IngredientNo", mstockitemsnutrition.IngredientNo);
cmd.Parameters.AddWithValue("@NutritionNo", mstockitemsnutrition.NutritionNo);
cmd.Parameters.AddWithValue("@NutritionValue", mstockitemsnutrition.NutritionValue);
cmd.Parameters.AddWithValue("@NutritionUOM", mstockitemsnutrition.NutritionUOM);
cmd.Parameters.AddWithValue("@SequenceNo", mstockitemsnutrition.SequenceNo);
cmd.Parameters.AddWithValue("@UserID", mstockitemsnutrition.UserID);
cmd.Parameters.AddWithValue("@UserDate", mstockitemsnutrition.UserDate);
cmd.Parameters.AddWithValue("@CompanyNo", mstockitemsnutrition.CompanyNo);
commandcollection.Add(cmd);
return(true);
}
public bool DeleteMStockItemsNutrition(MStockItemsNutrition mstockitemsnutrition)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMStockItemsNutrition";
cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsnutrition.PkSrNo);
commandcollection.Add(cmd);
return(true);
}