private void B_ent_Click(object sender, RoutedEventArgs e)
{
try
{
string conn_param = "Server=127.0.0.1;Port=5432;User Id=Training_login;Password=0000;Database=Training;";
string sql = "select login_trainer('" + tb_log.Text + "', '" + tb_pass.Password + "')";
NpgsqlConnection conn = new NpgsqlConnection(conn_param);
NpgsqlCommand comm = new NpgsqlCommand(sql, conn);
conn.Open();
int result = (int)comm.ExecuteScalar();
conn.Close();
if (result == -1)
{
MessageBox.Show("Пользователя с таким логином не существует", "Ошибка авторизации", MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
else
{
if (result == -2)
{
MessageBox.Show("Пара логин-пароль не совпадают", "Ошибка авторизации", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
Main_win main = new Main_win(this, result, tb_log.Text, tb_pass.Password);
main.Show();
Hide();
}
}
}catch (Exception ex) { MessageBox.Show(ex.Message); }
}
public Profile_win(Main_win super)
{
InitializeComponent();
this.super = super;
NpgsqlCommand comm = new NpgsqlCommand("select * from my_own_trainer(" + super.user_id + ")", super.conn);
try
{
super.conn.Open();
NpgsqlDataReader reader = comm.ExecuteReader();
reader.Read();
l_name.Content = reader.GetString(2) + " " + reader.GetString(1) + " " + reader.GetString(3);
l_birthday.Content += reader.GetDate(4).ToString();
l_mail.Content += reader.GetValue(5).ToString();
l_login.Content += reader.GetString(6);
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
}
public Profedit_win(Main_win super, Profile_win profile)
{
this.super = super;
prof_win = profile;
InitializeComponent();
string sql = "select login, pass, mail, fname, sname, pname from my_own_trainer(" + super.user_id + ")";
NpgsqlCommand comm = new NpgsqlCommand(sql, super.conn);
try
{
super.conn.Open();
NpgsqlDataReader reader = comm.ExecuteReader();
reader.Read();
old_login = tb_login.Text = reader.GetString(0);
tb_pass.Password = reader.GetString(1);
tb_repass.Password = reader.GetString(1);
tb_mail.Text = reader.GetValue(2).ToString();
tb_fname.Text = reader.GetString(3);
tb_sname.Text = reader.GetString(4);
tb_pname.Text = reader.GetString(5);
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
}
public View_win(Main_win super, int group_id)
{
InitializeComponent();
this.super = super;
string sql = "select customer_view.id, sname, fname, pname, age, mail " +
"from customer_view, \"customer-customer_group\" " +
"where customer_view.id = \"customer-customer_group\".id_customer and \"customer-customer_group\".id_group = " + group_id;
NpgsqlCommand comm = new NpgsqlCommand(sql, super.conn);
NpgsqlDataReader reader;
try
{
super.conn.Open();
reader = comm.ExecuteReader();
for (int i = 0; reader.Read(); i++)
{
dg_list.Items.Add(new CustomerList(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), (int)reader.GetDouble(4), reader.GetValue(5).ToString()));
}
super.conn.Close();
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
}
public XrcsList_win(Crtgr_win crt_win, Main_win super, List <ExerciseList> exerc_list) //Список передаётся для отметок уже добавленных упражнений
{
InitializeComponent();
this.super = super;
crtgr = crt_win;
list = exerc_list;
FillPickTable();
FillUnpickTable();
}
public CrtXrcs_win(Main_win super, ExerciseList exercise)
{
InitializeComponent();
b_accept.Visibility = Visibility.Collapsed;
gb_muscle.Margin = new Thickness(10, 70, 10, 10);
tb_name.IsReadOnly = true;
tb_name.Text = exercise.name;
Title = "Информация об упражнении";
this.super = super;
List <XTreeViewItem> groups = new List <XTreeViewItem>();
string sql = "select group_id, group_name from muscle_view, \"exercise-muscle\" where \"exercise-muscle\".id_muscle = muscle_view.muscle_id and \"exercise-muscle\".id_exercise = " + exercise.id + " group by group_id, group_name";
NpgsqlCommand comm = new NpgsqlCommand(sql, super.conn);
try
{
super.conn.Open();
NpgsqlDataReader reader = comm.ExecuteReader();
for (int i = 0; reader.Read(); i++)
{
groups.Add(new XTreeViewItem(reader.GetInt32(0), reader.GetString(1)));
}
super.conn.Close();
comm.CommandText = "Select group_id, muscle_id, muscle_name from muscle_view, \"exercise-muscle\" where \"exercise-muscle\".id_muscle = muscle_view.muscle_id and \"exercise-muscle\".id_exercise = " + exercise.id;
super.conn.Open();
reader = comm.ExecuteReader();
for (int i = 0; reader.Read(); i++)
{
groups.Find(gr => gr.id == reader.GetInt32(0)).Items.Add(new XTreeViewItem(reader.GetInt32(1), reader.GetString(2)));
}
super.conn.Close();
foreach (var item in groups)
{
tv_main.Items.Add(item);
}
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
}
public CrtXrcs_win(Main_win super, XrcsList_win table)
{
InitializeComponent();
this.super = super;
table_win = table;
NpgsqlCommand comm = new NpgsqlCommand("select group_id, group_name from muscle_view group by group_id, group_name order by group_id", super.conn);
try
{
super.conn.Open();
NpgsqlDataReader reader = comm.ExecuteReader();
List <XTreeViewItem> list = new List <XTreeViewItem>();
for (int i = 0; reader.Read(); i++)
{
XTreeViewItem item = new XTreeViewItem(reader.GetInt32(0), reader.GetString(1));
list.Add(item);
}
for (int i = 0; i < list.Count; i++)
{
string sql = "select muscle_id, muscle_name from muscle_view where group_id = " + list[i].id + " group by muscle_id, muscle_name ";
comm = new NpgsqlCommand(sql, super.conn);
super.conn.Close();
super.conn.Open();
reader = comm.ExecuteReader();
for (int j = 0; reader.Read(); j++)
{
list[i].Items.Add(new XCheckBox(reader.GetInt32(0), reader.GetString(1)));
}
tv_main.Items.Add(list[i]);
}
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
}
public Passreq(Main_win super, Profile_win prof)
{
this.super = super;
this.prof = prof;
InitializeComponent();
}
public Crtgr_win(Main_win super, GroupList group, bool edit)
{
InitializeComponent();
this.super = super;
Title = "Тренер: " + group.trainer;
b_save.Click += B_save_Click_2;
NpgsqlCommand comm = new NpgsqlCommand("select * from customer_group where id = " + group.id, super.conn);
group_id = group.id;
try
{
super.conn.Open();
NpgsqlDataReader reader = comm.ExecuteReader();
reader.Read();
var timestamps = (TimeSpan[])reader.GetValue(5);
week = (bool[])reader.GetValue(6);
for (int i = 0; i < timestamps.Length; i++)
{
if (week[i])
{
timetable[i] = timestamps[i].Hours.ToString() + ":" + (timestamps[i].Minutes.ToString().Length == 1 ? "0" + timestamps[i].Minutes.ToString() : timestamps[i].Minutes.ToString());
}
}
int min_age_db;
int max_age_db;
try { min_age_db = reader.GetInt32(3); } catch { min_age_db = 0; }
try { max_age_db = reader.GetInt32(4); } catch { max_age_db = 0; }
num_cost.Text = reader.GetInt32(2).ToString();
num_minage.Text = min_age_db.ToString();
num_maxage.Text = max_age_db.ToString();
cb_minage.IsChecked = !num_minage.Text.Equals("0");
cb_maxage.IsChecked = !num_maxage.Text.Equals("0");
super.conn.Close();
comm.CommandText = "select exercise.id, exercise.name " +
"from exercise, \"customer_group-exercise\" " +
"where \"customer_group-exercise\".id_exercise = exercise.id and \"customer_group-exercise\".id_group = " + group.id;
super.conn.Open();
reader = comm.ExecuteReader();
for (int i = 0; reader.Read(); i++)
{
exerciseList.Add(new ExerciseList(reader.GetInt32(0), reader.GetString(1)));
}
super.conn.Close();
UpdateList();
}
catch (NpgsqlException ex)
{
MessageBox.Show(ex.Message, "Ошибка на сервере", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
finally { super.conn.Close(); }
cb_mon.IsChecked = week[0];
cb_tue.IsChecked = week[1];
cb_wed.IsChecked = week[2];
cb_thu.IsChecked = week[3];
cb_fri.IsChecked = week[4];
cb_sat.IsChecked = week[5];
cb_sun.IsChecked = week[6];
tp_mon.Text = timetable[0];
tp_tue.Text = timetable[1];
tp_wed.Text = timetable[2];
tp_thu.Text = timetable[3];
tp_fri.Text = timetable[4];
tp_sat.Text = timetable[5];
tp_sun.Text = timetable[6];
if (!edit)
{
cb_mon.IsEnabled = cb_tue.IsEnabled = cb_wed.IsEnabled = cb_thu.IsEnabled = cb_fri.IsEnabled = cb_sat.IsEnabled = cb_sun.IsEnabled = false;
tp_mon.AllowSpin = tp_mon.AllowTextInput = false;
tp_tue.AllowSpin = tp_tue.AllowTextInput = false;
tp_wed.AllowSpin = tp_wed.AllowTextInput = false;
tp_thu.AllowSpin = tp_thu.AllowTextInput = false;
tp_fri.AllowSpin = tp_fri.AllowTextInput = false;
tp_sat.AllowSpin = tp_sat.AllowTextInput = false;
tp_sun.AllowSpin = tp_sun.AllowTextInput = false;
num_cost.AllowSpin = num_cost.AllowTextInput = false;
num_maxage.AllowSpin = num_maxage.AllowTextInput = false;
num_minage.AllowSpin = num_minage.AllowTextInput = false;
cb_minage.IsEnabled = cb_maxage.IsEnabled = false;
b_add_exerc.Visibility = Visibility.Collapsed;
dg_list.Margin = new Thickness(0);
b_save.Visibility = Visibility.Collapsed;
l_cost.Margin = new Thickness(10, 0, 0, 35);
num_cost.Margin = new Thickness(116, 0, 0, 35);
gb_age.Margin = new Thickness(10, 0, 0, 75);
gb_timetable.Margin = new Thickness(10, 0, 0, 160);
}
}
public Crtgr_win(Main_win super)
{
InitializeComponent();
this.super = super;
b_save.Click += B_save_Click_1;
}
