public Hands(string str)
{
_str = str;
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
HandsDG.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Hands");
}
public Back(string str)
{
a = 0;
_str = str;
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
BackDG.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Back");
}
public Hands()
{
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
HandsDG.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Hands");
Delete.Visibility = Visibility.Hidden;
Refresh.Visibility = Visibility.Hidden;
}
public Back(int _id)
{
a = _id;
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
BackDG.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Back");
Levels.IsReadOnly = true;
Content.IsReadOnly = true;
Photo.IsReadOnly = true;
Delete.Visibility = Visibility.Hidden;
Refresh.Visibility = Visibility.Hidden;
}
private void Subscribe_Click(object sender, RoutedEventArgs e)
{
if (a > 0)
{
using (KursachEntities db = new KursachEntities())
{
UsersToTopic user1 = new UsersToTopic {
UserId = a, TopicNumber = ((Topic)BackDG.SelectedItem).NumberOfTopic
};
db.UsersToTopics.Add(user1);
db.SaveChanges();
}
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
db = new KursachEntities();
db.Topics.Load();
db.UsersToTopics.Load();
Topic topic = BackDG.SelectedItem as Topic;
int numbers = 0;
var userToTopic = db.Topics;
foreach (Topic i in userToTopic.Where(x => x.NumberOfTopic == ((Topic)BackDG.SelectedItem).NumberOfTopic))
{
numbers = (int)i.NumberOfTopic;
}
int number = db.Database.ExecuteSqlCommand($"Delete from UsersToTopic Where TopicNumber={numbers}");
if (topic != null)
{
int b = db.Database.ExecuteSqlCommand($"Delete from Topic Where NumberOfTopic={numbers}");
}
db.Topics.Load();
BackDG.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Back");
}
