public (IEnumerable <RoomStatus> roomStatuses, int count) ReadRoomStatuses(RoomStatusFilter filter)
{
var query = context.RoomStatuses.Take(filter.Take).Skip(filter.Skip);
var roomStatuses = query.ToList();
return(roomStatuses, roomStatuses.Count);
}
public IActionResult Index(int?pageNumber, RoomStatusFilter roomStatusFilter)
{
try
{
roomStatusFilter.Take = 5;
pageNumber ??= 1;
roomStatusFilter.Skip = (pageNumber.Value - 1) * roomStatusFilter.Take;
var(roomStatuses, count) = roomStatusService.ReadRoomStatuses(roomStatusFilter);
return(View(PaginatedList <RoomStatusViewModel> .Create(roomStatuses, count, pageNumber.Value, roomStatusFilter.Take)));
}
catch (Exception)
{
return(BadRequest());
}
}
public (IEnumerable <RoomStatus> roomStatuses, int count) ReadRoomStatuses(RoomStatusFilter filter)
{
var roomStatuses = new List <RoomStatus>();
var count = 0;
using (var conn = new SqlConnection(connectionString))
{
var cmd = new SqlCommand();
cmd.Connection = conn;
var selectCmd = $@"SELECT *
FROM RoomStatuses
ORDER BY Id
OFFSET {filter.Skip} ROWS
FETCH NEXT {filter.Take} ROWS ONLY;
SELECT COUNT(*)
FROM RoomStatuses;";
cmd.CommandText = selectCmd;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var rs = new RoomStatus
{
Id = dr.GetInt32("Id"),
Status = dr.GetString("RoomStatus"),
};
roomStatuses.Add(rs);
}
dr.NextResult();
if (dr.Read())
{
count = dr.GetInt32(0);
}
}
}
return(roomStatuses, count);
}
public GetRoomsRequest(RoomStatusFilter status, string category)
{
this.status = status;
this.category = category;
}
public GetRoomsRequest(RoomStatusFilter statusFilter, RoomCategoryFilter categoryFilter)
{
this.statusFilter = statusFilter;
this.categoryFilter = categoryFilter;
}
public (IEnumerable <RoomStatusViewModel> roomStatuses, int count) ReadRoomStatuses(RoomStatusFilter filter)
{
var(roomStatuses, count) = roomStatusRepository.ReadRoomStatuses(filter);
var roomsStatusModel = mapper.Map <IEnumerable <RoomStatusViewModel> >(roomStatuses);
return(roomsStatusModel, count);
}
