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 delete(string taskname, string txtdate)
{
if (!String.IsNullOrEmpty(txtdate))
{
DateTime xdt = Convert.ToDateTime(txtdate);
var infos = _db.TrackInfoTables.Where(m => m.date == xdt);
foreach (TrackInfoTable info in infos)
{
var pts = _db.PointArrayTable.Where(m => m.taskName == info.taskName);
foreach (PointsTable pt in pts)
{
_db.Entry(pt).State = EntityState.Deleted;
}
_db.Entry(info).State = EntityState.Deleted;
}
_db.SaveChanges();
return(Json("success"));
}
else if (!String.IsNullOrEmpty(taskname))
{
TrackInfoTable info = _db.TrackInfoTables.FirstOrDefault(m => m.taskName == taskname);
//foreach (TrackInfoTable info in infos)
//{
var pts = _db.PointArrayTable.Where(m => m.taskName == taskname);
foreach (PointsTable pt in pts)
{
_db.Entry(pt).State = EntityState.Deleted;
}
_db.Entry(info).State = EntityState.Deleted;
//}
_db.SaveChanges();
return(Json("success"));
}
return(Json(""));
}
