private void AddServiceButton_Click(object sender, RoutedEventArgs e)
        {
            var service = ServiceComboBox.SelectedItem as Service;
            var guest   = GuestIDComboBox.SelectedItem as Guest;

            if (service != null && guest != null)
            {
                var newReservationDetail = new ReservationDetail()
                {
                    GuestID      = (from guest1 in MainWindow.db.Guests where guest1.ID == guest.ID select guest1.ID).Single(),
                    ServiceID    = service.ID,
                    ServicePrice = (from service1 in MainWindow.db.Services where service1.ID == service.ID select service1.Price).Single() ?? 0,
                    ServiceName  = (from service2 in MainWindow.db.Services where service2.ID == service.ID select service2.Name).Single(),
                    Date         = DateTime.Now,
                    isDeleted    = false,
                };
                bool added = false;
                foreach (var detail in tempList)
                {
                    if (detail.ServiceID == newReservationDetail.ServiceID)
                    {
                        added = true;
                        MessageBox.Show("Service is already added");
                        break;
                    }
                }
                if (added == false)
                {
                    tempList.Add(newReservationDetail);
                    reservationDataGrid.ItemsSource = tempList;
                }

                TotalTextBox.Text = "$" + TotalCalculator().ToString();
            }
        }
        private void RemoveButton_Click(object sender, RoutedEventArgs e)
        {
            ReservationDetail selectedItem = (ReservationDetail)reservationDataGrid.SelectedItem;

            if (selectedItem != null)
            {
                foreach (var detail in tempList)
                {
                    if (detail.GuestID == selectedItem.GuestID)
                    {
                        tempList.Remove(detail);
                        break;
                    }
                }

                reservationDataGrid.ItemsSource = tempList;
                TotalTextBox.Text = "$" + TotalCalculator().ToString();
            }
        }
Exemple #3
0
        private void ImportButton_Click(object sender, RoutedEventArgs e)
        {
            var screen = new OpenFileDialog();

            screen.Filter = "Excel files|*.xls;*.xlsx";

            if (screen.ShowDialog() == true)
            {
                var workbook = new Workbook(screen.FileName);

                var sheet = workbook.Worksheets[0];

                var col = "A";
                var row = 2;

                var cell = sheet.Cells[$"{col}{row}"];

                while (cell.Value != null)
                {
                    bool isContinue = true;

                    var roomid  = sheet.Cells[$"A{row}"].StringValue;
                    var guestid = sheet.Cells[$"B{row}"].StringValue;

                    bool gotRoomID  = MainWindow.db.Rooms.ToList().Any(cus => cus.ID == roomid);
                    bool gotGuestID = MainWindow.db.Guests.ToList().Any(cus => cus.ID == guestid);

                    if (gotRoomID == false)
                    {
                        string message = "The room with ID \"" + roomid + "\" in reservations does not exist.\nDo you want to add a new room? You can skip importing this reservation by clicking \"No\".";

                        if (MessageBox.Show(message, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
                        {
                            if (MainWindow.db.Categories.Count() == 0)
                            {
                                string message2 = "There are no categories for rooms. Click \"Yes\" to create a new category or \"No\" to skip importing this reservation.";

                                if (MessageBox.Show(message2, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
                                {
                                    var newCategory = new AddCategoryWindow();
                                    if (newCategory.ShowDialog() == true)
                                    {
                                        if (newCategory.CT_Name != null)
                                        {
                                            var category = new Category()
                                            {
                                                ID        = IDGenerator.createID("CT"),
                                                Name      = newCategory.CT_Name,
                                                isDeleted = false,
                                            };

                                            MainWindow.db.Categories.Add(category);
                                            MainWindow.db.SaveChanges();
                                            CategoryControl.category_notification.CategoryChange = true;
                                        }
                                    }
                                    else
                                    {
                                        isContinue = false;
                                    }
                                }
                            }

                            if (isContinue == true)
                            {
                                var newRoom = new AddRoomWindow();

                                if (newRoom.ShowDialog() == true)
                                {
                                    if (newRoom.CategoryComboBox.SelectedItem != null && newRoom.PriceTextBox.Value > 0 && newRoom.StatusComboBox.SelectedItem != null)
                                    {
                                        var room = new Room()
                                        {
                                            ID         = roomid,
                                            CategoryID = newRoom.R_CategoryID,
                                            Price      = newRoom.R_Price,
                                            Status     = newRoom.R_Status,
                                            Picture    = newRoom.R_Picture,
                                            isDeleted  = false,
                                        };

                                        MainWindow.db.Rooms.Add(room);
                                        MainWindow.db.SaveChanges();
                                        RoomControl.room_notification.RoomChange = true;
                                    }
                                }
                            }
                        }
                    }

                    if (gotGuestID == false && isContinue == true)
                    {
                        string message = "The guest with ID \"" + guestid + "\" in reservations does not exist.\nDo you want to add a new guest? You can skip importing this reservation by clicking \"No\".";

                        if (MessageBox.Show(message, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
                        {
                            var newGuest = new AddGuestWindow();

                            if (newGuest.ShowDialog() == true)
                            {
                                if (!string.IsNullOrWhiteSpace(newGuest.NameTextBox.Text) && !string.IsNullOrWhiteSpace(newGuest.IdentityCardTextBox.Text) && !string.IsNullOrWhiteSpace(newGuest.TelephoneTextBox.Text))
                                {
                                    var guest = new Guest()
                                    {
                                        ID           = guestid,
                                        Name         = newGuest.G_Name,
                                        Telephone    = newGuest.G_Telephone,
                                        IdentityCard = newGuest.G_IdentityCard,
                                        isDeleted    = false,
                                    };

                                    MainWindow.db.Guests.Add(guest);
                                    MainWindow.db.SaveChanges();
                                    GuestControl.guest_notification.GuestChange = true;
                                }
                            }
                        }
                    }

                    if (MainWindow.db.Rooms.ToList().Any(cus => cus.ID == roomid) == true && MainWindow.db.Rooms.ToList().Any(cus => cus.ID == roomid) == true)
                    {
                        var date       = sheet.Cells[$"C{row}"].DateTimeValue;
                        var startdate  = sheet.Cells[$"D{row}"].DateTimeValue;
                        var enddate    = sheet.Cells[$"E{row}"].DateTimeValue;
                        var totalprice = sheet.Cells[$"F{row}"].DoubleValue;

                        var newReservation = new Reservation()
                        {
                            RoomID     = roomid,
                            GuestID    = guestid,
                            Date       = date,
                            StartDate  = startdate,
                            EndDate    = enddate,
                            TotalPrice = totalprice,
                        };

                        var detail_Sheet = workbook.Worksheets[1];

                        var detail_Col = "A";
                        var detail_Row = 2;

                        var detail_Cell = detail_Sheet.Cells[$"{detail_Col}{detail_Row}"];

                        List <ReservationDetail> detail_List = new List <ReservationDetail>();

                        while (detail_Cell.Value != null)
                        {
                            var detail_roomID  = detail_Sheet.Cells[$"A{detail_Row}"].StringValue;
                            var detail_guestID = detail_Sheet.Cells[$"B{detail_Row}"].StringValue;
                            if (detail_roomID == newReservation.RoomID && detail_guestID == newReservation.GuestID)
                            {
                                var detail_serviceID = detail_Sheet.Cells[$"C{detail_Row}"].StringValue;
                                var detail_date      = detail_Sheet.Cells[$"D{detail_Row}"].DateTimeValue;

                                var newDetail = new ReservationDetail()
                                {
                                    RoomID       = detail_roomID,
                                    GuestID      = detail_guestID,
                                    ServiceName  = (from service in MainWindow.db.Services where service.ID == detail_serviceID select service.Name).Single(),
                                    ServicePrice = (double)(from service in MainWindow.db.Services where service.ID == detail_serviceID select service.Price).Single(),
                                    ServiceID    = detail_serviceID,
                                    Date         = detail_date,
                                };

                                detail_List.Add(newDetail);
                            }

                            detail_Row++;
                            detail_Cell = detail_Sheet.Cells[$"{detail_Col}{detail_Row}"];
                        }

                        foreach (var detail in detail_List)
                        {
                            MainWindow.db.ReservationDetails.Add(detail);
                            MainWindow.db.SaveChanges();
                        }

                        MainWindow.db.Reservations.Add(newReservation);
                        MainWindow.db.SaveChanges();

                        var chosenRoom = (from chosenroom in MainWindow.db.Rooms where chosenroom.ID == newReservation.RoomID select chosenroom).Single();
                        chosenRoom.Status = "Rented";
                        MainWindow.db.SaveChanges();
                    }

                    row++;
                    cell = sheet.Cells[$"{col}{row}"];
                }

                MessageBox.Show("Import completed!", "Message");

                reservationDataGrid.ItemsSource          = MainWindow.db.Reservations.ToList();
                RoomControl.room_notification.RoomChange = true;
            }
        }