public String AutoCorrect(String FlightUniqueID) {
GeoGrid myGrid = new GeoGrid(FlightUniqueID);
String SQL = "EXEC usp_PayLoad_AutoCorrectGrid '" + FlightUniqueID + "', " + myGrid.YardID;
Util.doSQL(SQL);
return myGrid.getGrid(FlightUniqueID, true);
//return "OK";
}
public String PayloadData([Bind(Prefix = "ID")] int FlightID)
{
var FlightUniqueID = "20160411095652";
var theGrid = new GeoGrid(FlightUniqueID);
Object GridInfo = theGrid.getGridKML();
Response.ContentType = "text/xml";
return(GridInfo.ToString());
}
public ActionResult PayLoad([Bind(Prefix = "ID")] String FlightUniqueID = "")
{
if (!exLogic.User.hasAccess("PAYLOAD.MAP"))
{
return(RedirectToAction("NoAccess", "Home"));
}
int ProcessingModel = Util.getDBInt("Select ISNULL(ProcessingModel,1) From PayLoadFlight where FlightUniqueID='" + FlightUniqueID + "'");
if (ProcessingModel == 1)
{
return(RedirectToAction("PayLoadIndoor", new { ID = FlightUniqueID }));
}
ViewBag.Title = "Payload Data";
String SQL =
"SELECT \n" +
" [RFID], \n" +
" [RSSI], \n" +
" [ReadTime], \n" +
" [ReadCount], \n" +
" CASE WHEN [GridLat] = 0 THEN [Latitude] ELSE [GridLat] END as [Latitude], \n" +
" CASE WHEN [GridLng] = 0 THEN [Longitude] ELSE [GridLng] END as [Longitude],\n" +
" [RowNumber] as [Row], \n" +
" [ColumnNumber] as [Col],\n" +
" Count(*) Over() as _TotalRecords,\n" +
" Concat([RFID],',',FlightUniqueID) as _PKey\n" +
"FROM \n" +
" [PayLoadMapData] \n" +
"WHERE\n" +
" FlightUniqueID='" + FlightUniqueID + "'";
qView nView = new qView(SQL);
nView.addMenu("Detail", Url.Action("Detail", "Payload", new { ID = "_Pkey" }));
ViewBag.FlightUniqueID = FlightUniqueID;
if (Request.IsAjaxRequest())
{
Response.ContentType = "text/javascript";
return(PartialView("qViewData", nView));
}
else
{
//get yard information for FlightUniqueID
GeoGrid theYard = new GeoGrid(FlightUniqueID);
ViewBag.Yard = theYard.getYard();
return(View(nView));
}//if(IsAjaxRequest)
}
// Gets Called after the creation of the current instance
void Start()
{
geoGridParent = this.GetComponentInParent <GeoGrid> ();
SpawnAssets(maxSeed);
}
public JsonResult getYard([Bind(Prefix = "ID")] int YardID = 0)
{
GeoGrid theYard = new GeoGrid(0);
return(Json(theYard.getYard(YardID), JsonRequestBehavior.AllowGet));
}
public ActionResult Table(String FlightUniqueID) {
GeoGrid myGrid = new GeoGrid(FlightUniqueID);
ViewBag.JSon = myGrid.getTable(FlightUniqueID);
return View();
}