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()
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 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 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)
}
// 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)
}
// 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());
}
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 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)
}
// 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 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
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 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: 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()
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 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()
// GET: DroneFlight
public ActionResult Index([Bind(Prefix = "ID")] int DroneID = 0, string FlightType = "") {
if (!exLogic.User.hasAccess("FLIGHT"))
return RedirectToAction("NoAccess", "Home");
ViewBag.Title = "RPAS Flights";
ViewBag.DroneID = DroneID;
String SQLVideo = @"CASE
WHEN
[MSTR_Drone].LastFlightID = DroneFlight.ID and
[MSTR_Drone].FlightTime > DATEADD(MINUTE, -1, GETDATE())
THEN '<span class=green_icon></span>'
WHEN (
SELECT Count(*)
FROM DroneFlightVideo
WHERE DroneFlightVideo.FlightID = DroneFlight.ID
) = 0
THEN ''
ELSE '<span class=icon></span>'
END AS Video,";
//tblPilot.FirstName AS CreatedBy,
String SQLFilter = "";
String SQL = @"SELECT
DroneFlight.ID,
MSTR_Drone.DroneName AS RPAS,
tblPilot.FirstName AS PilotName,
tblGSC.FirstName AS GCSName,
FlightDate AS 'FlightDate',
ISNULL(g.ApprovalName,'NO NOC') as ApprovalName,
" + (exLogic.User.hasAccess("FLIGHT.VIDEOS") ? SQLVideo : "") + @"
Count(*) OVER () AS _TotalRecords,
DroneFlight.ID AS _PKey
FROM
DroneFlight
LEFT JOIN GCA_Approval as g
ON g.ApprovalID = DroneFlight.ApprovalID
LEFT JOIN MSTR_Drone
ON MSTR_Drone.DroneId = DroneFlight.DroneID
LEFT JOIN MSTR_User AS tblPilot
ON tblPilot.UserID = DroneFlight.PilotID
LEFT JOIN MSTR_User AS tblGSC
ON tblGSC.UserID = DroneFlight.GSCID
LEFT JOIN MSTR_User AS tblCreated
ON tblCreated.UserID = DroneFlight.CreatedBy
";
if (DroneID > 0) {
if (SQLFilter != "")
SQLFilter += " AND";
SQLFilter += "\n" +
" DroneFlight.DroneID=" + DroneID;
ViewBag.Title += " [" + Util.getDroneName(DroneID) + "]";
}
if (exLogic.User.hasAccess("DRONE.VIEWALL") || exLogic.User.hasAccess("DRONE.MANAGE")) {
} else {
if (SQLFilter != "")
SQLFilter += " AND";
SQLFilter += " \n" +
" MSTR_Drone.AccountID=" + Util.getAccountID();
}
//this is using when click link on the dashboard
if (FlightType == "LastFlight") {
if (SQLFilter != "")
SQLFilter += " AND";
SQLFilter += " \n" +
" DroneFlight.ID=" + Util.GetLastFlightFromDrone(DroneID);
} else if (FlightType == "CurrentMonthFlight") {
if (SQLFilter != "")
SQLFilter += " AND";
SQLFilter += " \n" +
" DroneFlight.FlightDate >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)";
}
if( Util.getLoginUserID()==202 )
{
if (SQLFilter != "")
SQLFilter += " AND";
SQLFilter += " \n" +
" (DroneFlight.FlightDate BETWEEN '2016-06-26' AND '2016-08-01') or (DroneFlight.FlightDate between '2016-11-27' and '2016-12-02') ";
}
//this is using when click link on the dashboard
if (SQLFilter != "") {
SQL += "\n WHERE\n" + SQLFilter;
}
qView nView = new qView(SQL);
// if (!exLogic.User.hasAccess("FLIGHT.MAP")) return RedirectToAction("NoAccess", "Home");
if (exLogic.User.hasAccess("FLIGHT.EDIT"))
nView.addMenu("Edit", Url.Action("Edit", new { ID = "_PKey" }));
//if (exLogic.User.hasAccess("FLIGHT.VIEW"))
// nView.addMenu("Flight Detail", Url.Action("Detail", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("FLIGHT.MAP")) {
nView.addMenu("Flight Map", Url.Action("View", "FlightMap", new { ID = "_PKey" }));
nView.addMenu("Flight Data", Url.Action("FlightDataView", "Map", new { ID = "_PKey" }));
}
if (exLogic.User.hasAccess("FLIGHT.VIDEOS"))
nView.addMenu("Flight Videos", Url.Action("ListVdeos", "DroneFlight", new { ID = "_PKey" }));
//nView.addMenu("Flight Videos", Url.Action("List", "DroneFlight", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("FLIGHT.REPORT"))
nView.addMenu("Post Flight Report", Url.Action("PostFlightReport", "Report", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("FLIGHT.GEOTAG"))
nView.addMenu("Geo-Tagging", Url.Action("GeoTag", "DroneFlight", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("FLIGHT.EXPORTCSV"))
nView.addMenu("Export-CSV", Url.Action("ExportExcel", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("FLIGHT.DELETE"))
nView.addMenu("Delete", Url.Action("Delete", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("TRAFFIC.LIVE"))
nView.addMenu("RTA Live", Url.Action("Live","Traffic", new { ID = "_PKey" }));
if (Request.IsAjaxRequest()) {
Response.ContentType = "text/javascript";
return PartialView("qViewData", nView);
} else {
return View(nView);
}//if(IsAjaxRequest)
}//Index()
// GET: Approval
public ActionResult Index(int ID = 0)
{
if (!exLogic.User.hasAccess("DRONE.VIEW"))
{
return(RedirectToAction("NoAccess", "Home"));
}
ViewBag.Title = "View";
string SQL = @"SELECT ";
if (ID == 0)
{
SQL += " d.[DroneName],\n";
}
SQL += @"g.[ApprovalName]
,g.[StartDate]
,g.[EndDate]
,g.[MinAltitude]
,g.[MaxAltitude]
,g.[BoundaryInMeters] as Boundary
,Count(*) Over() as _TotalRecords
,g.[ApprovalID] as _PKey
from GCA_Approval g join mstr_drone d
on g.droneID = d.droneID";
String SQLWhere = "";
if (ID > 0)
{
SQLWhere += "g.DroneID =" + ID;
}
if (!exLogic.User.hasAccess("DRONE.VIEWALL"))
{
if (SQLWhere != "")
{
SQLWhere += " AND";
}
SQLWhere += " g.AccountID=" + Util.getAccountID();
}
if (SQLWhere != "")
{
SQL += " WHERE " + SQLWhere;
}
qView nView = new qView(SQL);
ViewBag.Title = "Regulatory Approval";
ViewBag.DroneID = ID;
ViewBag.Title += " [" + Util.getDroneName(ID) + "]";
//if (exLogic.User.hasAccess("USER.VIEW")) nView.addMenu("Detail", Url.Action("UserDetail", new { ID = "_PKey" }));
if (exLogic.User.hasAccess("DRONE.EDIT"))
{
nView.addMenu("Edit", Url.Action("GCAApproval", "S3Upload", new { ID = "_PKey" }));
}
if (exLogic.User.hasAccess("DRONE.DELETE"))
{
nView.addMenu("Delete", Url.Action("DeleteGCAApproval", "S3Upload", new { ID = "_PKey" }));
}
if (Request.IsAjaxRequest())
{
Response.ContentType = "text/javascript";
return(PartialView("qViewData", nView));
}
else
{
return(View(nView));
}//if(IsAjaxRequest)
}