public async Task <IActionResult> GetTemplateColumnsAsync()
{
var Result = new PLSOResponse <List <ExcelTemplate> >();
if (ModelState.IsValid)
{
Result = await excelTemplateRepo.GetTemplateColumnsAsync();
}
else
{
return(BadRequest(Result));
}
return(Ok(Result));
}
public PLSOResponse AddRecordFromExcel(Record record)
{
var Result = new PLSOResponse();
try {
DataContext.Records.Add(record);
DataContext.SaveChanges();
Result.WasSuccessful = true;
} catch (Exception e) {
Result.AddMessage(e, nameof(AddRecordFromExcel));
logger.LogError(2, e, "Unable to Save Record from Excel");
}
return(Result);
}
public async Task <PLSOResponse <List <ExcelTemplate> > > GetTemplateColumnsAsync()
{
var Result = new PLSOResponse <List <ExcelTemplate> >();
try {
Result.Result = await DataContext.ExcelTemplates
.OrderBy(x => x.ColumnIndex)
.ToListAsync();
Result.WasSuccessful = true;
} catch (Exception e) {
Result.AddMessage(e, nameof(GetTemplateColumnsAsync));
logger.LogError(1, e, "Unable to gather ExcelTemplate records");
}
return(Result);
}
public async Task <PLSOResponse <List <Record> > > GetRecordsAwaitingApproval()
{
var Result = new PLSOResponse <List <Record> >();
try {
Result.Result = await DataContext.Records
.Where(x => x.Approved == false)
.ToListAsync();
Result.WasSuccessful = true;
} catch (Exception e) {
Result.AddMessage(e, nameof(GetRecordsAwaitingApproval));
logger.LogError(1, e, "Unable to gather records awaiting approval");
}
return(Result);
}
public async Task <PLSOResponse <Record> > GetRecordById(int id)
{
var Result = new PLSOResponse <Record>();
try {
Result.Result = await DataContext.Records
.Where(x => x.ID == id)
.FirstOrDefaultAsync();
Result.WasSuccessful = true;
} catch (Exception e) {
Result.AddMessage(e, nameof(GetRecordById));
logger.LogError(3, e, "Unable to gather record");
}
return(Result);
}
public async Task <PLSOResponse> ApproveRecords(List <int> ids)
{
var Result = new PLSOResponse();
try {
foreach (var id in ids)
{
Record r = await DataContext.Records.FindAsync(id);
r.Approved = true;
r.Active = true;
}
DataContext.SaveChanges(UserID);
Result.WasSuccessful = true;
} catch (Exception e) {
Result.AddMessage(e, nameof(ApproveRecords));
logger.LogError(2, e, "Unable to approve record(s)");
}
return(Result);
}
