[Authorize] //this means the user has to login to access the view public ActionResult Add() { var model = new Euro2016.Models.FixturesViewModel(); //this is creating a new instance of an object //this is creating a new instance of an object //this is creating a new instance of an object using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { model.Teams = dbContext.Teams.OrderBy(x => x.Name).ToList(); model.Venues = dbContext.Venues.ToList(); } return(View(model)); }
// GET: Fixtures public ActionResult Index() { var model = new Euro2016.Models.FixturesViewModel(); //this is creating a new instance of an object using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { model.Fixtures = dbContext.Fixtures .Include("HomeTeam") .Include("AwayTeam") .Include("Venue") .ToList(); } return(View(model)); }
[Authorize] //this means the user has to login to access the view public ActionResult Edit(int id) { var model = new Euro2016.Models.FixturesViewModel(); //this is creating a new instance of an object using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { var fixture = dbContext.Fixtures.Where(x => x.Id == id).FirstOrDefault(); model.HomeTeamId = fixture.HomeTeamId; model.AwayTeamId = fixture.AwayTeamId; model.VenueId = fixture.VenueId; model.FixtureDate = fixture.Date; model.Teams = dbContext.Teams.OrderBy(x => x.Name).ToList(); model.Venues = dbContext.Venues.ToList(); } return(View(model)); }
[Authorize] //this means the user has to login to access the view public ActionResult Edit(Euro2016.Models.FixturesViewModel model) { if (!ModelState.IsValid) //this checks if the model is valid, if it's not valid then we are returning the view and displaying an error. The model is invalid if a required property is not filled in for example. { return(View(model)); } using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { var fixture = dbContext.Fixtures.Where(x => x.Id == model.Id).FirstOrDefault(); fixture.MaintenanceDate = DateTime.Now; fixture.MaintenanceSource = "Dan"; fixture.HomeTeamId = model.HomeTeamId; fixture.AwayTeamId = model.AwayTeamId; fixture.VenueId = model.VenueId; fixture.Date = model.FixtureDate.GetValueOrDefault(); dbContext.SaveChanges(); } return(RedirectToAction("Index")); }
[Authorize] //this means the user has to login to access the view public ActionResult Add(Euro2016.Models.FixturesViewModel model) { using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { model.Teams = dbContext.Teams.OrderBy(x => x.Name).ToList(); model.Venues = dbContext.Venues.ToList(); } if (!ModelState.IsValid) //this checks if the model is valid, if it's not valid then we are returning the view and displaying an error. The model is invalid if a required property is not filled in for example. { return(View(model)); } if (model.HomeTeamId == model.AwayTeamId) { TempData.Add("Message", "Please select two different teams."); return(View(model)); } var fixture = new Fixture(); //this is creating a new instance of an object fixture.HomeTeamId = model.HomeTeamId; fixture.AwayTeamId = model.AwayTeamId; fixture.VenueId = model.VenueId; fixture.Date = model.FixtureDate.GetValueOrDefault(); fixture.CreationDate = DateTime.Now; fixture.CreationSource = "Dan"; using (var dbContext = new Euro2016Entities()) //this gets a database connection until the curly bracket is closed { dbContext.Fixtures.Add(fixture); dbContext.SaveChanges(); } return(RedirectToAction("Index")); }