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