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 InfoAboutUser()
{
InitializeComponent();
db = new KursachEntities();
db.UsersToTopics.Load();
UserInfoDg.ItemsSource = db.UsersToTopics.Local.ToBindingList();
}
public BanUser()
{
InitializeComponent();
db = new KursachEntities();
db.Users.Load();
UserBanDg.ItemsSource = db.Users.Local.ToBindingList();
}
public Legs(string str)
{
_str = str;
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
LegsDg.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Legs");
}
public Legs()
{
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
LegsDg.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Legs");
Delete.Visibility = Visibility.Hidden;
Refresh.Visibility = Visibility.Hidden;
}
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();
}
public Legs(int _id)
{
a = _id;
InitializeComponent();
db = new KursachEntities();
db.Topics.Load();
LegsDg.ItemsSource = db.Topics.Local.ToBindingList().Where(x => x.Topic1 == "Legs");
Levels.IsReadOnly = true;
Content.IsReadOnly = true;
Photo.IsReadOnly = true;
Delete.Visibility = Visibility.Hidden;
Refresh.Visibility = Visibility.Hidden;
}
private void Auth_Click(object sender, RoutedEventArgs e)
{
if (AuthLogin.Text.Length > 0) // проверяем введён ли логин
{
if (AuthPassword.Password.Length > 0) // проверяем введён ли пароль
{
KursachEntities kursachEntities = new KursachEntities();
kursachEntities.Users.Load();
kursachEntities.Admins.Load();
BindingList <User> ts = kursachEntities.Users.Local.ToBindingList();
BindingList <Admin> admins = kursachEntities.Admins.Local.ToBindingList();
int a = 0;
foreach (var i in admins)
{
if (i.Login == AuthLogin.Text && i.Password == AuthPassword.Password)
{
MainWindow mainWindow = new MainWindow(i.Login);
mainWindow.Show();
this.Close();
a++;
break;
}
}
foreach (var i in ts)
{
string vs = GetHash(AuthPassword.Password);
if (i.Login == AuthLogin.Text && i.Password == vs)
{
MainWindow mainWindow = new MainWindow(i.Id);
mainWindow.Show();
this.Close();
a++;
break;
}
}
if (a == 0)
{
MessageBox.Show("Пользователь не найден");
}
}
else
{
MessageBox.Show("Введите пароль"); // выводим ошибку
}
}
else
{
MessageBox.Show("Введите логин"); // выводим ошибку
}
}
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();
}
}
}
public MyWorkouts(int _id)
{
db = new KursachEntities();
InitializeComponent();
a = _id;
db.UsersToTopics.Load();
db.Topics.Load();
BindingList <UsersToTopic> usersTos = db.UsersToTopics.Local.ToBindingList();
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;
}
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 Delete_Click(object sender, RoutedEventArgs e)
{
db = new KursachEntities();
db.Topics.Load();
db.UsersToTopics.Load();
Topic topic = LegsDg.SelectedItem as Topic;
int numbers = 0;
var userToTopic = db.Topics;
foreach (Topic i in userToTopic.Where(x => x.NumberOfTopic == ((Topic)LegsDg.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}");
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
db = new KursachEntities();
db.Users.Load();
db.UsersToTopics.Load();
User user = UserBanDg.SelectedItem as User;
var userToTopic = db.Users;
int id = 0;
foreach (User i in userToTopic.Where(x => x.Id == ((User)UserBanDg.SelectedItem).Id))
{
id = (int)i.Id;
}
int number = db.Database.ExecuteSqlCommand($"Delete from UsersToTopic Where UserId={id}");
if (user != null)
{
int b = db.Database.ExecuteSqlCommand($"Delete from Users Where Id={id}");
}
db.Users.Load();
UserBanDg.ItemsSource = db.Users.Local.ToBindingList();
}
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;
}
}
}
}