private string[] Mas()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
var exercises = db.Exercises.ToList();
string[] GM = new string[9];
int count = 0;
foreach (var exer in exercises)
{
for (int i = 0; i < 9; i++)
{
if (GM[i] == exer.MuscleGroups)
{
break;
}
if (exer.MuscleGroups != GM[count] && count == i)
{
GM[count] = exer.MuscleGroups;
count++;
break;
}
}
if (count == 9)
{
break;
}
}
return(GM);
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
Random value = new Random();
int number = value.Next(0, 100);
var groups = db.Group.ToList();
Found : foreach (var g in groups)
{
if (g.Number_Group == number)
{
number = value.Next(0, 100000);
goto Found;
}
}
Trainer trainer = WorkTrainerWindowViewModel.trainer;
Group group = new Group();
group.Number_Group = number;
group.Id_Trainer = trainer.id;
db.Group.Add(group);
db.SaveChanges();
MessageBox.Show("группа создана, но в ней никто не участвует добавьте клиентов");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
Client client = new Client();
var clients = db.Client.ToList();
TextBox text = (TextBox)parameter;
foreach (var c in clients)
{
if (c.id.ToString() == text.Text)
{
client = c;
}
}
Trainer trainer = WorkTrainerWindowViewModel.trainer;
client.Number_Group = trainer.Number_Group;
db.Entry(client).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show($"клиент добавлен в группу под номером {client.Number_Group}");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public WorkUserWindowViewModel()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
client = db.Client.Include("DataClient").Where(i => i.Login.Replace(" ", "") == ((MainWindow)Application.Current.MainWindow).Login.Text &&
i.Password.Replace(" ", "") == ((MainWindow)Application.Current.MainWindow).Password.Text).FirstOrDefault();
}
}
public WorkTrainerWindowViewModel()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
trainer = db.Trainer.Include("DataTrainer").Include("Group").Where(i => i.Login.Replace(" ", "") == ((MainWindow)Application.Current.MainWindow).Login.Text &&
i.Password.Replace(" ", "") == ((MainWindow)Application.Current.MainWindow).Password.Text).FirstOrDefault();
}
}
public static string[] GetClientsGroup()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
string[] mas = new string[db.Client.ToList().Count()];
for (int i = 0; i < db.Client.ToList().Count(); i++)
{
mas[i] = db.Client.ToList().ElementAt(i).id.ToString();
}
return(mas);
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
string[] text = (string[])parameter;
var clients = db.Client.ToList();
var trainers = db.Trainer.ToList();
bool Fine = false;
foreach (var c in clients)
{
if (c.Login.Replace(" ", "") == text[0] && c.Password.Replace(" ", "") == text[1])
{
WindowOfViews.WorkUserWindow = new WorkUserWindow();
WindowOfViews.WorkUserWindow.Show();
Fine = true;
}
}
foreach (var c in trainers)
{
if (c.Login.Replace(" ", "") == text[0] && c.Password.Replace(" ", "") == text[1])
{
WindowOfViews.WorkTrainerWindow = new WorkTrainerWindow();
WindowOfViews.WorkTrainerWindow.Show();
Fine = true;
}
}
if (Fine == true)
{
transaction.Commit();
Application.Current.MainWindow.Close();
}
if (Fine == false)
{
MessageBox.Show("Вы неправильно ввели данные");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
}
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Random value = new Random();
Trainer trainer1 = (Trainer)parameter;
int rand = value.Next(0, 100000);
var trainers = db.Trainer.ToList();
Found:
foreach (var c in trainers)
{
if (c.id == rand)
{
rand = value.Next(0, 100000);
goto Found;
}
}
foreach (var c in trainers)
{
if (c.Login == trainer1.Login)
{
throw new Exception("Такой логин уже используется");
}
}
if (trainer1.DataTrainer.BarbellSquat < trainer1.DataTrainer.Weight * 1.4 && trainer1.DataTrainer.Deadlift < trainer1.DataTrainer.Weight * 1.8 &&
trainer1.DataTrainer.BenchPress < trainer1.DataTrainer.Weight * 1.2 && trainer1.DataTrainer.Pullups < 10)
{
throw new Exception("Вы слабоваты для тренера");
}
trainer1.id = rand;
db.DataTrainer.Add(trainer1.DataTrainer);
db.Trainer.Add(trainer1);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
MessageBox.Show("значения введены неверно, перепроверьте пожалуйсто");
transaction.Rollback();
}
}
}
}
public static List <Client> GetClientsGroup()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
var clients = db.Client.ToList();
List <Client> ClientGroup = new List <Client>();
foreach (var c in clients)
{
if (c.Number_Group.ToString() == trainer.Number_Group.ToString())
{
ClientGroup.Add(c);
}
}
return(ClientGroup);
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Random value = new Random();
Client client1 = (Client)parameter;
int rand = value.Next(0, 100000);
var clients = db.Client.ToList();
Found:
foreach (var c in clients)
{
if (c.id == rand)
{
rand = value.Next(0, 100000);
goto Found;
}
}
foreach (var c in clients)
{
if (c.Login == client1.Login)
{
throw new Exception("Такой логин уже используется");
}
}
client1.id = rand;
List <ExercisesForClient> lol = GenerateExercises(parameter);
db.Client.Add(client1);
db.DataClient.Add(client1.DataClient);
db.ExercisesForClient.AddRange(lol);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
}
}
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
OracleCommand get_client = new OracleCommand("FIND_INFO_CLIENT_FOR_ID", (OracleConnection)WindowOfViews.database.Database.Connection);
get_client.CommandType = CommandType.StoredProcedure;
var pResult1 = new OracleParameter("pResult1", OracleDbType.RefCursor, ParameterDirection.Output);
get_client.Parameters.Add(pResult1);
get_client.Parameters.Add("id_client1", WorkUserWindowViewModel.client.ID_CLIENT);
get_client.ExecuteNonQuery();
var res1 = (OracleRefCursor)pResult1.Value;
OracleDataReader reader1 = res1.GetDataReader();
DataTable dt1 = new DataTable();
dt1.Load(reader1);
OracleCommand get_dataclient = new OracleCommand("FIND_INFO_DATACLIENT", (OracleConnection)WindowOfViews.database.Database.Connection);
get_dataclient.CommandType = CommandType.StoredProcedure;
var pResult2 = new OracleParameter("pResult2", OracleDbType.RefCursor, ParameterDirection.Output);
get_dataclient.Parameters.Add(pResult2);
get_dataclient.Parameters.Add("Id_client1", WorkUserWindowViewModel.client.ID_CLIENT);
get_dataclient.ExecuteNonQuery();
var res2 = (OracleRefCursor)pResult2.Value;
OracleDataReader reader2 = res2.GetDataReader();
//DataTable dt2 = new DataTable();
//dt2.Load(reader2);
WindowOfViews.EditDataUser.FirstName.Text = dt1.Rows[0].ItemArray[0].ToString();
WindowOfViews.EditDataUser.SecondName.Text = dt1.Rows[0].ItemArray[1].ToString();
WindowOfViews.EditDataUser.Login.Text = dt1.Rows[0].ItemArray[2].ToString();
WindowOfViews.EditDataUser.Password.Text = dt1.Rows[0].ItemArray[3].ToString();
while (reader2.Read())
{
WindowOfViews.EditDataUser.Weight.Text = reader2[2].ToString();
WindowOfViews.EditDataUser.Height.Text = reader2[3].ToString();
WindowOfViews.EditDataUser.BodyType.Text = reader2[4].ToString();
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
int num = 0;
var clients = db.Client.ToList();
TextBox text = (TextBox)parameter;
var exer = db.ExercisesForClient.Where(i => i.Id_client.ToString() == text.Text).ToList();
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDayFirstExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDayFirstExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDayFirstExercise.Text;
num++;
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDaySecondExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDaySecondExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDaySecondExercise.Text;
num++;
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDayThirdExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDayThirdExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDayThirdExercise.Text;
num++;
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDayFourthExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDayFourthExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDayFourthExercise.Text;
num++;
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDayFifthExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDayFifthExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDayFifthExercise.Text;
num++;
exer.ElementAt(num).First_Day = WindowOfViews.EditUser.FirstDaySixthExercise.Text;
exer.ElementAt(num).Second_Day = WindowOfViews.EditUser.SecondDaySixthExercise.Text;
exer.ElementAt(num).Third_Day = WindowOfViews.EditUser.ThirdDaySixthExercise.Text;
db.SaveChanges();
MessageBox.Show("изменения прошли успешно");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//private void ThreadFunc()
//{
// while (true)
// {
// Thread.Sleep(5000);
// GetMessages();
// }
//}
private string GetMessages()
{
if (WindowOfViews.ChatTrainer != null)
{
Messages = "";
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
var sortmessages = (from u in db.Messages.ToList()
orderby u.Date ascending
select u).Where(i => i.Who_recipient == int.Parse(id) && i.Who_sender.ToString() == WorkTrainerWindowViewModel.trainer.id.ToString() ||
i.Who_recipient == WorkTrainerWindowViewModel.trainer.id && i.Who_sender == int.Parse(id));
for (int i = 0; i < sortmessages.Count(); i++)
{
Messages += sortmessages.ElementAt(i).Date + " " + sortmessages.ElementAt(i).messages1 + Environment.NewLine;
}
}
}
return(Messages);
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
WindowOfViews.EditDataUser.FirstName.Text = WorkUserWindowViewModel.client.FirstName;
WindowOfViews.EditDataUser.SecondName.Text = WorkUserWindowViewModel.client.SecondName;
WindowOfViews.EditDataUser.Login.Text = WorkUserWindowViewModel.client.Login;
WindowOfViews.EditDataUser.Password.Text = WorkUserWindowViewModel.client.Password;
WindowOfViews.EditDataUser.Weight.Text = WorkUserWindowViewModel.client.DataClient.Weight.ToString();
WindowOfViews.EditDataUser.Height.Text = WorkUserWindowViewModel.client.DataClient.Height.ToString();
WindowOfViews.EditDataUser.BodyType.Text = WorkUserWindowViewModel.client.DataClient.Bodytype.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
this.execute(parameter);
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
this.execute(parameter);
WindowOfViews.ChatUser = new ChatUser();
WindowOfViews.ChatUser.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
}
}
}
private static void getExercises()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
int num = 0;
var exer = db.ExercisesForClient.Where(i => i.Id_client == WorkUserWindowViewModel.client.id).ToList();
WindowOfViews.AddResult.FirstDayFirstExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDayFirstExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDayFirstExercise.Content = exer.ElementAt(num).Third_Day;
num++;
WindowOfViews.AddResult.FirstDaySecondExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDaySecondExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDaySecondExercise.Content = exer.ElementAt(num).Third_Day;
num++;
WindowOfViews.AddResult.FirstDayThirdExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDayThirdExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDayThirdExercise.Content = exer.ElementAt(num).Third_Day;
num++;
WindowOfViews.AddResult.FirstDayFourthExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDayFourthExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDayFourthExercise.Content = exer.ElementAt(num).Third_Day;
num++;
WindowOfViews.AddResult.FirstDayFifthExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDayFifthExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDayFifthExercise.Content = exer.ElementAt(num).Third_Day;
num++;
WindowOfViews.AddResult.FirstDaySixthExercise.Content = exer.ElementAt(num).First_Day;
WindowOfViews.AddResult.SecondDaySixthExercise.Content = exer.ElementAt(num).Second_Day;
WindowOfViews.AddResult.ThirdDaySixthExercise.Content = exer.ElementAt(num).Third_Day;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
Messages messages = new Messages();
Random value = new Random();
messages.id_Message = value.Next(0, 10000000);
messages.Who_sender = WorkTrainerWindowViewModel.trainer.id;
messages.Who_recipient = int.Parse(WindowOfViews.ChatTrainer.comboBox.Text);
messages.messages1 = WindowOfViews.ChatTrainer.messageText.Text;
messages.Date = DateTime.Now;
db.Messages.Add(messages);
db.SaveChanges();
ChatTrainerViewModel.lol.ChoiseClient = messages.Who_recipient.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
WorkUserWindowViewModel.client.FirstName = WindowOfViews.EditDataUser.FirstName.Text;
WorkUserWindowViewModel.client.SecondName = WindowOfViews.EditDataUser.SecondName.Text;
WorkUserWindowViewModel.client.Login = WindowOfViews.EditDataUser.Login.Text;
WorkUserWindowViewModel.client.Password = WindowOfViews.EditDataUser.Password.Text;
WorkUserWindowViewModel.client.DataClient.Weight = int.Parse(WindowOfViews.EditDataUser.Weight.Text);
WorkUserWindowViewModel.client.DataClient.Height = int.Parse(WindowOfViews.EditDataUser.Height.Text);
WorkUserWindowViewModel.client.DataClient.Bodytype = WindowOfViews.EditDataUser.BodyType.Text;
db.Entry(WorkUserWindowViewModel.client).State = EntityState.Modified;
db.Entry(WorkUserWindowViewModel.client.DataClient).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("изменения прошли успешно");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Execute(object parameter)
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
try
{
List <ResultExercises> listresult = new List <ResultExercises>();
var exer = db.ExercisesForClient.Where(i => i.Id_client == WorkUserWindowViewModel.client.id).ToList();
int num;
Random value = new Random();
for (num = 0; num < exer.Count; num++)
{
listresult.Add(new ResultExercises());
listresult.ElementAt(num).First_Day = exer.ElementAt(num).First_Day;
listresult.ElementAt(num).Second_Day = exer.ElementAt(num).Second_Day;
listresult.ElementAt(num).Third_Day = exer.ElementAt(num).Third_Day;
listresult.ElementAt(num).number = value.Next(0, 1000000);
listresult.ElementAt(num).Id_Client = exer.ElementAt(num).Id_client;
listresult.ElementAt(num).Date = DateTime.Now;
}
num = 0;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay1_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay1.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay1_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay1.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay1_Copy.Text;
listresult.ElementAt(num).Third_Day_Quantity = WindowOfViews.AddResult.ThirdDay1.Text;
num++;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay2_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay2.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay2_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay2.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay2.Text;
listresult.ElementAt(num).Third_Day_Quantity = WindowOfViews.AddResult.ThirdDay2.Text;
num++;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay3_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay3.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay3_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay3.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay3_Copy.Text;
listresult.ElementAt(num).Third_Day_Quantity = WindowOfViews.AddResult.ThirdDay3.Text;
num++;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay4_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay4.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay4_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay4.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay4_Copy.Text;
listresult.ElementAt(num).Third_Day_Quantity = WindowOfViews.AddResult.ThirdDay4.Text;
num++;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay5_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay5.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay5_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay5.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay5_Copy.Text;
listresult.ElementAt(num).Third_Day_Quantity = WindowOfViews.AddResult.ThirdDay5.Text;
num++;
listresult.ElementAt(num).First_Day_Weight = WindowOfViews.AddResult.FirstDay6_Copy.Text;
listresult.ElementAt(num).First_Day_Quantity = WindowOfViews.AddResult.FirstDay6.Text;
listresult.ElementAt(num).Second_Day_Weight = WindowOfViews.AddResult.SecondDay6_Copy.Text;
listresult.ElementAt(num).Second_Day_Quantity = WindowOfViews.AddResult.SecondDay6.Text;
listresult.ElementAt(num).Third_Day_Weight = WindowOfViews.AddResult.ThirdDay6_Copy.Text;
listresult.ElementAt(num).Third_Day_Quantity = (WindowOfViews.AddResult.ThirdDay6.Text);
num++;
bool fics = false;
int k;
for (int i = 0; i < exer.Count; i++)
{
if (listresult.ElementAt(i).First_Day_Weight != "" && !int.TryParse(listresult.ElementAt(i).First_Day_Weight, out k))
{
fics = true;
}
if (listresult.ElementAt(i).First_Day_Quantity != "" && !int.TryParse(listresult.ElementAt(i).First_Day_Quantity, out k))
{
fics = true;
}
if (listresult.ElementAt(i).Second_Day_Weight != "" && !int.TryParse(listresult.ElementAt(i).Second_Day_Weight, out k))
{
fics = true;
}
if (listresult.ElementAt(i).Second_Day_Quantity != "" && !int.TryParse(listresult.ElementAt(i).Second_Day_Quantity, out k))
{
fics = true;
}
if (listresult.ElementAt(i).Third_Day_Weight != "" && !int.TryParse(listresult.ElementAt(i).Third_Day_Weight, out k))
{
fics = true;
}
if (listresult.ElementAt(i).Third_Day_Quantity != "" && !int.TryParse(listresult.ElementAt(i).Third_Day_Quantity, out k))
{
fics = true;
}
}
if (fics == true)
{
throw new Exception("неверно введено значение");
}
if (fics == false)
{
db.ResultExercises.AddRange(listresult);
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public static List <ExercisesForClient> GetExercises()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
return(db.ExercisesForClient.ToList());
}
private static double GetProgress()
{
double progress11 = 1;
double progress12 = 1;
double progress13 = 1;
double progress21 = 1;
double progress22 = 1;
double progress23 = 1;
int crossexer = 0;
double progress = 0;
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
var exer = db.ResultExercises.Where(i => i.Id_Client == WorkUserWindowViewModel.client.id).ToList();
if (exer.Count() != 0)
{
try
{
var sortedexer = from u in exer
orderby u.Date descending
select u;
if (sortedexer.FirstOrDefault().First_Day_Quantity != "" && sortedexer.FirstOrDefault().Second_Day_Quantity != "" && sortedexer.FirstOrDefault().Third_Day_Quantity != "")
{
crossexer = 6;
}
if (sortedexer.FirstOrDefault().First_Day_Quantity == "" || sortedexer.FirstOrDefault().Second_Day_Quantity == "" || sortedexer.FirstOrDefault().Third_Day_Quantity == "")
{
crossexer = 12;
}
if (sortedexer.FirstOrDefault().First_Day_Quantity != "" && sortedexer.FirstOrDefault().Second_Day_Quantity == "" && sortedexer.FirstOrDefault().Third_Day_Quantity == "")
{
crossexer += 6;
}
if (sortedexer.FirstOrDefault().First_Day_Quantity == "" && sortedexer.FirstOrDefault().Second_Day_Quantity != "" && sortedexer.FirstOrDefault().Third_Day_Quantity == "")
{
crossexer += 6;
}
if (sortedexer.FirstOrDefault().First_Day_Quantity == "" && sortedexer.FirstOrDefault().Second_Day_Quantity == "" && sortedexer.FirstOrDefault().Third_Day_Quantity != "")
{
crossexer += 6;
}
for (int i = 0; i < crossexer; i++)
{
if (sortedexer.ElementAt(i).First_Day_Quantity != "")
{
if (sortedexer.ElementAt(i).First_Day_Weight != "" && sortedexer.ElementAt(i).First_Day_Quantity != "")
{
progress11 = int.Parse(sortedexer.ElementAt(i).First_Day_Weight);
progress11 = progress11 * int.Parse(sortedexer.ElementAt(i).First_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(i).First_Day_Weight == "" && sortedexer.ElementAt(i).First_Day_Quantity != "")
{
progress11 = int.Parse(sortedexer.ElementAt(i).First_Day_Quantity) * 10;
}
}
if (sortedexer.ElementAt(i).Second_Day_Quantity != "")
{
if (sortedexer.ElementAt(i).Second_Day_Weight != "" && sortedexer.ElementAt(i).Second_Day_Quantity != "")
{
progress12 = int.Parse(sortedexer.ElementAt(i).Second_Day_Weight);
progress12 = progress12 * int.Parse(sortedexer.ElementAt(i).Second_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(i).Second_Day_Weight == "" && sortedexer.ElementAt(i).Second_Day_Quantity != "")
{
progress12 = int.Parse(sortedexer.ElementAt(i).Second_Day_Quantity) * 10;
}
}
if (sortedexer.ElementAt(i).Third_Day_Quantity != "")
{
if (sortedexer.ElementAt(i).Third_Day_Weight != "" && sortedexer.ElementAt(i).Third_Day_Quantity != "")
{
progress13 = int.Parse(sortedexer.ElementAt(i).Third_Day_Weight);
progress13 = progress13 * int.Parse(sortedexer.ElementAt(i).Third_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(i).Third_Day_Weight == "" && sortedexer.ElementAt(i).Third_Day_Quantity != "")
{
progress13 = int.Parse(sortedexer.ElementAt(i).Third_Day_Quantity) * 10;
}
}
}
//--------------------------------------------------------------------------------------------------------------------
for (int k = sortedexer.Count() - crossexer; k < sortedexer.Count(); k++)
{
if (sortedexer.ElementAt(k).First_Day_Quantity != "")
{
if (sortedexer.ElementAt(k).First_Day_Weight != "" && sortedexer.ElementAt(k).First_Day_Quantity != "")
{
progress21 = int.Parse(sortedexer.ElementAt(k).First_Day_Weight);
progress21 = progress21 * int.Parse(sortedexer.ElementAt(k).First_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(k).First_Day_Weight == "" && sortedexer.ElementAt(k).First_Day_Quantity != "")
{
progress21 = int.Parse(sortedexer.ElementAt(k).First_Day_Quantity) * 10;
}
}
if (sortedexer.ElementAt(k).Second_Day_Quantity != "")
{
if (sortedexer.ElementAt(k).Second_Day_Weight != "" && sortedexer.ElementAt(k).Second_Day_Quantity != "")
{
progress22 = int.Parse(sortedexer.ElementAt(k).Second_Day_Weight);
progress22 = progress22 * int.Parse(sortedexer.ElementAt(k).Second_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(k).Second_Day_Weight == "" && sortedexer.ElementAt(k).Second_Day_Quantity != "")
{
progress22 = int.Parse(sortedexer.ElementAt(k).Second_Day_Quantity) * 10;
}
}
if (sortedexer.ElementAt(k).Third_Day_Quantity != "")
{
if (sortedexer.ElementAt(k).Third_Day_Weight != "" && sortedexer.ElementAt(k).Third_Day_Quantity != "")
{
progress23 = int.Parse(sortedexer.ElementAt(k).Third_Day_Weight);
progress23 = progress23 * int.Parse(sortedexer.ElementAt(k).Third_Day_Quantity) * 0.8;
}
if (sortedexer.ElementAt(k).Third_Day_Weight == "" && sortedexer.ElementAt(k).Third_Day_Quantity != "")
{
progress23 = int.Parse(sortedexer.ElementAt(k).Third_Day_Quantity) * 10;
}
}
}
if (progress21 != 1 && progress22 != 1 && progress23 != 1)
{
progress = (progress21 + progress22 + progress23) / (progress11 + progress12 + progress13);
}
if (progress21 == 1)
{
progress = (double)client.DataClient.Progress * (progress21 / progress11);
}
if (progress22 == 1)
{
progress = (double)client.DataClient.Progress * (progress22 / progress12);
}
if (progress23 == 1)
{
progress = (double)client.DataClient.Progress * (progress23 / progress13);
}
client.DataClient.Progress = Math.Round(progress, 2);
db.Entry(client.DataClient).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
}
}
}
return(Math.Round(progress, 2));
}
private List <ExercisesForClient> GenerateExercises(object parameter)
{
List <ExercisesForClient> list = new List <ExercisesForClient>();
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Random value = new Random();
int rand = value.Next(0, 8);
Client client1 = (Client)parameter;
for (int k = 0; k < 6; k++)
{
list.Add(new ExercisesForClient());
list.ElementAt(k).Number = value.Next(0, 10000);
list.ElementAt(k).Id_client = client1.id;
}
string First_Day = "";
string Second_Day = "";
string Third_Day = "";
var exercises = db.Exercises.ToList();
string[] GroupMus = Mas();
int i = 0;
int firstday = 0;
int secondday = 0;
int thirdday = 0;
if (rand >= 6)
{
rand = 6;
}
while (firstday < 6 || secondday < 6 || thirdday < 6)
{
foreach (var exer in exercises)
{
if (GroupMus[rand] == exer.MuscleGroups)
{
First_Day += exer.Exercises1 + ", ";
firstday++;
if (firstday == 2 || firstday == 4 || firstday == 6)
{
GroupMus[rand] = null;
}
}
if (GroupMus[rand + 1] == exer.MuscleGroups)
{
Second_Day += exer.Exercises1 + ", ";
secondday++;
if (secondday == 2 || secondday == 4 || secondday == 6)
{
GroupMus[rand + 1] = null;
}
}
if (GroupMus[rand + 2] == exer.MuscleGroups)
{
Third_Day += exer.Exercises1 + ", ";
thirdday++;
if (thirdday == 2 || thirdday == 4 || thirdday == 6)
{
GroupMus[rand + 2] = null;
}
}
if (GroupMus[rand] == null && GroupMus[rand + 1] == null && GroupMus[rand + 2] == null)
{
rand += 3;
if (rand >= 6)
{
rand = 6;
}
if (GroupMus[8] == null && i == 0)
{
i++;
rand = 0;
}
}
}
}
string[] first = First_Day.Split(new char[] { ',' });
string[] second = Second_Day.Split(new char[] { ',' });
string[] third = Third_Day.Split(new char[] { ',' });
for (int k = 0; k < 6; k++)
{
list.ElementAt(k).First_Day = first[k];
list.ElementAt(k).Second_Day = second[k];
list.ElementAt(k).Third_Day = third[k];
}
}
catch (Exception ex)
{
MessageBox.Show("не удалось сгенерировать программу тренировок");
transaction.Rollback();
}
}
}
return(list);
}
public static List <Client> GetClients()
{
using (BD_KURSACH_Entities db = new BD_KURSACH_Entities())
return(db.Client.ToList());
}
