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 <CandidateSubmissionCreateModel> UpdateCandidateSubmission(CandidateSubmissionCreateModel data)
{
try
{
CandidateSubmissionCreateModel model = null;
if (data.IsNewCustomer)
{
CandidateCreateModel candidate = await Task.Run(() => CreateCandidate(data.Candidate));
data.CandidateSubmission.CandidateId = candidate.Candidate.id;
}
if (data.IsCustomerEdited)
{
await Task.Run(() => UpdateCandidate(data.Candidate));
}
await Task.Run(() => ManageCandidate.UpdateCandidateSubmissions(data.CandidateSubmission.ConverToTblCandidateSubmission()));
await Task.Run(() => ManageCandidateSubmissionsQuestionsResponses.DeleteCandidateSubmissionsQuestionsRespons(data.CandidateSubmission.ID));
foreach (VacancyQuestionViewModel vq in data.Questions)
{
vq.CandidateSubmissionsQuestionsResponse.All(re =>
{
re.createdTimestamp = data.CandidateSubmission.createdTimestamp;
re.createdUserID = data.CandidateSubmission.createdUserID;
re.updatedUserID = data.CandidateSubmission.updatedUserID;
re.updatedTimestamp = data.CandidateSubmission.updatedTimestamp;
return(true);
});
await Task.Run(() => ManageCandidateSubmissionsQuestionsResponses.InsertCandidateSubmissionsQuestionsRespons(vq.CandidateSubmissionsQuestionsResponse.Select(re => re.ConvertTotblCandidateSubmissionsQuestionsRespons()).ToList()));
}
await Task.Run(() => ManageCandidateSubmissionDocumentResponses.DeleteCandidateSubmissionDocumentRespons(data.CandidateSubmission.ID));
foreach (VacancyRequiredDocumentViewModel rd in data.RequiredDocument)
{
rd.CandidateSubmissionDocumentResponse.All(re => {
re.createdTimestamp = data.CandidateSubmission.createdTimestamp;
re.createdUserID = data.CandidateSubmission.createdUserID;
re.updatedUserID = data.CandidateSubmission.updatedUserID;
re.updatedTimestamp = data.CandidateSubmission.updatedTimestamp;
return(true);
});
await Task.Run(() => ManageCandidateSubmissionDocumentResponses.InsertCandidateSubmissionDocumentRespons(rd.CandidateSubmissionDocumentResponse.Select(res => res.ConvertTotblCandidateSubmissionsQuestionsResponses()).ToList()));
}
return(model);
}
catch (Exception)
{
throw;
}
}
public async Task <CandidateCreateModel> UpdateCandidate(CandidateCreateModel data)
{
try
{
return(await Task.Run(() => ManageCandidate.Update(data)));
}
catch (Exception)
{
throw;
}
}
public async Task <List <SuplierCandidatePlacementModel> > GetSupplierCandidatePlacement(long SupplierId)
{
try
{
return(await Task.Run(() => ManageCandidate.GetSupplierCandidatePlacement(SupplierId)));
}
catch (Exception ex)
{
throw;
}
}
public async Task <CandidateCreateModel> GetCandidate(int CandidateId)
{
try
{
tblCandidate res = await Task.Run(() => ManageCandidate.GetCandidate(CandidateId));
return(res.ConvertToCandidateCreateModel());
}
catch (Exception)
{
throw;
}
}
public async Task <List <CandidateCreateModel> > GetAllCandidates(int SupplierId)
{
try
{
List <CandidateCreateModel> data = null;
List <tblCandidate> res = await Task.Run(() => ManageCandidate.GetAll(SupplierId));
data = res.Select(a => a.ConvertToCandidateCreateModel()).ToList();
return(data);
}
catch (Exception)
{
throw;
}
}
public async Task <CandidateCreateModel> CreateCandidate(CandidateCreateModel data)
{
try
{
CandidateCreateModel model = null;
CandidateCreateModel res = await Task.Run(() => ManageCandidate.Insert(data));
// model = res.ConvertToCandidateCreateModel();
return(model);
}
catch (Exception)
{
throw;
}
}
public async Task <List <CandidateStatusModel> > GetCandidateStatus()
{
try
{
List <CandidateStatusModel> model = null;
List <tblCandidateStatu> res = await Task.Run(() => ManageCandidate.GetAllCandidateStatus());
model = res.Select(a => a.ConvertToCandidateStatusModel()).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public async Task <List <CandidateSubmissionModel> > GetCandidateSubmission(int vacancyId)
{
try
{
List <CandidateSubmissionModel> model = null;
List <tblCandidateSubmission> res = await Task.Run(() => ManageCandidate.GetCandidateSubmission(Convert.ToInt64(vacancyId)));
model = res.Select(a => a.ConvertToCandidateSubmissionModel()).ToList();
return(model);
}
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;
}
}
