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