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