public bool AddEquipment(Equipment value)
{
bool result = false;
try
{
using (var db = new BrewEverywhereDBContext())
{
db.EquipmentProfiles.Add(value);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_logService.Fatal(ex.Message);
_logService.Fatal(ex.StackTrace);
}
return result;
}
public bool UpdateYeast(Yeast value)
{
bool result = false;
try
{
using (var db = new BrewEverywhereDBContext())
{
db.Yeasts.Attach(value);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_logService.Fatal(ex.Message);
_logService.Fatal(ex.StackTrace);
}
return result;
}
public Account GetUserAccountByUserName(string userName)
{
Account result = null;
using (var db = new BrewEverywhereDBContext())
{
result = db.Accounts.Where(a => a.userName == userName).FirstOrDefault();
}
return result;
}
public Account GetUserAccount(Guid id)
{
Account result = null;
using (var db = new BrewEverywhereDBContext())
{
result = db.Accounts.Where(a => a.Id == id).FirstOrDefault();
}
return result;
}
public Brewer GetBrewer(Guid id)
{
Brewer result = null;
using (var db = new BrewEverywhereDBContext())
{
result = db.Brewers.Where(a => a.Id == id).FirstOrDefault();
}
return result;
}
public bool DeleteWaterProfile(WaterProfile value)
{
bool result = false;
try
{
using (var db = new BrewEverywhereDBContext())
{
db.WaterProfiles.Attach(value);
db.WaterProfiles.Remove(value);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_logService.Fatal(ex.Message);
_logService.Fatal(ex.StackTrace);
}
return result;
}