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