public IItem Get(int itemId)
{
IDbDataParameter itemParameter = new SqlParameter("@ItemID", SqlDbType.VarChar)
{
Value = itemId
};
return(ItemDao.Get(itemParameter));
}
public static Item Get(int id)
{
Item item;
ItemEntity entity;
entity = ItemDao.Get(id);
item = ItemMapper.Get(entity);
return(item);
}
private static void TestItems()
{
while (true)
{
Console.WriteLine("Enter any number between 1 and 13; type 'exit' to quit.");
string input = Console.ReadLine();
if (input.Equals("exit", StringComparison.OrdinalIgnoreCase))
{
break;
}
int id = Convert.ToInt32(input);
IDataParameter parameter = new SqlParameter("@ItemID", id);
IItem selectedItem = ItemDao.Get(parameter);
Console.WriteLine($"You have selected {selectedItem.Name} {Environment.NewLine}");
ItemRelationshipsDto dto = ItemDao.GetRelations(parameter);
foreach (IItemRelation relation in dto.Relations)
{
if (relation.ItemOneId == selectedItem.Id)
{
IItem relatedItem = dto.Items.FirstOrDefault(item => item.Id == relation.ItemTwoId);
Console.WriteLine($"{selectedItem.Name} has a downstream dependency to {relatedItem.Name}.");
}
else
{
IItem relatedItem = dto.Items.FirstOrDefault(item => item.Id == relation.ItemOneId);
Console.WriteLine($"{selectedItem.Name} has a upstream dependency to {relatedItem.Name}.");
}
}
Console.WriteLine(Environment.NewLine + Environment.NewLine + "----------------------------------------------------------");
}
}
public IEnumerable <IItem> Get()
{
return(ItemDao.Get());
}