public async Task <ProductEntity> GetById(long id) { var query = "SELECT * FROM product WHERE id = @id"; var param = new { @id = id }; var result = await DbQueryAsync <dynamic>(query, param); return(ProductEntityMapper.MapToProductEntities(result).FirstOrDefault()); }
public async Task <IEnumerable <ProductEntity> > GetAll(int batteryType, string queryType, int?queryStatus = null, int?pageSize = null, int?pageNumber = null) { var query = $"SELECT * FROM product"; if (pageSize != null) { query += $"{Environment.NewLine} LIMIT {pageSize}"; if (pageNumber != null) { query += $" OFFSET {pageSize * pageNumber}"; } } var result = await DbQueryAsync <dynamic>(query); return(ProductEntityMapper.MapToProductEntities(result)); }