private void ReadUI()
{
if (currentAnnotation == null)
{
currentAnnotation = new StudentAnnotation();
}
currentAnnotation.IsActive = chkCurrentAnnotationActive.Checked;
currentAnnotation.IdSchoolYear = txtSchoolYear.Text;
if (txtAnnotation.Text != "")
{
currentAnnotation.IdAnnotation = SafeDb.SafeInt(txtIdAnnotation.Text);
}
else
{
currentAnnotation.IdAnnotation = null;
}
if (currentAnnotation.IdStudent != 0)
{
currentAnnotation.IdStudent = SafeDb.SafeInt(txtIdStudent.Text);
}
else
{
currentAnnotation.IdStudent = null;
}
currentAnnotation.Annotation = txtAnnotation.Text;
}
private Student GetStudentFromRow(DbDataReader Row)
{
Student s = new Student();
s.IdStudent = (int)Row["IdStudent"];
s.LastName = SafeDb.SafeString(Row["LastName"]);
s.FirstName = SafeDb.SafeString(Row["FirstName"]);
s.Residence = SafeDb.SafeString(Row["Residence"]);
s.Origin = SafeDb.SafeString(Row["Origin"]);
s.Email = SafeDb.SafeString(Row["Email"]);
if (!(Row["birthDate"] is DBNull))
{
s.BirthDate = SafeDb.SafeDateTime(Row["birthDate"]);
}
s.BirthPlace = SafeDb.SafeString(Row["birthPlace"]);
s.Eligible = SafeDb.SafeBool(Row["drawable"]);
s.Disabled = SafeDb.SafeBool(Row["disabled"]);
s.RevengeFactorCounter = SafeDb.SafeInt(Row["VFCounter"]);
return(s);
}
private User GetUserFromRow(DbDataReader dRead)
{
User u = null;
if (dRead.HasRows)
{
u = new User(SafeDb.SafeString(dRead["username"]),
SafeDb.SafeString(dRead["password"]));
u.Description = SafeDb.SafeString(dRead["description"]);
u.LastName = SafeDb.SafeString(dRead["lastName"]);
u.FirstName = SafeDb.SafeString(dRead["firstName"]);
u.Email = SafeDb.SafeString(dRead["email"]);
//u.Password = SafeDb.SafeString(dRead["password"]);
u.LastChange = SafeDb.SafeDateTime(dRead["lastChange"]);
u.LastPasswordChange = SafeDb.SafeDateTime(dRead["lastPasswordChange"]);
u.CreationTime = SafeDb.SafeDateTime(dRead["creationTime"]);
u.Salt = SafeDb.SafeString(dRead["salt"]);
u.IdUserCategory = SafeDb.SafeInt(dRead["idUserCategory"]);
u.IsEnabled = SafeDb.SafeBool(dRead["isEnabled"]);
}
return(u);
}