/// <summary author="Jared Greenfield" created="2019/01/23">
/// Retrieves a list of all Items.
/// </summary>
/// <exception cref="SQLException">Insert Fails (example of exception tag)</exception>
/// <returns>List of all Items</returns>
public List <Item> RetrieveAllItems()
{
List <Item> items = new List <Item>();
try
{
items = _itemAccessor.SelectAllItems();
}
catch (Exception ex)
{
ExceptionLogManager.getInstance().LogException(ex);
throw ex;
}
return(items);
}
/// <summary>
/// Jared Greenfield
/// Created: 2018/01/29
///
/// Creates a recipe line under the given ID.
/// </summary>
/// <param name="recipeID">The ID of the recipe that the line will be listed under.</param>
/// <param name="line">The recipe line to be added.</param>
/// <exception cref="SQLException">Insert Fails (example of exception tag)</exception>
/// <returns>1 if successful, 0 if unsuccessful</returns>
public List <RecipeItemLineVM> SelectRecipeLinesByID(int recipeID)
{
List <RecipeItemLineVM> lines = new List <RecipeItemLineVM>();
var conn = DBConnection.GetDbConnection();
string cmdText = @"sp_select_recipe_item_lines";
List <Item> items = new List <Item>();
try
{
items = _itemAccessor.SelectAllItems();
SqlCommand cmd1 = new SqlCommand(cmdText, conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@RecipeID", recipeID);
try
{
conn.Open();
var reader = cmd1.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int itemID = reader.GetInt32(1);
decimal quantity = reader.GetDecimal(2);
string unitOfMeasure = reader.GetString(3);
var item = items.Find(x => x.ItemID == itemID);
string itemName = item.Name;
RecipeItemLineVM line = new RecipeItemLineVM(itemID, recipeID, itemName, quantity, unitOfMeasure);
lines.Add(line);
}
}
}
catch (Exception)
{
throw;
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(lines);
}