public List <ProductResponseEntities> GetAllProduct(PaggingRequestEntities productRequestEntities) { productRequestEntities.SearchByText = productRequestEntities.SearchByText == null ? "" : productRequestEntities.SearchByText; productRequestEntities.SearchByValue = productRequestEntities.SearchByValue == null ? "" : productRequestEntities.SearchByValue; DataSet dataset = ProductRepositoryQuery.GetData(productRequestEntities); return(dataset.Tables[0].DataTableToListObject <ProductResponseEntities>()); }
public IActionResult Get([FromQuery] PaggingRequest productViewRequest) { PaggingRequestEntities productRequestEntities = Mapper.Map <PaggingRequest, PaggingRequestEntities>(productViewRequest); List <ProductViewResponse> productViewEntities = Mapper.Map <List <ProductResponseEntities>, List <ProductViewResponse> >(productViewController.GetProduct(productRequestEntities)); baseJsonResponse.Data = productViewEntities ?? throw new DataNotExistException(); return(Ok(baseJsonResponse)); }
public List <ProductResponseEntities> GetProduct(PaggingRequestEntities productRequestEntities) { database.Connect(); List <ProductResponseEntities> data = productEnricher.GetAllProduct(productRequestEntities); database.Close(); database.Dispose(); return(data); }
public DataSet GetData(PaggingRequestEntities paggingRequestEntities) { string query = DatabaseUtil.ReadSQLQueriesFromResourceFile("GetData", typeof(ProductQuery)); return(database.ExecDataSet(query, DatabaseUtil.ObjectToParamSP(paggingRequestEntities))); }