public Ingredient(int id, string name, int quantity, Unit unit) { this.Id = id; this.Name = name; this.Quantity = quantity; this.Unit = unit; }
public static Unit Create(string name, string abbreviation) { Unit unit; // Insert new unit using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString)) { using (SqlCommand command = new SqlCommand("dbo.Unit_Insert", connection)) { command.CommandType = CommandType.StoredProcedure; //command.Parameters.AddWithValue("@UnitID", 0).Direction = ParameterDirection.Output; command.Parameters.Add("@UnitID", SqlDbType.Int); command.Parameters["@UnitID"].Direction = ParameterDirection.Output; command.Parameters.AddWithValue("@UnitName", name); command.Parameters.AddWithValue("@UnitAbbreviation", abbreviation); connection.Open(); command.ExecuteNonQuery(); unit = new Unit(Convert.ToInt32(command.Parameters["@UnitID"].Value), name, abbreviation); connection.Close(); } // SqlCommand } // SqlConnection return unit; }
public static Ingredient Create(string name, int quantity, Unit unit) { Ingredient ingredient; // Insert new ingredient using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString)) { using (SqlCommand command = new SqlCommand("dbo.Ingredient_Insert", connection)) { command.CommandType = CommandType.StoredProcedure; //command.Parameters.AddWithValue("@IngredientID", 0).Direction = ParameterDirection.Output; command.Parameters.Add("@IngredientID", SqlDbType.Int); command.Parameters["@IngredientID"].Direction = ParameterDirection.Output; command.Parameters.AddWithValue("@IngredientName", name); command.Parameters.AddWithValue("@IngredientQuantity", quantity); command.Parameters.AddWithValue("@UnitID", unit.Id); connection.Open(); command.ExecuteNonQuery(); ingredient = new Ingredient((int)command.Parameters["@IngredientID"].Value, name, quantity, unit); connection.Close(); } // SqlCommand } // SqlConnection return ingredient; }
public static Unit GetUnitByID(int id) { Unit unit = null; // Select unit using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString)) { using (SqlCommand command = new SqlCommand("db_datareader.Unit_Select", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@UnitID", id); connection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { if (dataReader.HasRows && dataReader.Read()) { unit = new Unit(id, (string)dataReader["UnitName"], (string)dataReader["UnitAbbreviation"]); } } // SqlDataReader } // SqlCommand } // SqlConnection return unit; }
public static List<Unit> GetUnits() { List<Unit> units = new List<Unit>(); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString)) { using (SqlCommand command = new SqlCommand("db_datareader.Units_Select", connection)) { command.CommandType = CommandType.StoredProcedure; connection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { Unit unit = new Unit(); unit.Id = Convert.ToInt32(dataReader["UnitID"]); unit.Name = (string)dataReader["UnitName"]; unit.Abbreviation = (string)dataReader["UnitAbbreviation"]; units.Add(unit); } } // SqlDataReader } // SqlCommand } // SqlConnection return units; }