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)); }