public ActionResult DeleteConfirmed(int id)
{
TournamentScore tournamentScore = db.TournamentScores.Find(id);
db.TournamentScores.Remove(tournamentScore);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TournamentScoresID,TournamentID,PlayerID,PointsFor,PointsAgainst,LeagueID,DefenseAgainst")] TournamentScore tournamentScore)
{
if (ModelState.IsValid)
{
db.Entry(tournamentScore).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "MainTournaments", new { id = tournamentScore.TournamentID }));
}
ViewBag.LeagueID = new SelectList(db.Leagues, "LeagueID", "LeagueName", tournamentScore.LeagueID);
ViewBag.PlayerID = new SelectList(db.Players, "PlayerID", "PlayerName", tournamentScore.PlayerID);
ViewBag.TournamentID = new SelectList(db.Tournaments, "TournamentID", "TournamentName", tournamentScore.TournamentID);
return(View(tournamentScore));
}
public ActionResult Create([Bind(Include = "TournamentScoresID,TournamentID,PlayerID,PointsFor,PointsAgainst,LeagueID,DefenseAgainst")] TournamentScore tournamentScore)
{
if (ModelState.IsValid)
{
db.TournamentScores.Add(tournamentScore);
db.SaveChanges();
return(RedirectToAction("Index", "MainTournaments"));
}
ViewBag.LeagueID = new SelectList(db.Leagues, "LeagueID", "LeagueName", tournamentScore.LeagueID);
ViewBag.PlayerID = new SelectList(db.Players, "PlayerID", "PlayerName", tournamentScore.PlayerID);
ViewBag.TournamentID = new SelectList(db.Tournaments, "TournamentID", "TournamentName", tournamentScore.TournamentID);
return(View(tournamentScore));
}
// GET: MainTournamentScores/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TournamentScore tournamentScore = db.TournamentScores.Find(id);
if (tournamentScore == null)
{
return(HttpNotFound());
}
return(View(tournamentScore));
}
// GET: MainTournamentScores/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TournamentScore tournamentScore = db.TournamentScores.Find(id);
if (tournamentScore == null)
{
return(HttpNotFound());
}
ViewBag.LeagueID = new SelectList(db.Leagues, "LeagueID", "LeagueName", tournamentScore.LeagueID);
ViewBag.PlayerID = new SelectList(db.Players, "PlayerID", "PlayerName", tournamentScore.PlayerID);
ViewBag.TournamentID = new SelectList(db.Tournaments, "TournamentID", "TournamentName", tournamentScore.TournamentID);
return(View(tournamentScore));
}
public ActionResult Upload(HttpPostedFileBase postedFile)
{
if (postedFile != null)
{
ExcelPackage package = new ExcelPackage(postedFile.InputStream);
ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault();
TournamentScore tournamentScore = new TournamentScore();
int rowLength = worksheet.Dimension.End.Row;
// plus 1 to avoid headers
for (int rowIndex = worksheet.Dimension.Start.Row + 1; rowIndex <= rowLength; rowIndex++)
{
var playerId = worksheet.Cells[rowIndex, 3].Value;
// don't include benched players or rows without a playerID
if (worksheet.Cells[rowIndex, 9].GetValue <int>() != 1 && playerId != null)
{
tournamentScore.TournamentID = worksheet.Cells[rowIndex, 1].GetValue <int>();
tournamentScore.LeagueID = worksheet.Cells[rowIndex, 2].GetValue <int>();
tournamentScore.PlayerID = worksheet.Cells[rowIndex, 3].GetValue <int>();
tournamentScore.PointsFor = worksheet.Cells[rowIndex, 5].GetValue <int>();
tournamentScore.PointsAgainst = worksheet.Cells[rowIndex, 6].GetValue <int>();
tournamentScore.MissedDrives = worksheet.Cells[rowIndex, 8].GetValue <bool>();
tournamentScore.DefenseAgainst = worksheet.Cells[rowIndex, 7].GetValue <int>();
db.TournamentScores.Add(tournamentScore);
db.SaveChanges();
}
}
//ViewBag.Message = "File uploaded successfully.";
}
return(View());
}
