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 dgv_reservation_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int id_reservation = (int)dgv_reservation.Rows[e.RowIndex].Cells[0].Value;
this.id_reservation = id_reservation;
Reservation_DTO reservation = Reservation_BUS.Instance.GetInfoReservation(id_reservation);
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(id_reservation);
lb_id.Text = id_reservation.ToString();
lb_customer.Text = reservation.Customer.Name;
if (calendar != null)
{
lb_start_date.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
}
else
{
Calendar_DTO calendar_laster = Calendar_BUS.Instance.GetInfoCalendarLaster(id_reservation);
lb_start_date.Text = calendar_laster.Start_date.ToString();
lb_end_date.Text = calendar_laster.End_date.ToString();
}
if (reservation.Is_group == true)
{
lb_group.Text = "Yes";
}
else
{
lb_group.Text = "No";
}
lb_people.Text = reservation.People.ToString();
if (reservation.Status_reservation == 0)
{
lb_status.Text = "Đã hủy";
}
else
{
if (reservation.Status_reservation == 1)
{
lb_status.Text = "Hoàn tất";
}
else if (reservation.Status_reservation == 2)
{
lb_status.Text = "Chưa thanh toán";
}
else
{
lb_status.Text = "Chưa Đặt cọc";
}
}
}
catch
{
MessageBox.Show("Selected Error!");
}
}
private void LoadData()
{
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(this.id_reservation);
lb_reservation.Text = calendar.Reservation.Id_reservation.ToString();
lb_start_date.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
this.end_date = calendar.End_date;
this.start_date = calendar.Start_date;
}
public ActionResult SaveChanges(Calendar_DTO entity)
{
if (ModelState.IsValid)
{
calendarServ.Update(entity);
return(Json(new { success = true, mesaj = "Redaktə edildi" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, mesaj = "Məlumatları doldurun!!!" }, JsonRequestBehavior.AllowGet));
}
}
public Calendar_DTO GetSingleRecord(int id)
{
calendarRep.AddInputParameters("@id", id);
DataTable dt = calendarRep.GetList("sp_Calendar_GetByID", CommandType.StoredProcedure);
Calendar_DTO singleRow = new Calendar_DTO();
singleRow.id = Convert.ToInt32(dt.Rows[0]["id"]);
singleRow.cal_title = dt.Rows[0]["cal_title"].ToString();
singleRow.cal_date = Convert.ToDateTime(dt.Rows[0]["cal_date"]).ToString("dd/MM/yyyy");
singleRow.cal_enddate = Convert.ToDateTime(dt.Rows[0]["cal_enddate"]).ToString("dd/MM/yyyy");
return(singleRow);
}
public int Update(Calendar_DTO entity)
{
calendarRep.AddInputParameters("@id", entity.id);
if (entity.cal_date == null)
{
entity.cal_date = DateTime.Now.ToString("dd/MM/yyyy");
}
calendarRep.AddInputParameters("@cal_date", DateTime.ParseExact(entity.cal_date, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));
calendarRep.AddInputParameters("@cal_enddate", DateTime.ParseExact(entity.cal_enddate, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));
calendarRep.AddInputParameters("@cal_title", entity.cal_title);
return(calendarRep.IUD("sp_Calendar_UpdateByID", CommandType.StoredProcedure));
}
/// <summary>
/// Lấy ra thông tin lịch đăng sử dụng
/// </summary>
/// <param name="id_reservation"></param>
/// <returns></returns>
public Calendar_DTO GetCalendarReservationUsing(int id_reservation)
{
string query = "exec USP_GetCalendarReservationUsing @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
Calendar_DTO calendar = null;
foreach (DataRow item in table.Rows)
{
calendar = new Calendar_DTO(item);
}
return(calendar);
}
/// <summary>
/// Lấy thông tin của lịch bằng mã lịch
/// </summary>
/// <param name="id_calendar"> mẵ lịch cần tìm</param>
/// <returns>Thông tin của lịch</returns>
public Calendar_DTO GetInfoCalendar(int id_calendar)
{
string query = "exec USP_GetInfoCalendar @id_calendar";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_calendar });
Calendar_DTO calendar = null;
foreach (DataRow item in table.Rows)
{
calendar = new Calendar_DTO(item);
}
return(calendar);
}
public ActionResult SaveRecord(Calendar_DTO entity)
{
if (ModelState.IsValid)
{
calendarServ.Insert(entity);
return(Json(new { success = true, mesaj = "Əlavə olundu" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, mesaj = "Məlumatları doldurun!!!" }, JsonRequestBehavior.AllowGet));
}
}
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);
}
}
/// <summary>
/// Lấy ra thông tin tất cả các lịch của phiếu đặt (các lịch đã hủy, đã sửa,...)
/// </summary>
/// <param name="id_reservation">Mã của phiếu đặt</param>
/// <returns>Danh sách các Lịch thỏa mãn</returns>
public List <Calendar_DTO> GetListCalendarReservation(int id_reservation)
{
string query = "exec UPS_GetListCalendarReservation @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
List <Calendar_DTO> list_calendar_reservation = new List <Calendar_DTO>();
foreach (DataRow item in table.Rows)
{
Calendar_DTO calendar = new Calendar_DTO(item);
list_calendar_reservation.Add(calendar);
}
return(list_calendar_reservation);
}
/// <summary>
/// Lẩy ra danh sách tất cả các lịch trong hệ thống
/// </summary>
/// <returns>Danh sách các lịch trong hệ thống</returns>
public List <Calendar_DTO> GetListCalendar()
{
string query = "exec USP_GetListCalendar";
DataTable table = Connect.Instance.ExecuteQuery(query);
List <Calendar_DTO> list_calendar = new List <Calendar_DTO>();
foreach (DataRow item in table.Rows)
{
Calendar_DTO calendar = new Calendar_DTO(item);
list_calendar.Add(calendar);
}
return(list_calendar);
}
private void LoadData()
{
Bill_DTO bill = Bill_BUS.Instance.GetInfoBill(this.id_bill);
Reservation_DTO reservation = Reservation_BUS.Instance.GetInfoReservation(bill.Reservation.Id_reservation);
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(bill.Reservation.Id_reservation);
Deposit_DTO deposit = Deposit_BUS.Instance.GetInfoDepositUsing(bill.Reservation.Id_reservation);
List <Reservation_room_DTO> list_reservation_room = Reservation_room_BUS.Instance.Get_ListReservation_Using(bill.Reservation.Id_reservation);
List <Service_ticket_DTO> list_service_ticket = Service_ticket_BUS.Instance.Get_ListServiceReservation(bill.Reservation.Id_reservation);
lb_reservation.Text = bill.Reservation.Id_reservation.ToString();
lb_customer.Text = reservation.Customer.Name.ToString();
lb_group.Text = reservation.Is_group.ToString();
lb_peopel.Text = reservation.People.ToString();
lb_start_date.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
System.Globalization.CultureInfo cul = new System.Globalization.CultureInfo("vi-VN");
double total_room = Get_Money_Room(list_reservation_room, calendar) + this.Get_Money_Cancel_Room(bill.Reservation.Id_reservation);
lb_total_room.Text = total_room.ToString("c", cul);
double total_service = Get_Money_Service(list_service_ticket);
lb_total_service.Text = total_service.ToString("c", cul);
this.total_money = total_room + total_service;
lb_total_money.Text = this.total_money.ToString("c", cul);
lb_deposit.Text = deposit.Deposit.ToString("c", cul);
this.deposit = deposit.Deposit;
lb_staff.Text = bill.Staff.Username.ToString();
lb_rest.Text = (this.total_money - this.deposit).ToString("c", cul);
Load_Room_Using();
Load_Service_Using();
if (Bill_BUS.Instance.CheckConfirmBill(this.id_bill) == true)
{
cb_confirm.SelectedIndex = 1;
}
else
{
cb_confirm.SelectedIndex = 0;
}
}
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);
}
private void LoadData()
{
List <Calendar_DTO> list_calendar = Calendar_BUS.Instance.GetListCalendarReservation(this.id_reservation);
foreach (Calendar_DTO calendar in list_calendar)
{
ListViewItem item = new ListViewItem(calendar.Id_calendar.ToString());
item.SubItems.Add(calendar.Start_date.ToString());
item.SubItems.Add(calendar.End_date.ToString());
item.SubItems.Add(calendar.Created.ToString());
if (calendar.Status == 2)
{
item.SubItems.Add("Change");
}
else
{
if (calendar.Status == 1)
{
item.SubItems.Add("Active");
}
else
{
item.SubItems.Add("Cancel");
}
}
listView1.Items.Add(item);
}
Calendar_DTO calendar_info = Calendar_BUS.Instance.GetCalendarReservationUsing(this.Id_reservation);
if (calendar_info != null)
{
lb_id_calendar.Text = calendar_info.Id_calendar.ToString();
lb_start_date.Text = calendar_info.Start_date.ToString();
lb_end_date.Text = calendar_info.End_date.ToString();
lb_created.Text = calendar_info.Created.ToString();
}
}
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 Get_Money_Room(List <Reservation_room_DTO> list_reservation_room, Calendar_DTO calendar)
{
double xmod = 0;
if (calendar.End_date != null)
{
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 = 3;
}
this.xmod_room = xmod;
double total_room = 0;
foreach (Reservation_room_DTO reservation_room in list_reservation_room)
{
total_room = total_room + ((double)reservation_room.Room.Kind_of_room.Price * xmod);
}
return(total_room);
}
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);
}
private void Load_Data()
{
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("vi-VN");
Reservation_DTO reservation = Reservation_BUS.Instance.GetInfoReservation(id_reservation);
Calendar_DTO calendar = Calendar_BUS.Instance.GetCalendarReservationUsing(id_reservation);
lb_id.Text = id_reservation.ToString();
lb_customer.Text = reservation.Customer.Name;
if (calendar != null)
{
lb_start_date.Text = calendar.Start_date.ToString();
lb_end_date.Text = calendar.End_date.ToString();
}
else
{
Calendar_DTO calendar_laster = Calendar_BUS.Instance.GetInfoCalendarLaster(id_reservation);
lb_start_date.Text = calendar_laster.Start_date.ToString();
lb_end_date.Text = calendar_laster.End_date.ToString();
}
if (reservation.Is_group == true)
{
lb_group.Text = "Yes";
}
else
{
lb_group.Text = "No";
}
lb_people.Text = reservation.People.ToString();
if (reservation.Status_reservation == 0)
{
lb_status.Text = "Đã hủy";
}
else
{
if (reservation.Status_reservation == 1)
{
lb_status.Text = "Hoàn tất";
}
else if (reservation.Status_reservation == 2)
{
lb_status.Text = "Chưa thanh toán";
}
else
{
lb_status.Text = "Chưa Đặt cọc";
}
}
List <Calendar_DTO> list_calendar = Calendar_BUS.Instance.GetListCalendarReservation(this.id_reservation);
foreach (Calendar_DTO calendar1 in list_calendar)
{
ListViewItem item = new ListViewItem(calendar1.Id_calendar.ToString());
item.SubItems.Add(calendar1.Start_date.ToString());
item.SubItems.Add(calendar1.End_date.ToString());
item.SubItems.Add(calendar1.Created.ToString());
if (calendar1.Status == 2)
{
item.SubItems.Add("Change");
}
else
{
if (calendar1.Status == 1)
{
item.SubItems.Add("Active");
}
else
{
item.SubItems.Add("Cancel");
}
}
listView2.Items.Add(item);
}
List <Reservation_room_DTO> list_reservation_room = Reservation_room_BUS.Instance.Get_ListReservation_Using(this.id_reservation);
foreach (Reservation_room_DTO reservation_room in list_reservation_room)
{
ListViewItem item = new ListViewItem(reservation_room.Id_reservation_room.ToString());
item.SubItems.Add(reservation_room.Room.Id_room.ToString());
item.SubItems.Add(reservation_room.Room.Kind_of_room.Name.ToString());
item.SubItems.Add(reservation_room.Room.Kind_of_room.People.ToString());
item.SubItems.Add(((int)reservation_room.Room.Kind_of_room.Price).ToString());
listView1.Items.Add(item);
}
List <Service_ticket_DTO> list_service_reservation = Service_ticket_BUS.Instance.Get_ListServiceReservation(this.id_reservation);
foreach (Service_ticket_DTO service in list_service_reservation)
{
ListViewItem item = new ListViewItem(service.Reservation_room.Room.Id_room.ToString());
item.SubItems.Add(service.Service.Id_service.ToString());
item.SubItems.Add(service.Service.Name_service.ToString());
item.SubItems.Add(((int)service.Service.Price).ToString());
item.SubItems.Add(service.Number.ToString());
item.SubItems.Add(service.Date_use.ToString());
listView4.Items.Add(item);
}
List <Deposit_DTO> list_deposit = Deposit_BUS.Instance.GetListDepositReservation(id_reservation);
foreach (Deposit_DTO deposit in list_deposit)
{
ListViewItem item = new ListViewItem(deposit.Id_deposit.ToString());
item.SubItems.Add(deposit.Deposit.ToString("c", culture));
item.SubItems.Add(deposit.Confirm.ToString());
item.SubItems.Add(deposit.Created_confirm.ToString());
item.SubItems.Add(deposit.Locked.ToString());
item.SubItems.Add(deposit.Note.ToString());
listView3.Items.Add(item);
}
this.lb_total.Text = BUS.Bill_BUS.Instance.GetListBillByReservation(id_reservation).Total_money.ToString("c", culture);
this.lb_checkout.Text = BUS.Bill_BUS.Instance.GetListBillByReservation(id_reservation).Created.ToString();
}
