public void Save(Student student) { Boolean insert = true; if (student.Id != 0) { insert = false; } base.Save(student); this._db.OpenConnection(); MySqlCommand command = this._db.CreateCommand(); if (insert) { command.CommandText = "INSERT INTO student (user_id, studentnumber, study) VALUES " + "(?user_id, ?studentnumber, ?study)"; } else { command.CommandText = "UPDATE student (studentnumber, study) VALUES " + "(?studentnumber, ?study) WHERE user_id = ?user_id"; } command.Parameters.Add(new MySqlParameter("?user_id", MySqlDbType.Int32)).Value = student.Id; command.Parameters.Add(new MySqlParameter("?studentnumber", MySqlDbType.Int32)).Value = student.Studentnumber; command.Parameters.Add(new MySqlParameter("?study", MySqlDbType.String)).Value = student.Study; this._db.ExecuteCommand(command); this._db.CloseConnection(); if (insert) { Pair pair = new Pair(); pair.Student1 = student; pair.Student1_id = student.Id; PAZController.GetInstance().PairMapper.Save(pair); } }
public DeleteDataWindow() { InitializeComponent(); _controller = PAZController.GetInstance(); _users = _controller.UserMapper.FindAll(); _deleteList = new List <object>(); List <User> _admins = new List <User>(); foreach (User user in _users) { if (user.User_type == "admin") { _admins.Add(user); } } // Dit moet wel zo, omdat de admins niet direct in de users list kunnen worden verwijderd tijdens een loop foreach (User admin in _admins) { _users.Remove(admin); } _users.Sort(); PersonenToevoegen(); }
public static MysqlDb GetInstance() { if (MysqlDb._db == null) { IniFile ini = PAZController.GetInstance().IniReader; MysqlDb._db = new MysqlDb(ini["DATABASESETTINGS"]["db_host"], ini["DATABASESETTINGS"]["db_username"], ini["DATABASESETTINGS"]["db_password"], ini["DATABASESETTINGS"]["db_database"]); } return(MysqlDb._db); }
public LetterWindow(List <SessionRow> sessions, LetterTemplate letterTemplate) { InitializeComponent(); tbKenmerk.Text = letterTemplate.Kenmerk; tbContactpersonen.Text = letterTemplate.Contactpersonen; tbTelefoon.Text = letterTemplate.Telefoon; tbEmail.Text = letterTemplate.Email; tbAvansAdres.Text = letterTemplate.AvansAdres; tbAvansLocatie.Text = letterTemplate.AvansLocatie; tbBeginKern.Text = letterTemplate.BeginKern; tbReisInformatie.Text = letterTemplate.ReisInformatie; tbVerdereInformatie.Text = letterTemplate.VerdereInformatie; tbAfzenders.Text = letterTemplate.Afzenders; tbBijlagen.Text = letterTemplate.Bijlagen; tbVoettekstLinks.Text = letterTemplate.VoettekstLinks; tbVoettekstMidden.Text = letterTemplate.VoettekstCenter; tbVoettekstRechts.Text = letterTemplate.VoettekstRechts; _experts = new List <Expert>(); _receivers = new Dictionary <int, Expert>(); _sessions = sessions; // Note: Dit ziet er misschien klote uit, maar een List.Contains check schijnt niet te werken(mogelijk zijn er dubbele expert objecten?) Dictionary <int, Expert> experts = new Dictionary <int, Expert>(); foreach (SessionRow session in sessions) { Session sessionModel = session.GetSessionModel(); foreach (KeyValuePair <int, Expert> keyValuePair in sessionModel.Experts) { if (!experts.ContainsKey(keyValuePair.Key)) { experts.Add(keyValuePair.Key, keyValuePair.Value); } } } // En nu weer naar een List omdat Dictionary faalt en niet kan sorten foreach (KeyValuePair <int, Expert> keyValuePair in experts) { _experts.Add(keyValuePair.Value); } _experts.Sort(); ExpertsToevoegen(); _controller = PAZController.GetInstance(); _ini = _controller.IniReader; _letterTemplate = letterTemplate; btnSave.IsEnabled = false; }
public EmailWindow(List <SessionRow> sessions, EmailTemplate emailTemplate) { InitializeComponent(); tbAfzender.Text = emailTemplate.Displayname; tbInleiding.Text = emailTemplate.Inleiding; tbInformatie.Text = emailTemplate.Informatie; tbAfsluiting.Text = emailTemplate.Afsluiting; tbAfzenders.Text = emailTemplate.Afzenders; _teachers = new List <Teacher>(); _students = new List <Student>(); _receivers = new List <User>(); _sessions = sessions; // Note: Dit ziet er misschien klote uit, maar een List.Contains check schijnt niet te werken(mogelijk zijn er dubbele teacher objecten?) Dictionary <int, Teacher> teachers = new Dictionary <int, Teacher>(); foreach (SessionRow session in sessions) { Session sessionModel = session.GetSessionModel(); foreach (KeyValuePair <int, Teacher> keyValuePair in sessionModel.Teachers) { if (!teachers.ContainsKey(keyValuePair.Key)) { teachers.Add(keyValuePair.Key, keyValuePair.Value); } } _students.Add(sessionModel.Pair.Student1); _students.Add(sessionModel.Pair.Student2); } // En nu weer naar een List omdat Dictionary faalt en niet kan sorten foreach (KeyValuePair <int, Teacher> keyValuePair in teachers) { _teachers.Add(keyValuePair.Value); } _students.Sort(); _teachers.Sort(); StudentenToevoegen(); DocentenToevoegen(); _controller = PAZController.GetInstance(); _ini = _controller.IniReader; _emailTemplate = emailTemplate; btnSave.IsEnabled = false; }
public void Save(User user) { this._db.OpenConnection(); MySqlCommand command = this._db.CreateCommand(); if (user.Id != 0) { command.CommandText = "UPDATE user SET username=?username, firstname=?firstname, surname=?surname, email=?email, user_type=?user_type, status=?status, was_changed=?was_changed WHERE id = ?id"; command.Parameters.Add(new MySqlParameter("?id", MySqlDbType.Int32)).Value = user.Id; } else { command.CommandText = "INSERT INTO user (username, firstname, surname, email, user_type, status, was_changed) VALUES " + "(?username, ?firstname, ?surname, ?email, ?user_type, ?status, ?was_changed)"; } command.Parameters.Add(new MySqlParameter("?username", MySqlDbType.String)).Value = user.Username; command.Parameters.Add(new MySqlParameter("?firstname", MySqlDbType.String)).Value = user.Firstname; command.Parameters.Add(new MySqlParameter("?surname", MySqlDbType.String)).Value = user.Surname; command.Parameters.Add(new MySqlParameter("?email", MySqlDbType.String)).Value = user.Email; command.Parameters.Add(new MySqlParameter("?user_type", MySqlDbType.String)).Value = user.User_type; command.Parameters.Add(new MySqlParameter("?status", MySqlDbType.String)).Value = user.Status; command.Parameters.Add(new MySqlParameter("?was_changed", MySqlDbType.Int32)).Value = user.WasChanged; this._db.ExecuteCommand(command); this._db.CloseConnection(); if (user.Id == 0) { this._db.OpenConnection(); MySqlCommand command2 = this._db.CreateCommand(); command2.CommandText = "SELECT LAST_INSERT_ID()"; MySqlDataReader Reader = this._db.ExecuteCommand(command2); Reader.Read(); this._db.CloseConnection(); user.Id = Reader.GetInt32(0); } this._db.OpenConnection(); MySqlCommand command3 = this._db.CreateCommand(); command3.CommandText = "DELETE FROM blocked_timeslot WHERE user_id = ?user_id"; command3.Parameters.Add(new MySqlParameter("?user_id", MySqlDbType.Int32)).Value = user.Id; this._db.ExecuteCommand(command3); this._db.CloseConnection(); BlockedTimeslotMapper blockedtimeslotmapper = PAZController.GetInstance().BlockedTimeslotMapper; foreach (Blocked_timeslot slot in user.BlockedTimeslots) { slot.User = user; blockedtimeslotmapper.Save(slot); } }
public KoppelWindow() { InitializeComponent(); _controller = PAZController.GetInstance(); btnSave.IsEnabled = false; _pairs = _controller.PairMapper.FindAll(); _students = _controller.StudentMapper.FindAll(); _teachers = _controller.TeacherMapper.FindAll(); _experts = _controller.ExpertMapper.FindAll(); fillPairs(); fillStudents(); fillTeachers(); fillExperts(); }
public SessionWindow(Session session) { InitializeComponent(); _controller = PAZController.GetInstance(); List <Pair> pairs = _controller.PairMapper.FindAll(); foreach (Pair pair in pairs) { cbPairs.Items.Add(pair.ID + ", " + pair.ToString()); } foreach (Teacher teacher in _controller.TeacherMapper.FindAll()) { cbTeacher1.Items.Add(teacher.Id + ", " + teacher.ToString()); cbTeacher2.Items.Add(teacher.Id + ", " + teacher.ToString()); } foreach (Expert expert in _controller.ExpertMapper.FindAll()) { cbExpert1.Items.Add(expert.Id + ", " + expert.ToString()); cbExpert2.Items.Add(expert.Id + ", " + expert.ToString()); } List <string> teachers = new List <string>(); List <string> experts = new List <string>(); foreach (User user in session.Pair.Attachments) { if (user.User_type == "teacher") { Teacher t = _controller.TeacherMapper.Find(user.Id); teachers.Add(t.Id + ", " + t.ToString()); } else if (user.User_type == "expert") { Expert t = _controller.ExpertMapper.Find(user.Id); experts.Add(t.Id + ", " + t.ToString()); } } ids[0] = session.Pair.ID; string[] temp; cbPairs.SelectedIndex = cbPairs.Items.IndexOf(session.Pair.ID + ", " + session.Pair.ToString()); if (teachers.Count > 0) { cbTeacher1.SelectedIndex = cbTeacher1.Items.IndexOf(teachers[0]); cbTeacher2.SelectedIndex = cbTeacher2.Items.IndexOf(teachers[1]); temp = teachers[0].Split(','); ids[1] = Convert.ToInt32(temp[0]); temp = teachers[1].Split(','); ids[2] = Convert.ToInt32(temp[0]); } if (experts.Count > 0) { cbExpert1.SelectedIndex = cbExpert1.Items.IndexOf(experts[0]); cbExpert2.SelectedIndex = cbExpert2.Items.IndexOf(experts[1]); temp = experts[0].Split(','); ids[3] = Convert.ToInt32(temp[0]); temp = experts[1].Split(','); ids[4] = Convert.ToInt32(temp[0]); } }
public string GetStarttime() { return(PAZController.GetInstance().TimeslotMapper.Find(this.Timeslot).Time.Split(new char[] { '-' })[0]); }