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(""));
}
