partial void Inserttbl_ApplicationStatusHistory(tbl_ApplicationStatusHistory instance);
partial void Deletetbl_ApplicationStatusHistory(tbl_ApplicationStatusHistory instance);
/// <summary> /// Change candidate application status /// </summary> /// <param name="applicationIds"></param> /// <param name="appStatusId"></param> /// <returns></returns> public ApiResponse ChangeApplicationStatuses(string applicationIds, int appStatusId) { var context = new dbDataContext(); var response = new ApiResponse { IsError = false }; try { foreach (var applicationId in applicationIds.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries)) { var id = int.Parse(applicationId); var jobApp = context.tbl_JobApplications.FirstOrDefault(t => t.JobApplicationId == id); if (jobApp == null) continue; var appStatusHistory = new tbl_ApplicationStatusHistory { ApplicationStatusId = appStatusId, ApplicationId = id, UpdatedDate = DateTime.Now }; context.tbl_ApplicationStatusHistories.InsertOnSubmit(appStatusHistory); jobApp.ApplicationStatusId = appStatusId; } context.SubmitChanges(); } catch (Exception e) { response.ActualError = e.ToString(); response.ActualError = "Error changing the application status!"; } return response; }