private void label1_DragDrop(object sender, DragEventArgs e) { Booking b = (Booking)e.Data.GetData(typeof(Booking)); bookings.Remove(b); SaveObjects?.Invoke(bookings, bookingsPath); displayList(); }
private void btn_delete_room_Click(object sender, EventArgs e) { if (dgv_bookings.SelectedRows.Count == 1) { DataGridViewRow selectedRow = dgv_bookings.SelectedRows[0]; Booking booking = (Booking)selectedRow.Tag; bookings.Remove(booking); SaveObjects?.Invoke(bookings, bookingsPath); MessageBox.Show("Rezervare stearsa cu succes!"); displayList(); } }
private void scadePretCu100ToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewCell selectedCol = dgv_showRooms.SelectedCells[0]; if (dgv_showRooms.SelectedCells.Count == 1) { DataGridViewRow selectedRow = selectedCol.OwningRow; Room room = (Room)selectedRow.Tag; room = room + (-100); SaveObjects?.Invoke(rooms, roomsPath); displayList(); } }
private void stergeToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewCell cell = dgv_bookings.SelectedCells[0]; if (dgv_bookings.SelectedCells.Count == 1) { DataGridViewRow selectedRow = cell.OwningRow; Booking booking = (Booking)selectedRow.Tag; bookings.Remove(booking); SaveObjects?.Invoke(bookings, bookingsPath); MessageBox.Show("Rezervare stearsa cu succes!"); displayList(); } }
private void stergeToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewCell selectedCol = dgv_showRooms.SelectedCells[0]; if (dgv_showRooms.SelectedCells.Count == 1) { DataGridViewRow selectedRow = selectedCol.OwningRow; Room room = (Room)selectedRow.Tag; bookings.RemoveAll((b) => b.RoomId == room.Id); SaveObjects?.Invoke(bookings, bookingsPath); rooms.Remove(room); SaveObjects?.Invoke(rooms, roomsPath); MessageBox.Show("Camera stersa cu succes!"); displayList(); } }
private void btn_delete_room_Click(object sender, EventArgs e) { if (dgv_showRooms.SelectedRows.Count == 1) { DataGridViewRow selectedRow = dgv_showRooms.SelectedRows[0]; Room room = (Room)selectedRow.Tag; bookings.RemoveAll((b) => b.RoomId == room.Id); SaveObjects?.Invoke(bookings, bookingsPath); rooms.Remove(room); SaveObjects?.Invoke(rooms, roomsPath); MessageBox.Show("Camera stersa cu succes!"); displayList(); } else { MessageBox.Show("Prea multe linii selectate!"); } }
private void Btn_Edit_Booking_Click(object sender, EventArgs e) { int userIndex = this.Select_user.SelectedIndex; DateTime startDate = this.select_checkIn.Value.Date; DateTime endDate = this.select_checkOut.Value.Date; int roomIndex = this.select_camera.SelectedIndex; bool isValid = true; List <Booking> temp = new List <Booking>(); temp = bookings.FindAll(b => b.CompareTo(booking) == 0); if (userIndex == -1) { isValid = false; MessageBox.Show("Nu ati selectat clientul!\n"); } else if ((startDate - DateTime.Now.Date).Days < 0) { isValid = false; MessageBox.Show("Data de checkin nu poate fi mai mica decat data de astazi!\n"); } else if ((startDate - endDate).Days >= 0) { isValid = false; MessageBox.Show("Data de checkout trebuie sa fie mai mare decat data de checkin!\n"); } else if (roomIndex == -1) { isValid = false; MessageBox.Show("Nu ati selectat camera!\n"); } else if (temp.FindAll((b) => b.RoomId.ToString() == this.select_camera.Text).Any(b => (b.EndDate - startDate).Days > 0)) { isValid = false; MessageBox.Show("Camera este deja rezervata in acea perioada!\n"); } if (isValid) { try { try { string connStr = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = DB.accdb"; using (var conn = new OleDbConnection(connStr)) using (var myCommand = conn.CreateCommand()) { Item selected = this.Select_user.SelectedItem as Item; User user = users.Find((u) => u.Cnp == selected.cnp); Room room = rooms.Find((r) => r.Id.ToString() == this.select_camera.SelectedItem.ToString()); var oldCnp = booking.UserCNP; var oldStartDate = booking.StartDate; var oldRoomNumber = booking.RoomId; booking.UserCNP = user.Cnp; booking.RoomId = room.Id; booking.StartDate = startDate; booking.EndDate = endDate; SaveObjects?.Invoke(bookings, bookingsPath); string query = "Update bookings SET userCNP = @userCNP, roomId = @roomId, startdDate = @startDate, endDate = @endDate where userCNP = @oldCnp and roomId= @oldRoomNumber and startDate = @oldStartDate;"; myCommand.CommandText = query; myCommand.Parameters.AddWithValue("@userCNP", user.Cnp); myCommand.Parameters.AddWithValue("@roomId", room.Id); myCommand.Parameters.AddWithValue("@startDate", startDate); myCommand.Parameters.AddWithValue("@endDate", endDate); myCommand.Parameters.AddWithValue("@oldCnp", oldCnp); myCommand.Parameters.AddWithValue("@oldRoomNumber", oldRoomNumber); myCommand.Parameters.AddWithValue("@oldStartDate", oldStartDate); conn.Open(); myCommand.ExecuteNonQuery(); MessageBox.Show("Datele clientului au fost editate cu succes! Toate rezervarile au fost reatribuite!"); this.Dispose(); } } catch (Exception ex) { //MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void Btn_FinishEdit_Room_Click(object sender, EventArgs e) { int number = -1; double price = -1; int capacitate = -1; bool isValid = true; if (!Int32.TryParse(this.tb_numar.Text, out number)) { isValid = false; MessageBox.Show("Numar invalid!"); } if (rooms.Any(r => r.Id == number && r.CompareTo(room) != 0)) { isValid = false; MessageBox.Show("Exista o camera cu acest numar!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (!Double.TryParse(this.tb_pret.Text, out price)) { isValid = false; MessageBox.Show("Pret invalid!"); } if (!Int32.TryParse(this.Select_capacitate.Text, out capacitate)) { isValid = false; MessageBox.Show("Capacitate invalida!"); } if (capacitate > 3) { isValid = false; MessageBox.Show("Capacitate invalida!"); } if (isValid) { try { List <Booking> tempBookings; tempBookings = bookings.FindAll((b) => b.RoomId == room.Id); room.Id = number; room.Price = price; room.Capacity = capacitate; room.IsPremium = this.CB_camera_premium.Checked; SaveObjects?.Invoke(rooms, roomsPath); foreach (Booking booking in bookings) { if (tempBookings.Contains(booking)) { booking.RoomId = room.Id; } } SaveObjects?.Invoke(bookings, bookingsPath); MessageBox.Show("Camera editata cu succes! Toate rezervarile au fost reatribuite!"); this.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }