private void Load_Deposit_Using()
{
Deposit_DTO deposit = Deposit_BUS.Instance.GetInfoDepositUsing(this.id_reservation);
lb_reservation.Text = "Reservation: " + id_reservation.ToString();
lb_id.Text = deposit.Id_deposit.ToString();
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("vi-VN");
lb_deposit.Text = deposit.Deposit.ToString("c", culture);
lb_confirm.Text = deposit.Confirm.ToString();
lb_created.Text = deposit.Created_confirm.ToString();
}
public bool Check_Confirm(int id_reservation)
{
string query = "exec USP_CheckConfirm @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
Deposit_DTO deposit = new Deposit_DTO();
foreach (DataRow item in table.Rows)
{
deposit.Confirm = (bool)item["confirm"];
break;
}
return(deposit.Confirm);
}
public double Check_Deposit_Old(int id_reservation)
{
string query = "exec USP_CheckDepositPrev @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
Deposit_DTO deposit = new Deposit_DTO();
foreach (DataRow item in table.Rows)
{
deposit.Deposit = (double)((decimal)item["deposit"]);
break;
}
return(deposit.Deposit);
}
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;
}
}
public Deposit_DTO GetInfoDepositUsing(int id_reservation)
{
string query = "exec USP_CheckConfirm @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
Deposit_DTO deposit = new Deposit_DTO();
foreach (DataRow item in table.Rows)
{
deposit.Id_deposit = (int)item["id_deposit"];
deposit.Reservation.Id_reservation = (int)item["id_reservation"];
deposit.Deposit = (double)((decimal)item["deposit"]);
deposit.Confirm = (bool)item["confirm"];
deposit.Created_confirm = (DateTime)item["created_confirm"];
deposit.Locked = (bool)item["locked"];
deposit.Note = item["note"].ToString();
}
return(deposit);
}
public List <Deposit_DTO> GetListDepositReservation(int id_reservation)
{
string query = "exec USP_GetListDeposit @id_reservation";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_reservation });
List <Deposit_DTO> list_deposit = new List <Deposit_DTO>();
foreach (DataRow item in table.Rows)
{
Deposit_DTO deposit = new Deposit_DTO();
deposit.Id_deposit = (int)item["id_deposit"];
deposit.Reservation.Id_reservation = (int)item["id_reservation"];
deposit.Deposit = (double)((decimal)item["deposit"]);
deposit.Confirm = (bool)item["confirm"];
deposit.Created_confirm = (DateTime)item["created_confirm"];
deposit.Locked = (bool)item["locked"];
deposit.Note = item["note"].ToString();
list_deposit.Add(deposit);
}
return(list_deposit);
}
