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