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; }