/// <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); }