public IActionResult Admin()
{
SkillsMatrixDB database = HttpContext.RequestServices.GetService(typeof(SkillsMatrix.Models.SkillsMatrixDB)) as SkillsMatrixDB;
ViewModel viewModel = new ViewModel();
viewModel.People = database.GetAllPeople();
return(View(viewModel));
}
public IActionResult ProjectsOverview()
{
SkillsMatrixDB database = HttpContext.RequestServices.GetService(typeof(SkillsMatrix.Models.SkillsMatrixDB)) as SkillsMatrixDB;
ViewModel viewModel = new ViewModel();
viewModel.Locations = database.GetAllLocations();
viewModel.SkillGroups = database.GetAllSkillGroups();
return(View(viewModel));
}
public IActionResult SkillsOverview()
{
SkillsMatrixDB database = HttpContext.RequestServices.GetService(typeof(SkillsMatrix.Models.SkillsMatrixDB)) as SkillsMatrixDB;
ViewModel viewModel = new ViewModel();
viewModel.Managers = database.GetAllManagers();
viewModel.Skills = database.GetAllSkills();
viewModel.People = database.GetAllPeople();
viewModel.Locations = database.GetAllLocations();
return(View(viewModel));
}
public async Task <ActionResult> Upload(UploadModel files)
{
ViewBag.Msg = "";
SkillsMatrixDB database = HttpContext.RequestServices.GetService(typeof(SkillsMatrix.Models.SkillsMatrixDB)) as SkillsMatrixDB;
int filesProcessed = 0;
List <string> distUnknownUsers = null;
List <string> ppmUnknownUsers = null;
// process the manager report
var filename = files.MgrReportFilename;
if (filename != null && filename.Length > 0)
{
filesProcessed++;
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", Path.GetFileName(filename.FileName));
using (var stream = new FileStream(path, FileMode.Create))
{
await filename.CopyToAsync(stream);
}
FileReaderModel reader = new FileReaderModel();
FileReaderModel.FileReaderResults dbResult = reader.AddManagerSkillsReport(database, path);
if (dbResult == FileReaderModel.FileReaderResults.FileReaderSuccess)
{
ViewBag.Msg = "Uploaded " + Path.GetFileName(filename.FileName) + " Successfuly";
}
else
{
ViewBag.Msg = "Upload of " + Path.GetFileName(filename.FileName) + " failed " + getErrorString(dbResult);
}
System.IO.File.Delete(path);
}
// now process the PPM report
filename = files.PpmFilename;
if (filename != null && filename.Length > 0)
{
filesProcessed++;
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", Path.GetFileName(filename.FileName));
using (var stream = new FileStream(path, FileMode.Create))
{
await filename.CopyToAsync(stream);
}
FileReaderModel reader = new FileReaderModel();
if (filesProcessed > 1)
{
ViewBag.Msg += "<br/>";
}
FileReaderModel.FileReaderResults dbResult = reader.AddPpmReport(database, path, out ppmUnknownUsers);
if (dbResult == FileReaderModel.FileReaderResults.FileReaderSuccess)
{
ViewBag.Msg += "Uploaded " + Path.GetFileName(filename.FileName) + " Successfuly";
}
else
{
ViewBag.Msg += "Upload of " + Path.GetFileName(filename.FileName) + " failed " + getErrorString(dbResult);
}
System.IO.File.Delete(path);
}
// now process the distribution report
filename = files.DistFilename;
if (filename != null && filename.Length > 0)
{
filesProcessed++;
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", Path.GetFileName(filename.FileName));
using (var stream = new FileStream(path, FileMode.Create))
{
await filename.CopyToAsync(stream);
}
FileReaderModel reader = new FileReaderModel();
if (filesProcessed > 1)
{
ViewBag.Msg += "<br/>";
}
FileReaderModel.FileReaderResults dbResult = reader.AddDistReport(database, path, out distUnknownUsers);
if (dbResult == FileReaderModel.FileReaderResults.FileReaderSuccess)
{
ViewBag.Msg += "Uploaded " + Path.GetFileName(filename.FileName) + " Successfuly";
}
else
{
ViewBag.Msg += "Upload of " + Path.GetFileName(filename.FileName) + " failed " + getErrorString(dbResult);
}
System.IO.File.Delete(path);
}
ViewModel viewModel = new ViewModel();
viewModel.Upload = new UploadModel();
if (ppmUnknownUsers != null)
{
viewModel.Upload.PpmUnknownUsers = ppmUnknownUsers;
}
else
{
viewModel.Upload.PpmUnknownUsers = new List <string>();
}
if (distUnknownUsers != null)
{
viewModel.Upload.DistUnknownUsers = distUnknownUsers;
}
else
{
viewModel.Upload.DistUnknownUsers = new List <string>();
}
return(View(viewModel));
}
