protected void Button1_Click(object sender, EventArgs e) { SqlConnection conn = null; SqlDataReader dr = null; try { UserRepository ur = new UserRepository(); conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataServices"].ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand("Select * from [dbo].[User]", conn); dr = cmd.ExecuteReader(); while (dr.Read()) { UserData user = new UserData(); user.emailAddress = dr.GetString(1); user.lastLogin = dr.GetDateTime(2); user.createdDate = user.lastLogin.AddDays(-10); user.locale = dr.GetString(3); user.firstName = dr.GetString(4); user.lastName = dr.GetString(5); user.timezoneFromUTC = dr.GetInt32(6); user.name = dr.GetString(7); if (dr.GetValue(8) != DBNull.Value) user.gender = dr.GetString(8); if (dr.GetValue(9) != DBNull.Value && dr.GetString(9).Trim().Length > 0) user.location = dr.GetString(9); if (dr.GetValue(10) != DBNull.Value && dr.GetString(10).Trim().Length > 0) user.fBUsername = dr.GetString(10); if (dr.GetValue(11) != DBNull.Value && dr.GetString(11).Trim().Length > 0) user.fBLink = dr.GetString(11); if (dr.GetValue(12) != DBNull.Value && dr.GetString(12).Trim().Length > 0) user.oauthId = dr.GetString(12); user = (UserData)ur.Add(user); string fbstuff = user.fBLink; } } finally { if (conn != null) { conn.Close(); } } }
public UserData Update(UserData user) { _userRepository.Collection.Save(user); return Get(user.emailAddress); }
public UserData Add(UserData user) { _userRepository.Collection.Insert(user); return Get(user.emailAddress); }