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)); } }