// GET: Faculties public ActionResult Index(int?page, int?RegionId, int?currentRegion) { ViewBag.CurrentRegion = RegionId.HasValue ? RegionId : currentRegion; NomRegion initial = new NomRegion(); initial.ID = -1; initial.Name = "All regions"; List <Models.NomRegion> list = new List <Models.NomRegion>(); list.Add(initial); list.AddRange(db.Regions); ViewBag.RegionId = new SelectList(list, "ID", "Name", ViewBag.CurrentRegion); if (!RegionId.HasValue) { RegionId = currentRegion; } var faculties = db.Faculties.Include(f => f.CountryObj).Include(f => f.FacultyTypeOfExchangeObj).Include(f => f.LastUpdatedByUser).Include(f => f.RegisteredByUser).Include(f => f.StudentTypeOfExchangeObj); if (RegionId.HasValue && RegionId != -1) { faculties = faculties.Where(f => f.CountryObj != null && f.CountryObj.RegionId == RegionId); } int pageSize = 10; int pageNumber = (page ?? 1); return(View(faculties.OrderBy(l => l.Name).ToPagedList(pageNumber, pageSize))); }
public ActionResult CreateUpdateCountry(NomCountry model) { if (ModelState.IsValid) { try { var message = ""; if (model.ID > 0) { NomCountry countryDb = db.Countries.FirstOrDefault(x => x.ID == model.ID); countryDb.ID = model.ID; countryDb.Name = model.Name; countryDb.RegionObj = model.RegionObj; countryDb.RegionId = model.RegionId; message = "Successfully edited country!"; db.SaveChanges(); } else { if (db.Countries.Any(x => x.Name.ToLower() == model.Name.ToLower() && x.RegionId == model.RegionId)) { throw new Exception("Country already exists!"); } NomCountry country = new NomCountry(); country.ID = model.ID; country.Name = model.Name; NomRegion region = db.Regions.Find(model.RegionId); country.RegionObj = region; country.RegionId = region.ID; message = "Successfully added country!"; db.Countries.Add(country); db.SaveChanges(); } DisplaySuccessMessage(message); return(Json(true)); } catch (Exception ex) { var modelErrors = new List <string>(); modelErrors.Add(ex.Message); return(Json(modelErrors)); } } else { var errors = GetModelStateErrors(ModelState.Values); return(Json(errors)); } }
public ActionResult CreateUpdateRegion(NomRegion model) { if (ModelState.IsValid) { try { var message = ""; if (model.ID > 0) { NomRegion regionDb = db.Regions.FirstOrDefault(x => x.ID == model.ID); regionDb.ID = model.ID; regionDb.Name = model.Name; message = "Successfully edited region!"; db.SaveChanges(); } else { if (db.Regions.Any(x => x.Name.ToLower() == model.Name.ToLower())) { throw new Exception("Region with that name already exists!"); } NomRegion region = new NomRegion(); region.ID = model.ID; region.Name = model.Name; message = "Successfully added region!"; db.Regions.Add(region); db.SaveChanges(); } DisplaySuccessMessage(message); return(Json(true)); } catch (Exception ex) { var modelErrors = new List <string>(); modelErrors.Add(ex.Message); return(Json(modelErrors)); } } else { var errors = GetModelStateErrors(ModelState.Values); return(Json(errors)); } }
public ActionResult AddEditRegion(int regionId) { NomRegion model = new NomRegion(); if (regionId > 0) { NomRegion region = db.Regions.Find(regionId); model.ID = region.ID; model.Name = region.Name; } return(PartialView("AddEditRegion", model)); }
public ActionResult DeleteRegion(int id) { try { NomRegion regionDb = db.Regions.Find(id); db.Regions.Remove(regionDb); db.SaveChanges(); DisplaySuccessMessage("Successfully deleted region!"); return(Json(true)); } catch (Exception ex) { DisplayErrorMessage("Region can't be deleted because there are countries/states in it!"); return(Json(false)); } }
protected void AddSearchFields() { NomRegion initial = new NomRegion(); initial.ID = -1; initial.Name = "Select region"; List <Models.NomRegion> list = new List <Models.NomRegion>(); list.Add(initial); list.AddRange(db.Regions); NomCountry initialC = new NomCountry(); initialC.ID = -1; initialC.Name = "Select country/state"; List <Models.NomCountry> listCountries = new List <Models.NomCountry>(); listCountries.Add(initialC); listCountries.AddRange(db.Countries.OrderBy(x => x.Name)); ViewBag.RegionId = new SelectList(list, "ID", "Name"); ViewBag.CountryId = new SelectList(listCountries, "ID", "Name"); }