public DtoRooms GetAllRooms() { DataModels.ConferenceRoomBookingContext context = ConferenceRoomBookingContext; var objRooms = context.Rooms; DtoRooms room = new DtoRooms(); room.Rooms = objRooms.ToList(); room.Total = context.Rooms.Count(); return(room); }
public void TestGetBookings110StatusCode204() { var mockBookingServiceRepository = new Mock <IRoomBookingServiceRepository>(); DtoRooms objDtoRooms = null; mockBookingServiceRepository.Setup(m => m.GetAvialableRoom(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <int>(), It.IsAny <int>())).Returns(objDtoRooms); RoomsController objBookingController = new RoomsController(mockBookingServiceRepository.Object); IActionResult response = objBookingController.GetAvialableRoom("2019-02-08 12:00:00.000", "2019-02-08 12:10:00.000"); Assert.AreEqual(204, ((Microsoft.AspNetCore.Mvc.StatusCodeResult)response).StatusCode); }
public void TestGetBookingsStatusCode204() { var mockBookingServiceRepository = new Mock <IRoomBookingServiceRepository>(); DtoRooms objDtoRooms = null; mockBookingServiceRepository.Setup(m => m.GetAllRooms()).Returns(objDtoRooms); RoomsController objBookingController = new RoomsController(mockBookingServiceRepository.Object); IActionResult response = objBookingController.GetBookings(); Assert.AreEqual(204, ((Microsoft.AspNetCore.Mvc.StatusCodeResult)response).StatusCode); }
public void TestGetBookings110StatusCode200() { var mockBookingServiceRepository = new Mock <IRoomBookingServiceRepository>(); DtoRooms objDtoRooms = new DtoRooms(); objDtoRooms.Total = 10; objDtoRooms.Rooms = new System.Collections.Generic.List <WebAppServices.DataModels.Rooms>(); mockBookingServiceRepository.Setup(m => m.GetAvialableRoom(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <int>(), It.IsAny <int>())).Returns(objDtoRooms); RoomsController objBookingController = new RoomsController(mockBookingServiceRepository.Object); IActionResult response = objBookingController.GetAvialableRoom("2019-02-08 12:00:00.000", "2019-02-08 12:10:00.000"); Assert.AreEqual(200, ((Microsoft.AspNetCore.Mvc.ObjectResult)response).StatusCode); }
public void TestGetBookingsStatusCode200() { var mockBookingServiceRepository = new Mock <IRoomBookingServiceRepository>(); DtoRooms objDtoRooms = new DtoRooms(); objDtoRooms.Total = 10; objDtoRooms.Rooms = new System.Collections.Generic.List <WebAppServices.DataModels.Rooms>(); mockBookingServiceRepository.Setup(m => m.GetAllRooms()).Returns(objDtoRooms); RoomsController objBookingController = new RoomsController(mockBookingServiceRepository.Object); IActionResult response = objBookingController.GetBookings(); Assert.AreEqual(200, ((Microsoft.AspNetCore.Mvc.ObjectResult)response).StatusCode); }
public IActionResult GetBookings() { try { DtoRooms returnValue = _repository.GetAllRooms(); if (returnValue != null && returnValue.Total > 0) { return(Ok(returnValue)); } return(NoContent()); } catch (Exception exp) { if (_logger != null) { _logger.LogCritical(string.Format("Exception for {0}/{1}", "GetBookings", GetInnerErrorMessage(exp))); } return(BadRequest()); } }
public IActionResult GetAvialableRoom(string bookIn, string bookOut) { try { int currentPage = 0, pageSize = 10; DtoRooms returnValue = _repository.GetAvialableRoom(bookIn, bookOut, currentPage, pageSize); if (returnValue != null && returnValue.Total > 0) { return(Ok(returnValue)); } return(NoContent()); } catch (Exception exp) { if (_logger != null) { _logger.LogCritical(string.Format("Exception for {0}", "GetBookings With", GetInnerErrorMessage(exp))); } return(BadRequest()); } }
public DtoRooms GetAvialableRoom(string bookIn, string bookOut, int currentPage, int pageSize) { DtoRooms room = new DtoRooms(); List <DataModels.Rooms> objRooms = new List <Rooms>(); using (var connection = new SqlConnection("Server=.\\SQLEXPRESS;Database=ConferenceRoomBooking;Trusted_Connection=True;")) { using (var command = new SqlCommand("sp_CheckRoomAvialable", connection) { CommandType = CommandType.StoredProcedure }) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@BookingTimeIn", Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm:ss}", bookIn.Trim()), CultureInfo.CurrentCulture))); command.Parameters.Add(new SqlParameter("@BookingTimeOut", Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm:ss}", bookOut.Trim()), CultureInfo.CurrentCulture))); connection.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); objRooms = (from DataRow row in dt.Rows select new Rooms { RoomId = (long)row["RoomId"], RoomName = (string)row["RoomName"], RoomStatus = (long)row["RoomStatus"] }).ToList(); room.Total = dt.Rows.Count; room.Rooms = objRooms.ToList(); connection.Close(); } } return(room); }