public List<AlertReportData> getAlertReportData(FlightReportFilter Filter = null) {
var Request = HttpContext.Current.Request;
var thisReport = new exLogic.Report();
var Records = new List<AlertReportData>();
if (Filter == null) Filter = new FlightReportFilter();
var SQL = thisReport.getAlertSQL(Filter);
SQL = SQL + "\nORDER BY PortalAlert.CreatedOn DESC";
using (var db = new ExponentPortalEntities()) {
using (var cmd = db.Database.Connection.CreateCommand()) {
db.Database.Connection.Open();
cmd.CommandText = SQL;
using (var reader = cmd.ExecuteReader()) {
while (reader.Read()) {
var TheRow = new AlertReportData {
AlertID = reader.GetInt32(reader.GetOrdinal("AlertID")),
FlightID = reader.GetInt32(reader.GetOrdinal("FlightID")),
CreatedOn = reader.GetDateTime(reader.GetOrdinal("CreatedOn")),
DroneName = reader["RPAS"].ToString(),
Pilot = reader["Pilot"].ToString(),
SMS = reader["SMS"].ToString(),
AlertCategory = reader["AlertCategory"].ToString(),
AlertType = reader["AlertType"].ToString(),
Latitude = reader.GetDecimal(reader.GetOrdinal("Latitude")),
Longitude = reader.GetDecimal(reader.GetOrdinal("Longitude")),
Altitude = reader.GetInt32(reader.GetOrdinal("Altitude"))
};
Records.Add(TheRow);
}//while
}//using reader
}
}//using (var db = new ExponentPortalEntities())
return Records;
}
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 AlertPDF(FlightReportFilter ReportFilter) {
var myReport = new ReportData();
LocalReport localReport = new LocalReport();
ReportParameter[] TheParams = {
new ReportParameter("ReportFilterInfo", ReportFilter.getReadableFilter(), false)
};
localReport.ReportPath = Server.MapPath("~/ReportsManager/AlertReport.rdlc");
ReportDataSource reportDataSource = new ReportDataSource("AlertReportDataSet", myReport.getAlertReportData(ReportFilter));
//localReport.SetParameters(TheParams);
localReport.DataSources.Add(reportDataSource);
string reportType = "PDF";
string mimeType;
string encoding;
string fileNameExtension;
//The DeviceInfo settings should be changed based on the reportType
//http://msdn2.microsoft.com/en-us/library/ms155397.aspx
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>11.69in</PageWidth>" +
" <PageHeight>8.27in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0.5in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
//Render the report
renderedBytes = localReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
Response.AddHeader("content-disposition", "attachment; filename=AlertReport." + fileNameExtension);
return File(renderedBytes, mimeType);
}
private void popupWindowShowAction_CustomizePopupWindowParams(object sender, CustomizePopupWindowParamsEventArgs e)
{
PopupWindowShowAction action = (PopupWindowShowAction)sender;
IObjectSpace objectSpace = action.Application.CreateObjectSpace(typeof(FlightReportFilter));
string detailViewId = action.Application.FindDetailViewId(typeof(FlightReportFilter));
FlightReportFilter flightReportFilter = objectSpace.FindObject <FlightReportFilter>(null);
if (flightReportFilter == null)
{
//flightReportFilter = new FlightReportFilter();
flightReportFilter = objectSpace.CreateObject <FlightReportFilter>();
}
//if (flightReportFilter == null)
//{
// flightReportFilter = objectSpace.CreateObject<FlightReportFilter>();
// //message.Text = ActionsDemoStrings.LogTraceHeader + e.Action.Caption + ActionsDemoStrings.LogTraceTail;
//}
e.View = action.Application.CreateDetailView(objectSpace, flightReportFilter);
}
protected override object CreateControlsCore()
{
var grid = base.CreateControlsCore();
var objectSapce = ObjectSpace.CreateNestedObjectSpace();
flightReportFilter = objectSapce.CreateObject <FlightReportFilter>();
//flightReportFilter = new FlightReportFilter();
string detailViewId = Application.FindDetailViewId(typeof(FlightReportFilter));
var view = Application.CreateDetailView(objectSapce, flightReportFilter, false);
view.ViewEditMode = ViewEditMode.Edit;
view.CreateControls();
//var editor = new DevExpress.ExpressApp.Web.Editors.WebLookupEditorHelper(Application, objectSapce, XafTypesInfo.CastTypeToTypeInfo(typeof(AircraftRegister)),null);
// var editor = new ASPxLookupPropertyEditor(typeof(Aircraft), null);
// editor.CreateControl();
var table = RenderHelper.CreateTable();
var mainViewRow = new TableRow();
var filterViewRow = new TableRow();
var mainViewTableCell = new TableCell();
var filterTableCell = new TableCell();
mainViewTableCell.Controls.Add((System.Web.UI.Control)grid);
filterTableCell.Controls.Add((System.Web.UI.Control)view.Control);
//filterTableCell.Controls.Add((System.Web.UI.Control)editor.Control);
mainViewRow.Cells.Add(filterTableCell);
filterViewRow.Cells.Add(mainViewTableCell);
table.Rows.Add(mainViewRow);
table.Rows.Add(filterViewRow);
table.Style.Add("width", "auto");
table.Style.Add("border-spacing", "1px");
return(table);
}
public List<FlightReportData>getFlightReportData(FlightReportFilter Filter = null) {
var Request = HttpContext.Current.Request;
var thisReport = new exLogic.Report();
var Records = new List<FlightReportData>();
if (Filter == null) Filter = new FlightReportFilter();
var SQL = thisReport.getFlightReportSQL(Filter, true) ;
SQL = SQL + "\nORDER BY DroneFlight.ID DESC";
using (var db = new ExponentPortalEntities()) {
using (var cmd = db.Database.Connection.CreateCommand()) {
db.Database.Connection.Open();
cmd.CommandText = SQL;
using (var reader = cmd.ExecuteReader()) {
while (reader.Read()) {
var TheRow = new FlightReportData {
ID = Util.toInt(reader["Ref"]),
FlightDate = reader.GetDateTime(reader.GetOrdinal("FlightDate")),
FlightTime = reader["FlightTime"].ToString(),
Pilot = reader["Pilot"].ToString(),
UAS = reader["UAS"].ToString(),
BoundaryAlerts = reader["BoundaryAlerts"].ToString(),
HeightAlerts = reader["AltitudeAlerts"].ToString(),
ProximityAlerts = reader["ProximityAlerts"].ToString(),
MaxAltitude = reader["MaxAltitude"].ToString(),
Height = Util.toInt(reader["Height"]),
HeightCritical = Util.toInt(reader["HeightCritical"]),
Boundary = Util.toInt(reader["Boundary"]),
BoundaryCritical = Util.toInt(reader["BoundaryCritical"]),
Proximity = Util.toInt(reader["Proximity"]),
ProximityCritical = Util.toInt(reader["ProximityCritical"])
};
Records.Add(TheRow);
}//while
}//using reader
}
}//using (var db = new ExponentPortalEntities())
return Records;
}//getFlightReportData
/// <summary>
///
/// </summary>
/// <param name="ReportFilter"></param>
/// <returns></returns>
public ActionResult GeoTag(FlightReportFilter ReportFilter) {
if (!exLogic.User.hasAccess("REPORT.FLIGHTS"))
return RedirectToAction("NoAccess", "Home");
ViewBag.ReportFilter = ReportFilter;
int DroneID = ReportFilter.UAS;
int IsCompany = 0;
DateTime FromDate = DateTime.Parse(ReportFilter.From);
DateTime ToDate = DateTime.Parse(ReportFilter.To);
ToDate = ToDate.AddHours(24);
List<DroneDocument> Docs = new List<DroneDocument>();
IList<GeoTagReport> DocsGeo = new List<GeoTagReport>();
ExponentPortalEntities Db = new ExponentPortalEntities();
if (!exLogic.User.hasAccess("DRONE.VIEWALL")) {
IsCompany = 1;
} else {
IsCompany = 0;
}
DocsGeo = Util.getAllGeoTag(FromDate, ToDate, IsCompany, DroneID);
return View(DocsGeo);
}
//adding this for auto complete drone name
public ActionResult DroneFilter(FlightReportFilter ReportFilter) {
return View(ReportFilter);
}
