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