public List <JobStatus> GetJobStatus(ReqJobStatus data) { List <JobStatus> ResultSet = new List <JobStatus>(); using (IDbConnection connection = GetOpenConnection()) { try { string sql = @"SELECT B.JobOrderID, B.ProcessStatusID, C.ProcessStatusName, B.ModifiedOn as ProcessStatusDateTime, B.IsCompleted FROM TruckVisualJobOrdersStatus B left join MasterProcessStatus C on B.ProcessStatusID = C.ProcessStatusID WHERE B.JobOrderID = @JobOrderID"; var param = new DynamicParameters(); param.Add("@JobOrderID", data.JobOrderID); ResultSet = connection.Query <JobStatus>(sql, param).ToList(); } catch (Exception ex) { throw ex; } finally { if (connection != null) { connection.Close(); } } return(ResultSet); } }
public ResponseInfo <RspJobStatus> GetJobStatus([FromBody] ReqJobStatus data) { try { return(base.PostDataToAPINotAuth <ResponseInfo <RspJobStatus> >(base.apiPathAndQuery, data)); } catch (Exception ex) { throw ex; } }
public ResponseInfo <RspJobStatus> GetJobStatus([FromBody] ReqJobStatus data) { ResponseInfo <RspJobStatus> res = new ResponseInfo <RspJobStatus>(); try { res = process.GetJobStatus(data); } catch (Exception ex) { throw ex; } return(res); }
public ResponseInfo <RspJobStatus> GetJobStatus(ReqJobStatus data) { ResponseInfo <RspJobStatus> response = new ResponseInfo <RspJobStatus>(); try { response.ResponseData = new RspJobStatus(); response.ResponseData.jobStatus = SODAL.GetJobStatus(data); } catch (Exception ex) { throw ex; } return(response); }