public (IEnumerable <RoomTypeViewModel> roomTypes, int count) ReadRoomTypes(RoomTypeFilter filter)
{
var(roomTypes, count) = roomTypeRepository.ReadRoomTypes(filter);
var roomsModel = mapper.Map <IEnumerable <RoomTypeViewModel> >(roomTypes);
return(roomsModel, count);
}
public (IEnumerable <RoomType> roomTypes, int count) ReadRoomTypes(RoomTypeFilter filter)
{
var query = context.RoomTypes.Take(filter.Take).Skip(filter.Skip);
var roomTypes = query.ToList();
return(roomTypes, roomTypes.Count);
}
public IActionResult Index(int?pageNumber, RoomTypeFilter roomTypeFilter)
{
try
{
roomTypeFilter.Take = 5;
pageNumber ??= 1;
roomTypeFilter.Skip = (pageNumber.Value - 1) * roomTypeFilter.Take;
var(roomTypes, count) = roomTypeService.ReadRoomTypes(roomTypeFilter);
return(View(PaginatedList <RoomTypeViewModel> .Create(roomTypes, count, pageNumber.Value, roomTypeFilter.Take)));
}
catch (Exception)
{
return(BadRequest());
}
}
public (IEnumerable <RoomType> roomTypes, int count) ReadRoomTypes(RoomTypeFilter filter)
{
var roomTypes = new List <RoomType>();
var count = 0;
using (var conn = new SqlConnection(connectionString))
{
var cmd = new SqlCommand();
cmd.Connection = conn;
var selectCmd = $@"SELECT *
FROM RoomTypes
ORDER BY Id
OFFSET {filter.Skip} ROWS
FETCH NEXT {filter.Take} ROWS ONLY;
SELECT COUNT(*)
FROM RoomTypes;";
cmd.CommandText = selectCmd;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var rt = new RoomType
{
Id = dr.GetInt32("Id"),
Type = dr.GetString("RoomType"),
};
roomTypes.Add(rt);
}
dr.NextResult();
if (dr.Read())
{
count = dr.GetInt32(0);
}
}
}
return(roomTypes, count);
}
public ServiceResultModel <List <RoomTypeVM> > GetAllRoomTypes(RoomTypeFilter filter)
{
List <RoomTypeVM> resultList = new List <RoomTypeVM>();
using (EFBookingContext context = new EFBookingContext())
{
IQueryable <RoomType> roomTypeList = context.RoomTypes;
if (filter.Title.IsNotNull())
{
roomTypeList = roomTypeList.Where(p => p.Title.Contains(filter.Title));
}
roomTypeList.ToList().ForEach(p =>
{
resultList.Add(p.MapToViewModel <RoomTypeVM>());
});
return(ServiceResultModel <List <RoomTypeVM> > .OK(resultList));
}
}
