/// <summary> /// Medhod to get items from the database. /// </summary> /// <returns></returns> public async Task<Tuple<List<DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode>> GetItems() { try { using (var db = new Database()) { var items = await db.Items .Include(i => i.Category).ToListAsync(); List<DROM_Client.Models.BusinessObjects.Item> itemList = new List<DROM_Client.Models.BusinessObjects.Item>(); foreach (var i in items) { var item = new DROM_Client.Models.BusinessObjects.Item() { Category = i.Category.Name, Description = i.Description, Id = i.Id, Name = i.Name, Price = i.Price }; itemList.Add(item); } return new Tuple<List<DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode>(itemList, "Success", HttpStatusCode.OK); } } catch (Exception ex) { return new Tuple<List<DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode>(null, ex.Message, HttpStatusCode.InternalServerError); } }
/// <summary> /// Medhod to get items from the database. /// </summary> /// <returns></returns> public async Task <Tuple <List <DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode> > GetItems() { try { using (var db = new Database()) { var items = await db.Items .Include(i => i.Category).ToListAsync(); List <DROM_Client.Models.BusinessObjects.Item> itemList = new List <DROM_Client.Models.BusinessObjects.Item>(); foreach (var i in items) { var item = new DROM_Client.Models.BusinessObjects.Item() { Category = i.Category.Name, Description = i.Description, Id = i.Id, Name = i.Name, Price = i.Price }; itemList.Add(item); } return(new Tuple <List <DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode>(itemList, "Success", HttpStatusCode.OK)); } } catch (Exception ex) { return(new Tuple <List <DROM_Client.Models.BusinessObjects.Item>, string, HttpStatusCode>(null, ex.Message, HttpStatusCode.InternalServerError)); } }