public JsonResult SaveZone(MSTR_NoFlyZone Zone)
{
MSTR_NoFlyZone ezone = new MSTR_NoFlyZone();
if (Zone.ID != 0)
{
ezone = ctx.MSTR_NoFlyZone.Where(x => x.ID == Zone.ID).FirstOrDefault();
ezone.Name = Zone.Name;
ezone.Coordinates = Zone.Coordinates;
ezone.FillColour = "Orange";
ezone.StartDate = Zone.StartDate;
ezone.EndDate = Zone.EndDate;
ezone.StartTime = Zone.StartTime;
ezone.EndTime = Zone.EndTime;
ezone.ZoneDescription = Zone.ZoneDescription;
ezone.DisplayType = "Dynamic";
ezone.Message = Zone.Message;
ezone.IsDeleted = false;
ctx.SaveChanges();
}
else
{
ezone = Zone;
ezone.FillColour = "Orange";
ezone.DisplayType = "Dynamic";
ezone.IsDeleted = false;
ctx.MSTR_NoFlyZone.Add(ezone);
ctx.SaveChanges();
}
var flUSer = GetActivePilots();
int UserID = exLogic.Util.getLoginUserID();
foreach (PilotFlight pil in flUSer)
{
int Pilotid = pil.PilotID.GetValueOrDefault();
if (Pilotid != 0)
{
MSTR_Comms mcom = new MSTR_Comms();
mcom.CreatedBy = UserID;
mcom.Message = Zone.Message;
mcom.FlightID = pil.FlightID;
ctx.MSTR_Comms.Add(mcom);
ctx.SaveChanges();
CommsDetail cdet = new CommsDetail();
cdet.FromID = UserID;
cdet.ToID = pil.PilotID.Value;
cdet.MessageID = mcom.MessageID;
cdet.Status = "NEW";
cdet.StatusUpdatedOn = DateTime.Now;
cdet.CreatedBy = UserID;
ctx.CommsDetail.Add(cdet);
ctx.SaveChanges();
}
}
List <MSTR_NoFlyZone> NoFlyZoneList = ctx.MSTR_NoFlyZone.ToList();
return(Json(ezone.ID, JsonRequestBehavior.AllowGet));
}
public JsonResult RemoveZone(MSTR_NoFlyZone Zone)
{
MSTR_NoFlyZone ezone = new MSTR_NoFlyZone();
if (Zone.ID != 0)
{
ezone = ctx.MSTR_NoFlyZone.Where(x => x.ID == Zone.ID).FirstOrDefault();
ezone.IsDeleted = true;
ctx.SaveChanges();
}
return(Json(ezone.ID, JsonRequestBehavior.AllowGet));
}
