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