public async Task <IActionResult> Districts(string search, int page = 1)
{
PageTitle = "School Districts";
var filter = new BaseFilter(page)
{
Search = search
};
var districtList = await _schoolService.GetPaginatedDistrictListAsync(filter);
PaginateViewModel paginateModel = new PaginateViewModel()
{
ItemCount = districtList.Count,
CurrentPage = page,
ItemsPerPage = filter.Take.Value
};
if (paginateModel.MaxPage > 0 && paginateModel.CurrentPage > paginateModel.MaxPage)
{
return(RedirectToRoute(
new
{
page = paginateModel.LastPage ?? 1
}));
}
DistrictListViewModel viewModel = new DistrictListViewModel()
{
SchoolDistricts = districtList.Data.ToList(),
PaginateModel = paginateModel
};
return(View(viewModel));
}
public async Task <IActionResult> EditDistrict(DistrictListViewModel model)
{
try
{
if (model.TypeSelection == 1)
{
model.District.IsPrivate = true;
model.District.IsCharter = false;
}
else if (model.TypeSelection == 2)
{
model.District.IsPrivate = false;
model.District.IsCharter = true;
}
else
{
model.District.IsPrivate = false;
model.District.IsCharter = false;
}
model.District.Name = model.District.Name?.Trim();
await _schoolService.UpdateDistrictAsync(model.District);
ShowAlertSuccess($"School District '{model.District.Name}' updated");
}
catch (GraException gex)
{
ShowAlertDanger("Unable to edit School District: ", gex);
}
return(RedirectToAction("Districts", new { search = model.Search }));
}
public async System.Threading.Tasks.Task <ActionResult> Edit(DistrictListViewModel model)
{
System.Security.Claims.ClaimsPrincipal currentUserClaims = this.User;
var currentUser = await _userManager.GetUserAsync(currentUserClaims);
var regionId = (int)userRepo.FilteredGet().Where(x => x.Id == currentUser.Id).FirstOrDefault().RegionId;
int cityId = (int)regionRepo.FilteredGet().Where(x => x.Id == regionId).FirstOrDefault().CityId;
var availableResources = cityAuditRepo.FilteredGet().Where(x => x.CityId == cityId && x.ResourceId == model.ResourceId).FirstOrDefault() ?? new CityAudit();;
availableResources.TotalAvailable = availableResources.TotalAvailable - model.TotalNeeded;
cityAuditRepo.Update(availableResources);
var addedResource = auditRepo.FilteredGet().Where(x => x.RegionId == regionId && x.ResourceId == model.ResourceId).FirstOrDefault();
if (addedResource != null)
{
addedResource.TotalCountAvailable = addedResource.TotalCountAvailable + model.TotalNeeded;
auditRepo.Update(addedResource);
}
else
{
var res = new ResourceAudit
{
RegionId = regionId,
CityId = cityId,
ResourceId = model.ResourceId,
StateId = 1,
TotalCountAvailable = model.TotalNeeded,
};
auditRepo.Insert(res);
}
var request = distributerRequestRepo.FilteredGet().Where(x => x.Id == model.Id).FirstOrDefault();
distributerRequestRepo.Delete(request);
return(RedirectToActionPermanent("GetRequests"));
}
public async Task <IActionResult> Districts(int page = 1)
{
PageTitle = "School Districts";
int take = 15;
int skip = take * (page - 1);
var districtList = await _schoolService.GetPaginatedDistrictListAsync(skip, take);
PaginateViewModel paginateModel = new PaginateViewModel()
{
ItemCount = districtList.Count,
CurrentPage = page,
ItemsPerPage = take
};
if (paginateModel.MaxPage > 0 && paginateModel.CurrentPage > paginateModel.MaxPage)
{
return(RedirectToRoute(
new
{
page = paginateModel.LastPage ?? 1
}));
}
DistrictListViewModel viewModel = new DistrictListViewModel()
{
SchoolDistricts = districtList.Data.ToList(),
PaginateModel = paginateModel,
};
return(View(viewModel));
}
public ActionResult StaffInformation(DistrictListViewModel item, DistrictSchoolListViewModel ds)
{
if (ds.SelectedSchool != null)
{
var code = securityCodeCheck(ds.SelectedDistrict);
if (ds.DistrictCode == code.First().securityCode)
{
Session["schoolID"] = ds.SelectedSchool;
Session["leaID"] = ds.SelectedDistrict;
return(View());
}
else
{
return(RedirectToAction("SchoolDistrictInformation", "Staff"));
}
}
else
{
var code = securityCodeCheck(item.SelectedDistrict);
if (item.DistrictCode == code.First().securityCode)
{
Session["leaID"] = item.SelectedDistrict;
Session["schoolID"] = "";
return(View());
}
else
{
return(RedirectToAction("DistrictInformation", "Staff"));
}
}
}
public ActionResult DistrictInformation(StaffInformationViewModel s)
{
var viewModel = new DistrictListViewModel()
{
Districts = new SelectList(db.Districts.ToList(), "leaID", "name")
};
return(View(viewModel));
}
public async Task <IActionResult> EditDistrict(DistrictListViewModel model)
{
try
{
await _schoolService.UpdateDistrictAsync(model.District);
ShowAlertSuccess($"School District '{model.District.Name}' updated");
}
catch (GraException gex)
{
ShowAlertDanger("Unable to edit School District: ", gex);
}
return(RedirectToAction("Districts"));
}
public async Task <IActionResult> AddDistrict(DistrictListViewModel model)
{
try
{
await _schoolService.AddDistrict(model.District.Name);
ShowAlertSuccess($"Added School District '{model.District.Name}'");
}
catch (GraException gex)
{
ShowAlertDanger("Unable to add School District: ", gex);
}
return(RedirectToAction("Districts"));
}
public IActionResult Create(DistrictListViewModel d)
{
if (d is null)
{
throw new ArgumentNullException(nameof(d));
}
int i = _db.Database.ExecuteSqlRaw($"EXEC InsertDistrict @Name = '{d.Name}', @IsActive = {d.IsActive}, @StateID = {d.StateID}");
if (i > 0)
{
return(RedirectToAction("index"));
}
return(View());
}
