public async Task <IHttpActionResult> InsertCandidateSpend(CandidateSubmissionSpendViewModel model)
{
try
{
userId = User.Identity.GetUserId();
Helpers.Helpers.AddBaseProperties(model, "create", userId);
model.Files.All(x => { Helpers.Helpers.AddBaseProperties(x, "create", userId); return(true); });
return(Ok(await CandidateService.InsertCandidateExpenseSpent(model)));
}
catch (Exception)
{
throw;
}
}
public static tblCandidateSubmissionSpend ConvertTotblCandidateSubmissionSpend(this CandidateSubmissionSpendViewModel data)
{
return(new tblCandidateSubmissionSpend()
{
ID = Convert.ToInt64(data.ID),
PayPeriodID = data.PayPeriodID,
SpendCategoryID = data.SpendCategoryID,
PlacementID = data.PlacementID,
CurrentStatusID = data.CurrentStatusID,
Name = data.Name,
Description = data.Description,
Amount = data.Amount,
IsActive = data.isActive,
IsDeleted = data.isDeleted ?? false,
CreatedUserID = data.createdUserID,
UpdatedUserID = data.updatedUserID,
CreatedTimestamp = data.createdTimestamp ?? DateTime.Now,
UpdatedTimestamp = data.updatedTimestamp,
tblCandidateSubmissionSpendFiles = data?.CandidateSubmissionSpendFiles?
.Select(x => x.ConvertTotblCandidateSubmissionSpendFile())
.ToList()
});
}
public async Task <CandidateSubmissionSpendViewModel> UpdateCandidateExpenseSpent(CandidateSubmissionSpendViewModel data)
{
try
{
foreach (var a in data.Files)
{
CandidateSubmissionSpendFilesViewModel submittedfiles = new CandidateSubmissionSpendFilesViewModel();
var file = await Task.Run(() => ManageCandidate.InsertFiles(a.ConvertTotblFile()));
submittedfiles.FileID = file.ID;
submittedfiles.createdUserID = a.createdUserID;
submittedfiles.createdTimestamp = a.createdTimestamp;
submittedfiles.updatedTimestamp = a.updatedTimestamp;
submittedfiles.updatedUserID = a.updatedUserID;
data.CandidateSubmissionSpendFiles.Add(submittedfiles);
}
await Task.Run(() => ManageCandidateSubmissionSpendFiles.DeleteCandidateSubmissionSpendFiles(data.ID));
data.CandidateSubmissionSpendFiles.All(x => { x.SpendID = data.ID; return(true); });
tblCandidateSubmissionSpend res = await Task.Run(() => ManageCandidateSubmissionSpend.UpdateCandidateSubmissionSpend(data.ConvertTotblCandidateSubmissionSpend()));
List <tblCandidateSubmissionSpendFile> submittedFiles = await Task.Run(() => ManageCandidateSubmissionSpendFiles.InsertCandidateSubmissionSpendFiles(data.CandidateSubmissionSpendFiles.Select(x => x.ConvertTotblCandidateSubmissionSpendFile()).ToList()));
data.CandidateSubmissionSpendFiles = submittedFiles.Select(x => x.ConvertToCandidateSubmissionSpendFilesViewModel()).ToList();
return(data);
}
catch (Exception)
{
throw;
}
}
public async Task <CandidateSubmissionSpendViewModel> InsertCandidateExpenseSpent(CandidateSubmissionSpendViewModel data)
{
try
{
foreach (var a in data.Files)
{
CandidateSubmissionSpendFilesViewModel submittedfiles = new CandidateSubmissionSpendFilesViewModel();
var file = await Task.Run(() => ManageCandidate.InsertFiles(a.ConvertTotblFile()));
submittedfiles.FileID = file.ID;
submittedfiles.createdUserID = a.createdUserID;
submittedfiles.createdTimestamp = a.createdTimestamp;
submittedfiles.updatedTimestamp = a.updatedTimestamp;
submittedfiles.updatedUserID = a.updatedUserID;
data.CandidateSubmissionSpendFiles.Add(submittedfiles);
}
tblCandidateSubmissionSpend res = await Task.Run(() => ManageCandidateSubmissionSpend.InsertCandidateSubmissionSpend(data.ConvertTotblCandidateSubmissionSpend()));
return(res.ConvertToCandidateSubmissionSpendViewModel());
}
catch (Exception ex)
{
throw;
}
}
