public List<MSTR_Drone> get_MSTR_Drone() { using (var db = new ExponentPortalEntities()) { var Query = (from n in db.MSTR_Drone select n); var Data = Query.ToList(); return Data; } }
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 IEnumerable <System.Web.Mvc.SelectListItem> GetBlackBoxList() { var db = new ExponentPortalEntities(); var BlackBoxList = from b in db.MSTR_BlackBox orderby b.BlackBoxName select new System.Web.Mvc.SelectListItem { Text = b.BlackBoxName, Value = b.BlackBoxID.ToString() }; var theList = BlackBoxList.ToList(); theList.Insert(0, new System.Web.Mvc.SelectListItem { Text = "Please Select...", Value = "" }); return(theList); }
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
public List<MSTR_User> MSTR_User() { using (var db = new ExponentPortalEntities()) { return (from n in db.MSTR_User select n).ToList(); } }