public User GetUserByID(short id)
{
DataRow[] rows = _studentRecords.Users.Select("ID = '" + id + "'");
StudentRecordsDataSet.UsersRow r = (StudentRecordsDataSet.UsersRow)rows[0];
User user = new User(r.ID, r.UserName, r.Password, r.FirstName, r.LastName);
user.SetUserGroups(GetUserGroups(r.ID));
User.UserDemographicData d = user.GetData();
if (rows[0][5] != DBNull.Value) d.SetSSN(r.SocialSecurityNumber);
if (rows[0][6] != DBNull.Value) d.SetPhoneNumber(r.PhoneNumber);
if (rows[0][7] != DBNull.Value) d.SetPreferredEmailAddress(r.PreferredEmailAddress);
if (rows[0][8] != DBNull.Value) d.SetCurrentHomeAddress(r.CurrentHomeAddress);
if (rows[0][9] != DBNull.Value) d.SetCity(r.City);
if (rows[0][10] != DBNull.Value) d.SetState(r.State);
if (rows[0][11] != DBNull.Value) d.SetCountry(r.Country);
return user;
}
public User GetUser(String uName, String pWord)
{
String expression = "UserName = '******'";
expression += " AND ";
expression += "Password = '******'";
DataRow[] rows = _studentRecords.Users.Select(expression);
StudentRecordsDataSet.UsersRow r = (StudentRecordsDataSet.UsersRow)rows[0];
User user = new User(r.ID, r.UserName, r.Password, r.FirstName, r.LastName);
user.SetUserGroups(GetUserGroups(r.ID));
User.UserDemographicData d = user.GetData();
if(rows[0][5] != DBNull.Value) d.SetSSN(r.SocialSecurityNumber);
if(rows[0][6] != DBNull.Value) d.SetPhoneNumber(r.PhoneNumber);
if(rows[0][7] != DBNull.Value) d.SetPreferredEmailAddress(r.PreferredEmailAddress);
if(rows[0][8] != DBNull.Value) d.SetCurrentHomeAddress(r.CurrentHomeAddress);
if(rows[0][9] != DBNull.Value) d.SetCity(r.City);
if(rows[0][10] != DBNull.Value) d.SetState(r.State);
if(rows[0][11] != DBNull.Value) d.SetCountry(r.Country);
return user;
}
