Ejemplo n.º 1
0
        public static IngredientAdjustment Add(int employeeId, int ingredientId,
                                               double?originalValue, double?newValue, MeasurementUnit measurementUnit,
                                               int?recipeIngredientId = null, DateTime?when = null)
        {
            IngredientAdjustment result = null;
            SqlConnection        cn     = GetConnection();

            if (when == null)
            {
                when = DateTime.Now;
            }

            string cmd = "AddIngredientAdjustment";

            using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
            {
                sqlCmd.CommandType = CommandType.StoredProcedure;
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentEmployeeId", SqlDbType.Int, employeeId);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentIngredientId", SqlDbType.Int, ingredientId);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentOriginalValue", SqlDbType.Float, originalValue);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentNewValue", SqlDbType.Float, newValue);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentMeasurementUnit", SqlDbType.SmallInt, measurementUnit);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentRecipeIngredientId", SqlDbType.Int, recipeIngredientId);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentWhen", SqlDbType.DateTime, when.Value);
                BuildSqlParameter(sqlCmd, "@IngredientAdjustmentId", SqlDbType.Int, ParameterDirection.ReturnValue);

                if (sqlCmd.ExecuteNonQuery() > 0)
                {
                    result = new IngredientAdjustment(Convert.ToInt32(sqlCmd.Parameters["@IngredientAdjustmentId"].Value),
                                                      employeeId, ingredientId, originalValue, newValue, measurementUnit, recipeIngredientId, when.Value);
                }
            }
            FinishedWithConnection(cn);
            return(result);
        }
Ejemplo n.º 2
0
        public static IngredientAdjustment Get(int id)
        {
            IngredientAdjustment result = null;
            SqlConnection        cn     = GetConnection();

            result = Get(cn, id);
            FinishedWithConnection(cn);
            return(result);
        }
Ejemplo n.º 3
0
        private static IngredientAdjustment Get(SqlConnection cn, int id)
        {
            IngredientAdjustment result = null;

            using (SqlCommand cmd = new SqlCommand("SELECT * FROM IngredientAdjustment WHERE IngredientAdjustmentId=" + id, cn))
            {
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    if (rdr.Read())
                    {
                        result = BuildIngredientAdjustment(rdr);
                    }
                }
            }
            return(result);
        }