private void addToolStripMenuItem_Click(object sender, EventArgs e)
{
Room_DTO room = Room_BUS.Instance.Get_Info_Room(id_room);
this.list_room.Add(room);
LoadListView();
}
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();
}
}
private void fStuff_detail_Load(object sender, EventArgs e)
{
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.id_room);
lb_room.Text = "Room " + ((room.Num_floor * 100) + room.Num_order).ToString();
Load_Combobox();
Load_Data();
}
private void fService_ticket_Load(object sender, EventArgs e)
{
Load_CB_Service();
Load_Data();
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.id_room);
lb_room.Text = "Room " + ((room.Num_floor * 100) + room.Num_order).ToString();
}
private void Load_Info_Room()
{
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.id_room);
nud_floor.Value = room.Num_floor;
nud_order.Value = room.Num_order;
cb_staff.Text = room.Username;
cb_type.Text = room.Kind_of_room.Name;
}
private void btnEditRoom_Click(object sender, EventArgs e)
{
string id = idRoom.Text;
string sn = snRoom.Text;
string area = areaRoom.Text;
string status = statusRoom.Text;
Room_DTO room = new Room_DTO(id, sn, area, status);
Room_BUS.EditRoom(room);
}
private void btn_eyes_Click(object sender, RoutedEventArgs e)
{
Button temp = sender as Button;
Room_DTO room = temp.DataContext as Room_DTO;
if (manage_bed != null)
{
manage_bed.Invoke(room.roomID.ToString());
}
}
private void Load_Room_Using()
{
Bill_DTO bill = Bill_BUS.Instance.GetInfoBill(this.id_bill);
List <Reservation_room_DTO> list_room = Reservation_room_BUS.Instance.Get_ListReservation_Using(bill.Reservation.Id_reservation);
foreach (Reservation_room_DTO reservation_room in list_room)
{
ListViewItem item = new ListViewItem(((reservation_room.Room.Num_floor * 100) + reservation_room.Room.Num_order).ToString());
item.SubItems.Add(((double)reservation_room.Room.Kind_of_room.Price * xmod_room).ToString());
item.SubItems.Add("Using");
lv_room.Items.Add(item);
}
List <Log_swap_room_DTO> list_room_cancel = Log_swap_room_BUS.Instance.ListRoomCancel(bill.Reservation.Id_reservation);
foreach (Log_swap_room_DTO reservation_room in list_room_cancel)
{
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(bill.Reservation.Id_reservation);
Room_DTO room = Room_BUS.Instance.Get_Info_Room(reservation_room.Reservation_room.Room.Id_room);
double xmod_room_cancel = 0;
TimeSpan interval = calendar.Start_date.Subtract(reservation_room.Created);
if (interval.Days < 1)
{
if (interval.Hours < 2)
{
xmod_room_cancel = 0.25;
}
else if (interval.Hours < 6)
{
xmod_room_cancel = 0.5;
}
else
{
xmod_room_cancel = 1;
}
}
else
{
if (interval.Hours > 6)
{
xmod_room_cancel = interval.Days + 0.5;
}
}
ListViewItem item = new ListViewItem(((room.Num_floor * 100) + room.Num_order).ToString());
item.SubItems.Add(((double)room.Kind_of_room.Price * xmod_room_cancel).ToString());
item.SubItems.Add("Cancel");
lv_room.Items.Add(item);
}
}
public List <Room_DTO> List_Room_By_Type(int id_kind_of_room)
{
string query = "exec USP_GetListRoomByKindOfRoom @id_kind_of_room";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_kind_of_room });
List <Room_DTO> list = new List <Room_DTO>();
foreach (DataRow item in table.Rows)
{
Room_DTO room = new Room_DTO(item);
list.Add(room);
}
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
string id = idAddRoom.Text;
string sn = seatNumberAddRoom.Text;
string area = areaAddRoom.Text;
string status = statusAddRoom.Text;
Room_DTO room = new Room_DTO(id, sn, area, status);
Room_BUS.AddRoom(room);
MessageBox.Show("Complete!", "Add a room", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
public Room_DTO Get_Info_Room(int id_room)
{
string query = "exec USP_GetInfoRoom @id_room";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_room });
Room_DTO room = null;
foreach (DataRow item in table.Rows)
{
room = new Room_DTO(item);
}
return(room);
}
public List <Room_DTO> Get_List_Room_Floor(int floor)
{
string query = "exec USP_Get_ListRoom_Floor @floor";
DataTable room_floor = Connect.Instance.ExecuteQuery(query, new object[] { floor });
List <Room_DTO> list_room = new List <Room_DTO>();
foreach (DataRow item in room_floor.Rows)
{
Room_DTO room = new Room_DTO(item);
list_room.Add(room);
}
return(list_room);
}
private void Load_Data()
{
lv_stuff_detail.Items.Clear();
Room_DTO room = Room_BUS.Instance.Get_Info_Room(this.id_room);
List <Stuff_detail_DTO> list_stuff_detail = Stuff_detail_BUS.Instance.Get_List(room.Kind_of_room.Id);
foreach (Stuff_detail_DTO stuff_detail in list_stuff_detail)
{
ListViewItem lvitem = new ListViewItem(stuff_detail.Stuff.Name_stuff.ToString());
lvitem.SubItems.Add(stuff_detail.Kind_of_room.Name.ToString());
lvitem.SubItems.Add(stuff_detail.Number.ToString());
lv_stuff_detail.Items.Add(lvitem);
}
txt_type_room.Text = room.Kind_of_room.Name;
}
//Add a room
public static void AddRoom(Room_DTO room)
{
SqlConnection connecter = sqlConnectionData.Connecter();
SqlCommand commander = new SqlCommand("AddRoom", connecter);
commander.CommandType = CommandType.StoredProcedure;
commander.Parameters.Add("@id", SqlDbType.Char, 10).Value = room.Id;
commander.Parameters.Add("@sn", SqlDbType.Int).Value = room.Seatnumber;
commander.Parameters.Add("@area", SqlDbType.VarChar, 20).Value = room.Area;
commander.Parameters.Add("@status", SqlDbType.NVarChar, 50).Value = room.Status;
connecter.Open();
commander.ExecuteNonQuery();
connecter.Close();
}
private void Load_Service_Using()
{
Bill_DTO bill = Bill_BUS.Instance.GetInfoBill(this.id_bill);
List <Service_ticket_DTO> list_service_by_reservation = Service_ticket_BUS.Instance.Get_ListServiceReservation(bill.Reservation.Id_reservation);
foreach (Service_ticket_DTO service_by_reservation in list_service_by_reservation)
{
ListViewItem item = new ListViewItem(service_by_reservation.Service.Id_service.ToString());
item.SubItems.Add(service_by_reservation.Service.Name_service.ToString());
item.SubItems.Add(service_by_reservation.Service.Price.ToString());
item.SubItems.Add(service_by_reservation.Number.ToString());
Room_DTO room = Room_BUS.Instance.Get_Info_Room(service_by_reservation.Reservation_room.Room.Id_room);
item.SubItems.Add(((room.Num_floor * 100) + room.Num_order).ToString());
lv_service.Items.Add(item);
}
}
private double Get_Money_Cancel_Room(int id_reservation)
{
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(id_reservation);
List <Log_swap_room_DTO> list_log = Log_swap_room_BUS.Instance.ListRoomCancel(id_reservation);
double total_room_cancel = 0;
foreach (Log_swap_room_DTO item in list_log)
{
double xmod2 = 0;
TimeSpan interval = item.Created.Subtract(calendar.Start_date);
if (interval.Days < 1)
{
if (interval.Hours < 2)
{
xmod2 = 0.25;
}
else if (interval.Hours < 6)
{
xmod2 = 0.5;
}
else
{
xmod2 = 1;
}
}
else
{
if (interval.Hours > 6)
{
xmod2 = interval.Days + 0.5;
}
}
Room_DTO room = Room_BUS.Instance.Get_Info_Room(item.Reservation_room.Room.Id_room);
total_room_cancel = total_room_cancel + ((double)room.Kind_of_room.Price * xmod2);
}
return(total_room_cancel);
}
//Edit info room
public static void EditRoom(Room_DTO room)
{
Room_DAO.EditRoom(room);
}
//Add a room
public static void AddRoom(Room_DTO room)
{
Room_DAO.AddRoom(room);
}
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();
}
private double check_deposit_new()
{
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(this.id_reservation);
List <Log_swap_room_DTO> list_log = Log_swap_room_BUS.Instance.ListRoomCancel(this.id_reservation);
double total_room_cancel = 0;
foreach (Log_swap_room_DTO item in list_log)
{
double xmod2 = 0;
TimeSpan interval = item.Created.Subtract(calendar.Start_date);
if (interval.Days < 1)
{
if (interval.Hours < 2)
{
xmod2 = 0.25;
}
else if (interval.Hours < 6)
{
xmod2 = 0.5;
}
else
{
xmod2 = 1;
}
}
else
{
if (interval.Hours > 6)
{
xmod2 = interval.Days + 0.5;
}
else
{
xmod2 = interval.Days;
}
}
Room_DTO room = Room_BUS.Instance.Get_Info_Room(item.Reservation_room.Room.Id_room);
total_room_cancel = total_room_cancel + ((double)room.Kind_of_room.Price * xmod2);
}
List <Reservation_room_DTO> list_reservation_room = Reservation_room_BUS.Instance.Get_ListReservation_Using(this.id_reservation);
double xmod = 0;
if (calendar.End_date != null) // neu không hen lich se coi nhu 3 ngay
{
TimeSpan interval = calendar.End_date.Subtract(calendar.Start_date);
if (interval.Days < 1)
{
if (interval.Hours < 2)
{
xmod = 0.25;
}
else if (interval.Hours < 6)
{
xmod = 0.5;
}
else
{
xmod = 1;
}
}
else
{
if (interval.Hours > 6)
{
xmod = interval.Days + 0.5;
}
else
{
xmod = interval.Days;
}
}
}
else
{
xmod = 3;
}
double total_room_using = 0;
foreach (Reservation_room_DTO reservation_room in list_reservation_room)
{
total_room_using = total_room_using + ((double)reservation_room.Room.Kind_of_room.Price * xmod);
}
this.total = total_room_using + total_room_cancel;
return(total * 0.3);
}
