}//
public String DroneServiceDetail(int ID = 0)
{
string UASFormat;
int DroneId;
if (!exLogic.User.hasAccess("SERVICE.VIEW"))
{
return("Access Denied");
}
string SQL = "select a.ServiceId as ServiceId ,a.DateOfService as " +
"ServiceDate,b.DroneId as UASId,b.DroneName as RPAS,c.UserName as " +
" ServicedBy, Count(*) Over() as _TotalRecords from MSTR_DroneService" +
" a left join MSTR_Drone b on a.DroneId=b.DroneId " +
" left join MSTR_User c on a.CreatedBy=c.UserId where a.ServiceId=" + ID;
qDetailView theView = new qDetailView(SQL);
theView.Columns = 3;
//this part for adding link to requred fields in the details
string sqldroneid = "select b.DroneId as UASId,a.ServiceId as ServiceId from MSTR_DroneService a left join MSTR_Drone b on a.DroneId = b.DroneId where a.ServiceId =" + ID;
DroneId = Convert.ToInt32(Util.getDBInt(sqldroneid));
string sqldronename = "select DroneName from MSTR_Drone where droneid=" + DroneId;
string rpasname = Util.getDBVal(sqldronename);
UASFormat = "<a href='/Drone/Detail/" + DroneId + "'>" + rpasname + "</a>"; //url
theView.FormatCols.Add("RPAS", UASFormat); //Adding the Column required for formatting
return(theView.getTable());
}
}//AccountDe
// GET: Parts/Details/5
public String PartsDetails(int id)
{
if (!exLogic.User.hasAccess("PARTS.VIEW"))
{
return(Util.jsonStat("ERROR", "Access Denied"));
}
string SQL = " select a.PartsName,\n " +
" a.Model, \n " +
" a.description, \n " +
" b.name \n " +
" as ComapnyName \n " +
" from mstr_parts a \n " +
" left \n " +
" join \n " +
" MSTR_Account b \n " +
" on a.SupplierId = b.AccountId \n " +
" where a.PartsId=" + id;
qDetailView nView = new qDetailView(SQL);
ViewBag.Message = nView.getTable();
return(nView.getTable());
}
public String AccountDetailView([Bind(Prefix = "ID")] int AccountID = 0) {
if (!exLogic.User.hasAccess("ACCOUNT.VIEW")) return "Access Denied";
String SQL = @"SELECT
[Name]
,[EmailId] AS [Email ID]
,[MobileNo] as [Mobile No.]
,[OfficeNo] as [Office No.]
,[ContactName] as [Contact Person]
FROM [MSTR_Account] WHERE AccountID=" + AccountID; ;
qDetailView nView = new qDetailView(SQL);
return nView.getTable();
}
public ActionResult PilotDetailView([Bind(Prefix = "ID")] int UserID = 0)
{
string SQL = "SELECT a.[UserName]\n" +
" ,a.[FirstName] \n " +
",a.[MiddleName]\n " +
",a.[LastName]\n " +
//",a.[Remarks]\n " +
",a.[MobileNo]\n " +
",a.[OfficeNo]\n " +
",a.[HomeNo]\n" +
" ,a.[EmailId]\n as [Email ID] " +
",b.[PassportNo]" +
" ,CONVERT(NVARCHAR, b.[DateOfExpiry], 106) AS DateOfExpiry\n " +
",b.[Department]\n " +
" ,b.[EmiratesId] as [Emirates ID]\n " +
",b.[Title] as JobTitle\n " +
",a.[RPASPermitNo] as [RPAS Permit No.]\n " +
",a.[PermitCategory] as [Permit Category]\n " +
",c.[Name] as Organization\n " +
//",d.[ProfileName]\n " +
" FROM[MSTR_User] a\n " +
" left join mstr_user_pilot b\n " +
"on a.UserId=b.UserId\n " +
"left join MSTR_Account c\n " +
"on a.AccountId=c.AccountId\n " +
"left join MSTR_Profile d " +
"on a.UserProfileId=d.ProfileId" +
" where a.userid=" + UserID;
if (exLogic.User.hasAccess("PILOT"))
{
//nothing
}
else if (!exLogic.User.hasAccess("DRONE.VIEWALL"))
{
SQL +=
" AND\n" +
" a.AccountID=" + Util.getAccountID();
}
qDetailView nView = new qDetailView(SQL);
ViewBag.Message = nView.getTable();
ViewBag.ProfileImage = Util.getProfileImage(UserID);
return(View());
}
// GET: BlackBox/Details/5
public String BBDetails(int id) {
// if (!exLogic.User.hasAccess("BLACKBOX.VIEW")) return Util.jsonStat("ERROR", "Access Denied");
string SQL = @"SELECT [BlackBoxID] as _PKey
,[BlackBoxSerial]
,[BlackBoxName]
,[IsActive]
,[CreatedOn]
,[CreatedBy]
,[CurrentStatus]
,[CurrentUserID]
,[LastUpdateDate]
,[CurrentDroneID]
, Count(*) Over() as _TotalRecords ";
//if (exLogic.User.hasAccess("BLACKBOX.AES"))
// SQL = SQL + ",[EncryptionKey]";
SQL = SQL + @"
FROM MSTR_BlackBox
where BlackBoxID = " + id;
qDetailView nView = new qDetailView(SQL);
ViewBag.Message = nView.getTable();
ViewBag.Title = "Black Box Details";
return nView.getTable();
}
public String DroneDetail(int ID = 0)
{
if (!exLogic.User.hasAccess("SERVICE.VIEW"))
{
return("Access Denied");
}
String SQL =
"SELECT \n" +
" D.[DroneId] , \n" +
" D.[DroneName], \n" +
" D.[DroneIdHexa] as DroneHex, \n" +
" D.[CommissionDate] , \n" +
" D.[DroneSerialNo], \n" +
" O.Name as OwnerName, \n" +
" M.Name as ManufactureName, \n" +
" U.Name as UAVType, \n" +
" Count(*) Over() as _TotalRecords, \n" +
" D.[DroneId] as _PKey \n" +
"FROM \n" +
" [ExponentPortal].[dbo].[MSTR_Drone] D \n" +
"inner join[ExponentPortal].[dbo].LUP_Drone O on\n" +
" OwnerID = O.TypeID and O.Type = 'Owner' " +
"inner join[ExponentPortal].[dbo].LUP_Drone M on\n" +
" ManufactureID = M.TypeID and M.Type='Manufacturer' " +
"inner join [ExponentPortal].[dbo].LUP_Drone U on\n" +
" UAVTypeID = U.TypeID and U.Type= 'UAV Type' \n" +
"WHERE\n" +
" D.DroneId =" + ID.ToString();
qDetailView theView = new qDetailView(SQL);
theView.Columns = 3;
return(theView.getTable());
}//DroneFlightDeta
}//Detail()
public String DroneFlightDetail(int ID = 0) {
String CheckListMessage = "";
if (!exLogic.User.hasAccess("FLIGHT.VIEW"))
return "Access Denied";
int DroneId, UserId;
string UASFormat, PilotFormat;
String UploadedDocs = "";
String SQL =
"SELECT\n" +
" DroneFlight.ID RPASFlightId,\n" +
" MSTR_Drone.DroneName as RPAS,\n" +
" tblPilot.FirstName + ' ' + tblPilot.LastName as PilotName,\n" +
" tblGSC.FirstName + ' ' + tblGSC.LastName as [GroundStation],\n" +
" tblPilot.FirstName + ' ' + tblPilot.LastName as CreatedBy,\n" +
" FORMAT(FlightDate, 'dd-MMM-yyyy HH:mm:ss', 'en-US' ) 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.ID =" + ID.ToString();
qDetailView theView = new qDetailView(SQL);
theView.Columns = 3;
//this part for adding link to requred fields in the details
DroneId = Util.GetDroneIdFromFlight(ID);
UserId = Util.GetPilotIdFromFlight(ID);
UASFormat = "<a href='/Drone/Detail/" + DroneId + "'>" + Util.GetUASFromFlight(ID) + "</a>";//url
PilotFormat = "<a href='/Pilot/PilotDetail/" + UserId + "'>" + Util.GetPilotFromFlight(ID) + "</a>";//url
theView.FormatCols.Add("RPAS", UASFormat); //Adding the Column required for formatting
theView.FormatCols.Add("PilotName", PilotFormat); // //Adding the Column required for formatting
/*
SQL = @"
SELECT
Count([DroneCheckList].[ID]) as FlightCheckList
FROM
[DroneCheckList]
LEFT JOIN [MSTR_DroneCheckList] ON
[MSTR_DroneCheckList].ID = [DroneCheckListID]
WHERE
[MSTR_DroneCheckList].[CheckListTitle]='Pre-Flight Checklist' AND
[DroneCheckList].[FlightID]=" + ID;
int CheckListCount = Util.getDBInt(SQL);
if (CheckListCount >= 3) {
CheckListMessage = "<div class=\"authorise\"><span class=\"icon\"></span>" +
"You have successfully completed all the checklist</div>";
} else if (CheckListCount >= 1) {
CheckListMessage = "<div class=\"warning\"><span class=\"icon\"></span>" +
"Please complete all the checklist for the flight.</div>";
} else {
CheckListMessage = "<div class=\"invalid\"><span class=\"icon\"></span>" +
"You need to complete all checklist before the flight</div>";
}
//Check the documents for Regulator is uploaded
SQL = "SELECT\n" +
" Count(*)\n" +
"FROM\n" +
" [DroneDocuments]\n" +
"WHERE\n" +
" FlightID = " + ID.ToString() + " and\n" +
" DocumentType = 'Regulator Approval'\n";
int TheCount = Util.getDBInt(SQL);
if (TheCount < 1) {
UploadedDocs = "<div class=\"warning\"><span class=\"icon\"></span>" +
"Please upload your Regulatory Authorisation document before the flight</div>";
} else {
UploadedDocs = "<div class=\"authorise\"><span class=\"icon\"></span>" +
"Your Regulatory Authorization: " + getUploadedDocs(ID) +
"</div>";
}
*/
return UploadedDocs + CheckListMessage + theView.getTable();
}//DroneFlightDetail ()
