private void DataGrid_rooms_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Entity.Rooms currentRoom = (Entity.Rooms)DataGrid_rooms.SelectedItem;
this.selectedRoom = currentRoom;
// MessageBox.Show("double click #" + currentRoom.Price);
updateLabelStatusRoom();
UpdateCalendar();
}
// Вручную устанавливаем зависисые сущности
public void customInit(DbSet <Clients> dbClients, DbSet <Rooms> dbRooms)
{
Clients tmp_client = dbClients.Where(c => c.Id == this.ClientsId).ToList()[0];
this.Clients = tmp_client;
Entity.Rooms tmp_room = dbRooms.Where(r => r.Id == this.RoomsId).ToList()[0];
this.Rooms = tmp_room;
}
private void Button_editRow_click(object sender, RoutedEventArgs e)
{
Entity.Rooms room = ((FrameworkElement)sender).DataContext as Entity.Rooms;
Console.WriteLine("clicked edit row id = " + room.Id);
Form_createRoom form = new Form_createRoom(room);
form.Owner = this;
form.ShowDialog();
}
private void UpdateCalendar()
{
Entity.Rooms selectedRoom = (Entity.Rooms)DataGrid_rooms.SelectedItem;
List <Order_entity> ordersList = Order_entity.init_Orders(db);
// достаем заказы с выбранной комнатой
OrderRepos orderRepos = new OrderRepos(db);
List <Order_entity> selectedRoomOrderList = orderRepos.GetByRoomId(selectedRoom.Id);
Calendar_.BlackoutDates.Clear();
foreach (Order_entity order in selectedRoomOrderList)
{
Calendar_.BlackoutDates.Add(
new CalendarDateRange(order.DateStart, order.DateEnd)
);
}
int a = 2;
}
private void Button_delRow_click(object sender, RoutedEventArgs e)
{
Entity.Rooms room = ((FrameworkElement)sender).DataContext as Entity.Rooms;
MessageBoxResult messageBoxResult =
System.Windows.MessageBox.Show(
"Вы действительно хотите удалить комнату №" + room.Number,
"Delete Confirmation",
System.Windows.MessageBoxButton.YesNo
);
if (messageBoxResult == MessageBoxResult.Yes)
{
Console.WriteLine("clicked delete row id = " + room.Id);
// Проверяем, нет ли зависимых от это строки записей
OrderRepos orderRepo = new OrderRepos(db);
List <Order_entity> dependentOrders = orderRepo.GetByRoomId(room.Id);
if (dependentOrders.Count != 0)
{
MessageBox.Show(
"Невозможно удалить эту запись, т.к. от нее зависят " + dependentOrders.Count + " заказов");
return;
}
using (var context = new ApplicationContext())
{
var deletedCustomer = context.Rooms.Where(c => c.Id == room.Id).FirstOrDefault();
context.Rooms.Remove(deletedCustomer);
context.SaveChanges();
}
db.SaveChanges();
this.updateDataGrid();
}
}
