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);
}
}
private void SelectCoupledUsers(Pair selectedPair, ComboBox firstBox, ComboBox secondBox)
{
bool userSelected = false;
bool foundAllUsers = false;
for (int i = 1; i < firstBox.Items.Count && !foundAllUsers; ++i)
{
User currentUser = (User)firstBox.Items[i];
foreach (User user in selectedPair.Attachments)
{
if (currentUser.Id == user.Id)
{
if (userSelected)
{
secondBox.SelectedIndex = i;
foundAllUsers = true;
break;
}
else
{
firstBox.SelectedIndex = i;
userSelected = true;
}
}
}
}
if (!foundAllUsers)
secondBox.SelectedIndex = 0;
if (!userSelected)
firstBox.SelectedIndex = 0;
}
