public ActionResult Account() { if (!exLogic.User.hasAccess("ACCOUNT.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "Accounts"; String SQL = "SELECT \n" + " [AccountId],\n" + " [Name],\n" + " [Code],\n" + " [EmailId],\n" + " [MobileNo],\n" + " Count(*) Over() as _TotalRecords,\n" + " [AccountId] as _PKey\n" + "FROM\n" + " [MSTR_Account]"; qView nView = new qView(SQL); if (exLogic.User.hasAccess("ACCOUNT.VIEW")) nView.addMenu("Detail", Url.Action("AccountDetail", new { ID = "_PKey" })); if (exLogic.User.hasAccess("ACCOUNT.EDIT")) nView.addMenu("Edit", Url.Action("AccountEdit", new { ID = "_PKey" })); if (exLogic.User.hasAccess("ACCOUNT.DELETE")) nView.addMenu("Delete", Url.Action("AccountDelete", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//Account()
// GET: RpasUser public ActionResult Index() { string SQL = "SELECT MSTR_User.UserName,\n" + "MSTR_User.FirstName + ' ' + MSTR_User.LastName as Name,\n" + "MSTR_Profile.ProfileName as Profile,\n" + "MSTR_Account.Name as Account,\n" + "MSTR_User.MobileNo as Mobile,\n" + "MSTR_User.EmailId,\n" + "Count(*) Over() as _TotalRecords,\n" + "UserId as _PKey\n" + "FROM \n" + "MSTR_User INNER JOIN MSTR_Account \n" + "ON MSTR_User.AccountId = MSTR_Account.AccountId INNER JOIN MSTR_Profile \n" + "ON MSTR_User.UserProfileId = MSTR_Profile.ProfileId \n" + "where MSTR_User.AccountId = " + 23; qView nView = new qView(SQL); nView.addMenu("Edit", Url.Action("Edit", "RpasUser", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) //return View(db.MSTR_User.ToList()); }
// GET: Product public ActionResult Index() { ViewBag.Title = "Product Listing"; String SQL = "SELECT \n" + " ProductId, \n" + " LEFT(RFID,5) as RFID,\n" + " DecimalCode,\n" + " BinaryCode,\n" + " IsAssigned,\n" + " IsActive,\n" + " RecordType,\n" + " Product_Name,\n" + " SerialNo,\n" + " AccountId,\n" + " Count(*) Over() as _TotalRecords\n" + "FROM\n" + " MSTR_Product"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//ActionResult Index()
public ActionResult RawData(String ID = "") { if (!exLogic.User.hasAccess("PAYLOAD.RAW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "Payload RAW Data"; String SQL = @"SELECT PayLoadDataID as ID, FlightUniqueID as UID, RFID, RSSI, ReadTime, ReadCount, ProcessingModel as PModel, CreatedTime, Count(*) Over() as _TotalRecords, PayLoadDataID as _PKey FROM [PayLoadData]"; if (!String.IsNullOrEmpty(ID)) SQL = SQL + "\n" + " WHERE FlightUniqueID='" + ID + "'"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
public ActionResult OutDoor() { if (!exLogic.User.hasAccess("OUTDOOR.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "Out Door Flights"; String SQL = @"SELECT PayLoadFlightID, FlightUniqueID, PayLoadYard.YardName, [RFIDCount], [CreatedTime], Count(*) Over() as _TotalRecords, FlightUniqueID as _PKey FROM PayLoadFlight LEFT JOIN PayLoadYard ON PayLoadYard.YardID = PayLoadFlight.YardID WHERE PayLoadFlight.Processingmodel=0"; qView nView = new qView(SQL); nView.addMenu("PayLoad Data", Url.Action("PayLoad", "Map", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
public ActionResult ChartDetails() { String SQL = @"select t.DroneId, v.DroneName, max(T.TotalFlightTime) as TotalFlightTime, CASE WHEN max(T.TotalFlightTime) - min(k.FlightTime)IS NULL or max(T.TotalFlightTime) - min(k.FlightTime) = 0 THEN max(T.TotalFlightTime) ELSE max(T.TotalFlightTime) - min(k.FlightTime) END as CurrentFlightTime, Count(*) Over() as _TotalRecords, t.DroneId as _PKey from MSTR_Drone v join FlightMapData t on v.DroneId = t.DroneId left join(select u.DroneId, min(u.ReadTime) as ReadTime, max(u.TotalFlightTime) as FlightTime from FlightMapData u Select * from convert(nvarchar(30), u.ReadTime, 120) BETWEEN DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AND GETDATE() group by u.DroneId )k on t.DroneId = k.DroneId group by t.DroneId,v.DroneName"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text /javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); } }
public ActionResult InDoorFlightDetails([Bind(Prefix = "ID")] String FlightUniqueID) { if (!exLogic.User.hasAccess("INDOOR.VIEW")) return RedirectToAction("NoAccess", "Home"); // if (!exLogic.User.hasAccess("PAYLOAD.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "In Door Flight Details"; String SQL = @"SELECT PayLoadFlight.FlightUniqueID, PayLoadMapData.RFID , [RFIDCount], PayLoadFlight.CreatedTime, PayLoadFlight.ShelfID, Count(*) Over() as _TotalRecords, PayLoadFlight.FlightUniqueID as _PKey FROM PayLoadFlight LEFT JOIN PayLoadMapData ON PayLoadMapData.FlightUniqueID=payloadflight.FlightUniqueID WHERE PayLoadFlight.Processingmodel= 1 AND PayLoadFlight.FlightUniqueID= " + FlightUniqueID + " AND PayLoadMapData.IsValid= 0"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
public ActionResult Detail([Bind(Prefix = "ID")] String FlightUniqueID) { var Parts = FlightUniqueID.Split(','); ViewBag.Title = "UAS Listing"; String SQL = @"SELECT [RSSI], [ReadTime], [ReadCount], [Latitude], [Longitude], [RowNumber], [ColumnNumber], [CellID], [IsProcessed], Count(*) Over() as _TotalRecords FROM [PayLoadData] WHERE [RFID] ='" + Parts[0] + @"' AND [FlightUniqueID] ='" + Parts[1] + @"'"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
public ActionResult BlackBoxList() { // if (!exLogic.User.hasAccess("BLACKBOX.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "Blackbox"; string SQL = @"SELECT m.[BlackBoxID] as _PKey ,m.[LastRentalId] ,m.[BlackBoxSerial] ,m.[BlackBoxName] ,m.[CurrentStatus] ,isnull(u.Firstname,'') +' '+ isnull(u.lastname,'') as Pilot, MSTR_Account.name as Organization ,d.DroneName,m.currentDroneID as [Stream Key] , Count(*) Over() as _TotalRecords FROM MSTR_BlackBox m left join mstr_user u on m.currentUserID = u.userid left join mstr_drone d on d.droneid = m.currentDroneID left join MSTR_Account on u.Accountid=MSTR_Account.AccountID where m.[IsActive] = 1 "; qView nView = new qView(SQL); nView.addMenu("Detail", Url.Action("BlackBoxDetails", new { ID = "_PKey" })); nView.addMenu("Edit", Url.Action("Edit", new { ID = "_PKey" })); nView.addMenu("Receive", Url.Action("ReceiveBlackBox", new { ID = "LastRentalId" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//PartsBlackBoxlist
public String ByDrone([Bind(Prefix = "ID")] int DroneID = 0) { if (!exLogic.User.hasAccess("FLIGHT")) return "Access Denied"; String SQL = "SELECT TOP 5" + " MSTR_Drone.DroneName as RPAS,\n" + " tblPilot.FirstName as PilotName,\n" + " tblGSC.FirstName as GSCName,\n" + //" tblCreated.FirstName as CreatedBy,\n" + " FlightDate as 'FlightDate(UTC)'\n" + "FROM\n" + " DroneFlight\n" + "LEFT JOIN MSTR_Drone ON\n" + " MSTR_Drone.DroneId = DroneFlight.DroneID\n" + "LEFT JOIN MSTR_User as tblPilot ON\n" + " tblPilot.UserID = DroneFlight.PilotID\n" + "LEFT JOIN MSTR_User as tblGSC ON\n" + " tblGSC.UserID = DroneFlight.GSCID\n" + "LEFT JOIN MSTR_User as tblCreated ON\n" + " tblCreated.UserID = DroneFlight.CreatedBy\n" + "WHERE\n" + " DroneFlight.DroneID=" + DroneID + "\n" + "ORDER BY" + " DroneFlight.ID DESC"; qView nView = new qView(SQL, false); if (nView.HasRows) { return "<h2>Recent Flights</h2>\n" + nView.getDataTable(true, false); } return ""; }
public ActionResult CMS() { if(!exLogic.User.hasAccess("CMS.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "Content Management"; String SQL = @"SELECT [CmsID], [CmsRefName] as URL, (CASE WHEN [IsShowInMenu] = 1 THEN 'Yes' ELSE 'No' END) as InMenu , [PageTitle], [MenuTitle], [ContentManagement].[CreatedOn], [FirstName] + ' ' + [LastName] as CreatedBy, Count(*) Over() as _TotalRecords, [CmsID] as _PKey FROM [ContentManagement] LEFT JOIN MSTR_User ON MSTR_User.UserID = ContentManagement.CreatedBy "; qView nView = new qView(SQL); if(exLogic.User.hasAccess("CMS.VIEW")) nView.addMenu("View Result", Url.Action("demo", "home", new { id = "URL" })); if(exLogic.User.hasAccess("CMS.EDIT")) nView.addMenu("Edit", Url.Action("CmsEdit", new { ID = "_PKey" })); if(exLogic.User.hasAccess("CMS.DELETE")) nView.addMenu("Delete", Url.Action("CmsDelete", new { ID = "_PKey" })); if(Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//Account()
public ActionResult Index() { if (!exLogic.User.hasAccess("SERVICE.VIEW")) { return(RedirectToAction("NoAccess", "Home")); } ViewBag.Title = "Drone Service Listing"; String SQL = "select\n" + " a.ServiceId As ServiceId,\n" + " b.DroneName as RPAS,\n" + " c.Name as ServiceType,\n" + " a.DateOfService as DateOfService,\n" + " a.FlightHour,\n" + " a.Description,Count(*) Over() as _TotalRecords,\n" + " a.ServiceId as _PKey\n" + "from\n" + " MSTR_DroneService a\n" + "Inner join MSTR_Drone b on\n" + " a.DroneId = b.DroneId"; if (!exLogic.User.hasAccess("DRONE.VIEWALL")) { SQL += " AND\n" + " b.AccountID=" + Util.getAccountID(); } SQL += "\n" + "Inner join LUP_Drone c on\n" + " a.TypeOfServiceId = c.TypeId AND\n" + " c.Type = 'ServiceType'\n" + "WHERE\n" + " b.DroneId IS NOT NULL AND\n" + " c.TypeId IS NOT NULL"; qView nView = new qView(SQL); if (exLogic.User.hasAccess("SERVICE.VIEW")) { nView.addMenu("Detail", Url.Action("Details", new { ID = "_PKey" })); } if (exLogic.User.hasAccess("SERVICE.EDIT")) { nView.addMenu("Edit", Url.Action("Edit", new { ID = "_PKey" })); } if (exLogic.User.hasAccess("SERVICE.DELETE")) { nView.addMenu("Delete", Url.Action("Delete", new { ID = "_PKey" })); } if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
public ActionResult PortalAlert() { String SQL = "SELECT [AlertID] ,[FlightID] ,[FlightReadTime],[Latitude],[Longitude],[Altitude],[FlightDataID],[AlertMessage],[CreatedOn],Count(*) Over() as _TotalRecords,FlightID as _PKey FROM[ExponentPortal].[dbo].[PortalAlert]"; qView nView = new qView(SQL); nView.addMenu("Report", Url.Action("Index", "Drone", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
public string PilotLogDetails([Bind(Prefix = "ID")] int PilotID) { if (!exLogic.User.hasAccess("PILOTLOG.VIEWDETAIL")) { return("Access Denied"); } string SQL = @"SELECT REPLACE(CONVERT(NVARCHAR, a.DATE, 106), ' ', '-') AS DATE, b.DroneName AS RPAS, a.FlightID, a.FixedWing, a.MultiDashRotor, a.SimulatedInstrument AS Simulator, a.AsflightInstructor, a.DualRecieved as DualReceived, a.FloatingCommand AS PilotInCommand, a.Id AS _PKey FROM MSTR_Pilot_Log a LEFT JOIN mstr_drone b ON a.DroneId = b.DroneId WHERE a.PilotId = " + +PilotID; string TotalSQL = @"SELECT 'Total' AS DATE, '' AS UASName, '' AS FlightID, sum(FixedWing) AS FixedWing, sum(MultiDashRotor) AS MultiDashRotor, sum(SimulatedInstrument) AS Simulator, sum(AsflightInstructor) AS AsflightInstructor, sum(DualRecieved) AS DualRecieved, sum(FloatingCommand) AS PilotInCommandm FROM [MSTR_Pilot_Log] WHERE PilotId = " + PilotID; qView nView = new qView(SQL); nView.TotalSQL = TotalSQL; nView.ClassName += " dataTable"; if (nView.HasRows) { nView.isFilterByTop = false; return ("<h2>Pilot Log Details</h2>\n" + nView.getDataTable( isIncludeData: true, isIncludeFooter: false, qDataTableID: "PilotLogDetails" )); } return(""); }
public ActionResult Alert(FlightReportFilter ReportFilter) { //if(!exLogic.User.hasAccess("REPORT.ALERT")) // return RedirectToAction("NoAccess", "Home"); var theReport = new exLogic.Report(); qView nView = new qView(theReport.getAlertSQL(ReportFilter)); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { ViewBag.ReportFilter = ReportFilter; return View(nView); }//if(IsAjaxRequest) }
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) }
public ActionResult FlightDataView([Bind(Prefix = "ID")] String FlightID = "") { if (!exLogic.User.hasAccess("FLIGHT.MAP")) { return(RedirectToAction("NoAccess", "Home")); } ViewBag.FlightID = FlightID; int FID = Util.toInt(FlightID); if (FID < 1) { return(RedirectToAction("Error")); } ViewBag.Title = "Flight Data"; // ViewBag.DroneID = DroneID; String SQL = "SELECT \n" + " FlightMapDataID,\n" + " ReadTime,\n" + " Latitude,\n" + " Longitude,\n" + " Altitude,\n" + " Speed,\n" + " FixQuality,\n" + " Satellites,\n" + " Pitch,\n" + " Roll,\n" + " Heading,\n" + " TotalFlightTime,\n" + " Count(*) OVER() as _TotalRecords\n" + "FROM\n" + " FlightMapData\n" + "WHERE\n" + " FlightID=" + FID; qView nView = new qView(SQL); nView.IsFormatDate = false; if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
// GET: List/Details/5 public ActionResult Details(string TypeName) { String SQL = "select name, Count(*) Over() as _TotalRecords,TypeId as _PKey from LUP_Drone where type='" + TypeName + "'"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
// GET: Pilot public ActionResult Index() { if (!exLogic.User.hasAccess("PILOTS.VIEW")) { return(RedirectToAction("NoAccess", "Home")); } ViewBag.Title = "All Pilot"; string SQL = @"select MSTR_User.FirstName + ' ' + MSTR_User.LastName as FullName, MSTR_User.MobileNo, MSTR_User.EmailId, MSTR_User.RPASPermitNo as PermitNumber, MSTR_User.DOI_RPASPermit as IssueDate, MSTR_User.DOE_RPASPermit as ExpiryDate, Count(*) Over() as _TotalRecords, MSTR_User.UserID as _PKey FROM MSTR_User Where IsPilot=1"; if (!exLogic.User.hasAccess("DRONE.VIEWALL")) { SQL += "\n and MSTR_User.AccountID=" + Util.getAccountID(); } qView nView = new qView(SQL); if (exLogic.User.hasAccess("PILOTS.VIEW")) { nView.addMenu("Detail", Url.Action("PilotDetail", new { ID = "_PKey" })); } if (exLogic.User.hasAccess("PILOTS.EDIT")) { nView.addMenu("Edit", Url.Action("Edit", new { ID = "_PKey" })); } // if (exLogic.User.hasAccess("PILOTS.DELETE")) nView.addMenu("Delete", Url.Action("Delete", new { ID = "_PKey" })); //if (exLogic.User.hasAccess("PILOTLOG.VIEW")) nView.addMenu("Add Pilot Log", Url.Action("Create", "PilotLog", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
}//Index() public ActionResult Live() { if (!exLogic.User.hasAccess("BLACKBOX.LIVE")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "FDR Live Data"; string SQL = "SELECT \n" + " [DroneDataId] as UASDataId ," + " MSTR_Drone.DroneName as UAS,\n" + " [ReadTime] as [Date],\n" + " [DroneData].[Latitude] ,\n" + " [DroneData].[Longitude],\n" + " [Altitude] as [Altitude],\n" + " [Speed] as [Speed],\n" + " [FixQuality],\n" + " [Satellites],\n" + " [Pitch],[Roll],[Heading],[TotalFlightTime],\n" + " [BBFlightID],\n" + " Count(*) Over() as _TotalRecords,[DroneDataId] as _PKey\n" + "FROM\n" + " [DroneData]\n" + "LEFT JOIN MSTR_Drone ON\n" + " MSTR_Drone.DroneID = [DroneData].DroneID"; /* " CASE isnumeric(TotalFlightTime)\n" + " WHEN 1 THEN cast(round(CONVERT(numeric(12, 3), TotalFlightTime) / 60.0, 2) as numeric(36, 2))\n" + " ELSE 0.00\n" + " END as TotalFlightTime, \n " + */ if (!exLogic.User.hasAccess("DRONE.VIEWALL")) { SQL += " AND\n" + " MSTR_Drone.AccountID=" + Util.getAccountID() + "\n" + "WHERE\n" + " MSTR_Drone.AccountID=" + Util.getAccountID(); } // SQL+= " Order By UasDataid"; qView nView = new qView(SQL); //if (!exLogic.User.hasAccess("BLACKBOX.LIVE")) nView.addMenu("Detail", Url.Action("Detail", new { ID = "_Pkey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//Index()
public ActionResult WaterSampling() { String SQL = "SELECT DroneDocuments.[DroneID] as UASID,DroneDocuments.[DocumentType] as Type,DroneDocuments.[UploadedDate], MSTR_Drone.DRONENAME as UAS,DroneDocuments.[DocumentTitle]as Title , Count(*) Over() as _TotalRecords,DroneDocuments.[DroneID] as _PKey FROM[DroneDocuments] Left join MSTR_Drone on DroneDocuments.DroneID = MSTR_Drone.DroneID where DocumentType='Water Sampling' "; qView nView = new qView(SQL); nView.addMenu("Report", Url.Action("Index", "Drone", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
// GET: Gps public ActionResult Index() { ViewBag.Title = "Drone Service Listing"; String SQL = @"SELECT [DroneId] ,[DroneRFID] ,[Latitude] ,[Longitude] ,[ProductRFID] ,[ProductQrCode] ,[ProductRSSI] ,[ReadTime] ,[CreatedTime] ,[RecordType] ,[IsActive] ,[ProductId] ,[Altitude] ,[Speed] ,[FixQuality] ,[Satellites] ,[Pitch] ,[Roll] ,[Heading] ,[TotalFlightTime] ,[BBFlightID] ,[IsProcessed] ,[CreatedDate] ,[Voltage], Count(*) Over() as _TotalRecords, [DroneGPSLogId] as _PKey FROM[DroneGPSLog]"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
//by BT public ActionResult TransactionDet([Bind(Prefix = "ID")] int BlackBoxID) { //string SQL = @"SELECT MSTR_BlackBox.BlackBoxName, // BlackBoxTransaction.BBStatus as Status, // BlackBoxTransaction.CollectionMode as 'TransactionMode', // BlackBoxTransaction.BankName as 'BankName', // BlackBoxTransaction.Amount, // BlackBoxTransaction.ChequeNumber as 'ChequeNumber', // BlackBoxTransaction.DateOfCheque as 'ChequeDate', // BlackBoxTransaction.NameOnCard as 'NameOnCard', // BlackBoxTransaction.CreatedDate as 'CreatedDate', // MSTR_Drone.DroneName as 'DroneName', // BlackBoxTransaction.Note, // Count(*) Over() as _TotalRecords, // BlackBoxTransaction.ID as _PKey // FROM // BlackBoxTransaction LEFT OUTER JOIN // MSTR_BlackBox ON BlackBoxTransaction.BlackBoxID = MSTR_BlackBox.BlackBoxID LEFT OUTER JOIN // MSTR_Drone ON BlackBoxTransaction.DroneID = MSTR_Drone.DroneId // WHERE(BlackBoxTransaction.BlackBoxID = " + BlackBoxID + ")"; string SQL = @"SELECT BlackBoxTransaction.ID as TransID,MSTR_BlackBox.BlackBoxName, BlackBoxTransaction.BBStatus as Status, BlackBoxTransaction.Amount, MSTR_Drone.DroneName as 'DroneName', BlackBoxTransaction.Note, RentStartDate, Count(*) Over() as _TotalRecords, BlackBoxTransaction.ID as _PKey FROM BlackBoxTransaction LEFT OUTER JOIN MSTR_BlackBox ON BlackBoxTransaction.BlackBoxID = MSTR_BlackBox.BlackBoxID LEFT OUTER JOIN MSTR_Drone ON BlackBoxTransaction.DroneID = MSTR_Drone.DroneId WHERE(BlackBoxTransaction.BlackBoxID = " + BlackBoxID + ")"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text /javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
// GET: BlackBox public ActionResult Index() { if (!exLogic.User.hasAccess("BLACKBOX.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "FDR Data"; String SQL = "SELECT \n" + " MSTR_Drone.DroneName as UAS,\n" + " BBFlightID as FdrFlightId,\n" + " Min([BlackBoxData].ReadTime) as StartTime,\n" + " Max([BlackBoxData].ReadTime) as EndTime,\n" + " Max(Speed) as MaxSpeed,\n" + " CASE isnumeric(Max(TotalFlightTime))\n" + " WHEN 1 THEN cast(round(CONVERT(numeric(12, 3), Max(TotalFlightTime)) / 60.0, 2) as numeric(36, 2))\n" + " ELSE 0.00\n" + " END as TotalFlightTime, \n " + " Max(Altitude) as MaxAltitude,\n" + " Count(*) Over() as _TotalRecords,\n" + " Cast([BlackBoxData].DroneId as varchar) + ',' + Cast(BBFlightID as varchar) as _Pkey\n" + "FROM\n" + " [BlackBoxData]\n" + "LEFT JOIN MSTR_Drone ON\n" + " MSTR_Drone.DroneId = [BlackBoxData].DroneId\n" + "WHERE\n" + " Speed > 0.00"; if (!exLogic.User.hasAccess("DRONE.VIEWALL")) { SQL += " AND\n" + " MSTR_Drone.AccountID=" + Util.getAccountID(); } SQL = SQL + "\n" + "GROUP BY\n" + " [BlackBoxData].DroneId,\n" + " MSTR_Drone.DroneName,\n" + " BBFlightID\n"; qView nView = new qView(SQL); nView.addMenu("Detail", Url.Action("Detail", new { ID = "_Pkey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//Index()
}//Index() public ActionResult Detail([Bind(Prefix = "ID")] String DroneID_BBFlightID = "") { if (!exLogic.User.hasAccess("BLACKBOX.VIEW")) return RedirectToAction("NoAccess", "Home"); String[] SplitData = DroneID_BBFlightID.Split(','); if (SplitData.Length != 2) return RedirectToAction("Error"); int DroneID = Util.toInt(SplitData[0]); int BBFlightID = Util.toInt(SplitData[1]); if (DroneID < 1 || BBFlightID < 1) return RedirectToAction("Error"); ViewBag.Title = "FDR Data"; ViewBag.DroneID = DroneID; String SQL = "SELECT \n" + " RecordNumber,\n" + " ReadTime,\n" + " Latitude,\n" + " Longitude,\n" + " Altitude,\n" + " Speed,\n" + " FixQuality,\n" + " Satellites,\n" + " Pitch,\n" + " Roll,\n" + " Heading,\n" + " TotalFlightTime,\n" + " Count(*) OVER() as _TotalRecords\n" + "FROM\n" + " BlackBoxData\n" + "WHERE\n" + " DroneID=" + DroneID + " AND\n" + " BBFlightID=" + BBFlightID; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }
// GET: PayLoad public ActionResult Index() { if (!exLogic.User.hasAccess("PAYLOAD.VIEW")) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "PayLoad Flights"; String SQL = @"SELECT PayLoadFlightID as ID, FlightID, PayLoadYard.YardName, (CASE Processingmodel WHEN 1 Then 'Indoor' ELSE 'Outdoor' END) as Processingmodel, [RFIDCount], [CreatedTime], Count(*) Over() as _TotalRecords, FlightUniqueID as _PKey FROM PayLoadFlight LEFT JOIN PayLoadYard ON PayLoadYard.YardID = PayLoadFlight.YardID LEFT JOIN [MSTR_Drone] ON [MSTR_Drone].DroneId = PayLoadFlight.PayLoadDroneID "; if (!exLogic.User.hasAccess("DRONE.VIEWALL")) { SQL += "WHERE\n" + " [MSTR_Drone].AccountID=" + Util.getAccountID(); } qView nView = new qView(SQL); nView.addMenu("PayLoad Data", Url.Action("PayLoad", "Map", new { ID = "_PKey" })); if (exLogic.User.hasAccess("PAYLOAD.RAW")) nView.addMenu("Raw Data", Url.Action("RawData", "Payload", new { ID = "_Pkey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//ActionResult Index()
public ActionResult TrafficMonitoring() { ViewBag.Title = "Trafic Monitoring"; // if (!exLogic.User.hasAccess("TRAFFIC.LIVE")) return RedirectToAction("NoAccess", "Home"); string SQL = $@"Select [MonitorID] [Monitor_ID] ,[CreatedDate], [DD] ,[DR] ,[DU] ,[DL] ,[RD] ,[RR] ,[RU] ,[RL] ,[UD] ,[UR] ,[UU] ,[UL] ,[LD] ,[LR] ,[LU] ,[LL],FlightID, Count(*) Over() as _TotalRecords, [MonitorID] as _PKey FROM [MSTR_TrafficMonitor]"; qView nView = new qView(SQL); nView.addMenu("View", Url.Action("dmat", new { FlightID = "FlightID" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
public ActionResult PartsList() { if (!exLogic.User.hasAccess("PARTS.VIEW")) { return(RedirectToAction("NoAccess", "Home")); } ViewBag.Title = "UAS Parts"; string SQL = " select a.PartsName,\n " + " a.Model, \n " + " b.name \n " + " as ComapnyName , \n " + " Count(*) Over() as _TotalRecords,\n" + " [PartsId] as _PKey\n" + " from mstr_parts a \n " + " left \n " + " join \n " + " MSTR_Account b \n " + " on a.SupplierId = b.AccountId \n "; qView nView = new qView(SQL); nView.addMenu("Detail", Url.Action("Detail", new { ID = "_PKey" })); nView.addMenu("Edit", Url.Action("Edit", new { ID = "_PKey" })); nView.addMenu("Delete", Url.Action("Delete", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); } //if(IsAjaxRequest) } //Partslist
// GET: DroneService/Details/5 public ActionResult Details(int id) { int DroneId = Util.GetDroneIdFromService(id); if (!exLogic.User.hasAccess("SERVICE.VIEW")) { return(RedirectToAction("NoAccess", "Home")); } if (!exLogic.User.hasDrone(DroneId)) { return(RedirectToAction("NoAccess", "Home")); } ViewBag.FlightID = DroneId; // customer has the access only access there on drones service ViewBag.ServiceId = id; ViewBag.Title = "View Checklist"; ViewBag.Title = "UAS Service Details"; string SQL = "select b.PartsName,a.ServicePartsType as Info,b.Model as ModelType,a.QtyCount as Qty, Count(*) Over() as _TotalRecords from M2M_DroneServiceParts" + " a left join MSTR_Parts b on a.PartsId=b.PartsId where a.ServiceId=" + id + " group by a.ServicePartsType,b.PartsName,b.Model,a.QtyCount"; qView nView = new qView(SQL); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return(PartialView("qViewData", nView)); } else { return(View(nView)); }//if(IsAjaxRequest) }
public ActionResult Detail(int ID = 0) { if (!exLogic.User.hasAccess("FLIGHT.VIEW")) return RedirectToAction("NoAccess", "Home"); if (!exLogic.User.hasDrone(Util.GetDroneIdFromFlight(ID))) return RedirectToAction("NoAccess", "Home"); ViewBag.Title = "RPAS Flight Details"; ViewBag.FlightID = ID; String SQL = "SELECT \n" + " [DroneCheckList].[ID],\n" + " MSTR_DroneCheckList.CheckListTitle,\n" + " MSTR_DroneCheckList.CheckListSubTitle,\n" + " MSTR_User.FirstName as CreatedBy,\n" + " [DroneCheckList].[CreatedOn],\n" + " Count(*) Over() as _TotalRecords, \n" + " [DroneCheckList].[ID] as _PKey\n" + "FROM\n" + "[DroneCheckList]\n" + "LEFT JOIN MSTR_DroneCheckList ON\n" + "MSTR_DroneCheckList.ID = [DroneCheckList].DroneCheckListID\n" + "LEFT JOIN MSTR_User ON\n" + " MSTR_User.UserID = [DroneCheckList].CreatedBy\n" + "WHERE\n" + " [DroneCheckList].[FlightID] = " + ID.ToString(); qView nView = new qView(SQL); nView.addMenu("View", Url.Action("View", "DroneCheckList", new { ID = "_PKey" })); if (Request.IsAjaxRequest()) { Response.ContentType = "text/javascript"; return PartialView("qViewData", nView); } else { return View(nView); }//if(IsAjaxRequest) }//Detail()