private void setReportMessages(IList<PortalAlert> Messages, GCA_Approval thisApproval) {
foreach (var Message in Messages) {
if (thisApproval != null) {
var FlightInfo = (
from f in db.FlightMapDatas
where f.FlightMapDataID == Message.FlightDataID
select f
).FirstOrDefault();
switch (Message.AlertCategory) {
case "Height":
Message.AlertMessage = "RPAS is above proposed height of " + thisApproval.MaxAltitude + " Meter at " + Message.Altitude + " Meter";
break;
case "Boundary":
Message.AlertCategory = "Perimeter";
Message.AlertMessage = "RPAS is outside approved perimeter at " + fmtGPS((Double)Message.Latitude, (Double)Message.Longitude);
break;
case "Proximity":
//Message.AlertMessage = getProximityMessage(FlightInfo.OtherFlightIDs, (int)FlightInfo.FlightID);
Message.AlertMessage = "Proximity Error";
break;
}//switch
} else {
//nothing.
}
}//foreach
}//private void setReportMessages
public string UploadGCA(GCA_Approval GCA)
{
//Doc.DocumentTitle = Doc.DocumentTitle.Trim();
if (String.IsNullOrWhiteSpace(GCA.ApprovalName))
{
GCA.ApprovalName = toTitle(GCA.ApprovalFileUrl);
}
string[] Coord = GCA.Coordinates.Split(',');
string Poly = GCA.Coordinates + "," + Coord[0];
if (string.IsNullOrEmpty(GCA.BoundaryInMeters.ToString().Trim()))
GCA.BoundaryInMeters = 0;
string SQL = "SELECT Count(*) FROM [GCA_Approval] WHERE ApprovalID = " + GCA.ApprovalID;
if (Util.getDBInt(SQL) != 0 && GCA.ApprovalID != 0)
{
//string UpdateRingQuery = "Update [GCA_Approval] set Polygon=Polygon.ReorientObject().MakeValid() where Polygon.STArea()>999999 and ApprovalID=" + GCA.ApprovalID;
//int res = Util.doSQL(SQL);
//UpdateRingQuery = @"Update [GCA_Approval] set
// InnerBoundary=Polygon.STBuffer(BoundaryInMeters),
// InnerBoundaryCoord = Polygon.STBuffer(BoundaryInMeters).ToString() where ApprovalID=" + GCA.ApprovalID;
string SQLQ = "Update [GCA_Approval] set" +
"[ApprovalName] = '" + GCA.ApprovalName + "' " +
",[ApprovalDate] = '" + Util.toSQLDate(Convert.ToDateTime(GCA.ApprovalDate)) + "' " +
",[StartDate] = '" + Util.toSQLDate(Convert.ToDateTime(GCA.StartDate)) + "' " +
",[EndDate] = '" + Util.toSQLDate(Convert.ToDateTime(GCA.EndDate)) + "' " +
",[StartTime]= '" + GCA.StartTime + "' " +
",[EndTime]= '" + GCA.EndTime + "' " +
",[Coordinates]= '" + GCA.Coordinates + "' " +
",[Polygon]= geography::STGeomFromText('POLYGON((" + Poly + @"))',4326).MakeValid() " +
",DroneID= '" + GCA.DroneID + "' " +
",ApprovalFileUrl= '" + GCA.S3Url + "' " +
",MinAltitude= '" + (GCA.MinAltitude == null ? 0 : GCA.MinAltitude) + "' " +
",MaxAltitude= '" + (GCA.MaxAltitude == null ? 60 : GCA.MaxAltitude) + "' " +
",BoundaryInMeters= '" + (GCA.BoundaryInMeters == null ? 0 : GCA.BoundaryInMeters) + "' " +
" WHERE ApprovalID = " + GCA.ApprovalID;
int res = Util.doSQL(SQLQ);
}
else
{
SQL = @" insert into [GCA_Approval]
([ApprovalName]
,[ApprovalDate]
,[StartDate]
,[EndDate]
,[StartTime]
,[EndTime]
,[Coordinates]
,[Polygon]
,DroneID
,ApprovalFileUrl
,MinAltitude
,MaxAltitude
,BoundaryInMeters)
values
('" + GCA.ApprovalName + @"',
'" + Util.toSQLDate(Convert.ToDateTime(GCA.ApprovalDate)) + @"',
'" + Util.toSQLDate(Convert.ToDateTime(GCA.StartDate)) + @"',
'" + Util.toSQLDate(Convert.ToDateTime(GCA.EndDate)) + @"',
'" + GCA.StartTime + @"',
'" + GCA.EndTime + @"',
'" + GCA.Coordinates + @"',
geography::STGeomFromText('POLYGON((" + Poly + @"))',4326).MakeValid(),
" + GCA.DroneID + @",
'" + GCA.S3Url + @"',
" + (GCA.MinAltitude == null ? 0 : GCA.MinAltitude) + @",
" + (GCA.MaxAltitude == null ? 60 : GCA.MaxAltitude) + @",
-" + (GCA.BoundaryInMeters == null ? 0 : GCA.BoundaryInMeters) + @")";
GCA.ApprovalID = Util.InsertSQL(SQL);
}
return "../../Approval/Index";// RedirectToAction("Index","Approval");
}
public ActionResult GCAApproval(int ID=0)
{
//to create gcaapproval
if (!exLogic.User.hasAccess("FLIGHT.GCAAPPROVAL")) return RedirectToAction("NoAccess", "Home");
var fileStorageProvider = new AmazonS3FileStorageProvider();
var fileUploadViewModel = new S3Upload(
fileStorageProvider.PublicKey,
fileStorageProvider.PrivateKey,
fileStorageProvider.BucketName,
Url.Action("complete", "home", null, Request.Url.Scheme)
);
fileUploadViewModel.SetPolicy(
fileStorageProvider.GetPolicyString(
fileUploadViewModel.FileId,
fileUploadViewModel.RedirectUrl
)
);
ViewBag.FormAction = fileUploadViewModel.FormAction;
ViewBag.FormMethod = fileUploadViewModel.FormMethod;
ViewBag.FormEnclosureType = fileUploadViewModel.FormEnclosureType;
ViewBag.AWSAccessKey = fileUploadViewModel.AWSAccessKey;
ViewBag.Acl = fileUploadViewModel.Acl;
ViewBag.Base64EncodedPolicy = fileUploadViewModel.Base64EncodedPolicy;
ViewBag.Signature = fileUploadViewModel.Signature;
var GCAApprovalDoc = new GCA_Approval();
if (ID != 0)
{
GCAApprovalDoc.DroneID = ID;
}
if (ID != 0)
{
var olist = (from p in db.GCA_Approval where p.ApprovalID == ID select p).ToList();
if (olist.Count > 0)
{
GCAApprovalDoc.ApprovalID = olist[0].ApprovalID;
GCAApprovalDoc.DroneID = olist[0].DroneID;
GCAApprovalDoc.ApprovalName = olist[0].ApprovalName;
GCAApprovalDoc.Coordinates = olist[0].Coordinates;
GCAApprovalDoc.ApprovalDate = olist[0].ApprovalDate == null ? null : olist[0].ApprovalDate;
GCAApprovalDoc.StartDate = olist[0].StartDate == null ? null : olist[0].StartDate;
GCAApprovalDoc.EndDate = olist[0].EndDate == null ? null : olist[0].EndDate;
GCAApprovalDoc.StartTime = olist[0].StartTime;
GCAApprovalDoc.EndTime = olist[0].EndTime;
GCAApprovalDoc.MinAltitude = olist[0].MinAltitude;
GCAApprovalDoc.MaxAltitude = olist[0].MaxAltitude;
GCAApprovalDoc.BoundaryInMeters = olist[0].BoundaryInMeters;
}
}
return View(GCAApprovalDoc);
}//ActionResult GCAApproval()
