public ActionResult Index()
{
GetLocationCategoriesVM model = new GetLocationCategoriesVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.LocationCategoriesList = _db.kategorije.Include(x => x.poznatelokacije).AsNoTracking().ToList();
}
return(View(viewName: "Index", model: model));
}
public ActionResult GetStatistics()
{
GetStatisticsVM model = new GetStatisticsVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.NumberOfFinishedOrders = _db.nalozi.Where(s => s.stanje_id == 3).Count();
model.NumberOfFinishedTasks = _db.zadaci.Include(s => s.nalozi).Where(s => s.nalozi.stanje_id == 3).Count();
model.NumberOfDrivers = _db.vozaci.Count();
model.NumberOfVehicles = _db.vozila.Count();
}
return(PartialView(viewName: "_Statistics", model: model));
}
public static dispecerlogin GetUserIfAny()
{
if (HttpContext.Current.Session[Constants.UserSessionLabel] != null)
{
int userID = (int)HttpContext.Current.Session[Constants.UserSessionLabel];
using (TruckTransportDbContext db = new TruckTransportDbContext())
{
return(db.dispecerlogin.AsNoTracking().Where(x => x.dispecerlogin_id == userID).SingleOrDefault());
}
}
return(null);
}
public JsonResult CheckNumberOfMessages()
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var numOfMessages = _db.poruke.Where(x => x.odvozaca == 1 && !x.text.Contains("SOS")).Count();
if (numOfMessages > Constants.NumberOfMessages)
{
Constants.NumberOfMessages = numOfMessages;
return(Json(new { setNotif = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { setNotif = false }, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangePassword(int driverID)
{
ChangeDriverPasswordVM model = new ChangeDriverPasswordVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var driver = _db.vozaci.AsNoTracking().Where(x => x.vozac_id == driverID).SingleOrDefault();
if (driver != null)
{
model.DriverID = driver.vozac_id;
}
}
return(PartialView(viewName: "_ChangePassword", model: model));
}
public ActionResult GetKnownLocationCoordinatesByID(int knownLocationID)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
poznatelokacije knownLocation = _db.poznatelokacije.AsNoTracking().Where(x => x.poznatalokacija_id == knownLocationID).FirstOrDefault();
if (knownLocation != null)
{
return(Json(new { success = true, latitude = knownLocation.sirina, longitude = knownLocation.duzina }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Edit(int locationCategoryID)
{
EditLocationCategoryVM model = new EditLocationCategoryVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var locationCategory = _db.kategorije.AsNoTracking().Where(x => x.kategorija_id == locationCategoryID).FirstOrDefault();
if (locationCategory != null)
{
model.LocationCategoryID = locationCategory.kategorija_id;
model.Name = locationCategory.naziv;
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public ActionResult Edit(int orderConditionID)
{
EditOrderConditionVM model = new EditOrderConditionVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var orderCondition = _db.stanja.AsNoTracking().Where(x => x.stanje_id == orderConditionID).FirstOrDefault();
if (orderCondition != null)
{
model.OrderConditionID = orderCondition.stanje_id;
model.Description = orderCondition.opis;
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public ActionResult Delete(int locationCategoryID)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var locationCategoryDB = _db.kategorije.Where(x => x.kategorija_id == locationCategoryID).FirstOrDefault();
if (locationCategoryDB != null)
{
_db.kategorije.Remove(locationCategoryDB);
_db.SaveChanges();
return(Json(data: new { success = true }, behavior: JsonRequestBehavior.AllowGet));
}
}
return(Json(data: new { success = false }, behavior: JsonRequestBehavior.AllowGet));
}
public ActionResult DispatcherUserChangePassword(ChangePasswordVM model)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
if (ModelState.IsValid)
{
var dispatcherUser = _db.dispecerlogin.Where(x => x.dispecerlogin_id == _dispatcherUserID).SingleOrDefault();
dispatcherUser.password = model.NewPassword;
_db.SaveChanges();
return(Json(new { success = true }));
}
}
return(PartialView(viewName: "_DispatcherUserPassword", model: model));
}
public ActionResult Edit(int settingID)
{
EditSettingsVM model = new EditSettingsVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var setting = _db.postavke.AsNoTracking().Where(x => x.postavka_id == settingID).FirstOrDefault();
if (setting != null)
{
model.SettingID = setting.postavka_id;
model.KeyName = setting.kljuc;
model.Value = setting.vrijednost;
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public ActionResult Edit(EditSettingsVM model)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
if (ModelState.IsValid)
{
var settingDB = _db.postavke.Where(x => x.postavka_id == model.SettingID).FirstOrDefault();
settingDB.vrijednost = model.Value;
_db.SaveChanges();
return(Json(data: new { success = true }));
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public ActionResult Delete(int orderConditionID)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var orderConditionDB = _db.stanja.Where(x => x.stanje_id == orderConditionID).FirstOrDefault();
if (orderConditionDB != null)
{
_db.stanja.Remove(orderConditionDB);
_db.SaveChanges();
return(Json(data: new { success = true }, behavior: JsonRequestBehavior.AllowGet));
}
}
return(Json(data: new { success = false }, behavior: JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int settingID)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var settingDB = _db.postavke.Where(x => x.postavka_id == settingID).FirstOrDefault();
if (settingDB != null)
{
_db.postavke.Remove(settingDB);
_db.SaveChanges();
return(Json(data: new { success = true }, behavior: JsonRequestBehavior.AllowGet));
}
}
return(Json(data: new { success = false }, behavior: JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int taskID)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
zadaci task = _db.zadaci.Where(x => x.zadatak_id == taskID).FirstOrDefault();
if (task != null)
{
_db.zadaci.Remove(task);
_db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Index()
{
GetDriversVM model = new GetDriversVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.DriversList = _db.vozaci.Select(x => new GetDriversVM.DriverVM {
DriverID = x.vozac_id,
FirstName = x.ime,
LastName = x.prezime,
PersonUniqueID = x.jmbg,
Username = x.user,
Status = _db.nalozi.Where(s => s.stanje_id == 1 && s.vozac_id == x.vozac_id).FirstOrDefault() != null ? "Aktivan" : "Na čekanju"
}).AsNoTracking().ToList();
}
return(View(viewName: "Index", 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 AddSetTaskAndDriverStopNumbers(int[] taskIDs, int?[] driverStopIDs)
{
AddOrderVM model = new AddOrderVM();
model.TaskAndDriverStopNumbers = new List <AssignTaskAndDriverStopNumbersInOrderVM>();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
foreach (var taskID in taskIDs)
{
AssignTaskAndDriverStopNumbersInOrderVM taskAndDriverStopNumberModel = new AssignTaskAndDriverStopNumbersInOrderVM();
var task = _db.zadaci.Where(x => x.zadatak_id == taskID).AsNoTracking().FirstOrDefault();
taskAndDriverStopNumberModel.ID = task.zadatak_id;
taskAndDriverStopNumberModel.Name = task.naziv;
taskAndDriverStopNumberModel.IsTask = true;
taskAndDriverStopNumberModel.Number = task.broj_zadatka;
model.TaskAndDriverStopNumbers.Add(taskAndDriverStopNumberModel);
}
if (driverStopIDs != null)
{
foreach (var driverStopID in driverStopIDs)
{
if (driverStopID != null)
{
AssignTaskAndDriverStopNumbersInOrderVM taskAndDriverStopNumberModel = new AssignTaskAndDriverStopNumbersInOrderVM();
var driverStop = _db.stajalista.Where(x => x.stajaliste_id == driverStopID).AsNoTracking().FirstOrDefault();
taskAndDriverStopNumberModel.ID = driverStop.stajaliste_id;
taskAndDriverStopNumberModel.Name = driverStop.naziv;
taskAndDriverStopNumberModel.IsTask = false;
taskAndDriverStopNumberModel.Number = 1;
model.TaskAndDriverStopNumbers.Add(taskAndDriverStopNumberModel);
}
}
}
}
return(PartialView(viewName: "_AddAssignTaskAndDriverStopNumbers", model: model));
}
public ActionResult Index()
{
GetAuditLoggingsVM model = new GetAuditLoggingsVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
List <logiranidogadjaji> events = _db.logiranidogadjaji.AsNoTracking().ToList();
model.AuditLoggingsList = events.Select(x => new AuditLoggingVM {
AuditLoggingID = x.logirani_dogadjaj_id,
Username = x.username,
IPAddress = x.ip_adresa,
URL = x.url,
EventTime = UnixTime.ConvertToDateTimeString(x.vrijeme_dogadjaja)
}).ToList();
}
return(View(viewName: "Index", 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));
}
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 GetActiveDrivers()
{
GetDriversVM model = new GetDriversVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.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();
}
return(PartialView(viewName: "_ActiveDrivers", model: model));
}
public ActionResult Add()
{
AddTaskVM model = new AddTaskVM();
model.KnownLocations = _dropdownMaker.GetKnownLocations();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var knownLocationID = Convert.ToInt32(model.KnownLocations.First().Value);
var selectedKnownLocation = _db.poznatelokacije.Where(x => x.poznatalokacija_id == knownLocationID).FirstOrDefault();
if (selectedKnownLocation != null)
{
model.Latitude = selectedKnownLocation.sirina;
model.Longitude = selectedKnownLocation.duzina;
}
}
return(View(viewName: "Add", model: model));
}
public ActionResult Edit(int driverStopID)
{
EditDriverStopVM model = new EditDriverStopVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
stajalista driverStop = _db.stajalista.AsNoTracking().Where(x => x.stajaliste_id == driverStopID).FirstOrDefault();
if (driverStop != null)
{
model.DriverStopID = driverStop.stajaliste_id;
model.Name = driverStop.naziv;
model.Description = driverStop.opis;
model.Latitude = driverStop.sirina;
model.Longitude = driverStop.duzina;
}
}
return(View(viewName: "Edit", model: model));
}
public ActionResult Index()
{
GetKnownLocationsVM model = new GetKnownLocationsVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
model.KnownLocationsList = _db.poznatelokacije
.Include(x => x.kategorije).Select(x => new GetKnownLocationsVM.KnownLocationVM
{
KnownLocationID = x.poznatalokacija_id,
Name = x.naziv,
Description = x.opis,
Longitude = x.duzina,
Latitude = x.sirina,
Category = x.kategorije.naziv
}).AsNoTracking().ToList();
}
return(View(viewName: "Index", model: model));
}
public ActionResult Edit(int driverID)
{
EditDriverVM model = new EditDriverVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var driver = _db.vozaci.AsNoTracking().Where(x => x.vozac_id == driverID).FirstOrDefault();
if (driver != null)
{
model.DriverID = driver.vozac_id;
model.FirstName = driver.ime;
model.LastName = driver.prezime;
model.PersonUniqueID = driver.jmbg;
model.Username = driver.user;
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
var request = filterContext.HttpContext.Request;
logiranidogadjaji audit = new logiranidogadjaji()
{
username = (Authentication.GetLoggedInUser() != null) ?
Authentication.GetLoggedInUser().username : "******",
ip_adresa = request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? request.UserHostAddress,
url = request.RawUrl,
vrijeme_dogadjaja = UnixTime.GetUnixTimeNow()
};
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
_db.logiranidogadjaji.Add(audit);
_db.SaveChanges();
}
base.OnActionExecuting(filterContext);
}
public ActionResult Details(int knownLocationID)
{
GetKnownLocationDetailsVM model = new GetKnownLocationDetailsVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
poznatelokacije knownLocation = _db.poznatelokacije.Include(x => x.kategorije).Where(x => x.poznatalokacija_id == knownLocationID).AsNoTracking().FirstOrDefault();
if (knownLocation != null)
{
model.KnownLocationID = knownLocation.poznatalokacija_id;
model.Name = knownLocation.naziv;
model.Description = knownLocation.opis;
model.LocationCategory = knownLocation.kategorije.naziv;
model.Latitude = knownLocation.sirina;
model.Longitude = knownLocation.duzina;
}
}
return(View(viewName: "Details", model: model));
}
public ActionResult Edit(int vehicleID)
{
EditVehicleVM model = new EditVehicleVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var vehicle = _db.vozila.AsNoTracking().Where(x => x.vozilo_id == vehicleID).FirstOrDefault();
if (vehicle != null)
{
model.VehicleID = vehicle.vozilo_id;
model.Name = vehicle.naziv;
model.Manufacturer = vehicle.marka;
model.Type = vehicle.tip;
model.YearMade = vehicle.godiste;
model.LoadCapacity = vehicle.nosivost;
}
}
return(PartialView(viewName: "_Edit", model: model));
}
public ActionResult Index()
{
ChatVM model = new ChatVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var drivers = _db.vozaci.ToList();
model.FirstDriverID = drivers.First().vozac_id;
model.ChatUsersMessages = new List <ChatUserMessagesVM>();
if (drivers != null)
{
foreach (var driver in drivers)
{
ChatUserMessagesVM userMessagesModel = new ChatUserMessagesVM();
userMessagesModel.DriverID = driver.vozac_id;
userMessagesModel.DriverFullName = driver.ime + " " + driver.prezime;
userMessagesModel.UserMessages = _db.poruke.Where(s => s.vozac_id == driver.vozac_id).Select(s => new ChatMessagesVM
{
MessageID = s.poruka_id,
DriverID = s.vozac_id,
UnixCreationTime = s.vrijeme,
SByteFromDriver = s.odvozaca,
MessageText = s.text
}).OrderByDescending(s => s.MessageID).Take(50).ToList();
foreach (var userMessage in userMessagesModel.UserMessages)
{
userMessage.CreationTime = UnixTime.ConvertToDateTimeString(userMessage.UnixCreationTime);
userMessage.FromDriver = Convert.ToBoolean(userMessage.SByteFromDriver);
}
model.ChatUsersMessages.Add(userMessagesModel);
}
}
}
return(View(viewName: "Index", model: model));
}
