public async Task <IActionResult> Edit(string id, [Bind("TeamId,Teams,Matches,Won,Lost,Tied,Points,Nrr,Nrrposition")] PointsTable pointsTable) { if (id != pointsTable.Teams) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(pointsTable); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PointsTableExists(pointsTable.Teams)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(pointsTable)); }
/// <summary> /// Calculate and populate the club points table. /// </summary> private void PopulateClubTable() { foreach (ClubSeasonDetails clubSeasonDetail in this.model.Clubs) { TeamTrophyPointsTableRowViewModel clubPoints = new TeamTrophyPointsTableRowViewModel( clubSeasonDetail.Name, clubSeasonDetail.TeamTrophy.TotalScore); foreach (ITeamTrophyEvent eventPoints in clubSeasonDetail.TeamTrophy.Events) { TeamTrophyPointsTypeViewModel points = new TeamTrophyPointsTypeViewModel( eventPoints.Score, eventPoints.TotalAthletePoints, eventPoints.NumberOfAthletes, eventPoints.Points, eventPoints.Date); clubPoints.AddPoints(points); } PointsTable.Add(clubPoints); } this.PointsTable = new ObservableCollection <TeamTrophyPointsTableRowViewModel>( this.PointsTable.OrderByDescending( order => order.TotalPoints)); }
public async Task <IActionResult> Create([Bind("TeamId,Teams,Matches,Won,Lost,Tied,Points,Nrr,Nrrposition")] PointsTable pointsTable) { if (ModelState.IsValid) { _context.Add(pointsTable); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(pointsTable)); }
public ActionResult TaskArrived(string taskname, string teamname, int index) { isTaskAccept = false; PointsTable pt = new PointsTable(); //pt.teamName = mTeamName; pt.taskName = taskname; //pt.date = DateTime.Now.Date; pt.index = index; var TaskItem = _db.TaskEntries.FirstOrDefault(m => m.TEAMNAME == teamname && m.TASK == taskname); pt.lat = double.Parse(TaskItem.COORDINATE.Split(',')[0]); pt.lng = double.Parse(TaskItem.COORDINATE.Split(',')[1]); _db.PointArrayTable.Add(pt); _db.SaveChanges(); return(Json(null)); }
public ActionResult TaskAccept(string teamloc, string teamname, string taskname) { if (!string.IsNullOrWhiteSpace(teamloc) && !string.IsNullOrWhiteSpace(taskname)) { isTaskAccept = true; mTaskName = taskname; PointsTable fPoint = new PointsTable(); fPoint.taskName = taskname; fPoint.lat = double.Parse(teamloc.Split(',')[0]); fPoint.lng = double.Parse(teamloc.Split(',')[1]); fPoint.index = 0; TrackInfoTable info = new TrackInfoTable(); info.date = DateTime.Now; info.teamName = teamname; info.taskName = fPoint.taskName; _db.PointArrayTable.Add(fPoint); _db.TrackInfoTables.Add(info); _db.SaveChanges(); } mCount = 0; return(Json("")); }
public ActionResult ChangeTeamLocation(string teamLocation, string teamname, string taskname = "", int isaccept = 0) { if (!String.IsNullOrWhiteSpace(teamLocation) && !String.IsNullOrWhiteSpace(teamname)) { //var teamMem = _db.TeamMemberEntries.FirstOrDefault(u => u.TEAMMEMBERNAME == teamname); // if (teamMem != null) // { var team = _db.TeamItems.FirstOrDefault(u => u.TEAMNAME == teamname); if (team != null) { team.TEAMLOCATION = teamLocation; _db.Entry(team).State = EntityState.Modified; _db.SaveChanges(); if (isaccept > 0) { PointsTable pt = new PointsTable(); pt.taskName = taskname; pt.index = isaccept; pt.lat = double.Parse(teamLocation.Split(',')[0]); pt.lng = double.Parse(teamLocation.Split(',')[1]); _db.PointArrayTable.Add(pt); //TrackInfoTable info = new TrackInfoTable(); //info.date = DateTime.Now.Date; //info.teamName = team.TEAMNAME; //info.taskName = mTaskName; //_db.TrackInfoTables.Add(info); _db.SaveChanges(); return(Json("success")); } } //} } return(Json("")); }