public static Profile GetProfile(int userId) { Profile profile = null; try { DataAccess DAL = new DataAccess(); DataTable dt = DAL.select(String.Format("UserId = '{0}'", userId), "UserProfile", NumRows : 1); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; string name = Convert.ToString(row["DisplayName"]); string email = Convert.ToString(row["UserName"]); string facebookId = row["FacebookId"] is DBNull ? null : Convert.ToString(row["FacebookId"]); string facebookLink = row["FacebookLink"] is DBNull ? null : Convert.ToString(row["FacebookLink"]); profile = new Profile(userId, name, email, facebookId, facebookLink); } } catch (Exception ex) { Console.Write("ERROR: An error occured in retrieving the user profile --- " + ex.Message); } return profile; }
//User clicked on link //We shall update the database to validate his/her account using the provided token public static Profile ValidateProfile(Guid Token) { Profile profile = null; try { var DAL = new DataAccess(); var dt = DAL.select(String.Format("ValidationToken = '{0}'", Token), "UserProfile", NumRows: 1); if (dt != null && dt.Rows.Count > 0) { var updateDictionary = new Dictionary<string, object>(); updateDictionary.Add("IsValid", true); DAL.update("UserProfile", "ValidationToken = '{0}'", updateDictionary); var row = dt.Rows[0]; var UserName = Convert.ToString(row["UserName"]); var profileId = Convert.ToInt32(row["UserId"]); var displayName = Convert.ToString(row["DisplayName"]); var facebookId = row["FacebookId"] is DBNull ? null : Convert.ToString(row["FacebookId"]); var facebookLink = row["FacebookLink"] is DBNull ? null : Convert.ToString(row["FacebookLink"]); profile = new Profile(profileId, displayName, UserName, facebookId, facebookLink); } } catch (Exception ex) { Console.Write("ERROR: An error occured in retrieving the user profile --- " + ex.Message); } return profile; }