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