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