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