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