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