private void btn_Click(object sender, EventArgs e)
{
int id_room = (int)((sender as Button).Tag as Room_DTO).Id_room;
this.room = id_room;
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.room);
if (room.Locked == true)
{
Reservation_room_DTO reservation_room = Reservation_room_BUS.Instance.GetInfoReservationRoom(this.room);
Calendar_DTO calendar = Calendar_BUS.Instance.GetInfoCalendarLaster(reservation_room.Reservation.Id_reservation);
Reservation_DTO reservation = Reservation_BUS.Instance.GetInfoReservation(reservation_room.Reservation.Id_reservation);
lb_name.Text = reservation.Customer.Name.ToString();
lb_reservation.Text = reservation_room.Reservation.Id_reservation.ToString();
lb_startdate.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
lb_type_room.Text = room.Kind_of_room.Name.ToString();
lb_people.Text = room.Kind_of_room.People.ToString();
}
else
{
lb_name.Text = "Nope";
lb_reservation.Text = "Nope";
lb_startdate.Text = "Nope";
lb_end_date.Text = "Nope";
lb_type_room.Text = room.Kind_of_room.Name.ToString();
lb_people.Text = room.Kind_of_room.People.ToString();
}
}
public Reservation_room_DTO GetInfoReservationRoom(int id_room)
{
string query = "exec USP_GetInfoReservationRoom @id_room";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_room });
Reservation_room_DTO reservation_room = new Reservation_room_DTO();
foreach (DataRow item in table.Rows)
{
reservation_room.Reservation.Id_reservation = (int)item["id_reservation"];
}
return(reservation_room);
}
public List <Reservation_room_DTO> GetListHistoryRoom(int id_reservation)
{
string query = "exec USP_GetHistory @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
List <Reservation_room_DTO> list_reservation_room = new List <Reservation_room_DTO>();
foreach (DataRow item in table.Rows)
{
Reservation_room_DTO reservation_room = new Reservation_room_DTO();
reservation_room.Id_reservation_room = (int)item["id_reservation"];
reservation_room.Reservation.Id_reservation = (int)item["id_reservation"];
reservation_room.Room.Id_room = (int)item["id_room"];
reservation_room.Room.Num_floor = (int)item["num_floor"];
reservation_room.Room.Num_order = (int)item["num_order"];
reservation_room.Using = (int)item["using"];
list_reservation_room.Add(reservation_room);
}
return(list_reservation_room);
}
public List <Reservation_room_DTO> Get_ListReservation_Using(int id_reservation)
{
string query = "exec USP_GetListReservationRoomUsing @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
List <Reservation_room_DTO> list_reservation_using = new List <Reservation_room_DTO>();
foreach (DataRow item in table.Rows)
{
Reservation_room_DTO reservation_room = new Reservation_room_DTO();
reservation_room.Id_reservation_room = (int)item["id_reservation_room"];
reservation_room.Room.Id_room = (int)item["id_room"];
reservation_room.Room.Num_floor = (int)item["num_floor"];
reservation_room.Room.Num_order = (int)item["num_order"];
reservation_room.Room.Kind_of_room.Name = item["name"].ToString();
reservation_room.Room.Kind_of_room.People = (int)item["people"];
reservation_room.Room.Kind_of_room.Price = (decimal)item["price"];
list_reservation_using.Add(reservation_room);
}
return(list_reservation_using);
}
private void LoadData()
{
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.id_room);
if (room.Locked == true)
{
Reservation_room_DTO reservation_room = Reservation_room_BUS.Instance.GetInfoReservationRoom(this.id_room);
Calendar_DTO calendar = Calendar_BUS.Instance.GetInfoCalendarLaster(reservation_room.Reservation.Id_reservation);
Reservation_DTO reservation = Reservation_BUS.Instance.GetInfoReservation(reservation_room.Reservation.Id_reservation);
lb_id_reservation.Text = reservation.Id_reservation.ToString();
lb_customer.Text = reservation.Customer.Name.ToString();
lb_group.Text = reservation.Is_group.ToString();
lb_people_reservation.Text = reservation.People.ToString();
lb_start_date.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
if (reservation.Status_reservation == 0)
{
lb_status_reservation.Text = "Cancel";
}
else
{
if (reservation.Status_reservation == 1)
{
lb_status_reservation.Text = "Success";
}
else if (reservation.Status_reservation == 2)
{
lb_status_reservation.Text = "Not paid";
}
else
{
lb_status_reservation.Text = "Not deposit";
}
}
lb_floor.Text = room.Num_floor.ToString();
lb_order.Text = room.Num_order.ToString();
lb_type_room.Text = room.Kind_of_room.Name.ToString();
lb_people.Text = room.Kind_of_room.People.ToString();
CultureInfo cul = new CultureInfo("vi-VN");
lb_price.Text = room.Kind_of_room.Price.ToString("c", cul);
lb_staff.Text = room.Username.ToString();
if (room.Locked == true)
{
lb_status.Text = "Active";
}
else
{
lb_status.Text = "Empty";
}
}
else
{
lb_id_reservation.Text = "Nope";
lb_customer.Text = "Nope";
lb_group.Text = "Nope";
lb_people_reservation.Text = "Nope";
lb_start_date.Text = "Nope";
lb_end_date.Text = "Nope";
lb_status_reservation.Text = "Nope";
lb_floor.Text = room.Num_floor.ToString();
lb_order.Text = room.Num_order.ToString();
lb_type_room.Text = room.Kind_of_room.Name.ToString();
lb_people.Text = room.Kind_of_room.People.ToString();
CultureInfo cul = new CultureInfo("vi-VN");
lb_price.Text = room.Kind_of_room.Price.ToString("c", cul);
lb_staff.Text = room.Username.ToString();
if (room.Locked == true)
{
lb_status.Text = "Active";
}
else
{
lb_status.Text = "Empty";
}
}
List <Stuff_detail_DTO> list_stuff = BUS.Stuff_detail_BUS.Instance.Get_List(room.Kind_of_room.Id);
foreach (Stuff_detail_DTO stuff in list_stuff)
{
ListViewItem item = new ListViewItem(stuff.Stuff.Id_stuff.ToString());
item.SubItems.Add(stuff.Stuff.Name_stuff);
item.SubItems.Add(stuff.Number.ToString());
listView1.Items.Add(item);
}
lb_used.Text = BUS.Analytic_BUS.Instance.CountUsingRoom(room.Id_room).ToString();
lb_stuff.Text = BUS.Analytic_BUS.Instance.CountStuffInRoom(room.Kind_of_room.Id).ToString();
}
