/// <summary>
/// This function deletes the applications
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool DeleteJobApplications(DeleteApplicationsHelper request)
{
var context = new dbDataContext();
var appIds = request.ApplicationIds.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (var appId in appIds)
{
var applciation =
context.tbl_JobApplications.FirstOrDefault(t => t.JobApplicationId == int.Parse(appId));
if (applciation != null)
{
//delete the history
var histories = context.tbl_Histories.Where(
t => t.SubRefId == int.Parse(appId) & t.SubRefType.Equals("JobApplication")).ToList();
context.tbl_Histories.DeleteAllOnSubmit(histories);
context.SubmitChanges();
//delete the app history
var appHistories = context.tbl_ApplicationStatusHistories.Where(
t => t.ApplicationId == int.Parse(appId)).ToList();
context.tbl_ApplicationStatusHistories.DeleteAllOnSubmit(appHistories);
context.SubmitChanges();
//delete the documents
var docTypes = new List<int> { 4, 5 };
var documents = context.tbl_Documents.Where(
t => t.RefId == applciation.CandidateId
&& t.SubRefId == applciation.JobId
&& docTypes.Contains(t.DocumentTypeValue)
).ToList();
context.tbl_Documents.DeleteAllOnSubmit(documents);
context.SubmitChanges();
//finally delete the application
context.tbl_JobApplications.DeleteOnSubmit(applciation);
context.SubmitChanges();
}
}
return false;
}
public bool DeleteJobApplications(DeleteApplicationsHelper request)
{
return new JobApplications().DeleteJobApplications(request);
}
