public ActionResult CreateOrEditTeam(int?id) { GarageTeamModel model = new GarageTeamModel(); var GarageList = db.Garages.OrderBy(o => o.Garage_Name).ToList(); if (id.HasValue) { GarageTeam entity = db.GarageTeams.Where(i => i.Id == id.Value).SingleOrDefault(); if (entity != null) { var garage = db.Garages.Where(i => i.GarageId == entity.GarageId).SingleOrDefault(); model.Id = entity.Id; model.Title = entity.Title; model.GarageId = entity.GarageId; if (garage != null) { model.GarageName = garage.Garage_Name; } model.Active = entity.Active; model.CreatedOn = entity.CreatedOn; } } foreach (var garage in GarageList) { model.AvailableGarages.Add(new SelectListItem() { Text = garage.Garage_Name, Value = garage.GarageId.ToString() }); } return(View(model)); }
public ActionResult TeamList() { IList <GarageTeamModel> teammodelList = new List <GarageTeamModel>(); var garageTeams = db.GarageTeams.ToList(); GarageTeamModel model; foreach (var item in garageTeams) { var garage = db.Garages.Where(i => i.GarageId == item.GarageId).SingleOrDefault(); model = new GarageTeamModel(); model.Id = item.Id; model.Title = item.Title; if (garage != null) { model.GarageName = garage.Garage_Name; } model.GarageId = item.GarageId; model.Active = item.Active; model.CreatedOn = item.CreatedOn; teammodelList.Add(model); } return(View(teammodelList)); }
public ActionResult CreateOrEditTeam(GarageTeamModel model) { if (ModelState.IsValid) { if (model.Id <= 0) { GarageTeam entity = new GarageTeam(); entity.Title = model.Title; entity.GarageId = model.GarageId; entity.CreatedOn = DateTime.Now; entity.Active = model.Active; db.GarageTeams.Add(entity); db.SaveChanges(); } else { GarageTeam entity = db.GarageTeams.Where(i => i.Id == model.Id).SingleOrDefault(); if (entity != null) { entity.Title = model.Title; entity.GarageId = model.GarageId; entity.Active = model.Active; db.SaveChanges(); } } return(RedirectToAction("TeamList")); } var GarageList = db.Garages.OrderBy(o => o.Garage_Name).ToList(); foreach (var garage in GarageList) { model.AvailableGarages.Add(new SelectListItem() { Text = garage.Garage_Name, Value = garage.GarageId.ToString() }); } return(View(model)); }