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;
}
}
public async Task <CandidateSubmissionSpendViewModel> GetExpenseDetails(long ExpenseId)
{
try
{
tblCandidateSubmissionSpend res = await Task.Run(() => ManageCandidateSubmissionSpend.GetExpenseDetails(ExpenseId));
return(res.ConvertToCandidateSubmissionSpendViewModel());
}
catch (Exception)
{
throw;
}
}
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 static CandidateSubmissionSpendViewModel ConvertToCandidateSubmissionSpendViewModel(this tblCandidateSubmissionSpend data)
{
return(new CandidateSubmissionSpendViewModel()
{
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,
updatedTimestamp = data.UpdatedTimestamp,
Files = data.tblCandidateSubmissionSpendFiles?.Select(x => x?.tblFile?.ConvertToCandidateFileModel()).ToList(),
MSPPayperiod = data.tblMSPPayPeriod?.ConvertToMSPPayPeriodViewModel(),
MSPSpendCategory = data?.tblMSPSpendCategory?.ConvertToMSPSpendCategoryViewModel(),
TimesheetStatus = data?.tblTimesheetStatu?.ConvertToTimesheetStatusViewModel(),
CandidatePlacement = data?.tblCandidatePlacement?.ConvertToCandidatePlacementViewModel(),
CandidateSubmissionSpendFiles = data?.tblCandidateSubmissionSpendFiles?
.Select(x => x?.ConvertToCandidateSubmissionSpendFilesViewModel())
.ToList()
});
}
internal static async Task <tblCandidateSubmissionSpend> UpdateCandidateSubmissionSpend(tblCandidateSubmissionSpend model)
{
try
{
using (db = new eMSPEntities())
{
db.Entry(model).State = EntityState.Modified;
int x = await Task.Run(() => db.SaveChangesAsync());
return(model);
}
}
catch (Exception)
{
throw;
}
}
internal static async Task <tblCandidateSubmissionSpend> InsertCandidateSubmissionSpend(tblCandidateSubmissionSpend model)
{
try
{
using (db = new eMSPEntities())
{
var response = db.tblCandidateSubmissionSpends.Add(model);
int x = await Task.Run(() => db.SaveChangesAsync());
return(model);
}
}
catch (Exception ex)
{
throw;
}
}
