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