public ActionResult GetDriverStopLocationsCoordinatesByIDs(int[] driverStopIDs)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
List <GeoLocationVM> model = new List <GeoLocationVM>();
for (int i = 0; i < driverStopIDs.Length; i++)
{
int driverStopID = driverStopIDs[i];
GeoLocationVM singleLocation = _db.stajalista.Where(x => x.stajaliste_id == driverStopID).Select(x => new GeoLocationVM
{
ID = x.stajaliste_id,
Info = x.naziv,
Latitude = x.sirina,
Longitude = x.duzina
}).AsNoTracking().FirstOrDefault();
model.Add(singleLocation);
}
if (model != null && model.Count != 0)
{
return(Json(new { success = true, driverStopLocations = model }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetTaskLocationsCoordinatesByIDs(int[] taskIDs)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
List <GeoLocationVM> model = new List <GeoLocationVM>();
for (int i = 0; i < taskIDs.Length; i++)
{
int taskID = taskIDs[i];
GeoLocationVM singleLocation = _db.zadaci.Where(x => x.zadatak_id == taskID).Include(x => x.poznatelokacije).Select(x => new GeoLocationVM
{
ID = x.zadatak_id,
Info = x.naziv,
Latitude = x.poznatelokacije.sirina,
Longitude = x.poznatelokacije.duzina
}).AsNoTracking().FirstOrDefault();
model.Add(singleLocation);
}
if (model != null && model.Count != 0)
{
return(Json(new { success = true, taskLocations = model }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetAllActiveDriversLatestPosition()
{
List <GeoLocationVM> model = new List <GeoLocationVM>();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
foreach (var driver in _db.vozaci.ToList())
{
var latestPosition = _db.geotacke.Include(x => x.nalozi).Where(x => x.nalozi.stanje_id == 1 && x.nalozi.vozac_id == driver.vozac_id).OrderByDescending(x => x.vrijeme).FirstOrDefault();
GeoLocationVM latestPositionVM = new GeoLocationVM();
if (latestPosition != null)
{
latestPositionVM.Info = UnixTime.ConvertToDateTimeString(latestPosition.vrijeme);
latestPositionVM.Latitude = latestPosition.sirina;
latestPositionVM.Longitude = latestPosition.duzina;
}
model.Add(latestPositionVM);
}
}
return(PartialView(viewName: "_ActiveDriversLatestPosition", model: model));
}
public JsonResult GetLatestCoordinatePosition(int driverID)
{
GeoLocationVM model = new GeoLocationVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var latestPosition = _db.geotacke.Include(x => x.nalozi).Where(x => x.nalozi.stanje_id == 1 && x.nalozi.vozac_id == driverID).OrderByDescending(x => x.vrijeme).FirstOrDefault();
if (latestPosition != null)
{
model.Info = UnixTime.ConvertToDateTimeString(latestPosition.vrijeme);
model.Latitude = latestPosition.sirina;
model.Longitude = latestPosition.duzina;
}
}
return(Json(new { info = model.Info, latitude = model.Latitude, longitude = model.Longitude }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetLatestPosition(int driverID)
{
GeoLocationVM model = new GeoLocationVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var latestPosition = _db.geotacke.Include(x => x.nalozi).Where(x => x.nalozi.stanje_id == 1 && x.nalozi.vozac_id == driverID).OrderByDescending(x => x.vrijeme).FirstOrDefault();
if (latestPosition != null)
{
model.ID = driverID;
model.Info = UnixTime.ConvertToDateTimeString(latestPosition.vrijeme);
model.Latitude = latestPosition.sirina;
model.Longitude = latestPosition.duzina;
}
}
return(PartialView(viewName: "_LatestMapPosition", model: model));
}
public ActionResult Index()
{
IndexVM model = new IndexVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.Statistics = new GetStatisticsVM();
model.Statistics.NumberOfFinishedOrders = _db.nalozi.Where(s => s.stanje_id == 3).Count();
model.Statistics.NumberOfFinishedTasks = _db.zadaci.Include(s => s.nalozi).Where(s => s.nalozi.stanje_id == 3).Count();
model.Statistics.NumberOfDrivers = _db.vozaci.Count();
model.Statistics.NumberOfVehicles = _db.vozila.Count();
model.ActiveDrivers = new GetDriversVM();
model.ActiveDrivers.DriversList = _db.nalozi.Include(x => x.vozaci).Where(x => x.stanje_id == 1).Select(x => new GetDriversVM.DriverVM
{
DriverID = x.vozaci.vozac_id,
FirstName = x.vozaci.ime,
LastName = x.vozaci.prezime,
PersonUniqueID = x.vozaci.jmbg,
Username = x.vozaci.user,
Status = "Aktivan"
}).AsNoTracking().ToList();
model.ActiveDriversLatestPositions = new List <GeoLocationVM>();
foreach (var driver in _db.vozaci.ToList())
{
var latestPosition = _db.geotacke.Include(x => x.nalozi).Where(x => x.nalozi.stanje_id == 1 && x.nalozi.vozac_id == driver.vozac_id).OrderByDescending(x => x.vrijeme).FirstOrDefault();
GeoLocationVM latestPositionVM = new GeoLocationVM();
if (latestPosition != null)
{
latestPositionVM.Info = UnixTime.ConvertToDateTimeString(latestPosition.vrijeme);
latestPositionVM.Latitude = latestPosition.sirina;
latestPositionVM.Longitude = latestPosition.duzina;
}
model.ActiveDriversLatestPositions.Add(latestPositionVM);
}
}
return(View(viewName: "Index", model: model));
}
