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