public IList <HopForm> GetHopForms() { using (var context = new MicrobrewitContext()) { return(context.HopForms.ToList()); } }
public void Add(Brewery brewery) { using (var context = new MicrobrewitContext()) { brewery.Origin = null; brewery.CreatedDate = DateTime.Now; brewery.UpdatedDate = DateTime.Now; context.Entry(brewery).State = EntityState.Added; try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public HopForm GetForm(int id) { using (var context = new MicrobrewitContext()) { return(context.HopForms.SingleOrDefault(h => h.Id == id)); } }
protected override int?ResolveCore(FermentableDto source) { using (var context = new MicrobrewitContext()) { Supplier supplier = null; if (source.Supplier != null) { supplier = context.Suppliers.SingleOrDefault(s => s.SupplierId == source.Supplier.Id || s.Name.Equals(source.Supplier.Name)); if (supplier == null) { supplier = new Supplier() { Name = source.Supplier.Name, }; context.Suppliers.Add(supplier); context.SaveChanges(); } return(supplier.SupplierId); } else { return(null); } } }
public IList <BrewerySocial> GetBrewerySocials(int breweryId) { using (var context = new MicrobrewitContext()) { return(context.BrewerySocials.Where(b => b.BreweryId == breweryId).ToList()); } }
public override async Task <int> UpdateAsync(params User[] users) { using (var context = new MicrobrewitContext()) { foreach (var user in users) { var originalUser = context.Users.SingleOrDefault(u => u.Username == user.Username); if (originalUser != null) { SetChanges(context, originalUser, user); foreach (var social in user.Socials) { var originalSocial = context.UserSocials.SingleOrDefault( s => s.Username == user.Username && s.SocialId == social.SocialId); if (originalSocial != null) { SetChanges(context, originalSocial, social); } else { context.UserSocials.Add(social); } } } } return(await context.SaveChangesAsync()); } }
public async Task <IList <BreweryMember> > GetAllMembersAsync(int breweryId) { using (var context = new MicrobrewitContext()) { return(await context.BreweryMembers.Where(b => b.BreweryId == breweryId).ToListAsync()); } }
public async Task <BreweryMember> GetSingleMemberAsync(int breweryId, string username) { using (var context = new MicrobrewitContext()) { return(await context.BreweryMembers.SingleOrDefaultAsync(bm => bm.MemberUsername.Equals(username) && bm.BreweryId == breweryId)); } }
public async Task <IList <HopForm> > GetHopFormsAsync() { using (var context = new MicrobrewitContext()) { return(await context.HopForms.ToListAsync()); } }
public void Add(Fermentable fermentable) { using (var context = new MicrobrewitContext()) { if (fermentable.Supplier != null) { fermentable.Supplier = null; } context.Entry(fermentable).State = EntityState.Added; try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public virtual async Task AddAsync(Other origin) { using (var context = new MicrobrewitContext()) { context.Entry(origin).State = EntityState.Added; try { await context.SaveChangesAsync(); } catch (DbEntityValidationException dbEx) { //foreach (var validationErrors in dbEx.EntityValidationErrors) //{ // foreach (var validationError in validationErrors.ValidationErrors) // { // Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // throw dbEx; // } //} throw; } catch (Exception ex) { throw; } } }
protected override IList <Hop> ResolveCore(HopDto dto) { using (var context = new MicrobrewitContext()) { List <Hop> hops = new List <Hop>(); if (dto.Substituts != null) { foreach (var sub in dto.Substituts) { if (sub.Id > 0) { var hop = context.Hops.SingleOrDefault(h => h.HopId == sub.Id); if (hop != null) { hops.Add(hop); } } else { var hop = context.Hops.SingleOrDefault(h => h.Name.Equals(sub.Name)); if (hop != null) { hops.Add(hop); } } } } return(hops); } }
public virtual void Add(params T[] items) { using (var context = new MicrobrewitContext()) { foreach (T item in items) { context.Entry(item).State = EntityState.Added; } try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public async Task <bool> ConfirmBreweryMemberAsync(string username, NotificationDto notificationDto) { using (var context = new MicrobrewitContext()) { var breweryMember = await context.BreweryMembers.SingleOrDefaultAsync( b => b.BreweryId == notificationDto.Id && b.MemberUsername == username); if (breweryMember == null) { return(false); } if (notificationDto.Value) { breweryMember.Confirmed = true; } else { context.BreweryMembers.Remove(breweryMember); } await context.SaveChangesAsync(); return(true); } }
protected override int ResolveCore(T source) { using (var context = new MicrobrewitContext()) { return(1); } }
public IEnumerable <UserSocial> GetUserSocials(string username) { using (var context = new MicrobrewitContext()) { return(context.UserSocials.Where(s => s.Username == username).ToList()); } }
public async Task <IEnumerable <UserBeer> > GetAllUserBeersAsync(string username) { using (var context = new MicrobrewitContext()) { return(await context.UserBeers.Where(u => u.Username == username).ToListAsync()); } }
public IList <BreweryMember> GetMembers(int breweryId) { using (var context = new MicrobrewitContext()) { return(context.BreweryMembers.Where(bm => bm.BreweryId == breweryId).ToList()); } }
public IList <BreweryMember> GetMemberships(string username) { using (var context = new MicrobrewitContext()) { return(context.BreweryMembers.Where(b => b.MemberUsername.Equals(username)).ToList()); } }
public static void InsertDataDatabase() { using (var context = new MicrobrewitContext()) { var insert = File.ReadAllText(@"..\..\JSON\insert.sql"); context.Database.ExecuteSqlCommand(insert); } }
public virtual void Update(Fermentable fermentable) { using (var context = new MicrobrewitContext()) { context.Entry(fermentable).State = EntityState.Modified; context.SaveChanges(); } }
public virtual void Remove(BeerStyle beerStyle) { using (var context = new MicrobrewitContext()) { context.Entry(beerStyle).State = EntityState.Deleted; context.SaveChanges(); } }
public async Task AddMemberAsync(BreweryMember breweryMember) { using (var context = new MicrobrewitContext()) { context.BreweryMembers.Add(breweryMember); await context.SaveChangesAsync(); } }
public async Task UpdateMemberAsync(BreweryMember breweryMember) { using (var context = new MicrobrewitContext()) { context.Entry(breweryMember).State = EntityState.Modified; await context.SaveChangesAsync(); } }
public async Task AddAsync(Beer beer) { using (var context = new MicrobrewitContext()) { context.Entry(beer).State = EntityState.Added; await context.SaveChangesAsync(); } }
public static void DeleteDataInDatabase() { using (var context = new MicrobrewitContext()) { var delete = File.ReadAllText(@"..\..\JSON\delete.sql"); context.Database.ExecuteSqlCommand(delete); } }
public virtual void Remove(Other other) { using (var context = new MicrobrewitContext()) { context.Entry(other).State = EntityState.Deleted; context.SaveChanges(); } }
public virtual void Update(Other other) { using (var context = new MicrobrewitContext()) { context.Entry(other).State = EntityState.Modified; context.SaveChanges(); } }
public async Task <IList <Hop> > GetAllAsync(params string[] navigationProperties) { using (var context = new MicrobrewitContext()) { IQueryable <Hop> dbQueryable = context.Set <Hop>(); dbQueryable = navigationProperties.Aggregate(dbQueryable, (current, navigationProperty) => current.Include(navigationProperty)); return(await dbQueryable.ToListAsync()); } }
public async Task <Hop> GetSingleAsync(int id, params string[] navigtionProperties) { using (var context = new MicrobrewitContext()) { IQueryable <Hop> dbQueryable = context.Set <Hop>(); dbQueryable = navigtionProperties.Aggregate(dbQueryable, (current, navigationProperty) => current.Include(navigationProperty)); return(await dbQueryable.SingleOrDefaultAsync(h => h.HopId == id)); } }