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