public List <SODetailsDB> GetDetailsFromJobOrderID(RequestDetailsFromJobOrderID data) { List <SODetailsDB> ResultSet = new List <SODetailsDB>(); using (IDbConnection connection = GetOpenConnection()) { try { var param = new DynamicParameters(); param.Add("@JobOrderID", data.JobOrderID); ResultSet = connection.Query <SODetailsDB>("SP_GetDetailsFromJobOrderID", param, commandType: CommandType.StoredProcedure).ToList(); } catch (Exception ex) { throw ex; } finally { if (connection != null) { connection.Close(); } } } return(ResultSet); }
public ResponseInfo <ResponseSODetails> GetDetailsFromJobOrderID([FromBody] RequestDetailsFromJobOrderID data) { try { return(base.PostDataToAPINotAuth <ResponseInfo <ResponseSODetails> >(base.apiPathAndQuery, data)); } catch (Exception ex) { throw ex; } }
public ResponseInfo <ResponseSODetails> GetDetailsFromJobOrderID([FromBody] RequestDetailsFromJobOrderID data) { ResponseInfo <ResponseSODetails> res = new ResponseInfo <ResponseSODetails>(); try { res = process.GetDetailsFromJobOrderID(data); } catch (Exception ex) { throw ex; } return(res); }
public ResponseInfo <ResponseSODetails> GetDetailsFromJobOrderID(RequestDetailsFromJobOrderID data) { ResponseInfo <ResponseSODetails> response = new ResponseInfo <ResponseSODetails>(); try { response.ResponseData = new ResponseSODetails(); var listData = EPODDAL.GetDetailsFromJobOrderID(data); response.ResponseData.sODetails = HelperUtil.GenerateSoDetailBase64String(listData); } catch (Exception ex) { throw ex; } return(response); }