public static List <DTO.RoomDTO> GetRooms() { string stringquery = "select* from ROOM"; con = DataProvider.OpenConnection(); DataTable dt = DataProvider.ExcuteQuery(stringquery, con); if (dt.Rows.Count == 0) { return(null); } List <RoomDTO> listRoom = new List <RoomDTO>(); for (int i = 0; i < dt.Rows.Count; i++) { RoomDTO room = new RoomDTO(); room.IdRoom = int.Parse(dt.Rows[i]["id_Room"].ToString()); room.Name = dt.Rows[i]["name"].ToString(); room.Status = int.Parse(dt.Rows[i]["status"].ToString()); room.Kind_Of_Room = int.Parse(dt.Rows[i]["kind_Of_Room"].ToString()); room.Price = float.Parse(dt.Rows[i]["price"].ToString()); listRoom.Add(room); } return(listRoom); }
public async Task <bool> EditRoomAsync(RoomDTO room) { var path = Properties.Resources.editRoomPath; var result = await _apiHelper.Put(path, room); return(result != null && result.ResponseType == ResponseType.Success); }
public async Task <HotelRoomDTO> TranslateToDTO(HotelRoom hotelRoom) { List <AmenityDTO> amenityDTO = new List <AmenityDTO>(); foreach (var amenity in hotelRoom.Room.RoomAmenities) { amenityDTO.Add(await _amenity.GetAmenity(amenity.AmenitiesID)); } RoomDTO roomDTO = new RoomDTO() { ID = hotelRoom.Room.Id, Name = hotelRoom.Room.Name, Layout = hotelRoom.Room.Layout, Amenities = amenityDTO }; HotelRoomDTO hotelRoomDTO = new HotelRoomDTO() { HotelID = hotelRoom.HotelID, RoomNumber = hotelRoom.RoomNumber, PetFriendly = hotelRoom.PetFriendly, Rate = hotelRoom.Rate, RoomID = hotelRoom.RoomId, Room = roomDTO }; return(hotelRoomDTO); }
public async Task <RoomDTO> Update(RoomDTO model) { var pureModel = ConvertToPureModel(model); var updateModel = await _repository.Update(pureModel); return(await ConvertToDto(updateModel)); }
public RoomDTO GetRoomById(int roomId) { try { RoomDTO roomDTO = new RoomDTO(); Room room = _roomRepository.GetRoomById(roomId); roomDTO = new RoomDTO() { ID = room.ID, location = new LocationDTO() { ID = room.Location.ID, Name = room.Location.Name }, RoomName = room.RoomName, ComputerCount = room.ComputerCount, SeatCount = room.SeatCount, PhoneCount = room.PhoneCount, SmartRoom = room.SmartRoom, Active = room.Active }; _logger.Trace(LoggerHelper.ExecutedFunctionMessage(roomDTO, roomId)); return(roomDTO); } catch (Exception ex) { _logger.ErrorException("Unable to get room using roomid: " + roomId, ex); var result = new RoomDTO(); _logger.Trace(LoggerHelper.ExecutedFunctionMessage(result, roomId)); return(result); } }
public ActionResult DeleteConfirmed(Guid Id) { RoomDTO roomDto = roomService.GetRoomById(Id); roomService.DeleteRoom(roomDto); return(RedirectToAction("Index")); }
public ActionResult PutRoom(string id, RoomDTO values) { _roomService.Update(id,values); var room = _roomService.GetBy(id); return Ok(new { success = true, data = room }); }
public static PasswdMode CheckPassword(string pPlayerName, string pPassword) { //This method checks the password, to see if it correct PasswdMode result = GameModel.PasswdMode.AllBad; Player aPlayer = ds.getPlayer(pPlayerName, pPassword); //If the players data isn't empty/null if (aPlayer != null) { if (aPlayer.Password == pPassword) { //If the password entered is correct it returns ok result = GameModel.PasswdMode.OK; GameModel.currentPlayer = aPlayer; // << WATCHOUT THIS IS A SIDE EFFECT GameModel.currentLocaleDTO = GameModel.ds.GetPlayerLocation(GameModel.currentPlayer); Debug.Log("THIS IS CURRENT LOCATIONDTO"); Debug.Log(GameModel.currentLocaleDTO); GameModel.currentLocale = GameModel.AllRooms[currentLocaleDTO.ID]; } else { //If the password is null then there is a password needed result = GameModel.PasswdMode.NeedPassword; } } //If there is no name then the player is required to enter a name else { result = GameModel.PasswdMode.NeedName; } return(result); }
public async Task <RoomDTO> GetRoom(int id) { //look in the db on the room table where the id is //equal to the id that was brought in as an argument var room = await _context.Rooms.Where(x => x.Id == id) .Include(x => x.RoomAmenities) .FirstOrDefaultAsync(); RoomDTO dto = new RoomDTO { Name = room.Name, Layout = room.Layout.ToString(), Id = room.Id }; dto.Amenities = new List <AmenityDTO>(); foreach (var item in room.RoomAmenities) { dto.Amenities.Add(await _amenity.GetAmenity(item.AmenitiesId)); } // Convert the whole Room a RoomDTO // some foreach loop // for every amentity thats in there call // _amenities.GetAmentity(id) // which will return you a DTO return(dto); }
private void btnLuu_Click(object sender, EventArgs e) { RoomDTO infor = LayThongTinPhong(); if (btnThemPhong.Text == "Ngừng") { if (RoomBUS.ThemPhong(infor)) { MessageBox.Show("Bạn đã thêm phòng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); frmQuanLiPhong_Load(sender, e); KhoiTaoLai(); gcDanhSachPhong.Enabled = true; btnThemPhong.Text = "Thêm phòng"; } else { MessageBox.Show("Lỗi"); } } else if (btnCapNhat.Text == "Ngừng") { if (RoomBUS.SuaThongTinPhong(infor)) { MessageBox.Show("Bạn đã sửa thông tin phòng " + txtMaPhong.Text + " thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); frmQuanLiPhong_Load(sender, e); KhoiTaoLai(); gcDanhSachPhong.Enabled = true; btnCapNhat.Text = "Cập nhật"; } else { MessageBox.Show("Lỗi"); } } }
public RoomEntry(RoomDTO room) { RoomEntryViewModel.Errors = 0; InitializeComponent(); Messenger.Default.Send <RoomDTO>(room); Messenger.Reset(); }
public async Task Delete(int id) { RoomDTO room = await GetRoom(id); _context.Entry(room).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; await _context.SaveChangesAsync(); }
public async Task <RoomDTO> GetRoom(int id) { var room = await _context.Rooms.Where(x => x.ID == id) .Include(x => x.RoomAmenities) .FirstOrDefaultAsync(); RoomDTO dto = new RoomDTO { Name = room.Name, Layout = room.Layout.ToString(), ID = room.ID }; dto.Amenities = new List <AmenityDTO>(); foreach (var item in room.RoomAmenities) { dto.Amenities.Add(await _amenities.GetAmentity(item.AmenitiesID)); } // Convert the whole Room a RoomDTO // some foreach loop // for every amentity thats in there call // _amenities.GetAmentity(id) // which will return you a DTO return(dto); }
private void btnReserve_Click(object sender, RoutedEventArgs e) { int numRecord = ListRoom.SelectedIndex + 1; if (numRecord == 0) { MessageBox.Show("Для бронювання виберіть параметри"); } else { HotelServiceClient idRecord = new HotelServiceClient(); int _idRecord = idRecord.GetId(numRecord); RoomDTO room = new RoomDTO(); room = idRecord.GetRowById(_idRecord); ReserveRoom reserveRoom = new ReserveRoom(); DateTime aaa = Convert.ToDateTime(mwDateFrom.Text); DateTime bbb = Convert.ToDateTime(mwDateTo.Text); string ccc = Convert.ToString(bbb - aaa); int price = room.Price; reserveRoom.txtBlockType.Text = room.Name; reserveRoom.rrDateFrom.Text = mwDateFrom.Text; reserveRoom.rrDateTo.Text = mwDateTo.Text; reserveRoom.txtBlockCost.Text = price.ToString() + " грн."; reserveRoom.txtBlockInfo.Text = "14:00 " + reserveRoom.rrDateFrom.Text + " - 12:00 " + reserveRoom.rrDateTo.Text; reserveRoom._IDRecord = _idRecord; reserveRoom.Show(); } }
/// <summary> /// Gets a room object by id /// </summary> /// <param name="id">takes and int for the id</param> /// <returns>A single room DTO object</returns> public async Task <RoomDTO> GetRoom(int id) { Room room = await _context.Rooms.FindAsync(id); var list = await _context.RoomAmenities.Where(x => x.RoomId == id) .Include(x => x.Amenity) .ToListAsync(); List <AmenityDTO> amenities = new List <AmenityDTO>(); foreach (var item in list) { amenities.Add(await _amenities.GetAmenity(item.Amenity.Id)); } RoomDTO roomDTO = new RoomDTO() { ID = room.Id, Name = room.Name, Layout = room.Layout.ToString(), Amenities = amenities }; return(roomDTO); }
async private void DeleteRoom_Click(object sender, RoutedEventArgs e) { RoomDTO roomtodelete = (RoomDTO)RoomList.SelectedItem; await core.DeleteRoomAsync(roomtodelete.RoomID); LoadRoomsToDataGrid(BuildingID); }
// Start is called before the first frame update void Start() { //Sets the list of rooms to an array that can be pulled to set the players room Debug.Log(Rooms[0].roomName); for (int i = 0; i < 7; i++) { Room aRoom; aRoom = Rooms[i]; if (GameModel.AllRooms == null) { GameModel.AllRooms = new Room[7]; } Debug.Log("THIS IS ALL ROOMS"); Debug.Log(GameModel.AllRooms); //Takes the rooms and sets them out for the stored locations GameModel.AllRooms[i] = aRoom; RoomDTO aRoomDTO = new RoomDTO(); aRoomDTO.ID = i; aRoomDTO.roomName = aRoom.roomName; GameModel.ds.StoreLocation(aRoomDTO); } }
public async Task <RoomDTO> Insert(RoomDTO model) { var pureModel = ConvertToPureModel(model); var insertedModel = await _repository.Insert(pureModel); return(await ConvertToDto(insertedModel)); }
public ActionResult Update(RoomDTO roomdetails) { if (ModelState.IsValid) { Room room = new Room { Id = roomdetails.Id, Name = roomdetails.Name }; int result = DataService.Service.roomService.Update(room); if (result != 0) { return(RedirectToAction("Detail", new { id = room.Id })); } else { return(RedirectToAction("Update", new { id = room.Id })); } } else { return(RedirectToAction("Index")); } }
private void FormRoomEdit_Load(object sender, EventArgs e) { if (type.Equals("EDIT")) { lbTitle.Text = "Cập nhật phòng"; btnUpdate.Text = "Cập nhật"; RoomDTO roomDTO = roomBll.findOne(roomId); txtRoomName.Text = roomDTO.RoomName; txtRoomMoney.Text = roomDTO.RoomMoney.ToString(); txtElectricMoney.Text = roomDTO.ElectricMoney.ToString(); txtLastElectricNumber.Text = roomDTO.LastElectricNumber.ToString(); txtWaterMoney.Text = roomDTO.WaterMoney.ToString(); cbbWaterMoneyType.Text = roomDTO.WaterMoneyType; txtLastWaterNumber.Text = roomDTO.LastWaterNumber.ToString(); cbbNetworkMoneyType.Text = roomDTO.NetworkMoneyType; txtNetworkMoney.Text = roomDTO.NetworkMoney.ToString(); txtOtherMoney.Text = roomDTO.OtherMoney.ToString(); txtDescription.Text = roomDTO.Description; roomNameOld = roomDTO.RoomName; } else if (type.Equals("ADD")) { lbTitle.Text = "Thêm phòng"; btnUpdate.Text = "Thêm phòng"; } }
private void cmbRoomList_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbRoomList.SelectedIndex > 0) { RoomService service = new RoomService(); RoomDTO room = service.GetRoomDetail(Convert.ToInt32(cmbRoomList.SelectedValue)); lbRoomNumber.Text = room.RoomNumber.ToString(); lbRoomName.Text = room.RoomName; lbMaxOccupancy.Text = room.MaxOccupancy.ToString(); lbBaseRate.Text = room.BaseRate.ToString("C"); lbBedType.Text = room.BedType; lbRoomType.Text = room.RoomType; grpGuestInformation.Visible = true; } else { lbRoomNumber.Text = ""; lbRoomName.Text = ""; lbMaxOccupancy.Text = ""; lbBaseRate.Text = ""; lbBedType.Text = ""; lbRoomType.Text = ""; grpGuestInformation.Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public async Task <RoomDTO> GetRoom(int id, IAmenity amenity) { Room room = await _context.Rooms .Where(x => x.Id == id) .Include(x => x.RoomAmenities) .FirstOrDefaultAsync(); if (room == null) { return(null); } RoomDTO roomDTO = await _context.Rooms .Where(x => x.Id == id) .Select(x => new RoomDTO() { Id = x.Id, Name = x.Name, Layout = x.Layout }) .FirstOrDefaultAsync(); List <AmenityDTO> amenityDTOs = new List <AmenityDTO>(); foreach (RoomAmenities oneAmenity in room.RoomAmenities) { amenityDTOs.Add(await amenity.GetAmenity(oneAmenity.AmenityId)); } roomDTO.Amenities = amenityDTOs; return(roomDTO); }
// //make a call out to bring in amenities interface //make a new list // public async Task <RoomDTO> GetRoomByID(int roomId) { var room = await _context.Rooms.FindAsync(roomId); List <AmenitiesDTO> roomAmenityDTO = new List <AmenitiesDTO>(); foreach (var amenity in room.RoomAmenities) { var getAmenities = new AmenitiesDTO { ID = amenity.ID, Name = _context.Amenities.Find(amenity.AmenitiesID).Name, }; roomAmenityDTO.Add(getAmenities); } RoomDTO roomDto = new RoomDTO { Id = room.ID, Name = room.Name, Layout = room.Layout.ToString(), Amenities = roomAmenityDTO }; return(roomDto); }
private void Button_Click(object sender, RoutedEventArgs e) { RoomDTO tempRoom = new RoomDTO() { Floor = "two", Type = Project.Model.RoomType.medicalRoom, Ward = "op" }; AvailableAppoitments.Clear(); AvailableAppoitments.Add(new MedicalAppointmentDTO() { Room = tempRoom, Beginning = new DateTime(2020, 5, 10, 15, 0, 0), Type = Project.Model.MedicalAppointmentType.examination, End = new DateTime(2020, 5, 10, 15, 30, 0), IsScheduled = false }); AvailableAppoitments.Add(new MedicalAppointmentDTO() { Room = tempRoom, Beginning = new DateTime(2020, 5, 11, 15, 0, 0), Type = Project.Model.MedicalAppointmentType.examination, End = new DateTime(2020, 5, 11, 15, 30, 0), IsScheduled = false }); AvailableAppoitments.Add(new MedicalAppointmentDTO() { Room = tempRoom, Beginning = new DateTime(2020, 5, 12, 15, 0, 0), Type = Project.Model.MedicalAppointmentType.examination, End = new DateTime(2020, 5, 12, 15, 30, 0), IsScheduled = false }); AvailableAppoitments.Add(new MedicalAppointmentDTO() { Room = tempRoom, Beginning = new DateTime(2020, 5, 13, 15, 0, 0), Type = Project.Model.MedicalAppointmentType.examination, End = new DateTime(2020, 5, 13, 15, 30, 0), IsScheduled = false }); AvailableAppoitments.Add(new MedicalAppointmentDTO() { Room = tempRoom, Beginning = new DateTime(2020, 5, 14, 15, 0, 0), Type = Project.Model.MedicalAppointmentType.examination, End = new DateTime(2020, 5, 14, 15, 30, 0), IsScheduled = false }); ConfirmButton.IsEnabled = true; CancelButton.IsEnabled = true; ViewAvailableButton.IsEnabled = false; }
async private void Button_Click(object sender, RoutedEventArgs e) { if (newroomname.Text.Length > 0) { RoomDTO new_possible_code_room = room_being_edited; new_possible_code_room.Code = newroomname.Text; bool response = await core.EditRoomAsync(new_possible_code_room); if (response) { this.room_being_edited = new_possible_code_room; InitializeData(); MessageBox.Show("Successfully edited!"); Close(); } else { MessageBox.Show("Could not edit the room's code!"); } } else { MessageBox.Show("Code cannot be empty"); } }
public async Task <ActionResult> AddRoom([FromBody] RoomDTO newRoom, [FromRoute] long hotelId) { var newRoomView = mapper.Map <RoomDTO, RoomViewModel>(newRoom); await roomService.AddRoomAsync(newRoomView, hotelId); return(Ok()); }
private void btnReserve_Click(object sender, EventArgs e) { var client = new ClientDTO { FirstName = tbxFirstName.Text, LastName = tbxLastName.Text, Email = tbxEmail.Text, Phone = tbxPhone.Text }; _service.InsertClient(client); int clientId = _service.GetClientId(client.Email); int hotelId = _service.GetHotelId(cbxHotel.SelectedValue.ToString()); MessageBox.Show(hotelId.ToString()); string roomName = cbxRoom.SelectedValue.ToString(); bool approved = cbxStatus.Checked; var room = new RoomDTO { ClientId = clientId, HotelId = hotelId, Name = roomName, Approved = approved }; _service.InsertRoom(room); lbxClients.DataSource = _service.GetClients(); ResetInfo(); }
/// <summary> /// Event that do tasks on screen loading. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FormMain_Load(object sender, EventArgs e) { if (cbxRoom.SelectedValue != null) { roomDTO = roomBLL.LoadRoom(cbxRoom.SelectedValue.ToString()); } else { LoadRooms(); dtpWeekday.MinDate = DateTime.Today; dtpWeekday.MaxDate = DateTime.Today.AddDays(365); LoadStartHour(); } if (cbxRoom.SelectedValue != null) { bookingBLL = new BookingBLL(cbxRoom.SelectedValue.ToString()); if (bookingBLL != null) { bookingListAll = Functions.ConvertToList <BookingDTO>(bookingBLL.LoadXML()); } LoadBookings(); LoadAllBookings(); } tmrRefreshGrid.Interval = 60000; tmrRefreshGrid.Start(); }
public async Task ClearRoomAsync(RoomDTO roomDTO) { var searchedRoom = await _unitOfWork.RoomRepository .GetByIdAsync(roomDTO.Id); await _unitOfWork.RoomRepository.UpdateAsync(searchedRoom); }
public void EditRoom(RoomDTO roomDTO) { var room = MapperExtension.mapper.Map <RoomDTO, Room>(roomDTO); _db.Entry(_db.Rooms.Find(roomDTO.RoomID)).CurrentValues.SetValues(room); _db.SaveChanges(); }
public void AddRoom(RoomDTO roomDTO) { var room = MapperExtension.mapper.Map <RoomDTO, Room>(roomDTO); _db.Rooms.Add(room); _db.SaveChanges(); }
public JsonResult Update(RoomDTO dto) { var manager = this.GetManagerFor<IRoomManager>(); var result = manager.Update(dto); var resultDTO = new RoomDTO(result); return Json(resultDTO); }
public JsonResult Get(int id, IEnumerable<string> query) { var queries = new Query[] { }; if (query != null) { queries = query.Select(q => new Query { Name = q }).ToArray(); } var manager = this.GetManagerFor<IRoomManager>(); var result = manager.GetById(id); var resultDTO = new RoomDTO(queries, result); return Json(resultDTO); }