private void Add_admin(object sender, RoutedEventArgs e) { if (AddLogin.Text.Length > 0) { db = new KursachEntities(); db.Admins.Load();; foreach (Admin i in db.Admins) { if (AddLogin.Text == i.Login) { MessageBox.Show("This login is busy, pls pressed another login"); } } if (AddPassword.Password.Length > 0) { Admin admin = new Admin { Login = AddLogin.Text, Password = AddPassword.Password }; db.Admins.Add(admin); db.SaveChanges(); } else { MessageBox.Show("You dont pressed password"); } } else { MessageBox.Show("You dont pressed login"); } }
public void Add_Click(object sender, RoutedEventArgs e) { db = new KursachEntities(); Topic topic = new Topic { Topic1 = Topic.Text, Level = Convert.ToInt32(Levels.Text), Image = FilePath, Content = new TextRange(Content1.Document.ContentStart, Content1.Document.ContentEnd).Text }; db.Topics.Add(topic); db.SaveChanges(); }
private void Subscribe_Click(object sender, RoutedEventArgs e) { if (a > 0) { using (KursachEntities db = new KursachEntities()) { UsersToTopic user1 = new UsersToTopic { UserId = a, TopicNumber = ((Topic)LegsDg.SelectedItem).NumberOfTopic }; db.UsersToTopics.Add(user1); db.SaveChanges(); } } }
private void Reg_Click(object sender, RoutedEventArgs e) { if (RegLogin.Text.Length > 0) // проверяем логин { if (RegPassword.Password.Length > 0) // проверяем пароль { if (RegCopyPassword.Password.Length > 0) // проверяем второй пароль { if (RegPassword.Password == RegCopyPassword.Password) { using (KursachEntities db = new KursachEntities()) { string vs = GetHash(RegPassword.Password); User user1 = new User { Login = RegLogin.Text, Password = vs }; db.Users.Add(user1); db.SaveChanges(); MainWindow mainWindow = new MainWindow(user1.Id); mainWindow.Show(); this.Close(); } } else { MessageBox.Show("Пароли не совподают"); } } else { MessageBox.Show("Повторите пароль"); } } else { MessageBox.Show("Укажите пароль"); } } else { MessageBox.Show("Укажите логин"); } }
private void IsDone_Click(object sender, RoutedEventArgs e) { var result = MessageBox.Show("Вы закончили тренировку?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { UsersToTopic usersToTopic = new UsersToTopic { UserId = a, TopicNumber = ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic }; if (usersToTopic != null) { var maxLevel = db.Topics; int maxlevel = 0; foreach (Topic i in maxLevel.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level > ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (maxlevel < i.Level) { maxlevel = (int)i.Level; } } if (maxlevel > ((Topic)MyWorkoutsDG.SelectedItem).Level) { var result2 = MessageBox.Show("Не хотели бы приступить к следующему уровну?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result2 == MessageBoxResult.Yes) { int topicasd = 0; var _topicNumber = db.Topics; int d = 0; foreach (Topic i in _topicNumber.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level > ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (d == 0) { d++; topicasd = i.NumberOfTopic; } else if (d > 0) { break; } } db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics7 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics7.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics7; UsersToTopic user1 = new UsersToTopic { UserId = a, TopicNumber = topicasd }; db.UsersToTopics.Add(user1); db.SaveChanges(); BindingList <Topic> topics1 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics1.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics1; } else { var result4 = MessageBox.Show("Хотите остаться на данном уровне?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result4 == MessageBoxResult.No) { BindingList <Topic> topics1 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics1.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics1; db = new KursachEntities(); var minLevel = db.Topics; int minlevel = 123123; foreach (Topic i in minLevel.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level < ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (minlevel > i.Level) { minlevel = (int)i.Level; } } if (minlevel < ((Topic)MyWorkoutsDG.SelectedItem).Level) { var result5 = MessageBox.Show("Хотите перейти на предыдущий уровень?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result5 == MessageBoxResult.Yes) { int topicasd = 0; var _topicNumber = db.Topics; int d = 0; foreach (Topic i in _topicNumber.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level < ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (d == 0) { d++; topicasd = i.NumberOfTopic; } else if (d > 0) { break; } } db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); UsersToTopic user1 = new UsersToTopic { UserId = a, TopicNumber = topicasd }; db.UsersToTopics.Add(user1); db.SaveChanges(); BindingList <Topic> topics6 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics6.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics6; } else { db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics6 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics1.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics6; } } else { var result8 = MessageBox.Show("Простите ниже этого уровня нету, повторяем?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result8 == MessageBoxResult.No) { db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics6 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics1.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics6; } } } } } else { var result2 = MessageBox.Show("Не хочешь повторить что сделал?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result2 == MessageBoxResult.Yes) { BindingList <Topic> topics1 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics1.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics1; } else { db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics4 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics4.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics4; } } } BindingList <Topic> topics = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics; } else { var result3 = MessageBox.Show("Хотите отменить тренировку?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result3 == MessageBoxResult.Yes) { db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics; } else { var minLevel = db.Topics; int minlevel = 123123; foreach (Topic i in minLevel.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level < ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (minlevel > i.Level) { minlevel = (int)i.Level; } } if (minlevel < ((Topic)MyWorkoutsDG.SelectedItem).Level) { var result9 = MessageBox.Show("Хотите вернуться на предыдущий уровень?", "Qustion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result9 == MessageBoxResult.Yes) { int topicasd = 0; var _topicNumber = db.Topics; int d = 0; foreach (Topic i in _topicNumber.Where(y => y.Topic1 == ((Topic)MyWorkoutsDG.SelectedItem).Topic1 && y.Level < ((Topic)MyWorkoutsDG.SelectedItem).Level)) { if (d == 0) { d++; topicasd = i.NumberOfTopic; } else if (d > 0) { break; } } db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); UsersToTopic user1 = new UsersToTopic { UserId = a, TopicNumber = topicasd }; db.UsersToTopics.Add(user1); db.SaveChanges(); BindingList <Topic> topics10 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics10.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics10; } } else { db.UsersToTopics.Remove(db.UsersToTopics.Where(x => x.UserId == a && x.TopicNumber == ((Topic)MyWorkoutsDG.SelectedItem).NumberOfTopic).First()); db.SaveChanges(); BindingList <Topic> topics10 = new BindingList <Topic>(); foreach (var i in db.UsersToTopics.Where(x => x.UserId == a)) { topics10.Add(db.Topics.Where(y => y.NumberOfTopic == i.TopicNumber).First()); } MyWorkoutsDG.ItemsSource = topics10; } } } }