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]);
}
public void createCalendar(Ini.IniFile ini, List <Classroom> classrooms, PAZController controller)
{
_controller = controller;
DateTime startDate = DateTime.Parse(ini["DATES"]["startdate"]);
DateTime stopDate = DateTime.Parse(ini["DATES"]["enddate"]);
Brush headerColor = Brushes.LightGray;
int interval = 1;
int rows = 0;
//Firste column color rec
Rectangle recC = new Rectangle();
recC.Fill = headerColor;
Grid.SetColumn(recC, 0);
Grid.SetRow(recC, 0);
Children.Add(recC);
//Defining rowdef & row height
RowDefinition row = new RowDefinition();
GridLength height = new GridLength(140);
for (DateTime dateTime = startDate; dateTime <= stopDate; dateTime += TimeSpan.FromDays(interval))
{
if (dateTime.DayOfWeek != DayOfWeek.Sunday && dateTime.DayOfWeek != DayOfWeek.Saturday)
{
//Adding color
Rectangle rec = new Rectangle();
rec.Fill = headerColor;
Grid.SetColumn(rec, 0);
Grid.SetRow(rec, rows);
Grid.SetColumnSpan(rec, classrooms.Count + 1);
Children.Add(rec);
//Add labels
for (int c = 0; c < classrooms.Count + 1; c++)
{
if (ColumnDefinitions.Count != classrooms.Count + 1)
{
//making columns
ColumnDefinition column = new ColumnDefinition();
GridLength width;
if (c == 0)
{
width = new GridLength(75);
}
else
{
width = new GridLength(120);
}
column.Width = width;
ColumnDefinitions.Add(column);
}
//making labels
Label header = new Label();
if (c == 0)
{
header.Content = dateTime.ToString("dddd",
new CultureInfo("nl-NL")) + "\n" + dateTime.ToShortDateString();
}
else
{
header.Content = classrooms[c - 1].Room_number;
}
header.VerticalContentAlignment = System.Windows.VerticalAlignment.Center;
header.HorizontalContentAlignment = System.Windows.HorizontalAlignment.Center;
Grid.SetColumn(header, c);
Grid.SetRow(header, rows);
Children.Add(header);
}
List <Timeslot> timeslots = controller.Timeslots;
//Making rows
for (int block = 0; block < timeslots.Count; ++block)
{
row = new RowDefinition();
//blok 0 = row for headers(classrooms,date)
if (block == 0)
{
row.Height = new GridLength(60);
}
else
{
row.Height = height;
}
RowDefinitions.Add(row);
rows++;
Label blk = new Label();
blk.Content = timeslots[block].Time;
blk.VerticalContentAlignment = System.Windows.VerticalAlignment.Center;
blk.HorizontalContentAlignment = System.Windows.HorizontalAlignment.Center;
Grid.SetColumn(blk, 0);
Grid.SetRow(blk, rows);
Children.Add(blk);
}
//Maken dateGrids
Grid dateGrid = new Grid();
for (int i = 0; i < ColumnDefinitions.Count - 1; i++)
{
ColumnDefinition column = new ColumnDefinition();
GridLength width = new GridLength(120);
column.Width = width;
dateGrid.ColumnDefinitions.Add(column);
}
for (int i = 0; i < 4; i++)
{
row = new RowDefinition();
row.Height = height;
dateGrid.RowDefinitions.Add(row);
}
for (int j = 0; j < 4; j++)
{
for (int i = 0; i < dateGrid.ColumnDefinitions.Count; i++)
{
CustomLabel emptySession = new CustomLabel();
Grid.SetColumn(emptySession, i);
Grid.SetRow(emptySession, j);
emptySession.AllowDrop = true;
emptySession.Drop += new DragEventHandler(Session_Drop);
dateGrid.Children.Add(emptySession);
}
}
Grid.SetColumn(dateGrid, 1);
Grid.SetColumnSpan(dateGrid, dateGrid.ColumnDefinitions.Count);
Grid.SetRow(dateGrid, rows - 3);
Grid.SetRowSpan(dateGrid, dateGrid.RowDefinitions.Count);
dateGrid.ShowGridLines = true;
dateGrids.Add(dateTime.ToShortDateString(), dateGrid);
Children.Add(dateGrid);
//row block 4
row = new RowDefinition();
row.Height = height;
RowDefinitions.Add(row);
rows++;
}
}
//set first column color over all rows
Grid.SetRowSpan(recC, rows);
}
