private static void Raise(RSVPed rsvped)
{
var dinners = new NerdDinners();
PopularDinner.Handle(dinners, Event.Make(rsvped, Guid.NewGuid(), 0));
dinners.SaveChanges();
}
private void PopulatePopularDinnerReadModelForDinner(int dinnerId, int rsvpCount)
{
var ctx = new NerdDinners();
var pop = PopularDinnerFromDinner(ctx.Dinners.Find(dinnerId));
pop.RSVPCount = rsvpCount;
ctx.PopularDinners.Add(pop);
ctx.SaveChanges();
}
public ActionResult Edit(Dinner dinner)
{
if (ModelState.IsValid)
{
nerdDinners.Entry(dinner).State = System.Data.Entity.EntityState.Modified;
nerdDinners.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dinner));
}
public ActionResult Create(Dinner dinner)
{
if (ModelState.IsValid)
{
nerdDinners.Dinners.Add(dinner);
nerdDinners.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dinner));
}
static void LoadDataFile()
{
string connectionstring = @"Data Source=(localdb)\v11.0;Initial Catalog=TestDb;Integrated Security=True";
using (var db = new NerdDinners(connectionstring))
{
db.Database.CreateIfNotExists();
db.Database.ExecuteSqlCommand("TRUNCATE TABLE Customers");
foreach (var e in new ChoCSVReader <Customer>("Test.txt").WithDelimiter("\t"))
{
db.Customers.AddOrUpdate(e);
}
int recordsAffected = db.SaveChanges();
Console.WriteLine($"Total inserted: {recordsAffected}");
}
}
public ActionResult Register(int id)
{
Dinner dinner = nerdDinnerDB.Dinners.Find(id);
if (!dinner.IsUserRegistered(User.Identity.Name))
{
RSVP rsvp = new RSVP();
rsvp.AttendeeName = User.Identity.Name;
//if (dinner.RSVPs == null)
//{
// dinner.RSVPs = new List<RSVP>();
//}
dinner.RSVPs.Add(rsvp);
nerdDinnerDB.SaveChanges();
}
return(Content("Thanks - we'll see you there!"));
}
private static void InitializeLocalDbWithTestData()
{
Database.SetInitializer <NerdDinners>(new CreateDatabaseIfNotExistsIncludingIndicesAndUDFs());
var dbContext = new NerdDinners();
dbContext.Database.ExecuteSqlCommand("TRUNCATE TABLE [Dinners]");
dbContext.Database.ExecuteSqlCommand("TRUNCATE TABLE [Events]");
var testData = FakeDinnerData.CreateTestDinners();
foreach (var testDinner in testData.Item1)
{
dbContext.Dinners.Add(testDinner);
}
foreach (var testEvent in testData.Item2)
{
dbContext.Events.Add(testEvent);
}
dbContext.SaveChanges();
}
