public ActionResult SubmitDeleteCity(CitiesVM cvm) { DataLayer dl = new DataLayer(); List <string> cities = (from u in dl.smartAgent where u.Location.ToUpper() == cvm.selectedCity.ToUpper() select u.Location).ToList <string>(); cvm.cities = (from u in dl.smartAgent select u.Location).ToList <string>(); if (cities.Count == 1) { string cty = cities.FirstOrDefault().ToUpper(); SmartAgent sa = (from u in dl.smartAgent where u.Location.ToUpper() == cty select u).ToList <SmartAgent>().FirstOrDefault(); dl.smartAgent.Remove(sa); dl.SaveChanges(); ViewData["msg"] = "City deleted!"; return(View("DeleteCities", cvm)); } ViewData["msg"] = "City does not exist!"; return(View("DeleteCities", cvm)); }
public TableVM() { carriagesVM = new CarriagesVM(); citiesVM = new CitiesVM(); locomotivesVM = new LocomotivesVM(); routesVM = new RoutesVM(); schedulesVM = new SchedulesVM(); ticketsVM = new TicketsVM(); trainsVM = new TrainsVM(); usersVM = new UsersVM(); CurrentModel = schedulesVM; RequestCommand = new RelayCommand(o => { CurrentModel.Request(); }); AddCommand = new RelayCommand(o => { CurrentModel.AddEdit(true); }); EditCommand = new RelayCommand(o => { CurrentModel.AddEdit(false); }); DeleteCommand = new RelayCommand(o => { CurrentModel.Delete(); }); }
public IActionResult Create(CitiesVM model) { model.Country = GetAllCountries(); if (!ModelState.IsValid) { Response.StatusCode = 400; return(PartialView("_Create", model)); } try { City city = new City(); if (city == null) { return(BadRequest()); } city.Name = model.Name; city.CountryId = model.CountryId; city.PostalCode = model.PostalCode; _context.Cities.Add(city); _context.SaveChanges(); return(PartialView("_Create", model)); } catch (Exception ex) { throw; } }
public IActionResult Edit(CitiesVM model) { model.Country = GetAllCountries(); if (!ModelState.IsValid) { Response.StatusCode = 400; return(PartialView("_Edit", model)); } try { City city = _context.Cities.Where(x => x.CityId == model.CityId).FirstOrDefault(); city.Name = model.Name; city.CountryId = model.CountryId; city.PostalCode = model.PostalCode; _context.Cities.Update(city); _context.SaveChanges(); return(PartialView("_Edit", model)); } catch (Exception ex) { throw; } }
public IActionResult Create() { CitiesVM model = new CitiesVM() { Country = GetAllCountries() }; return(PartialView("_Create", model)); }
//----------------------------------------------------------------------------------------------------------------------------- // Smart Agent Delete Cities //----------------------------------------------------------------------------------------------------------------------------- public ActionResult DeleteCities() { DataLayer dl = new DataLayer(); CitiesVM cvm = new CitiesVM(); cvm.cities = (from u in dl.smartAgent select u.Location).ToList <string>(); return(View(cvm)); }
public IActionResult Delete(CitiesVM model) { model.Country = GetAllCountries(); if (model == null) { return(NotFound("Resource not found")); } var c = _context.Cities.Where(x => x.CityId == model.CityId).FirstOrDefault(); _context.Cities.Remove(c); _context.SaveChanges(); return(PartialView("_Delete", model)); }
// // GET: /Admin/Cities/ public ActionResult Index(int PageNo = 1, int PageSize = 10, string SearchTerm = "") { try { string query = "PageNo=" + PageNo + "&PageSize=" + PageSize + "&SearchTerm=" + SearchTerm; CitiesAPIVM apiModel = objAPI.GetRecordByQueryString <CitiesAPIVM>("configuration", "cities", query); CitiesVM model = new CitiesVM(); model.Cities = apiModel.Cities; model.PagingInfo = new PagingInfo { CurrentPage = PageNo, ItemsPerPage = PageSize, TotalItems = apiModel.TotalRecords }; if (Request.IsAjaxRequest()) { return(PartialView("_pvCitiesList", model)); } return(View(model)); } catch (AuthorizationException) { TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again"; return(RedirectToAction("Login", "Account", new { Area = "" })); } }