public ActionResult Create(CommViewModel cvm)
{
try {
// TODO: Add insert logic here
if (cvm.Message.Trim().Length > 0)
{
MSTR_Comms Comms = new MSTR_Comms();
Comms.Message = cvm.Message;
Comms.CreatedBy = exLogic.Util.getLoginUserID();
ctx.MSTR_Comms.Add(Comms);
ctx.SaveChanges();
List <MSTR_User> UserList = ctx.MSTR_User.Where(x => x.AccountId == 1).ToList();
foreach (MSTR_User Us in UserList)
{
CommsDetail Cmd = new CommsDetail();
Cmd.FromID = exLogic.Util.getLoginUserID();
Cmd.ToID = Us.UserId;
Cmd.MessageID = Comms.MessageID;
Cmd.Status = "NEW";
Cmd.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(Cmd);
}
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
} catch (Exception Ex) {
return(View());
}
}
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 CreateMessage(string Message, int FlightID)
{
try {
// TODO: Add insert logic here
int userid = exLogic.Util.getLoginUserID();
if (userid != 0)
{
if (Message.Trim().Length > 0)
{
MSTR_Comms Comms = new MSTR_Comms();
Comms.Message = Message;
Comms.CreatedBy = userid;
Comms.FlightID = FlightID;
ctx.MSTR_Comms.Add(Comms);
ctx.SaveChanges();
List <MSTR_User> UserList = ctx.MSTR_User.Where(x => x.AccountId == 1).ToList();
foreach (MSTR_User Us in UserList)
{
CommsDetail Cmd = new CommsDetail();
Cmd.FromID = exLogic.Util.getLoginUserID();
Cmd.ToID = Us.UserId;
Cmd.MessageID = Comms.MessageID;
Cmd.Status = "NEW";
Cmd.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(Cmd);
}
ctx.SaveChanges();
return(Json("OK"));
}
else
{
return(Json("Empty Message"));
}
}
else
{
return(Json("Invalid User"));
}
} catch (Exception Ex) {
return(Json("Unsuccessful"));
}
}
public JsonResult CreateMessageToUser(string Message, int FlightID)
{
try
{
// TODO: Add insert logic here
int?ToID = ctx.DroneFlight.Where(x => x.ID == FlightID).Select(x => x.PilotID).FirstOrDefault();
int userid = exLogic.Util.getLoginUserID();
if (userid != 0)
{
if (Message.Trim().Length > 0)
{
MSTR_Comms Comms = new MSTR_Comms();
Comms.Message = Message;
Comms.CreatedBy = userid;
Comms.FlightID = FlightID;
ctx.MSTR_Comms.Add(Comms);
ctx.SaveChanges();
CommsDetail Cmd = new CommsDetail();
Cmd.FromID = userid;
Cmd.ToID = ToID.Value;
Cmd.MessageID = Comms.MessageID;
Cmd.Status = "NEW";
Cmd.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(Cmd);
ctx.SaveChanges();
return(Json("OK"));
}
else
{
return(Json("Empty Message"));
}
}
else
{
return(Json("Invalid User"));
}
}
catch (Exception Ex)
{
return(Json("Unsuccessful"));
}
}
public JsonResult SendMessage(CommsSender Comm)
{
if (Comm.OrganizationID > 0)
{
if (Comm.PilotID > 0)
{
MSTR_Comms mcom = new MSTR_Comms();
mcom.CreatedBy = 1;
mcom.Message = Comm.Message;
ctx.MSTR_Comms.Add(mcom);
ctx.SaveChanges();
CommsDetail cdet = new CommsDetail();
cdet.FromID = exLogic.Util.getLoginUserID();
cdet.ToID = Comm.PilotID;
cdet.MessageID = mcom.MessageID;
cdet.Status = "NEW";
cdet.StatusUpdatedOn = DateTime.Now;
cdet.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(cdet);
ctx.SaveChanges();
}
}
else if (Comm.OrganizationID == 0)
{
if (Comm.ActivePilot == true)
{
var flUSer = GetActivePilots();
foreach (PilotFlight pil in flUSer)
{
int Pilotid = pil.PilotID.GetValueOrDefault();
if (Pilotid != 0)
{
MSTR_Comms mcom = new MSTR_Comms();
mcom.CreatedBy = exLogic.Util.getLoginUserID();
mcom.Message = Comm.Message;
mcom.FlightID = pil.FlightID;
ctx.MSTR_Comms.Add(mcom);
ctx.SaveChanges();
CommsDetail cdet = new CommsDetail();
cdet.FromID = exLogic.Util.getLoginUserID();
cdet.ToID = pil.PilotID.Value;
cdet.MessageID = mcom.MessageID;
cdet.Status = "NEW";
cdet.StatusUpdatedOn = DateTime.Now;
cdet.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(cdet);
ctx.SaveChanges();
}
}
}
else if (Comm.ActiveRegionPilot == true)
{
List <PilotFlight> actPilotRegion = GetActivePilotsRegion(Comm.Zone);
foreach (PilotFlight pil in actPilotRegion)
{
int Pilotid = pil.PilotID.GetValueOrDefault();
if (Pilotid != 0)
{
MSTR_Comms mcom = new MSTR_Comms();
mcom.CreatedBy = exLogic.Util.getLoginUserID();
mcom.Message = Comm.Message;
mcom.FlightID = pil.FlightID;
ctx.MSTR_Comms.Add(mcom);
ctx.SaveChanges();
CommsDetail cdet = new CommsDetail();
cdet.FromID = exLogic.Util.getLoginUserID();
cdet.ToID = pil.PilotID.Value;
cdet.MessageID = mcom.MessageID;
cdet.Status = "NEW";
cdet.StatusUpdatedOn = DateTime.Now;
cdet.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(cdet);
ctx.SaveChanges();
}
}
}
else
{
List <int> mPils = ctx.MSTR_User.Where(x => x.AccountId != 1 && x.IsPilot == true).Select(x => x.UserId).ToList();
foreach (int pil in mPils)
{
MSTR_Comms mcom = new MSTR_Comms();
mcom.CreatedBy = exLogic.Util.getLoginUserID();
mcom.Message = Comm.Message;
ctx.MSTR_Comms.Add(mcom);
ctx.SaveChanges();
CommsDetail cdet = new CommsDetail();
cdet.FromID = exLogic.Util.getLoginUserID();
cdet.ToID = pil;
cdet.MessageID = mcom.MessageID;
cdet.Status = "NEW";
cdet.StatusUpdatedOn = DateTime.Now;
cdet.CreatedBy = exLogic.Util.getLoginUserID();
ctx.CommsDetail.Add(cdet);
ctx.SaveChanges();
}
}
}
return(Json("OK"));
}
