// GET: TuesdayTeams/Create public ActionResult Create() { var items = db.TuesdayTeams.ToList(); int id = 1; if (items.Count > 1) { items.Sort((a, b) => a.id.CompareTo(b.id)); id = items[items.Count - 1].id + 1; } var item = new TuesdayTeam() { id = id }; var teams = db.TuesdayTeams.OrderBy(x => x.id); var list = new List <Player>(); var list1 = db.Players.Where(x => x.TuesdayLeague).ToList(); foreach (var player in list1) { if (!teams.Any(x => x.Skip == player.id || x.Lead == player.id)) { list.Add(player); } } ViewBag.Skip = new SelectList(list.OrderBy(x => x.LastName), "id", "FullName", ""); ViewBag.Lead = new SelectList(list.OrderBy(x => x.LastName), "id", "FullName", ""); ViewBag.Teams = teams; return(View(item)); }
public ActionResult DeleteConfirmed(int id) { TuesdayTeam tuesdayTeam = db.TuesdayTeams.Find(id); db.TuesdayTeams.Remove(tuesdayTeam); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Infrastructure.DbUpdateException e) { ErrorSignal.FromCurrentContext().Raise(e); Exception ex = e; while (ex.InnerException != null) { ex = ex.InnerException; } ViewBag.Error = ex.Message; } catch (Exception e) { ErrorSignal.FromCurrentContext().Raise(e); ViewBag.Error = "Delete failed"; } return(View(tuesdayTeam)); }
// GET: TuesdayTeams/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TuesdayTeam tuesdayTeam = db.TuesdayTeams.Find(id); if (tuesdayTeam == null) { return(HttpNotFound()); } var teams = db.TuesdayTeams.OrderBy(x => x.id); var list = new List <Player>(); var list1 = db.Players.Where(x => x.TuesdayLeague).ToList(); foreach (var player in list1) { if (!teams.Any(x => x.Skip == player.id || x.Lead == player.id)) { list.Add(player); } } if (tuesdayTeam.Lead != null) { list.Add(tuesdayTeam.Player1); } ViewBag.Lead = new SelectList(list.OrderBy(x => x.LastName), "id", "FullName", tuesdayTeam.Lead); ViewBag.Teams = teams; return(View(tuesdayTeam)); }
// GET: TuesdayTeams/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TuesdayTeam tuesdayTeam = db.TuesdayTeams.Find(id); if (tuesdayTeam == null) { return(HttpNotFound()); } return(View(tuesdayTeam)); }
public ActionResult RemoveLead(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TuesdayTeam tuesdayTeam = db.TuesdayTeams.Find(id); if (tuesdayTeam == null) { return(HttpNotFound()); } tuesdayTeam.Lead = null; db.Entry(tuesdayTeam).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,Skip,Lead")] TuesdayTeam tuesdayTeam) { if (ModelState.IsValid) { db.Entry(tuesdayTeam).State = EntityState.Modified; try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Infrastructure.DbUpdateException e) { ErrorSignal.FromCurrentContext().Raise(e); Exception ex = e; while (ex.InnerException != null) { ex = ex.InnerException; } ModelState.AddModelError(string.Empty, e.Message); } catch (Exception e) { ErrorSignal.FromCurrentContext().Raise(e); ModelState.AddModelError(string.Empty, "Edit failed"); } } var teams = db.TuesdayTeams.OrderBy(x => x.id); var list = new List <Player>(); var list1 = db.Players.Where(x => x.TuesdayLeague).ToList(); foreach (var player in list1) { if (!teams.Any(x => x.Skip == player.id || x.Lead == player.id)) { list.Add(player); } } if (tuesdayTeam.Lead != null) { list.Add(tuesdayTeam.Player1); } ViewBag.Lead = new SelectList(list.OrderBy(x => x.LastName), "id", "FullName", tuesdayTeam.Lead); ViewBag.Teams = teams; return(View(tuesdayTeam)); }