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