public void Ctor_sets_name_and_value()
{
var result = new SqliteParameter("@Parameter", 1);
Assert.Equal("@Parameter", result.ParameterName);
Assert.Equal(1, result.Value);
}
public bool Add(
Guid guid,
Guid siteGuid,
string folderName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_SiteFolders (");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("FolderName )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":Guid, ");
sqlCommand.Append(":SiteGuid, ");
sqlCommand.Append(":FolderName );");
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":Guid", DbType.String);
arParams[0].Value = guid.ToString();
arParams[1] = new SqliteParameter(":SiteGuid", DbType.String);
arParams[1].Value = siteGuid.ToString();
arParams[2] = new SqliteParameter(":FolderName", DbType.String);
arParams[2].Value = folderName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return rowsAffected > 0;
}
public DbDataReader GetUserCountByYearMonth(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT ");
sqlCommand.Append("strftime('%Y', DateCreated) AS Y, ");
sqlCommand.Append("strftime('%m', DateCreated) AS M, ");
sqlCommand.Append("strftime('%Y', DateCreated) + '-' + strftime('%m', DateCreated) AS Label, ");
sqlCommand.Append("COUNT(*) As Users ");
sqlCommand.Append("FROM ");
sqlCommand.Append("mp_Users ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SiteID = :SiteID ");
sqlCommand.Append("GROUP BY strftime('%Y', DateCreated), strftime('%m', DateCreated) ");
sqlCommand.Append("ORDER BY strftime('%Y', DateCreated), strftime('%m', DateCreated) ");
sqlCommand.Append("; ");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public virtual SqliteParameter AddWithValue(string parameterName, object value)
{
var parameter = new SqliteParameter(parameterName, value);
Add(parameter);
return parameter;
}
public DbDataReader GetSiteSettingsExList(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT e.* ");
sqlCommand.Append("FROM mp_SiteSettingsEx e ");
sqlCommand.Append("JOIN ");
sqlCommand.Append("mp_SiteSettingsExDef d ");
sqlCommand.Append("ON ");
sqlCommand.Append("e.KeyName = d.KeyName ");
sqlCommand.Append("AND e.GroupName = d.GroupName ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("e.SiteID = :SiteID ");
sqlCommand.Append("ORDER BY d.GroupName, d.SortOrder ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public bool Update(
Guid guid,
Guid siteGuid,
string folderName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_SiteFolders ");
sqlCommand.Append("SET ");
sqlCommand.Append("SiteGuid = :SiteGuid, ");
sqlCommand.Append("FolderName = :FolderName ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = :Guid ;");
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":Guid", DbType.String);
arParams[0].Value = guid.ToString();
arParams[1] = new SqliteParameter(":SiteGuid", DbType.String);
arParams[1].Value = siteGuid.ToString();
arParams[2] = new SqliteParameter(":FolderName", DbType.String);
arParams[2].Value = folderName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > -1);
}
public void Ctor_sets_other_values()
{
var result = new SqliteParameter("@Parameter", SqliteType.Integer, 8, "Column");
Assert.Equal("@Parameter", result.ParameterName);
Assert.Equal(SqliteType.Integer, result.SqliteType);
Assert.Equal(8, result.Size);
Assert.Equal("Column", result.SourceColumn);
}
public void ResetDbType_works()
{
var parameter = new SqliteParameter
{
DbType = DbType.Int64,
SqliteType = SqliteType.Integer
};
parameter.ResetDbType();
Assert.Equal(DbType.String, parameter.DbType);
Assert.Equal(SqliteType.Text, parameter.SqliteType);
}
public bool Create(
int siteId,
string loginProvider,
string providerKey,
string providerDisplayName,
string userId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_UserLogins (");
sqlCommand.Append("LoginProvider ,");
sqlCommand.Append("ProviderKey, ");
sqlCommand.Append("UserId, ");
sqlCommand.Append("SiteId, ");
sqlCommand.Append("ProviderDisplayName ");
sqlCommand.Append(") ");
sqlCommand.Append("VALUES (");
sqlCommand.Append(":LoginProvider, ");
sqlCommand.Append(":ProviderKey, ");
sqlCommand.Append(":UserId, ");
sqlCommand.Append(":SiteId, ");
sqlCommand.Append(":ProviderDisplayName ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[5];
arParams[0] = new SqliteParameter(":LoginProvider", DbType.String);
arParams[0].Value = loginProvider;
arParams[1] = new SqliteParameter(":ProviderKey", DbType.String);
arParams[1].Value = providerKey;
arParams[2] = new SqliteParameter(":UserId", DbType.String);
arParams[2].Value = userId;
arParams[3] = new SqliteParameter(":SiteId", DbType.Int32);
arParams[3].Value = siteId;
arParams[4] = new SqliteParameter(":ProviderDisplayName", DbType.String);
arParams[4].Value = providerDisplayName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > -1);
}
public DbDataReader GetUserList(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT UserID, Name, PasswordSalt, Pwd, Email FROM mp_Users WHERE SiteID = :SiteID ORDER BY Email");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public int RoleCreate(
Guid roleGuid,
Guid siteGuid,
int siteId,
string roleName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_Roles (");
sqlCommand.Append("SiteID, ");
sqlCommand.Append("RoleName, ");
sqlCommand.Append("DisplayName, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("RoleGuid )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":SiteID, ");
sqlCommand.Append(":RoleName, ");
sqlCommand.Append(":RoleName, ");
sqlCommand.Append(":SiteGuid, ");
sqlCommand.Append(":RoleGuid )");
sqlCommand.Append(";");
sqlCommand.Append("SELECT LAST_INSERT_ROWID();");
SqliteParameter[] arParams = new SqliteParameter[4];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":RoleName", DbType.String);
arParams[1].Value = roleName;
arParams[2] = new SqliteParameter(":SiteGuid", DbType.String);
arParams[2].Value = siteGuid.ToString();
arParams[3] = new SqliteParameter(":RoleGuid", DbType.String);
arParams[3].Value = roleGuid.ToString();
int newID = Convert.ToInt32(AdoHelper.ExecuteScalar(
connectionString,
sqlCommand.ToString(),
arParams).ToString());
return newID;
}
public int Create(
int siteId,
string userId,
string claimType,
string claimValue)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_UserClaims (");
sqlCommand.Append("SiteId, ");
sqlCommand.Append("UserId, ");
sqlCommand.Append("ClaimType, ");
sqlCommand.Append("ClaimValue )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":SiteId, ");
sqlCommand.Append(":UserId, ");
sqlCommand.Append(":ClaimType, ");
sqlCommand.Append(":ClaimValue )");
sqlCommand.Append(";");
sqlCommand.Append("SELECT LAST_INSERT_ROWID();");
SqliteParameter[] arParams = new SqliteParameter[4];
arParams[0] = new SqliteParameter(":UserId", DbType.String);
arParams[0].Value = userId;
arParams[1] = new SqliteParameter(":ClaimType", DbType.Object);
arParams[1].Value = claimType;
arParams[2] = new SqliteParameter(":ClaimValue", DbType.Object);
arParams[2].Value = claimValue;
arParams[3] = new SqliteParameter(":SiteId", DbType.Int32);
arParams[3].Value = siteId;
int newID = Convert.ToInt32(AdoHelper.ExecuteScalar(
connectionString,
sqlCommand.ToString(),
arParams).ToString());
return newID;
}
/// <summary>
/// Inserts a row in the mp_GeoCountry table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="name"> name </param>
/// <param name="iSOCode2"> iSOCode2 </param>
/// <param name="iSOCode3"> iSOCode3 </param>
/// <returns>bool</returns>
public bool Create(
Guid guid,
string name,
string iSOCode2,
string iSOCode3)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_GeoCountry (");
sqlCommand.Append("Guid, ");
sqlCommand.Append("Name, ");
sqlCommand.Append("ISOCode2, ");
sqlCommand.Append("ISOCode3 )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":Guid, ");
sqlCommand.Append(":Name, ");
sqlCommand.Append(":ISOCode2, ");
sqlCommand.Append(":ISOCode3 )");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[4];
arParams[0] = new SqliteParameter(":Guid", DbType.String);
arParams[0].Value = guid.ToString();
arParams[1] = new SqliteParameter(":Name", DbType.String);
arParams[1].Value = name;
arParams[2] = new SqliteParameter(":ISOCode2", DbType.String);
arParams[2].Value = iSOCode2;
arParams[3] = new SqliteParameter(":ISOCode3", DbType.String);
arParams[3].Value = iSOCode3;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return rowsAffected > 0;
}
/// <summary>
/// Inserts a row in the mp_Language table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="name"> name </param>
/// <param name="code"> code </param>
/// <param name="sort"> sort </param>
/// <returns>bool</returns>
public bool Create(
Guid guid,
string name,
string code,
int sort)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_Language (");
sqlCommand.Append("Guid, ");
sqlCommand.Append("Name, ");
sqlCommand.Append("Code, ");
sqlCommand.Append("Sort )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":Guid, ");
sqlCommand.Append(":Name, ");
sqlCommand.Append(":Code, ");
sqlCommand.Append(":Sort )");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[4];
arParams[0] = new SqliteParameter(":Guid", DbType.String);
arParams[0].Value = guid.ToString();
arParams[1] = new SqliteParameter(":Name", DbType.String);
arParams[1].Value = name;
arParams[2] = new SqliteParameter(":Code", DbType.String);
arParams[2].Value = code;
arParams[3] = new SqliteParameter(":Sort", DbType.Int32);
arParams[3].Value = sort;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return rowsAffected > 0;
}
public DbDataReader GetPageOfOtherSites(
int currentSiteId,
int pageNumber,
int pageSize)
{
int pageLowerBound = (pageSize * pageNumber) - pageSize;
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("WHERE SiteID <> :CurrentSiteID ");
sqlCommand.Append("ORDER BY ");
sqlCommand.Append("SiteName ");
sqlCommand.Append("LIMIT :PageSize ");
if (pageNumber > 1)
{
sqlCommand.Append("OFFSET :OffsetRows ");
}
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":CurrentSiteID", DbType.Int32);
arParams[0].Value = currentSiteId;
arParams[1] = new SqliteParameter(":PageSize", DbType.Int32);
arParams[1].Value = pageSize;
arParams[2] = new SqliteParameter(":OffsetRows", DbType.Int32);
arParams[2].Value = pageLowerBound;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public int CountOtherSites(int currentSiteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT Count(*) ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("WHERE SiteID <> :CurrentSiteID ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":CurrentSiteID", DbType.Int32);
arParams[0].Value = currentSiteId;
return Convert.ToInt32(AdoHelper.ExecuteScalar(
connectionString,
sqlCommand.ToString(),
arParams));
}
public DbDataReader GetPageListForAdmin(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT ");
sqlCommand.Append("PageID, ");
sqlCommand.Append("ParentID, ");
sqlCommand.Append("PageOrder, ");
sqlCommand.Append("PageName ");
sqlCommand.Append("FROM mp_Pages ");
sqlCommand.Append("WHERE SiteID = :SiteID ");
sqlCommand.Append("ORDER BY ParentID, PageName ;");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public DbDataReader GetSite(string hostName)
{
StringBuilder sqlCommand = new StringBuilder();
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":HostName", DbType.String);
arParams[0].Value = hostName;
int siteId = -1;
sqlCommand.Append("SELECT mp_SiteHosts.SiteID As SiteID ");
sqlCommand.Append("FROM mp_SiteHosts ");
sqlCommand.Append("WHERE mp_SiteHosts.HostName = :HostName ;");
using (DbDataReader reader = AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams))
{
if (reader.Read())
{
siteId = Convert.ToInt32(reader["SiteID"]);
}
}
sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("WHERE SiteID = :SiteID OR :SiteID = -1 ");
sqlCommand.Append("ORDER BY SiteID ");
sqlCommand.Append("LIMIT 1 ;");
arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public DbDataReader GetSite(Guid siteGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("WHERE SiteGuid = :SiteGuid ");
sqlCommand.Append("ORDER BY SiteName ;");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteGuid", DbType.String);
arParams[0].Value = siteGuid.ToString();
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public bool DeleteHostsBySite(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SiteHosts ");
sqlCommand.Append("WHERE SiteID = :SiteID ; ");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return rowsAffected > 0;
}
public bool AddHost(Guid siteGuid, int siteId, string hostName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_SiteHosts ");
sqlCommand.Append("( ");
sqlCommand.Append("SiteID, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("HostName ");
sqlCommand.Append(") ");
sqlCommand.Append("VALUES ");
sqlCommand.Append("( ");
sqlCommand.Append(":SiteID, ");
sqlCommand.Append(":SiteGuid, ");
sqlCommand.Append(":HostName ");
sqlCommand.Append(") ;");
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":HostName", DbType.String);
arParams[1].Value = hostName;
arParams[2] = new SqliteParameter(":SiteGuid", DbType.String);
arParams[2].Value = siteGuid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return rowsAffected > 0;
}
public DbDataReader GetHost(string hostName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_SiteHosts ");
sqlCommand.Append("WHERE HostName = :HostName ;");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":HostName", DbType.String);
arParams[0].Value = hostName;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public DbDataReader GetHostList(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_SiteHosts ");
sqlCommand.Append("WHERE SiteID = :SiteID ;");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
return AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams);
}
public bool Delete(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserProperties WHERE UserGuid IN (SELECT UserGuid FROM mp_Users WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_UserRoles WHERE UserID IN (SELECT UserID FROM mp_Users WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_UserLocation WHERE UserGuid IN (SELECT UserGuid FROM mp_Users WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_Users WHERE SiteID = :SiteID; ");
sqlCommand.Append("DELETE FROM mp_Roles WHERE SiteID = :SiteID; ");
sqlCommand.Append("DELETE FROM mp_SiteHosts WHERE SiteID = :SiteID; ");
sqlCommand.Append("DELETE FROM mp_SiteFolders WHERE SiteGuid IN (SELECT SiteGuid FROM mp_Sites WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_SiteSettingsEx WHERE SiteID = :SiteID; ");
sqlCommand.Append("DELETE FROM mp_RedirectList WHERE SiteGuid IN (SELECT SiteGuid FROM mp_Sites WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_TaskQueue WHERE SiteGuid IN (SELECT SiteGuid FROM mp_Sites WHERE SiteID = :SiteID);");
sqlCommand.Append("DELETE FROM mp_Sites ");
sqlCommand.Append("WHERE HostID = :SiteID ; ");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public bool UpdateExtendedProperties(
int siteId,
bool allowPasswordRetrieval,
bool allowPasswordReset,
bool requiresQuestionAndAnswer,
int maxInvalidPasswordAttempts,
int passwordAttemptWindowMinutes,
bool requiresUniqueEmail,
int passwordFormat,
int minRequiredPasswordLength,
int minRequiredNonAlphanumericCharacters,
String passwordStrengthRegularExpression,
String defaultEmailFromAddress
)
{
#region bit conversion
byte allowRetrieval;
if (allowPasswordRetrieval)
{
allowRetrieval = 1;
}
else
{
allowRetrieval = 0;
}
byte allowReset;
if (allowPasswordReset)
{
allowReset = 1;
}
else
{
allowReset = 0;
}
byte requiresQA;
if (requiresQuestionAndAnswer)
{
requiresQA = 1;
}
else
{
requiresQA = 0;
}
byte requiresEmail;
if (requiresUniqueEmail)
{
requiresEmail = 1;
}
else
{
requiresEmail = 0;
}
#endregion
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Sites ");
sqlCommand.Append("SET AllowPasswordRetrieval = :AllowPasswordRetrieval, ");
sqlCommand.Append("AllowPasswordReset = :AllowPasswordReset, ");
sqlCommand.Append("RequiresQuestionAndAnswer = :RequiresQuestionAndAnswer, ");
sqlCommand.Append("MaxInvalidPasswordAttempts = :MaxInvalidPasswordAttempts, ");
sqlCommand.Append("PasswordAttemptWindowMinutes = :PasswordAttemptWindowMinutes, ");
sqlCommand.Append("RequiresUniqueEmail = :RequiresUniqueEmail, ");
sqlCommand.Append("PasswordFormat = :PasswordFormat, ");
sqlCommand.Append("MinRequiredPasswordLength = :MinRequiredPasswordLength, ");
sqlCommand.Append("MinReqNonAlphaChars = :MinRequiredNonAlphanumericCharacters, ");
sqlCommand.Append("PwdStrengthRegex = :PasswordStrengthRegularExpression, ");
sqlCommand.Append("DefaultEmailFromAddress = :DefaultEmailFromAddress ");
sqlCommand.Append(" WHERE SiteID = :SiteID ;");
SqliteParameter[] arParams = new SqliteParameter[12];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":AllowPasswordRetrieval", DbType.Int32);
arParams[1].Value = allowRetrieval;
arParams[2] = new SqliteParameter(":AllowPasswordReset", DbType.Int32);
arParams[2].Value = allowReset;
arParams[3] = new SqliteParameter(":RequiresQuestionAndAnswer", DbType.Int32);
arParams[3].Value = requiresQA;
arParams[4] = new SqliteParameter(":MaxInvalidPasswordAttempts", DbType.Int32);
arParams[4].Value = maxInvalidPasswordAttempts;
arParams[5] = new SqliteParameter(":PasswordAttemptWindowMinutes", DbType.Int32);
arParams[5].Value = passwordAttemptWindowMinutes;
arParams[6] = new SqliteParameter(":RequiresUniqueEmail", DbType.Int32);
arParams[6].Value = requiresEmail;
arParams[7] = new SqliteParameter(":PasswordFormat", DbType.Int32);
arParams[7].Value = passwordFormat;
arParams[8] = new SqliteParameter(":MinRequiredPasswordLength", DbType.Int32);
arParams[8].Value = minRequiredPasswordLength;
arParams[9] = new SqliteParameter(":PasswordStrengthRegularExpression", DbType.Object);
arParams[9].Value = passwordStrengthRegularExpression;
arParams[10] = new SqliteParameter(":DefaultEmailFromAddress", DbType.String);
arParams[10].Value = defaultEmailFromAddress;
arParams[11] = new SqliteParameter(":MinRequiredNonAlphanumericCharacters", DbType.Int32);
arParams[11].Value = minRequiredNonAlphanumericCharacters;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public void SourceColumn_defaults_to_empty()
{
var parameter = new SqliteParameter();
Assert.Empty(parameter.SourceColumn);
}
public bool Update(
int siteId,
string siteName,
string skin,
bool allowNewRegistration,
bool useSecureRegistration,
bool isServerAdminSite,
bool useLdapAuth,
bool autoCreateLdapUserOnFirstLogin,
string ldapServer,
int ldapPort,
string ldapDomain,
string ldapRootDN,
string ldapUserDNKey,
bool useEmailForLogin,
bool reallyDeleteUsers,
string recaptchaPrivateKey,
string recaptchaPublicKey,
bool disableDbAuth,
bool requiresQuestionAndAnswer,
int maxInvalidPasswordAttempts,
int minRequiredPasswordLength,
string defaultEmailFromAddress,
bool allowDbFallbackWithLdap,
bool emailLdapDbFallback,
bool allowPersistentLogin,
bool captchaOnLogin,
bool captchaOnRegistration,
bool siteIsClosed,
string siteIsClosedMessage,
string privacyPolicy,
string timeZoneId,
string googleAnalyticsProfileId,
string companyName,
string companyStreetAddress,
string companyStreetAddress2,
string companyRegion,
string companyLocality,
string companyCountry,
string companyPostalCode,
string companyPublicEmail,
string companyPhone,
string companyFax,
string facebookAppId,
string facebookAppSecret,
string googleClientId,
string googleClientSecret,
string twitterConsumerKey,
string twitterConsumerSecret,
string microsoftClientId,
string microsoftClientSecret,
string preferredHostName,
string siteFolderName,
string addThisDotComUsername,
string loginInfoTop,
string loginInfoBottom,
string registrationAgreement,
string registrationPreamble,
string smtpServer,
int smtpPort,
string smtpUser,
string smtpPassword,
string smtpPreferredEncoding,
bool smtpRequiresAuth,
bool smtpUseSsl,
bool requireApprovalBeforeLogin,
bool isDataProtected,
bool requireConfirmedPhone,
string defaultEmailFromAlias,
string accountApprovalEmailCsv,
string dkimPublicKey,
string dkimPrivateKey,
string dkimDomain,
string dkimSelector,
bool signEmailWithDkim,
string oidConnectAppId,
string oidConnectAppSecret,
string smsClientId,
string smsSecureToken,
string smsFrom
)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Sites ");
sqlCommand.Append("SET SiteName = :SiteName, ");
sqlCommand.Append("IsServerAdminSite = :IsServerAdminSite, ");
sqlCommand.Append("Skin = :Skin, ");
sqlCommand.Append("AllowNewRegistration = :AllowNewRegistration, ");
sqlCommand.Append("UseSecureRegistration = :UseSecureRegistration, ");
sqlCommand.Append("UseLdapAuth = :UseLdapAuth, ");
sqlCommand.Append("AutoCreateLDAPUserOnFirstLogin = :AutoCreateLDAPUserOnFirstLogin, ");
sqlCommand.Append("LdapServer = :LdapServer, ");
sqlCommand.Append("LdapPort = :LdapPort, ");
sqlCommand.Append("LdapDomain = :LdapDomain, ");
sqlCommand.Append("LdapRootDN = :LdapRootDN, ");
sqlCommand.Append("LdapUserDNKey = :LdapUserDNKey, ");
sqlCommand.Append("UseEmailForLogin = :UseEmailForLogin, ");
sqlCommand.Append("ReallyDeleteUsers = :ReallyDeleteUsers, ");
sqlCommand.Append("RecaptchaPrivateKey = :RecaptchaPrivateKey, ");
sqlCommand.Append("RecaptchaPublicKey = :RecaptchaPublicKey, ");
sqlCommand.Append("DisableDbAuth = :DisableDbAuth, ");
sqlCommand.Append("RequiresQuestionAndAnswer = :RequiresQuestionAndAnswer, ");
sqlCommand.Append("MaxInvalidPasswordAttempts = :MaxInvalidPasswordAttempts, ");
sqlCommand.Append("MinRequiredPasswordLength = :MinRequiredPasswordLength, ");
sqlCommand.Append("DefaultEmailFromAddress = :DefaultEmailFromAddress, ");
sqlCommand.Append("AllowDbFallbackWithLdap = :AllowDbFallbackWithLdap, ");
sqlCommand.Append("EmailLdapDbFallback = :EmailLdapDbFallback, ");
sqlCommand.Append("AllowPersistentLogin = :AllowPersistentLogin, ");
sqlCommand.Append("CaptchaOnLogin = :CaptchaOnLogin, ");
sqlCommand.Append("CaptchaOnRegistration = :CaptchaOnRegistration,");
sqlCommand.Append("SiteIsClosed = :SiteIsClosed, ");
sqlCommand.Append("SiteIsClosedMessage = :SiteIsClosedMessage, ");
sqlCommand.Append("PrivacyPolicy = :PrivacyPolicy, ");
sqlCommand.Append("TimeZoneId = :TimeZoneId, ");
sqlCommand.Append("GoogleAnalyticsProfileId = :GoogleAnalyticsProfileId, ");
sqlCommand.Append("CompanyName = :CompanyName, ");
sqlCommand.Append("CompanyStreetAddress = :CompanyStreetAddress, ");
sqlCommand.Append("CompanyStreetAddress2 = :CompanyStreetAddress2, ");
sqlCommand.Append("CompanyRegion = :CompanyRegion, ");
sqlCommand.Append("CompanyLocality = :CompanyLocality, ");
sqlCommand.Append("CompanyCountry = :CompanyCountry, ");
sqlCommand.Append("CompanyPostalCode = :CompanyPostalCode, ");
sqlCommand.Append("CompanyPublicEmail = :CompanyPublicEmail, ");
sqlCommand.Append("CompanyPhone = :CompanyPhone, ");
sqlCommand.Append("CompanyFax = :CompanyFax, ");
sqlCommand.Append("FacebookAppId = :FacebookAppId, ");
sqlCommand.Append("FacebookAppSecret = :FacebookAppSecret, ");
sqlCommand.Append("GoogleClientId = :GoogleClientId, ");
sqlCommand.Append("GoogleClientSecret = :GoogleClientSecret, ");
sqlCommand.Append("TwitterConsumerKey = :TwitterConsumerKey, ");
sqlCommand.Append("TwitterConsumerSecret = :TwitterConsumerSecret, ");
sqlCommand.Append("MicrosoftClientId = :MicrosoftClientId, ");
sqlCommand.Append("MicrosoftClientSecret = :MicrosoftClientSecret, ");
sqlCommand.Append("PreferredHostName = :PreferredHostName, ");
sqlCommand.Append("SiteFolderName = :SiteFolderName, ");
sqlCommand.Append("AddThisDotComUsername = :AddThisDotComUsername, ");
sqlCommand.Append("LoginInfoTop = :LoginInfoTop, ");
sqlCommand.Append("LoginInfoBottom = :LoginInfoBottom, ");
sqlCommand.Append("RegistrationAgreement = :RegistrationAgreement, ");
sqlCommand.Append("RegistrationPreamble = :RegistrationPreamble, ");
sqlCommand.Append("SmtpServer = :SmtpServer, ");
sqlCommand.Append("SmtpPort = :SmtpPort, ");
sqlCommand.Append("SmtpUser = :SmtpUser, ");
sqlCommand.Append("SmtpPassword = :SmtpPassword, ");
sqlCommand.Append("SmtpPreferredEncoding = :SmtpPreferredEncoding, ");
sqlCommand.Append("SmtpRequiresAuth = :SmtpRequiresAuth, ");
sqlCommand.Append("SmtpUseSsl = :SmtpUseSsl, ");
sqlCommand.Append("IsDataProtected = :IsDataProtected, ");
sqlCommand.Append("RequireConfirmedPhone = :RequireConfirmedPhone, ");
sqlCommand.Append("DefaultEmailFromAlias = :DefaultEmailFromAlias, ");
sqlCommand.Append("AccountApprovalEmailCsv = :AccountApprovalEmailCsv, ");
sqlCommand.Append("DkimPublicKey = :DkimPublicKey, ");
sqlCommand.Append("DkimPrivateKey = :DkimPrivateKey, ");
sqlCommand.Append("DkimDomain = :DkimDomain, ");
sqlCommand.Append("DkimSelector = :DkimSelector, ");
sqlCommand.Append("SignEmailWithDkim = :SignEmailWithDkim, ");
sqlCommand.Append("OidConnectAppId = :OidConnectAppId, ");
sqlCommand.Append("OidConnectAppSecret = :OidConnectAppSecret, ");
sqlCommand.Append("SmsClientId = :SmsClientId, ");
sqlCommand.Append("SmsSecureToken = :SmsSecureToken, ");
sqlCommand.Append("SmsFrom = :SmsFrom, ");
sqlCommand.Append("RequireApprovalBeforeLogin = :RequireApprovalBeforeLogin ");
sqlCommand.Append(" WHERE SiteID = :SiteID ;");
SqliteParameter[] arParams = new SqliteParameter[79];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":SiteName", DbType.String);
arParams[1].Value = siteName;
arParams[2] = new SqliteParameter(":IsServerAdminSite", DbType.Int32);
arParams[2].Value = isServerAdminSite ? 1 : 0;
arParams[3] = new SqliteParameter(":Skin", DbType.String);
arParams[3].Value = skin;
arParams[4] = new SqliteParameter(":AllowNewRegistration", DbType.Int32);
arParams[4].Value = allowNewRegistration ? 1 : 0;
arParams[5] = new SqliteParameter(":UseSecureRegistration", DbType.Int32);
arParams[5].Value = useSecureRegistration ? 1 : 0;
arParams[6] = new SqliteParameter(":UseLdapAuth", DbType.Int32);
arParams[6].Value = useLdapAuth ? 1 : 0;
arParams[7] = new SqliteParameter(":AutoCreateLDAPUserOnFirstLogin", DbType.Int32);
arParams[7].Value = autoCreateLdapUserOnFirstLogin ? 1 : 0;
arParams[8] = new SqliteParameter(":LdapServer", DbType.String);
arParams[8].Value = ldapServer;
arParams[9] = new SqliteParameter(":LdapPort", DbType.Int32);
arParams[9].Value = ldapPort;
arParams[10] = new SqliteParameter(":LdapRootDN", DbType.String);
arParams[10].Value = ldapRootDN;
arParams[11] = new SqliteParameter(":LdapUserDNKey", DbType.String);
arParams[11].Value = ldapUserDNKey;
arParams[12] = new SqliteParameter(":UseEmailForLogin", DbType.Int32);
arParams[12].Value = useEmailForLogin ? 1 : 0;
arParams[13] = new SqliteParameter(":ReallyDeleteUsers", DbType.Int32);
arParams[13].Value = reallyDeleteUsers ? 1 : 0;
arParams[14] = new SqliteParameter(":LdapDomain", DbType.String);
arParams[14].Value = ldapDomain;
arParams[15] = new SqliteParameter(":RecaptchaPrivateKey", DbType.String);
arParams[15].Value = recaptchaPrivateKey;
arParams[16] = new SqliteParameter(":RecaptchaPublicKey", DbType.String);
arParams[16].Value = recaptchaPublicKey;
arParams[17] = new SqliteParameter(":DisableDbAuth", DbType.Int32);
arParams[17].Value = disableDbAuth ? 1 : 0;
arParams[18] = new SqliteParameter(":RequiresQuestionAndAnswer", DbType.Int32);
arParams[18].Value = requiresQuestionAndAnswer ? 1 : 0;
arParams[19] = new SqliteParameter(":MaxInvalidPasswordAttempts", DbType.Int32);
arParams[19].Value = maxInvalidPasswordAttempts;
arParams[20] = new SqliteParameter(":MinRequiredPasswordLength", DbType.Int32);
arParams[20].Value = minRequiredPasswordLength;
arParams[21] = new SqliteParameter(":DefaultEmailFromAddress", DbType.String);
arParams[21].Value = defaultEmailFromAddress;
arParams[22] = new SqliteParameter(":AllowDbFallbackWithLdap", DbType.Int32);
arParams[22].Value = allowDbFallbackWithLdap ? 1 : 0;
arParams[23] = new SqliteParameter(":EmailLdapDbFallback", DbType.Int32);
arParams[23].Value = emailLdapDbFallback ? 1 : 0;
arParams[24] = new SqliteParameter(":AllowPersistentLogin", DbType.Int32);
arParams[24].Value = allowPersistentLogin ? 1 : 0;
arParams[25] = new SqliteParameter(":CaptchaOnLogin", DbType.Int32);
arParams[25].Value = captchaOnLogin ? 1 : 0;
arParams[26] = new SqliteParameter(":CaptchaOnRegistration", DbType.Int32);
arParams[26].Value = captchaOnRegistration ? 1 : 0;
arParams[27] = new SqliteParameter(":SiteIsClosed", DbType.Int32);
arParams[27].Value = siteIsClosed ? 1 : 0;
arParams[28] = new SqliteParameter(":SiteIsClosedMessage", DbType.Object);
arParams[28].Value = siteIsClosedMessage;
arParams[29] = new SqliteParameter(":PrivacyPolicy", DbType.Object);
arParams[29].Value = privacyPolicy;
arParams[30] = new SqliteParameter(":TimeZoneId", DbType.String);
arParams[30].Value = timeZoneId;
arParams[31] = new SqliteParameter(":GoogleAnalyticsProfileId", DbType.String);
arParams[31].Value = googleAnalyticsProfileId;
arParams[32] = new SqliteParameter(":CompanyName", DbType.String);
arParams[32].Value = companyName;
arParams[33] = new SqliteParameter(":CompanyStreetAddress", DbType.String);
arParams[33].Value = companyStreetAddress;
arParams[34] = new SqliteParameter(":CompanyStreetAddress2", DbType.String);
arParams[34].Value = companyStreetAddress2;
arParams[35] = new SqliteParameter(":CompanyRegion", DbType.String);
arParams[35].Value = companyRegion;
arParams[36] = new SqliteParameter(":CompanyLocality", DbType.String);
arParams[36].Value = companyLocality;
arParams[37] = new SqliteParameter(":CompanyCountry", DbType.String);
arParams[37].Value = companyCountry;
arParams[38] = new SqliteParameter(":CompanyPostalCode", DbType.String);
arParams[38].Value = companyPostalCode;
arParams[39] = new SqliteParameter(":CompanyPublicEmail", DbType.String);
arParams[39].Value = companyPublicEmail;
arParams[40] = new SqliteParameter(":CompanyPhone", DbType.String);
arParams[40].Value = companyPhone;
arParams[41] = new SqliteParameter(":CompanyFax", DbType.String);
arParams[41].Value = companyFax;
arParams[42] = new SqliteParameter(":FacebookAppId", DbType.String);
arParams[42].Value = facebookAppId;
arParams[43] = new SqliteParameter(":FacebookAppSecret", DbType.String);
arParams[43].Value = facebookAppSecret;
arParams[44] = new SqliteParameter(":GoogleClientId", DbType.String);
arParams[44].Value = googleClientId;
arParams[45] = new SqliteParameter(":GoogleClientSecret", DbType.String);
arParams[45].Value = googleClientSecret;
arParams[46] = new SqliteParameter(":TwitterConsumerKey", DbType.String);
arParams[46].Value = twitterConsumerKey;
arParams[47] = new SqliteParameter(":TwitterConsumerSecret", DbType.String);
arParams[47].Value = twitterConsumerSecret;
arParams[48] = new SqliteParameter(":MicrosoftClientId", DbType.String);
arParams[48].Value = microsoftClientId;
arParams[49] = new SqliteParameter(":MicrosoftClientSecret", DbType.String);
arParams[49].Value = microsoftClientSecret;
arParams[50] = new SqliteParameter(":PreferredHostName", DbType.String);
arParams[50].Value = preferredHostName;
arParams[51] = new SqliteParameter(":SiteFolderName", DbType.String);
arParams[51].Value = siteFolderName;
arParams[52] = new SqliteParameter(":AddThisDotComUsername", DbType.String);
arParams[52].Value = addThisDotComUsername;
arParams[53] = new SqliteParameter(":LoginInfoTop", DbType.Object);
arParams[53].Value = loginInfoTop;
arParams[54] = new SqliteParameter(":LoginInfoBottom", DbType.Object);
arParams[54].Value = loginInfoBottom;
arParams[55] = new SqliteParameter(":RegistrationAgreement", DbType.Object);
arParams[55].Value = registrationAgreement;
arParams[56] = new SqliteParameter(":RegistrationPreamble", DbType.Object);
arParams[56].Value = registrationPreamble;
arParams[57] = new SqliteParameter(":SmtpServer", DbType.String);
arParams[57].Value = smtpServer;
arParams[58] = new SqliteParameter(":SmtpPort", DbType.Int32);
arParams[58].Value = smtpPort;
arParams[59] = new SqliteParameter(":SmtpUser", DbType.String);
arParams[59].Value = smtpUser;
arParams[60] = new SqliteParameter(":SmtpPassword", DbType.String);
arParams[60].Value = smtpPassword;
arParams[61] = new SqliteParameter(":SmtpPreferredEncoding", DbType.String);
arParams[61].Value = smtpPreferredEncoding;
arParams[62] = new SqliteParameter(":SmtpRequiresAuth", DbType.Int32);
arParams[62].Value = smtpRequiresAuth ? 1 : 0;
arParams[63] = new SqliteParameter(":SmtpUseSsl", DbType.Int32);
arParams[63].Value = smtpUseSsl ? 1 : 0;
arParams[64] = new SqliteParameter(":RequireApprovalBeforeLogin", DbType.Int32);
arParams[64].Value = requireApprovalBeforeLogin ? 1 : 0;
arParams[65] = new SqliteParameter(":IsDataProtected", DbType.Int32);
arParams[65].Value = isDataProtected ? 1 : 0;
arParams[66] = new SqliteParameter(":RequireConfirmedPhone", DbType.Int32);
arParams[66].Value = requireConfirmedPhone ? 1 : 0;
arParams[67] = new SqliteParameter(":DefaultEmailFromAlias", DbType.String);
arParams[67].Value = defaultEmailFromAlias;
arParams[68] = new SqliteParameter(":AccountApprovalEmailCsv", DbType.String);
arParams[68].Value = accountApprovalEmailCsv;
arParams[69] = new SqliteParameter(":DkimPublicKey", DbType.String);
arParams[69].Value = dkimPublicKey;
arParams[70] = new SqliteParameter(":DkimPrivateKey", DbType.String);
arParams[70].Value = dkimPrivateKey;
arParams[71] = new SqliteParameter(":DkimDomain", DbType.String);
arParams[71].Value = dkimDomain;
arParams[72] = new SqliteParameter(":DkimSelector", DbType.String);
arParams[72].Value = dkimSelector;
arParams[73] = new SqliteParameter(":SignEmailWithDkim", DbType.Int32);
arParams[73].Value = signEmailWithDkim ? 1 : 0;
arParams[74] = new SqliteParameter(":OidConnectAppId", DbType.String);
arParams[74].Value = oidConnectAppId;
arParams[75] = new SqliteParameter(":OidConnectAppSecret", DbType.String);
arParams[75].Value = oidConnectAppSecret;
arParams[76] = new SqliteParameter(":SmsClientId", DbType.String);
arParams[76].Value = smsClientId;
arParams[77] = new SqliteParameter(":SmsSecureToken", DbType.String);
arParams[77].Value = smsSecureToken;
arParams[78] = new SqliteParameter(":SmsFrom", DbType.String);
arParams[78].Value = smsFrom;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public int GetSiteIdByHostName(string hostName)
{
int siteId = -1;
StringBuilder sqlCommand = new StringBuilder();
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":HostName", DbType.String);
arParams[0].Value = hostName;
sqlCommand.Append("SELECT mp_SiteHosts.SiteID As SiteID ");
sqlCommand.Append("FROM mp_SiteHosts ");
sqlCommand.Append("WHERE mp_SiteHosts.HostName = :HostName ;");
using (DbDataReader reader = AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams))
{
if (reader.Read())
{
siteId = Convert.ToInt32(reader["SiteID"]);
}
}
if (siteId == -1)
{
sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT SiteID ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("ORDER BY SiteID ");
sqlCommand.Append("LIMIT 1 ;");
using (DbDataReader reader = AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
null))
{
if (reader.Read())
{
siteId = Convert.ToInt32(reader["SiteID"]);
}
}
}
return siteId;
}
public int GetSiteIdByFolder(string folderName)
{
int siteId = -1;
StringBuilder sqlCommand = new StringBuilder();
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":FolderName", DbType.String);
arParams[0].Value = folderName;
sqlCommand.Append("SELECT COALESCE(s.SiteID, -1) As SiteID ");
sqlCommand.Append("FROM mp_SiteFolders sf ");
sqlCommand.Append("JOIN mp_Sites s ");
sqlCommand.Append("ON ");
sqlCommand.Append("sf.SiteGuid = s.SiteGuid ");
sqlCommand.Append("WHERE sf.FolderName = :FolderName ");
sqlCommand.Append("ORDER BY s.SiteID ");
sqlCommand.Append(";");
using (DbDataReader reader = AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
arParams))
{
if (reader.Read())
{
siteId = Convert.ToInt32(reader["SiteID"]);
}
}
if (siteId == -1)
{
sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT SiteID ");
sqlCommand.Append("FROM mp_Sites ");
sqlCommand.Append("ORDER BY SiteID ");
sqlCommand.Append("LIMIT 1 ;");
using (DbDataReader reader = AdoHelper.ExecuteReader(
connectionString,
sqlCommand.ToString(),
null))
{
if (reader.Read())
{
siteId = Convert.ToInt32(reader["SiteID"]);
}
}
}
return siteId;
}
public bool UpdateRelatedSitesWindowsLive(
int siteId,
string windowsLiveAppId,
string windowsLiveKey
)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Sites ");
sqlCommand.Append("SET ");
sqlCommand.Append("WindowsLiveAppID = :WindowsLiveAppID, ");
sqlCommand.Append("WindowsLiveKey = :WindowsLiveKey ");
sqlCommand.Append(" WHERE SiteID <> :SiteID ;");
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":WindowsLiveAppID", DbType.String);
arParams[1].Value = windowsLiveAppId;
arParams[2] = new SqliteParameter(":WindowsLiveKey", DbType.String);
arParams[2].Value = windowsLiveKey;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public bool UpdateRelatedSites(
int siteId,
bool allowNewRegistration,
bool useSecureRegistration,
bool useLdapAuth,
bool autoCreateLdapUserOnFirstLogin,
string ldapServer,
string ldapDomain,
int ldapPort,
string ldapRootDN,
string ldapUserDNKey,
bool allowUserFullNameChange,
bool useEmailForLogin,
bool allowOpenIdAuth,
bool allowWindowsLiveAuth,
bool allowPasswordRetrieval,
bool allowPasswordReset,
bool requiresQuestionAndAnswer,
int maxInvalidPasswordAttempts,
int passwordAttemptWindowMinutes,
bool requiresUniqueEmail,
int passwordFormat,
int minRequiredPasswordLength,
int minReqNonAlphaChars,
string pwdStrengthRegex
)
{
#region bool conversion
byte oidauth;
if (allowOpenIdAuth)
{
oidauth = 1;
}
else
{
oidauth = 0;
}
byte winliveauth;
if (allowWindowsLiveAuth)
{
winliveauth = 1;
}
else
{
winliveauth = 0;
}
byte uldapp;
if (useLdapAuth)
{
uldapp = 1;
}
else
{
uldapp = 0;
}
byte autoldapp;
if (autoCreateLdapUserOnFirstLogin)
{
autoldapp = 1;
}
else
{
autoldapp = 0;
}
byte allowNameChange;
if (allowUserFullNameChange)
{
allowNameChange = 1;
}
else
{
allowNameChange = 0;
}
byte emailForLogin;
if (useEmailForLogin)
{
emailForLogin = 1;
}
else
{
emailForLogin = 0;
}
byte allowNew;
if (allowNewRegistration)
{
allowNew = 1;
}
else
{
allowNew = 0;
}
byte secure;
if (useSecureRegistration)
{
secure = 1;
}
else
{
secure = 0;
}
int intAllowPasswordRetrieval = 0;
if (allowPasswordRetrieval)
{
intAllowPasswordRetrieval = 1;
}
int intAllowPasswordReset = 0;
if (allowPasswordReset)
{
intAllowPasswordReset = 1;
}
int intRequiresQuestionAndAnswer = 0;
if (requiresQuestionAndAnswer)
{
intRequiresQuestionAndAnswer = 1;
}
int intRequiresUniqueEmail = 0;
if (requiresUniqueEmail)
{
intRequiresUniqueEmail = 1;
}
#endregion
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Sites ");
sqlCommand.Append("SET ");
sqlCommand.Append("AllowNewRegistration = :AllowNewRegistration, ");
sqlCommand.Append("UseSecureRegistration = :UseSecureRegistration, ");
sqlCommand.Append("UseLdapAuth = :UseLdapAuth, ");
sqlCommand.Append("AutoCreateLDAPUserOnFirstLogin = :AutoCreateLDAPUserOnFirstLogin, ");
sqlCommand.Append("LdapServer = :LdapServer, ");
sqlCommand.Append("LdapPort = :LdapPort, ");
sqlCommand.Append("LdapDomain = :LdapDomain, ");
sqlCommand.Append("LdapRootDN = :LdapRootDN, ");
sqlCommand.Append("LdapUserDNKey = :LdapUserDNKey, ");
sqlCommand.Append("AllowUserFullNameChange = :AllowUserFullNameChange, ");
sqlCommand.Append("UseEmailForLogin = :UseEmailForLogin, ");
sqlCommand.Append("AllowOpenIDAuth = :AllowOpenIDAuth, ");
sqlCommand.Append("AllowWindowsLiveAuth = :AllowWindowsLiveAuth, ");
sqlCommand.Append("AllowPasswordRetrieval = :AllowPasswordRetrieval, ");
sqlCommand.Append("AllowPasswordReset = :AllowPasswordReset, ");
sqlCommand.Append("RequiresQuestionAndAnswer = :RequiresQuestionAndAnswer, ");
sqlCommand.Append("MaxInvalidPasswordAttempts = :MaxInvalidPasswordAttempts, ");
sqlCommand.Append("PasswordAttemptWindowMinutes = :PasswordAttemptWindowMinutes, ");
sqlCommand.Append("RequiresUniqueEmail = :RequiresUniqueEmail, ");
sqlCommand.Append("PasswordFormat = :PasswordFormat, ");
sqlCommand.Append("MinRequiredPasswordLength = :MinRequiredPasswordLength, ");
sqlCommand.Append("MinReqNonAlphaChars = :MinReqNonAlphaChars, ");
sqlCommand.Append("PwdStrengthRegex = :PwdStrengthRegex ");
sqlCommand.Append(" WHERE SiteID <> :SiteID ;");
SqliteParameter[] arParams = new SqliteParameter[24];
arParams[0] = new SqliteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SqliteParameter(":AllowNewRegistration", DbType.Int32);
arParams[1].Value = allowNew;
arParams[2] = new SqliteParameter(":UseSecureRegistration", DbType.Int32);
arParams[2].Value = secure;
arParams[3] = new SqliteParameter(":UseLdapAuth", DbType.Int32);
arParams[3].Value = uldapp;
arParams[4] = new SqliteParameter(":AutoCreateLDAPUserOnFirstLogin", DbType.Int32);
arParams[4].Value = autoldapp;
arParams[5] = new SqliteParameter(":LdapServer", DbType.String);
arParams[5].Value = ldapServer;
arParams[6] = new SqliteParameter(":LdapPort", DbType.Int32);
arParams[6].Value = ldapPort;
arParams[7] = new SqliteParameter(":LdapRootDN", DbType.String);
arParams[7].Value = ldapRootDN;
arParams[8] = new SqliteParameter(":LdapUserDNKey", DbType.String);
arParams[8].Value = ldapUserDNKey;
arParams[9] = new SqliteParameter(":AllowUserFullNameChange", DbType.Int32);
arParams[9].Value = allowNameChange;
arParams[10] = new SqliteParameter(":UseEmailForLogin", DbType.Int32);
arParams[10].Value = emailForLogin;
arParams[11] = new SqliteParameter(":LdapDomain", DbType.String);
arParams[11].Value = ldapDomain;
arParams[12] = new SqliteParameter(":AllowOpenIDAuth", DbType.Int32);
arParams[12].Value = oidauth;
arParams[13] = new SqliteParameter(":AllowWindowsLiveAuth", DbType.Int32);
arParams[13].Value = winliveauth;
arParams[14] = new SqliteParameter(":AllowPasswordRetrieval", DbType.Int32);
arParams[14].Value = intAllowPasswordRetrieval;
arParams[15] = new SqliteParameter(":AllowPasswordReset", DbType.Int32);
arParams[15].Value = intAllowPasswordReset;
arParams[16] = new SqliteParameter(":RequiresQuestionAndAnswer", DbType.Int32);
arParams[16].Value = intRequiresQuestionAndAnswer;
arParams[17] = new SqliteParameter(":MaxInvalidPasswordAttempts", DbType.Int32);
arParams[17].Value = maxInvalidPasswordAttempts;
arParams[18] = new SqliteParameter(":PasswordAttemptWindowMinutes", DbType.Int32);
arParams[18].Value = passwordAttemptWindowMinutes;
arParams[19] = new SqliteParameter(":RequiresUniqueEmail", DbType.Int32);
arParams[19].Value = intRequiresUniqueEmail;
arParams[20] = new SqliteParameter(":PasswordFormat", DbType.Int32);
arParams[20].Value = passwordFormat;
arParams[21] = new SqliteParameter(":MinRequiredPasswordLength", DbType.Int32);
arParams[21].Value = minRequiredPasswordLength;
arParams[22] = new SqliteParameter(":MinReqNonAlphaChars", DbType.Int32);
arParams[22].Value = minReqNonAlphaChars;
arParams[23] = new SqliteParameter(":PwdStrengthRegex", DbType.Object);
arParams[23].Value = pwdStrengthRegex;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public void ParameterName_defaults_to_empty()
{
var parameter = new SqliteParameter();
Assert.Empty(parameter.ParameterName);
}
