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