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";
 }
Exemple #2
0
        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());
        }
Exemple #3
0
        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)
        }
Exemple #4
0
 // Gets Called after the creation of the current instance
 void Start()
 {
     geoGridParent = this.GetComponentInParent <GeoGrid> ();
     SpawnAssets(maxSeed);
 }
Exemple #5
0
        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();
 }