//=============================================================== // Function: Page_Load //=============================================================== protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT HomePageContent FROM HomePageContent "; DbDataReader rdr = cmd.ExecuteReader(); rdr.Read(); homePageContentTextBox.Text = (string)rdr["HomePageContent"]; rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("", "", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } } }
//=============================================================== // Function: AddIntegerValue //=============================================================== public void AddIntegerValue(string keyName, int value) { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spGlobalDataAddIntegerValue", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@KeyName", SqlDbType.NVarChar, 50).Value = keyName; cmd.Parameters.Add("@Value", SqlDbType.Int).Value = value; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("GlobalData", "AddIntegerValue", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: GetAllEnableUserDetails //=============================================================== public DataTable GetAllEnableUserDetails() { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DataTable dtUsers = new DataTable(); DbCommand cmd = conn.CreateCommand(); //cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = "spGetAllEnableUserDetails"; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT top 24 userid,[guid],(select count(*) as gcount from events where deleted = 0 and userid = u.userid group by userid)gcount,(select count(*) as mcount from Users WHERE LoginEnabled = 1 and deleted = 0)mcount, " + "EmailAddress, FirstName, LastName, Gender, Deleted, DeletedDate," + "HomeTown, Birthday, ProfilePicFilename, ProfilePicThumbnail, ProfilePicPreview," + "ProfileText, CountryID, LanguageID, TimezoneID, EnableSendEmails," + "LoginEnabled, UserPassword, FailedLoginCount, PasswordExpiryDate, LastLoginDate," + "CreatedDate, CreatedByFullName, LastUpdatedDate, LastUpdatedByFullName " + "FROM Users u" + " WHERE LoginEnabled = 1 and deleted = 0 order by createddate desc"; DbDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; adp.Fill(dtUsers); return dtUsers; } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "GetAllEnableUserDetails", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: GetPendingInviteCountForUser //=============================================================== public static int GetPendingInviteCountForUser(int userID) { int inviteCount = 0; SedogoUser sedogoUser = new SedogoUser("", userID); SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectPendingInviteCountForUser"; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userID; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = sedogoUser.emailAddress; DbDataReader rdr = cmd.ExecuteReader(); rdr.Read(); inviteCount = int.Parse(rdr[0].ToString()); rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "GetPendingInviteCountForUser", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return inviteCount; }
//=============================================================== // Function: GetStringValue //=============================================================== public string GetStringValue(string keyName) { string returnString = ""; DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGlobalDataGetStringValue"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@KeyName"; param.Value = keyName; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == false) { // GlobalData value not found - throw an exception GlobalDataMissingException ex = new GlobalDataMissingException(); throw ex; } else { rdr.Read(); if (rdr.IsDBNull(rdr.GetOrdinal("StringValue"))) { // GlobalData value is null - throw an exception GlobalDataNullException ex = new GlobalDataNullException(); throw ex; } else { returnString = (string)rdr["StringValue"]; } rdr.Close(); } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("GlobalData", "GetStringValue", "Keyname: " + keyName + ", Error: " + ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return returnString; }
//=============================================================== // Function: ReadAdministratorDetails //=============================================================== public void ReadAdministratorDetails() { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectAdministratorDetails"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@AdministratorID"; param.Value = m_administratorID; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); rdr.Read(); if (!rdr.IsDBNull(rdr.GetOrdinal("EmailAddress"))) { m_emailAddress = (string)rdr["EmailAddress"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("AdministratorName"))) { m_administratorName = (string)rdr["AdministratorName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Deleted"))) { m_deleted = (Boolean)rdr["Deleted"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("DeletedDate"))) { m_deletedDate = (DateTime)rdr["DeletedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LoginEnabled"))) { m_loginEnabled = (Boolean)rdr["LoginEnabled"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("AdministratorPassword"))) { m_administratorPassword = (string)rdr["AdministratorPassword"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("FailedLoginCount"))) { m_failedLoginCount = int.Parse(rdr["FailedLoginCount"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("PasswordExpiryDate"))) { m_passwordExpiryDate = (DateTime)rdr["PasswordExpiryDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastLoginDate"))) { m_lastLoginDate = (DateTime)rdr["LastLoginDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedDate"))) { m_createdDate = (DateTime)rdr["CreatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedByFullName"))) { m_createdByFullName = (string)rdr["CreatedByFullName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedDate"))) { m_lastUpdatedDate = (DateTime)rdr["LastUpdatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedByFullName"))) { m_lastUpdatedByFullName = (string)rdr["LastUpdatedByFullName"]; } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("Administrator", "ReadAdministratorDetails", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: ReadUserDetailsByFacebookID //=============================================================== public bool ReadUserDetailsByFacebookUserID(long facebookUserId) { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectUserDetailsByFacebookID"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@FacebookUserID"; param.Value = facebookUserId; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (!rdr.HasRows) return false; rdr.Read(); if (!rdr.IsDBNull(rdr.GetOrdinal("UserID"))) { m_userID = int.Parse(rdr["UserID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("GUID"))) { m_GUID = rdr["GUID"].ToString(); } if (!rdr.IsDBNull(rdr.GetOrdinal("EmailAddress"))) { m_emailAddress = (string)rdr["EmailAddress"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("FirstName"))) { m_firstName = (string)rdr["FirstName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastName"))) { m_lastName = (string)rdr["LastName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("HomeTown"))) { m_homeTown = (string)rdr["HomeTown"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Birthday"))) { m_birthday = (DateTime)rdr["Birthday"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("ProfilePicFilename"))) { m_profilePicFilename = (string)rdr["ProfilePicFilename"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("ProfilePicThumbnail"))) { m_profilePicThumbnail = (string)rdr["ProfilePicThumbnail"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("ProfilePicPreview"))) { m_profilePicPreview = (string)rdr["ProfilePicPreview"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("AvatarNumber"))) { m_avatarNumber = int.Parse(rdr["AvatarNumber"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("Gender"))) { m_gender = (string)rdr["Gender"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Deleted"))) { m_deleted = (Boolean)rdr["Deleted"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("DeletedDate"))) { m_deletedDate = (DateTime)rdr["DeletedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CountryID"))) { m_countryID = int.Parse(rdr["CountryID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("LanguageID"))) { m_languageID = int.Parse(rdr["LanguageID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("TimezoneID"))) { m_timezoneID = int.Parse(rdr["TimezoneID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("ProfileText"))) { m_profileText = (string)rdr["ProfileText"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LoginEnabled"))) { m_loginEnabled = (Boolean)rdr["LoginEnabled"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("EnableSendEmails"))) { m_enableSendEmails = (Boolean)rdr["EnableSendEmails"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("UserPassword"))) { m_userPassword = (string)rdr["UserPassword"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("FailedLoginCount"))) { m_failedLoginCount = int.Parse(rdr["FailedLoginCount"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("PasswordExpiryDate"))) { m_passwordExpiryDate = (DateTime)rdr["PasswordExpiryDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastLoginDate"))) { m_lastLoginDate = (DateTime)rdr["LastLoginDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedDate"))) { m_createdDate = (DateTime)rdr["CreatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedByFullName"))) { m_createdByFullName = (string)rdr["CreatedByFullName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedDate"))) { m_lastUpdatedDate = (DateTime)rdr["LastUpdatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedByFullName"))) { m_lastUpdatedByFullName = (string)rdr["LastUpdatedByFullName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("FacebookUserID"))) { m_facebookUserID = long.Parse(rdr["FacebookUserID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("FirstLogin"))) { m_firstLogin = (Boolean)rdr["FirstLogin"]; } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "ReadUserDetailsByFacebookUserID", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return true; }
//=============================================================== // Function: Add //=============================================================== public void Add() { m_GUID = System.Guid.NewGuid().ToString(); SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spAddUser", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GUID", SqlDbType.NVarChar, 50).Value = m_GUID; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = m_emailAddress; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 200).Value = m_firstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar, 200).Value = m_lastName; cmd.Parameters.Add("@HomeTown", SqlDbType.NVarChar, 200).Value = m_homeTown; if (m_birthday == DateTime.MinValue) { cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = DBNull.Value; } else { cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = m_birthday; } cmd.Parameters.Add("@Gender", SqlDbType.NChar, 1).Value = m_gender; cmd.Parameters.Add("@CountryID", SqlDbType.Int).Value = m_countryID; cmd.Parameters.Add("@LanguageID", SqlDbType.Int).Value = m_languageID; cmd.Parameters.Add("@TimezoneID", SqlDbType.Int).Value = m_timezoneID; cmd.Parameters.Add("@AvatarNumber", SqlDbType.Int).Value = m_avatarNumber; cmd.Parameters.Add("@ProfileText", SqlDbType.NVarChar, 200).Value = m_profileText; cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@CreatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.Parameters.Add("@FacebookUserID", SqlDbType.BigInt).Value = (m_facebookUserID == -1 ? (object)DBNull.Value : (object)m_facebookUserID); SqlParameter paramUserID = cmd.CreateParameter(); paramUserID.ParameterName = "@UserID"; paramUserID.SqlDbType = SqlDbType.Int; paramUserID.Direction = ParameterDirection.Output; cmd.Parameters.Add(paramUserID); cmd.ExecuteNonQuery(); m_userID = (int)paramUserID.Value; //ReadUserDetails(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "Add", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: VerifyPassword //=============================================================== public Boolean VerifyPassword(string testPassword) { Boolean returnStatus = false; DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectUserPassword"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@UserID"; param.Value = m_userID; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows != false) { string userPassword; rdr.Read(); userPassword = (string)rdr["UserPassword"]; rdr.Close(); PasswordEncrypt pe = new PasswordEncrypt(); string encryptedTestPassword = pe.EncryptPassword(testPassword); // note that passwords are case sensitive if (userPassword == encryptedTestPassword) { returnStatus = true; } } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "VerifyPassword", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return returnStatus; }
//=============================================================== // Function: UpdateUserProfilePic //=============================================================== public void UpdateUserProfilePic() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spUpdateUserProfilePic", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; cmd.Parameters.Add("@ProfilePicFilename", SqlDbType.NVarChar, 200).Value = m_profilePicFilename; cmd.Parameters.Add("@ProfilePicThumbnail", SqlDbType.NVarChar, 200).Value = m_profilePicThumbnail; cmd.Parameters.Add("@ProfilePicPreview", SqlDbType.NVarChar, 200).Value = m_profilePicPreview; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "UpdateUserProfilePic", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: UpdateLoginHistory //=============================================================== public void UpdateLoginHistory(int userID, string status, string source) { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); // Update the DB with a failed login attempt (email address not recognised) DbCommand cmdLoginHistory = conn.CreateCommand(); cmdLoginHistory.CommandType = CommandType.StoredProcedure; cmdLoginHistory.CommandText = "spInsertUserLoginHistory"; DbParameter paramLoginHistory1 = cmdLoginHistory.CreateParameter(); paramLoginHistory1.ParameterName = "@UserID"; if (userID < 0) { paramLoginHistory1.Value = DBNull.Value; } else { paramLoginHistory1.Value = userID; } cmdLoginHistory.Parameters.Add(paramLoginHistory1); DbParameter paramLoginHistory2 = cmdLoginHistory.CreateParameter(); paramLoginHistory2.ParameterName = "@LoginStatus"; paramLoginHistory2.Value = status; cmdLoginHistory.Parameters.Add(paramLoginHistory2); DbParameter paramLoginHistorySource = cmdLoginHistory.CreateParameter(); paramLoginHistorySource.ParameterName = "@Source"; paramLoginHistorySource.Value = source; cmdLoginHistory.Parameters.Add(paramLoginHistorySource); cmdLoginHistory.ExecuteNonQuery(); if ((status == "L") || (status == "P") && userID > 0) { DbCommand cmdIncrementFailedLoginCount = conn.CreateCommand(); cmdIncrementFailedLoginCount.CommandType = CommandType.StoredProcedure; cmdIncrementFailedLoginCount.CommandText = "spIncrementFailedLoginCount"; DbParameter paramIncrementFailedLoginCount = cmdIncrementFailedLoginCount.CreateParameter(); paramIncrementFailedLoginCount.ParameterName = "@UserID"; paramIncrementFailedLoginCount.Value = userID; cmdIncrementFailedLoginCount.Parameters.Add(paramIncrementFailedLoginCount); cmdIncrementFailedLoginCount.ExecuteNonQuery(); } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "UpdateLoginHistory", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: ResetUserPassword //=============================================================== public Boolean ResetUserPassword(string emailAddress, ref string newPassword) { // Lookup the Contact ID of the supplied email address SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spVerifyUserLogin", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = emailAddress.Trim(); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == false) { // Email address supplied not found return false; } else { // Email address exists, now check the password is OK int userID; Boolean loginEnabled; rdr.Read(); userID = (int)rdr["UserID"]; loginEnabled = (Boolean)rdr["LoginEnabled"]; rdr.Close(); m_userID = userID; ReadUserDetails(); GenerateNewPassword(ref newPassword); } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "ResetUserPassword", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return true; }
//=============================================================== // Function: GetInviteCount //=============================================================== public static int GetInviteCount(int eventID) { int inviteCount = 0; SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectEventInviteCountByEventID"; cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = eventID; DbDataReader rdr = cmd.ExecuteReader(); rdr.Read(); inviteCount = int.Parse(rdr[0].ToString()); rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "GetInviteCount", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return inviteCount; }
//=============================================================== // Function: GetEventInviteIDFromUserIDEventID //=============================================================== public static int GetEventInviteIDFromUserIDEventID(int eventID, int userID) { int eventInviteID = 0; SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGetEventInviteIDFromUserIDEventID"; cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = eventID; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userID; DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == true) { rdr.Read(); eventInviteID = int.Parse(rdr[0].ToString()); } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "CheckUserEventInviteExists", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return eventInviteID; }
//=============================================================== // Function: GetEventInviteIDFromGUID //=============================================================== public static int GetEventInviteIDFromGUID(string eventInviteGUID) { int eventInviteID = -1; SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectEventInviteIDFromGUID"; cmd.Parameters.Add("@GUID", SqlDbType.NVarChar, 50).Value = eventInviteGUID; DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == true) { rdr.Read(); eventInviteID = int.Parse(rdr["EventInviteID"].ToString()); } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "GetEventInviteIDFromGUID", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return eventInviteID; }
/// <summary> /// Gets the image SRC. /// </summary> /// <param name="id">The id.</param> /// <param name="imageType">Type of the image.</param> /// <param name="physPath">The subdir.</param> /// <param name="virtPath">The virt path.</param> /// <param name="width">The width.</param> /// <param name="height">The height.</param> /// <param name="radius">The radius.</param> /// <param name="overrideImage">if set to <c>true</c> [override image].</param> /// <returns></returns> private static string GetRelativeImagePath(int id, ImageType imageType, string physPath, string virtPath, int width, int height, int radius, bool overrideImage) { try { int w = 1, h = 1; return GetRelativeImagePath(id, imageType, physPath, virtPath, width, height, radius, overrideImage, ref w, ref h); } catch (Exception ex) { var errorLog = new ErrorLog(); errorLog.WriteLog("ImageHelper", "GetRelativeImagePath", ex.Message, logMessageLevel.errorMessage); return string.Empty; } }
//=============================================================== // Function: GetProfileGoalPicsDetails //=============================================================== public DataTable GetProfileGoalPicsDetails(int userID, Boolean showPrivate) { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DataTable dtUsers = new DataTable(); DbCommand cmd = conn.CreateCommand(); //cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = "spGetAllEnableUserDetails"; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT top 16 EventID,EventName, EventPicThumbnail, EventPicPreview " + "FROM Events " + " WHERE UserID = " + userID.ToString() + " and Deleted = 0 "; if( showPrivate == false ) { cmd.CommandText += "and PrivateEvent = 0 "; } cmd.CommandText += "order by CreatedDate desc "; DbDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; adp.Fill(dtUsers); return dtUsers; } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "GetProfileGoalPicsDetails", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Update //=============================================================== public void Update() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spUpdateAdministrator", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AdministratorID", SqlDbType.Int).Value = m_administratorID; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = m_emailAddress; cmd.Parameters.Add("@AdministratorName", SqlDbType.NVarChar, 200).Value = m_administratorName; cmd.Parameters.Add("@LoginEnabled", SqlDbType.Bit).Value = m_loginEnabled; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("Administrator", "Update", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Update //=============================================================== public void Update() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spUpdateUser", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = m_emailAddress; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 200).Value = m_firstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar, 200).Value = m_lastName; cmd.Parameters.Add("@HomeTown", SqlDbType.NVarChar, 200).Value = m_homeTown; if (m_birthday == DateTime.MinValue) { cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = DBNull.Value; } else { cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = m_birthday; } cmd.Parameters.Add("@Gender", SqlDbType.NChar, 1).Value = m_gender; cmd.Parameters.Add("@CountryID", SqlDbType.Int).Value = m_countryID; cmd.Parameters.Add("@LanguageID", SqlDbType.Int).Value = m_languageID; cmd.Parameters.Add("@TimezoneID", SqlDbType.Int).Value = m_timezoneID; cmd.Parameters.Add("@LoginEnabled", SqlDbType.Bit).Value = m_loginEnabled; cmd.Parameters.Add("@EnableSendEmails", SqlDbType.Bit).Value = m_enableSendEmails; cmd.Parameters.Add("@AvatarNumber", SqlDbType.Int).Value = m_avatarNumber; cmd.Parameters.Add("@ProfileText", SqlDbType.NVarChar, 200).Value = m_profileText; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.Parameters.Add("@FacebookUserID", SqlDbType.BigInt).Value = (m_facebookUserID == -1 ? (object)DBNull.Value : (object)m_facebookUserID); cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "Update", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Add //=============================================================== public void Add() { m_eventInviteGUID = System.Guid.NewGuid().ToString(); SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spAddEventInvite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = m_eventID; cmd.Parameters.Add("@GUID", SqlDbType.NVarChar, 50).Value = m_eventInviteGUID; if (m_userID > 0) { cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; } else { cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = DBNull.Value; } cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = m_emailAddress; cmd.Parameters.Add("@InviteAdditionalText", SqlDbType.NVarChar, -1).Value = m_inviteAdditionalText; cmd.Parameters.Add("@InviteEmailSent", SqlDbType.Bit).Value = m_inviteEmailSent; cmd.Parameters.Add("@InviteEmailSentEmailAddress", SqlDbType.NVarChar, 200).Value = m_inviteEmailSentEmailAddress; if (m_inviteAcceptedDate > DateTime.MinValue) { cmd.Parameters.Add("@InviteEmailSentDate", SqlDbType.DateTime).Value = m_inviteEmailSentDate; } else { cmd.Parameters.Add("@InviteEmailSentDate", SqlDbType.DateTime).Value = DBNull.Value; } cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@CreatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; SqlParameter paramEventInviteID = cmd.CreateParameter(); paramEventInviteID.ParameterName = "@EventInviteID"; paramEventInviteID.SqlDbType = SqlDbType.Int; paramEventInviteID.Direction = ParameterDirection.Output; cmd.Parameters.Add(paramEventInviteID); cmd.ExecuteNonQuery(); m_eventInviteID = (int)paramEventInviteID.Value; } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "Add", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: UpdatePassword //=============================================================== public void UpdatePassword(string newPassword) { PasswordEncrypt pe = new PasswordEncrypt(); string encryptedPassword = pe.EncryptPassword(newPassword); SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); // Update users password SqlCommand cmd = new SqlCommand("spUpdateUserPassword", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; cmd.Parameters.Add("@UserPassword", SqlDbType.NVarChar, 50).Value = encryptedPassword; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "UpdatePassword", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Delete //=============================================================== public void Delete() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spDeleteEventInvite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EventInviteID", SqlDbType.Int).Value = m_eventInviteID; cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "Delete", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: VerifyLogin //=============================================================== public loginResults VerifyLogin(string emailAddress, string testPassword, Boolean passwordIsEncrypted, Boolean recordInLoginHistory, string source) { loginResults returnValue = loginResults.loginFailed; DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); // Get contact info DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spVerifyUserLogin"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@EmailAddress"; param.Value = emailAddress.Trim(); cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == false) { // Update the DB with a failed login attempt (email address not recognised) UpdateLoginHistory(-1, "U", source); // Unknown user returnValue = loginResults.loginFailed; } else { // Email address exists, now check the password is OK int userID; Boolean loginEnabled = false; string userPassword = ""; int failedLoginCount = 0; DateTime passwordExpiryDate = DateTime.MinValue; rdr.Read(); userID = (int)rdr["UserID"]; if (!rdr.IsDBNull(rdr.GetOrdinal("LoginEnabled"))) { loginEnabled = (Boolean)rdr["LoginEnabled"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("UserPassword"))) { userPassword = (string)rdr["UserPassword"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("FailedLoginCount"))) { failedLoginCount = (int)rdr["FailedLoginCount"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("PasswordExpiryDate"))) { passwordExpiryDate = (DateTime)rdr["PasswordExpiryDate"]; } rdr.Close(); if (DateTime.Compare(passwordExpiryDate, DateTime.Now) > 0) { // Update the DB with a failed login attempt (password expired) if (recordInLoginHistory == true) { UpdateLoginHistory(userID, "E", source); // Password expired } returnValue = loginResults.passwordExpired; m_userID = userID; ReadUserDetails(); } PasswordEncrypt pe = new PasswordEncrypt(); string encryptedTestPassword = ""; if (passwordIsEncrypted == false) { encryptedTestPassword = pe.EncryptPassword(testPassword); } else { encryptedTestPassword = testPassword; } if ((userPassword != encryptedTestPassword) || (loginEnabled == false)) { // Update the DB with a failed login attempt (invalid password) UpdateLoginHistory(userID, "P", source); // Invalid Password if (loginEnabled == false) { returnValue = loginResults.loginNotActivated; } else { returnValue = loginResults.loginFailed; } } else { // Update the DB with a successful login attempt if (recordInLoginHistory == true) { UpdateLoginHistory(userID, "S", source); // Success } returnValue = loginResults.loginSuccess; m_userID = userID; ReadUserDetails(); } } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "VerifyLogin", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return returnValue; }
//=============================================================== // Function: ReadEventInviteDetails //=============================================================== public void ReadEventInviteDetails() { DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectEventInviteDetails"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@EventInviteID"; param.Value = m_eventInviteID; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); rdr.Read(); if (!rdr.IsDBNull(rdr.GetOrdinal("EventID"))) { m_eventID = int.Parse(rdr["EventID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("GUID"))) { m_eventInviteGUID = rdr["GUID"].ToString(); } if (!rdr.IsDBNull(rdr.GetOrdinal("EmailAddress"))) { m_emailAddress = (string)rdr["EmailAddress"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("UserID"))) { m_userID = int.Parse(rdr["UserID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteAdditionalText"))) { m_inviteAdditionalText = (string)rdr["InviteAdditionalText"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteEmailSent"))) { m_inviteEmailSent = (Boolean)rdr["InviteEmailSent"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteEmailSentEmailAddress"))) { m_inviteEmailSentEmailAddress = (string)rdr["InviteEmailSentEmailAddress"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteEmailSentDate"))) { m_inviteEmailSentDate = (DateTime)rdr["InviteEmailSentDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteAccepted"))) { m_inviteAccepted = (Boolean)rdr["InviteAccepted"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteAcceptedDate"))) { m_inviteAcceptedDate = (DateTime)rdr["InviteAcceptedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteDeclined"))) { m_inviteDeclined = (Boolean)rdr["InviteDeclined"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("InviteDeclinedDate"))) { m_inviteDeclinedDate = (DateTime)rdr["InviteDeclinedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Deleted"))) { m_deleted = (Boolean)rdr["Deleted"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedDate"))) { m_createdDate = (DateTime)rdr["CreatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedByFullName"))) { m_createdByFullName = (string)rdr["CreatedByFullName"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedDate"))) { m_lastUpdatedDate = (DateTime)rdr["LastUpdatedDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("LastUpdatedByFullName"))) { m_lastUpdatedByFullName = (string)rdr["LastUpdatedByFullName"]; } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "ReadEventInviteDetails", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: GetUserIDFromGUID //=============================================================== public static int GetUserIDFromGUID(string GUID) { int userID = -1; DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGetUserIDFromGUID"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@GUID"; param.Value = GUID; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows != false) { rdr.Read(); userID = (int)rdr["UserID"]; rdr.Close(); } } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "GetUserIDFromGUID", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return userID; }
//=============================================================== // Function: Update //=============================================================== public void Update() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spUpdateEventInvite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EventInviteID", SqlDbType.Int).Value = m_eventInviteID; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 200).Value = m_emailAddress; if (m_userID > 0) { cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; } else { cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = DBNull.Value; } cmd.Parameters.Add("@InviteAdditionalText", SqlDbType.NVarChar, -1).Value = m_inviteAdditionalText; cmd.Parameters.Add("@InviteEmailSent", SqlDbType.Bit).Value = m_inviteEmailSent; cmd.Parameters.Add("@InviteEmailSentEmailAddress", SqlDbType.NVarChar, 200).Value = m_inviteEmailSentEmailAddress; if (m_inviteEmailSentDate > DateTime.MinValue) { cmd.Parameters.Add("@InviteEmailSentDate", SqlDbType.DateTime).Value = m_inviteEmailSentDate; } else { cmd.Parameters.Add("@InviteEmailSentDate", SqlDbType.DateTime).Value = DBNull.Value; } cmd.Parameters.Add("@InviteAccepted", SqlDbType.Bit).Value = m_inviteAccepted; if (m_inviteAcceptedDate > DateTime.MinValue) { cmd.Parameters.Add("@InviteAcceptedDate", SqlDbType.DateTime).Value = m_inviteAcceptedDate; } else { cmd.Parameters.Add("@InviteAcceptedDate", SqlDbType.DateTime).Value = DBNull.Value; } cmd.Parameters.Add("@InviteDeclined", SqlDbType.Bit).Value = m_inviteDeclined; if (m_inviteDeclinedDate > DateTime.MinValue) { cmd.Parameters.Add("@InviteDeclinedDate", SqlDbType.DateTime).Value = m_inviteDeclinedDate; } else { cmd.Parameters.Add("@InviteDeclinedDate", SqlDbType.DateTime).Value = DBNull.Value; } cmd.Parameters.Add("@LastUpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LastUpdatedByFullName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("EventInvite", "Update", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Delete //=============================================================== public void Delete() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spDeleteUser", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = m_userID; cmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SedogoUser", "Delete", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: Add //=============================================================== public void Add() { SqlConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand("spAddSentEmailHistory", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SentFrom", SqlDbType.NVarChar, 200).Value = m_sentFrom; cmd.Parameters.Add("@SentTo", SqlDbType.NVarChar, 200).Value = m_sentTo; cmd.Parameters.Add("@Subject", SqlDbType.NVarChar, 200).Value = m_subject; cmd.Parameters.Add("@Body", SqlDbType.NVarChar, -1).Value = m_body; cmd.Parameters.Add("@SentDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@LoggedInUserName", SqlDbType.NVarChar, 200).Value = m_loggedInUser; SqlParameter paramSentEmailHistoryID = cmd.CreateParameter(); paramSentEmailHistoryID.ParameterName = "@SentEmailHistoryID"; paramSentEmailHistoryID.SqlDbType = SqlDbType.Int; paramSentEmailHistoryID.Direction = ParameterDirection.Output; cmd.Parameters.Add(paramSentEmailHistoryID); cmd.ExecuteNonQuery(); m_sentEmailHistoryID = (int)paramSentEmailHistoryID.Value; } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("SentEmailHistory", "Add", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: CreateXMLContent //=============================================================== private void CreateXMLContent(XmlTextWriter writer, int userID) { SedogoUser user = new SedogoUser(Session["loggedInUserFullName"].ToString(), userID); SqlConnection conn = new SqlConnection((string)Application["connectionString"]); try { conn.Open(); SqlCommand cmd = new SqlCommand("", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spSelectFullEventListByCategory"; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userID; cmd.Parameters.Add("@ShowPrivate", SqlDbType.Bit).Value = false; DbDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { int categoryID = 1; string dateType = "D"; DateTime startDate = DateTime.MinValue; DateTime rangeStartDate = DateTime.MinValue; DateTime rangeEndDate = DateTime.MinValue; int beforeBirthday = -1; Boolean privateEvent = false; Boolean eventAchieved = false; DateTime timelineStartDate = DateTime.MinValue; DateTime timelineEndDate = DateTime.MinValue; //*New string eventPicThumbnail = ""; // int eventID = int.Parse(rdr["EventID"].ToString()); string eventName = (string)rdr["EventName"]; if (!rdr.IsDBNull(rdr.GetOrdinal("DateType"))) { dateType = (string)rdr["DateType"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("StartDate"))) { startDate = (DateTime)rdr["StartDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("RangeStartDate"))) { rangeStartDate = (DateTime)rdr["RangeStartDate"]; } if (!rdr.IsDBNull(rdr.GetOrdinal("RangeEndDate"))) { rangeEndDate = (DateTime)rdr["RangeEndDate"]; } eventAchieved = (Boolean)rdr["EventAchieved"]; if (!rdr.IsDBNull(rdr.GetOrdinal("CategoryID"))) { categoryID = int.Parse(rdr["CategoryID"].ToString()); } if (!rdr.IsDBNull(rdr.GetOrdinal("BeforeBirthday"))) { beforeBirthday = int.Parse(rdr["BeforeBirthday"].ToString()); } privateEvent = (Boolean)rdr["PrivateEvent"]; //*New if (!rdr.IsDBNull(rdr.GetOrdinal("EventPicThumbnail"))) { eventPicThumbnail = (string)rdr["EventPicThumbnail"]; } string EUserName = string.Empty; if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedByFullName"))) { EUserName = (string)rdr["CreatedByFullName"]; } // if (dateType == "D") { // Event occurs on a specific date timelineStartDate = startDate; timelineEndDate = startDate.AddDays(28); // Add 28 days so it shows up } if (dateType == "R") { // Event occurs in a date range - use the start date timelineStartDate = rangeStartDate; timelineEndDate = rangeEndDate; TimeSpan ts = timelineEndDate - timelineStartDate; if (ts.Days < 28) { timelineEndDate = startDate.AddDays(28); // Add 28 days so it shows up } startDate = rangeStartDate; } if (dateType == "A") { // Event occurs before birthday timelineStartDate = DateTime.Now; if (user.birthday > DateTime.MinValue) { timelineEndDate = user.birthday.AddYears(beforeBirthday); TimeSpan ts = timelineEndDate - DateTime.Now; // timelineStartDate.AddYears(beforeBirthday); if (ts.Days < 0) { // Birthday was in the past timelineStartDate = DateTime.Now; timelineEndDate = timelineStartDate.AddDays(28); // Add 28 days so it shows up // Set start date so event is correctly placed below startDate = DateTime.Now.AddDays(ts.Days); } else if (ts.Days >= 0 && ts.Days < 28) { // Birthday is within 28 days - extend the timeline a bit timelineEndDate = timelineStartDate.AddDays(28); // Add 28 days so it shows up startDate = timelineStartDate; } else { startDate = timelineStartDate; } } else { timelineEndDate = DateTime.Now.AddDays(28); } } string timelineColour = "#cd3301"; string category = ""; switch (categoryID) { case 1: timelineColour = "#cd3301"; category = "Personal"; break; case 2: timelineColour = "#ff0b0b"; category = "Travel"; break; case 3: timelineColour = "#ff6801"; category = "Friends"; break; case 4: timelineColour = "#ff8500"; category = "Family"; break; case 5: timelineColour = "#d5b21a"; category = "General"; break; case 6: timelineColour = "#8dc406"; category = "Health"; break; case 7: timelineColour = "#5b980c"; category = "Money"; break; case 8: timelineColour = "#079abc"; category = "Education"; break; case 9: timelineColour = "#5ab6cd"; category = "Hobbies"; break; case 10: timelineColour = "#8A67C1"; category = "Work"; break; case 11: timelineColour = "#E54ECF"; category = "Culture"; break; case 12: timelineColour = "#A5369C"; category = "Charity"; break; case 13: timelineColour = "#A32672"; category = "Green"; break; case 14: timelineColour = "#669"; category = "Misc"; break; } int messageCount = SedogoEvent.GetCommentCount(eventID); int trackingUserCount = SedogoEvent.GetTrackingUserCount(eventID); int memberUserCount = SedogoEvent.GetMemberUserCount(eventID); //string linkURL = "<a href=\"viewEvent.aspx?EID=" + eventID.ToString() + "\" class=\"modal\" title=\"\">Full details</a>"; //string linkURL = trackingUserCount.ToString() + " following this goal<br/>"; //linkURL = linkURL + memberUserCount.ToString() + " members<br/>"; //linkURL = linkURL + messageCount.ToString() + " comments<br/>"; //linkURL = linkURL + "<a href=\"javascript:openEvent(" + eventID.ToString() + ")\" title=\"\">Full details</a>"; //* New string linkURL = timelineStartDate.ToString("ddd dd MMM yyyy") + "<br/><br/>"; linkURL = linkURL + trackingUserCount.ToString() + " Followers<br/>"; linkURL = linkURL + memberUserCount.ToString() + " Members<br/>"; linkURL = linkURL + messageCount.ToString() + " Comments<br/>"; linkURL = linkURL + "<a style=\"text-decoration:underline;\" href=\"javascript:openEvent(" + eventID.ToString() + ")\" title=\"\">Goal details</a>"; linkURL = linkURL + " <a style=\"text-decoration:underline;\" href=\"javascript:viewProfile(" + userID.ToString() + ")\" title=\"\">Profile</a>"; string ImgLink = "|" + EUserName + " <a href=\"javascript:doSendMessage(" + userID.ToString() + ")\"><img src=\"images/ico_messages.gif\" title=\"Send Message\" alt=\"Send Message\" /></a>"; //string ImgLink = "|" + EUserName; //* writer.WriteStartElement("event"); // Time format: Feb 27 2009 09:00:00 GMT writer.WriteAttributeString("start", timelineStartDate.ToString("MMM dd yyyy HH:mm:ss 'GMT'")); writer.WriteAttributeString("end", timelineEndDate.ToString("MMM dd yyyy HH:mm:ss 'GMT'")); writer.WriteAttributeString("isDuration", "true"); writer.WriteAttributeString("title", eventName); //* New if (eventPicThumbnail == "") { writer.WriteAttributeString("image", "./images/eventThumbnailBlank.png"); } else { writer.WriteAttributeString("image", "./assets/eventPics/" + eventPicThumbnail); } //writer.WriteAttributeString("image", "http://simile.mit.edu/images/csail-logo.gif"); //* writer.WriteAttributeString("color", timelineColour); writer.WriteAttributeString("category", category); writer.WriteString(linkURL + " <br />" + ImgLink); writer.WriteEndElement(); } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("timelineUserXML", "Page_Load", ex.Message, logMessageLevel.errorMessage); //throw ex; } finally { conn.Close(); } }
//=============================================================== // Function: CheckValueExists //=============================================================== public Boolean CheckValueExists(string keyName) { Boolean returnValue = false; DbConnection conn = new SqlConnection(GlobalSettings.connectionString); try { conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGlobalDataGetStringValue"; DbParameter param = cmd.CreateParameter(); param.ParameterName = "@KeyName"; param.Value = keyName; cmd.Parameters.Add(param); DbDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows == true) { returnValue = true; } rdr.Close(); } catch (Exception ex) { ErrorLog errorLog = new ErrorLog(); errorLog.WriteLog("GlobalData", "CheckValueExists", ex.Message, logMessageLevel.errorMessage); throw ex; } finally { conn.Close(); } return returnValue; }