/// <summary>
/// Add interview request
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public int AddInterviewRequest(InterviewRequest request)
{
var context = new dbDataContext();
// look for any other requests and delete for that interview + contact
var requestsFound =
context.tbl_InterviewRequests.Where(
t => t.InterviewId == request.InterviewId && t.CandidateId == request.ContactId).ToList();
context.tbl_InterviewRequests.DeleteAllOnSubmit(requestsFound);
// add new contact request
var intRequest = new tbl_InterviewRequest
{
InterviewId = request.InterviewId,
CandidateId = request.ContactId,
RefId = string.IsNullOrEmpty(request.RefId) ? Guid.NewGuid().ToString() : request.RefId
};
if (intRequest.InterviewRequestId <= 0)
{
intRequest.CreatedDate = DateTime.Now;
context.tbl_InterviewRequests.InsertOnSubmit(intRequest);
}
context.SubmitChanges();
return intRequest.InterviewRequestId;
}
partial void Updatetbl_InterviewRequest(tbl_InterviewRequest instance);
partial void Deletetbl_InterviewRequest(tbl_InterviewRequest instance);
partial void Inserttbl_InterviewRequest(tbl_InterviewRequest instance);
