public List <SODetailsDB> GetJobListFromDriver(RequestJobListFromDriver data)
{
List <SODetailsDB> ResultSet = new List <SODetailsDB>();
using (IDbConnection connection = GetOpenConnection())
{
try
{
var param = new DynamicParameters();
param.Add("@UserID", data.UserID);
ResultSet = connection.Query <SODetailsDB>("SP_GetJobListFromDriver", param, commandType: CommandType.StoredProcedure).ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
return(ResultSet);
}
public ResponseInfo <ResponseSODetails> GetJobListFromDriver(RequestJobListFromDriver data)
{
ResponseInfo <ResponseSODetails> response = new ResponseInfo <ResponseSODetails>();
try
{
response.ResponseData = new ResponseSODetails();
var listData = EPODDAL.GetJobListFromDriver(data);
response.ResponseData.sODetails = HelperUtil.GenerateSoDetailBase64String(listData);
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
