private void Button_Click_6(object sender, RoutedEventArgs e) { if (EventsRatingDataGrid.SelectedItem != null) { Users user = MainWindow.db.Users.Find(Current.Users.Id); Events events = new Events(); KeyValuePair <Events, int> x = (KeyValuePair <Events, int>)EventsRatingDataGrid.SelectedItem; events = x.Key; Events currentEvent = MainWindow.db.Events.Find(events.Id); if (MainWindow.db.UserEvents.Where(p => p.EventId == currentEvent.Id && p.UserId == user.Id).Count() > 0) { MessageBox.Show("You are already subscribed on this event", "Oops"); EventsRatingDataGrid.SelectedItem = null; } else { UserEvents ue = new UserEvents() { Users = user, Events = currentEvent }; MainWindow.db.UserEvents.Add(ue); MainWindow.db.SaveChanges(); MessageBox.Show("Success"); EventsRatingDataGrid.SelectedItem = null; } } else { MessageBox.Show("You must select event first", "Error"); } }
private void Button_Click_7(object sender, RoutedEventArgs e) { if (EventsListDataGrid.SelectedItem != null) { Users user = MainWindow.db.Users.Find(Current.Users.Id); var result = MainWindow.db.Events.SingleOrDefault(b => b.Id == ((Events)EventsListDataGrid.SelectedItem).Id); UserEvents ue = new UserEvents() { Users = user, Events = result }; var resultFinish = MainWindow.db.UserEvents.FirstOrDefault((u) => u.UserId == user.Id && u.EventId == ue.Events.Id); if (result != null) { MainWindow.db.UserEvents.Remove(resultFinish); MainWindow.db.SaveChanges(); MessageBox.Show("Success"); } else { MessageBox.Show("error"); } //Events events = MainWindow.db.Events.Find(((Events)EventsListDataGrid.SelectedItem).Id); //MainWindow.db.UserEvents.Remove(events); //events.Count++; //MainWindow.db.Entry(events).State = EntityState.Modified; } else { MessageBox.Show("You must select event first", "Error"); } }
private void SubscribeButton(object sender, RoutedEventArgs e) { if (DataGridEvents.SelectedItem != null) { Users user = MainWindow.db.Users.Find(Current.Users.Id); Events events = MainWindow.db.Events.Find(((Events)DataGridEvents.SelectedItem).Id); UserEvents ue = new UserEvents() { Users = user, Events = events }; MainWindow.db.UserEvents.Add(ue); //events.Count++; //MainWindow.db.Entry(events).State = EntityState.Modified; MainWindow.db.SaveChanges(); MessageBox.Show("Success"); } else { MessageBox.Show("You must select event first", "Error"); } }