public static void EnsureDb()
{
using (var db = new MetrixContext())
{
db.Database.EnsureCreated();
}
}
public async Task <UsageData> GetItemAsync(Expression <Func <UsageData, bool> > predicate)
{
using (var context = new MetrixContext())
{
return(await context.UsageDatas
.FirstOrDefaultAsync(predicate));
}
}
public async Task <ComputerDetail> GetItemAsync(Expression <Func <ComputerDetail, bool> > predicate)
{
using (var context = new MetrixContext())
{
return(await context.ComputerDetails
.FirstOrDefaultAsync(predicate));
}
}
public List <UsageData> GetAllItemsWhere(Expression <Func <UsageData, bool> > predicate)
{
using (var context = new MetrixContext())
{
return(context.UsageDatas
.Where(predicate)
.ToList());
}
}
public List <ComputerDetail> GetAllItemsWhere(Expression <Func <ComputerDetail, bool> > predicate)
{
using (var context = new MetrixContext())
{
return(context.ComputerDetails
.Where(predicate)
.ToList());
}
}
public bool AddNewItem(ComputerDetail computerDetail)
{
using (var context = new MetrixContext())
{
//Null exception when trying to retrieve data
/*var value = context.ComputerDetails.FirstOrDefault(x => x.Name.Equals(computerDetail.Name));
* if (value != null)
* return false;*/
context.ComputerDetails.Add(computerDetail);
context.SaveChanges();
return(true);
}
}
public bool AddNewItem(UsageData usageData)
{
using (var context = new MetrixContext())
{
try
{
context.UsageDatas.Add(usageData);
context.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
