public IEnumerable <UserListItemModel> ListWithSearch(int startFrom, int endAt, int usersId)
{
try
{
SqlParameter startPaginationFrom = SetupSqlParameter("start", startFrom);
SqlParameter endPaginationAt = SetupSqlParameter("end", endAt);
SqlParameter loggedInUserId = SetupSqlParameter("userId", usersId);
return(m_context.Query <UserListItemModel>()
.FromSql("[dbo].[BID_GetUsers] @start, @end, @userId", startPaginationFrom, endPaginationAt, loggedInUserId));
}
catch (Exception ex)
{
throw new WebApiException(HttpStatusCode.BadRequest, UserErrorMessage.CouldNotFetchUserList, ex);
}
}
public IEnumerable <AuctionListItemModel> GetActiveAuctions(AuctionListRequestModel request, int startFrom, int endAt, DateTime auctionsFromDate)
{
try
{
string convertedCategoryIds = request.TopCategoryIds.IsNotSpecified() ? null : string.Join(',', request.TopCategoryIds.Select(t => t.ToString()));
string convertedTypeIds = request.TypeIds.IsNotSpecified() ? null : string.Join(',', request.TypeIds.Select(t => t.ToString()));
SqlParameter categoryIds = new SqlParameter
{
ParameterName = "selectedCategories",
Direction = ParameterDirection.Input,
Value = HandleNull(convertedCategoryIds),
SqlDbType = SqlDbType.Text
};
SqlParameter typeIds = new SqlParameter
{
ParameterName = "selectedTypes",
Direction = ParameterDirection.Input,
Value = HandleNull(convertedTypeIds),
SqlDbType = SqlDbType.Text
};
SqlParameter startPaginationFrom = new SqlParameter
{
ParameterName = "start",
Direction = ParameterDirection.Input,
Value = startFrom,
SqlDbType = SqlDbType.Int
};
SqlParameter endPaginationAt = new SqlParameter
{
ParameterName = "end",
Direction = ParameterDirection.Input,
Value = endAt,
SqlDbType = SqlDbType.Int
};
SqlParameter searchBy = new SqlParameter
{
ParameterName = "searchValue",
Direction = ParameterDirection.Input,
Value = HandleNull(request.SearchValue),
SqlDbType = SqlDbType.Text
};
SqlParameter loadFromDate = new SqlParameter
{
ParameterName = "fromDate",
Direction = ParameterDirection.Input,
Value = auctionsFromDate,
SqlDbType = SqlDbType.DateTime
};
return(m_context.Query <AuctionListItemModel>()
.FromSql("[dbo].[BID_GetAuctions] @selectedCategories, @selectedTypes, @start, @end, @searchValue, @fromDate", categoryIds, typeIds, startPaginationFrom, endPaginationAt, searchBy, loadFromDate));
}
catch (Exception ex)
{
throw new WebApiException(HttpStatusCode.BadRequest, AuctionErrorMessages.CouldNotFetchAuctionList, ex);
}
}