public IResult <IEnumerable <Brewery> > BulkCreate(IEnumerable <Brewery> breweries) => Do <IEnumerable <Brewery> > .Try((r) =>
{
breweries = breweries.Select(b => ProcessBrewery(b));
_data.Breweries.AddRange(breweries);
_data.SaveChanges();
return(breweries);
}).Result;
public ActionResult Create(Brewery brewery)
{
if (ModelState.IsValid)
{
_db.Breweries.Add(brewery);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(brewery));
}
private void InitializeData(BreweryDbContext context)
{
if (context.Brewers.Any())
{
return;
}
List <Brewer> brewers = new List <Brewer>();
for (int i = 0; i < 2000; i++)
{
Address address = new Address($"Street {i}", $"Country {i}");
brewers.Add(new Brewer($"Brewer {i}", $"Some Description for brewer {i}", $"brewer{i}@gnail.com", address, DateTime.UtcNow));
}
context.AddRange(brewers);
List <Customer> customers = new List <Customer>();
for (int i = 0; i < 2000; i++)
{
Address address = new Address($"Street {i}", $"Country {i}");
customers.Add(new Customer($"Brewer {i}", $"BE {i}", address));
}
context.AddRange(customers);
context.SaveChanges();
}
static void Main(string[] args)
{
// Deleting DB
// Creating DB
// Adding a Brewer
using (BreweryDbContext context = new BreweryDbContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
Brewer newBrewer = new Brewer("Moortgat", "Brouwerij Duvel Moortgat biedt je een heerlijke brouwerij-ervaring. Ben je een volledige leek of reikt je kennis toch al iets verder? Je ontdekt ongetwijfeld wat je zoekt.");
context.Brewers.Add(newBrewer);
context.SaveChanges();
}
// Query The Brewer
using (BreweryDbContext context = new BreweryDbContext())
{
Brewer moortgat = context.Brewers.FirstOrDefault();
Console.WriteLine(moortgat.Name);
}
}
//method to delete a brewery
public bool DeleteBrewery(int breweryId)
{
using (var ctx = new BreweryDbContext())
{
var entity =
ctx
.Breweries
.Single(e => e.BreweryId == breweryId);
ctx.Breweries.Remove(entity);
return(ctx.SaveChanges() == 1);
}
}
//method to create a brewery
public bool CreateBrewery(BreweryCreate model)
{
var entity = new Brewery()
{
Name = model.Name,
Inception = model.Inception,
Location = model.Location,
About = model.About,
};
using (var ctx = new BreweryDbContext())
{
ctx.Breweries.Add(entity);
return(ctx.SaveChanges() == 1);
}
}
//method to update a brewery
public bool UpdateBrewery(BreweryEdit model)
{
using (var ctx = new BreweryDbContext())
{
var entity =
ctx
.Breweries
.Single(e => e.Name == model.Name);
entity.Name = model.Name;
entity.Inception = model.Inception;
entity.Location = model.Location;
entity.About = model.About;
return(ctx.SaveChanges() == 1);
}
}
public IResult <User> Create(User user, string password) => Do <User> .Try((r) =>
{
var hashedPasswordResult = GetHashedPassword(password);
if (hashedPasswordResult.HasErrorsOrResultIsNull())
{
r.AddErrors(hashedPasswordResult);
return(null);
}
var(salt, hashedPassword) = hashedPasswordResult.ResultObject;
user.PasswordHash = hashedPassword;
user.Salt = salt;
_data.Users.Add(user);
_data.SaveChanges();
return(user);
}).Result;
