public DynamicResponse <Process> GetLastProcessForSubmission(long submissionId) { #region Accessors SubmissionInProcessAccessor _SubmissionInProcessAccessor = new SubmissionInProcessAccessor(); ProcessAccessor _ProcessAccessor = new ProcessAccessor(); #endregion DynamicResponse <Process> response = new DynamicResponse <Process>(); try { //get the last submission in process SubmissionInProcess submissionInProcess = _SubmissionInProcessAccessor.GetLast(submissionId); Process process = new Process(); //if null, not assigned if (submissionInProcess == null) { //get process of not assigned process = _ProcessAccessor.Get(ProcessCodes.unassigned.ToString()); } //else get the process else { //get process by the id process = _ProcessAccessor.Get((long)submissionInProcess.ProcessId); } if (process == null) { //return error response.HttpStatusCode = HttpStatusCode.InternalServerError; response.Message = "Please try again later."; response.ServerMessage = "Process in empty"; return(response); } else { //return response with displayed name of the process response.HttpStatusCode = HttpStatusCode.OK; response.Data = process; return(response); } } catch (Exception ex) { //return error response.HttpStatusCode = HttpStatusCode.InternalServerError; response.Message = "Please try again later."; response.ServerMessage = ex.Message; return(response); } }
public SubmissionInProcess Add(SubmissionInProcess toAdd) { try { using (LMJEntities db = new LMJEntities()) { db.SubmissionInProcesses.Add(toAdd); db.SaveChanges(); } return(toAdd); } catch (Exception ex) { throw; } }
public SubmissionInProcess Get(long processId) { try { SubmissionInProcess data = new SubmissionInProcess(); using (LMJEntities db = new LMJEntities()) { data = db.SubmissionInProcesses.Where(e => e.ProcessId == processId).FirstOrDefault(); } return(data); } catch (Exception ex) { throw; } }
public SubmissionInProcess GetLast(long submissionId) { try { SubmissionInProcess data = new SubmissionInProcess(); using (LMJEntities db = new LMJEntities()) { data = db.SubmissionInProcesses.Where(e => e.SubmissionId == submissionId) .OrderByDescending(o => o.Id).FirstOrDefault(); } return(data); } catch (Exception ex) { throw; } }