public async Task <IActionResult> GetReason([FromRoute] int id)
{
var reason = await _iRepo.Find(x => x.Id == id);
if (reason == null)
{
return(NotFound());
}
return(Ok(reason));
}
/// <summary>Uploads a List of CSVSessionUpload to the database</summary>
public async Task <int> UploadSessions(IEnumerable <CSVSessionUpload> sessionUploads)
{
var errorList = new List <string> ();
var personExistsErrors = (await Task.WhenAll(sessionUploads.Select(async x => {
var personExists = await personRepo.Exist(p => p.Email == x.Email);
if (!personExists)
{
return($"Person with Email: '{x.Email}' does not exist");
}
return(null);
}))).Where(x => x != null);
var classExistsErrors = (await Task.WhenAll(sessionUploads.SelectMany(x => x.CRNs).Select(async x => {
var classExists = await classRepo.Exist(c => c.CRN == x);
if (!classExists)
{
return($"Class with CRN: {x} does not exist");
}
return(null);
}))).Where(x => x != null);
var reasonExistsErrors = (await Task.WhenAll(sessionUploads.SelectMany(x => x.Reasons).Select(async x => {
var reasonExists = await reasonRepo.Exist(c => c.Name == x);
if (!reasonExists)
{
return($"Reason with Name: '{x}' does not exist");
}
return(null);
}))).Where(x => x != null);
var semesterExistError = (await Task.WhenAll(sessionUploads.Select(x => x.SemesterCode).Select(async x => {
var semesterExists = await semesterRepo.Exist(c => c.Code == x);
if (!semesterExists)
{
return($"Semester with Code: '{x}' does not exist");
}
return(null);
}))).Where(x => x != null);
errorList.AddRange(personExistsErrors);
errorList.AddRange(classExistsErrors);
errorList.AddRange(reasonExistsErrors);
errorList.AddRange(semesterExistError);
if (errorList.Count() != 0)
{
throw new TCSException(String.Join("\n", errorList));
}
var sessionList = await Task.WhenAll(sessionUploads.Select(async x => new Session()
{
Tutoring = x.Tutoring,
InTime = x.InTime,
OutTime = x.OutTime,
PersonId = (await personRepo.Find(p => p.Email == x.Email)).Id,
SemesterCode = x.SemesterCode,
SessionClasses = x.CRNs
.Select(c => new SessionClass()
{
ClassId = c
}).ToList(),
SessionReasons = await Task.WhenAll(x.Reasons
.Select(s => s.Trim())
.Select(async r => {
var reason = await reasonRepo.Find(re => re.Name == r);
return(new SessionReason()
{
ReasonId = reason.Id
});
}))
}));
return(await sessionRepo.Create(sessionList));
}
