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_name_and_value()
{
var result = new SQLiteParameter("@Parameter", 1);
Assert.Equal("@Parameter", result.ParameterName);
Assert.Equal(1, result.Value);
}
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 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 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 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;
}
/// <summary>
/// Inserts a row in the mp_BannedIPAddresses table. Returns new integer id.
/// </summary>
/// <param name="bannedIP"> bannedIP </param>
/// <param name="bannedUTC"> bannedUTC </param>
/// <param name="bannedReason"> bannedReason </param>
/// <returns>int</returns>
public int Add(
string bannedIP,
DateTime bannedUtc,
string bannedReason)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_BannedIPAddresses (");
sqlCommand.Append("BannedIP, ");
sqlCommand.Append("BannedUTC, ");
sqlCommand.Append("BannedReason )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":BannedIP, ");
sqlCommand.Append(":BannedUTC, ");
sqlCommand.Append(":BannedReason );");
sqlCommand.Append("SELECT LAST_INSERT_ROWID();");
SQLiteParameter[] arParams = new SQLiteParameter[3];
arParams[0] = new SQLiteParameter(":BannedIP", DbType.String);
arParams[0].Value = bannedIP;
arParams[1] = new SQLiteParameter(":BannedUTC", DbType.DateTime);
arParams[1].Value = bannedUtc;
arParams[2] = new SQLiteParameter(":BannedReason", DbType.String);
arParams[2].Value = bannedReason;
int newID = Convert.ToInt32(AdoHelper.ExecuteScalar(
connectionString,
sqlCommand.ToString(),
arParams).ToString());
return newID;
}
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 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 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));
}
private int GetCount(
int siteID,
string keyName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT Count(*) ");
sqlCommand.Append("FROM mp_SiteSettingsEx ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SiteID = :SiteID AND ");
sqlCommand.Append("KeyName = :KeyName ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[2];
arParams[0] = new SQLiteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteID;
arParams[1] = new SQLiteParameter(":KeyName", DbType.String);
arParams[1].Value = keyName;
return Convert.ToInt32(AdoHelper.ExecuteScalar(
connectionString,
sqlCommand.ToString(),
arParams));
}
private bool Create(
int siteId,
Guid siteGuid,
string keyName,
string keyValue,
string groupName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_SiteSettingsEx (");
sqlCommand.Append("SiteID, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("KeyName, ");
sqlCommand.Append("KeyValue, ");
sqlCommand.Append("GroupName )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append(":SiteId, ");
sqlCommand.Append(":SiteGuid, ");
sqlCommand.Append(":KeyName, ");
sqlCommand.Append(":KeyValue, ");
sqlCommand.Append(":GroupName )");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[5];
arParams[0] = new SQLiteParameter(":SiteId", DbType.Int32);
arParams[0].Value = siteId;
arParams[1] = new SQLiteParameter(":SiteGuid", DbType.String);
arParams[1].Value = siteGuid.ToString();
arParams[2] = new SQLiteParameter(":KeyName", DbType.String);
arParams[2].Value = keyName;
arParams[3] = new SQLiteParameter(":KeyValue", DbType.Object);
arParams[3].Value = keyValue;
arParams[4] = new SQLiteParameter(":GroupName", DbType.String);
arParams[4].Value = groupName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > 0);
}
public bool DeleteHost(int hostId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SiteHosts ");
sqlCommand.Append("WHERE HostID = :HostID ; ");
SQLiteParameter[] arParams = new SQLiteParameter[1];
arParams[0] = new SQLiteParameter(":HostID", DbType.Int32);
arParams[0].Value = hostId;
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 bool Update(
int siteId,
string siteName,
string skin,
string logo,
string icon,
bool allowNewRegistration,
bool allowUserSkins,
bool allowPageSkins,
bool allowHideMenuOnPages,
bool useSecureRegistration,
bool useSslOnAllPages,
string defaultPageKeywords,
string defaultPageDescription,
string defaultPageEncoding,
string defaultAdditionalMetaTags,
bool isServerAdminSite,
bool useLdapAuth,
bool autoCreateLdapUserOnFirstLogin,
string ldapServer,
int ldapPort,
String ldapDomain,
string ldapRootDN,
string ldapUserDNKey,
bool allowUserFullNameChange,
bool useEmailForLogin,
bool reallyDeleteUsers,
String editorSkin,
String defaultFriendlyUrlPattern,
bool enableMyPageFeature,
string editorProvider,
string datePickerProvider,
string captchaProvider,
string recaptchaPrivateKey,
string recaptchaPublicKey,
string wordpressApiKey,
string windowsLiveAppId,
string windowsLiveKey,
bool allowOpenIdAuth,
bool allowWindowsLiveAuth,
string gmapApiKey,
string apiKeyExtra1,
string apiKeyExtra2,
string apiKeyExtra3,
string apiKeyExtra4,
string apiKeyExtra5,
bool disableDbAuth)
{
#region bool conversion
byte intDisableDbAuth = 0;
if (disableDbAuth) { intDisableDbAuth = 1; }
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 deleteUsers;
if (reallyDeleteUsers)
{
deleteUsers = 1;
}
else
{
deleteUsers = 0;
}
byte allowNew;
if (allowNewRegistration)
{
allowNew = 1;
}
else
{
allowNew = 0;
}
byte allowSkins;
if (allowUserSkins)
{
allowSkins = 1;
}
else
{
allowSkins = 0;
}
byte secure;
if (useSecureRegistration)
{
secure = 1;
}
else
{
secure = 0;
}
byte enableMy;
if (enableMyPageFeature)
{
enableMy = 1;
}
else
{
enableMy = 0;
}
byte ssl;
if (useSslOnAllPages)
{
ssl = 1;
}
else
{
ssl = 0;
}
byte adminSite;
if (isServerAdminSite)
{
adminSite = 1;
}
else
{
adminSite = 0;
}
byte pageSkins;
if (allowPageSkins)
{
pageSkins = 1;
}
else
{
pageSkins = 0;
}
byte allowHide;
if (allowHideMenuOnPages)
{
allowHide = 1;
}
else
{
allowHide = 0;
}
#endregion
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Sites ");
sqlCommand.Append("SET SiteName = :SiteName, ");
sqlCommand.Append("IsServerAdminSite = :IsServerAdminSite, ");
sqlCommand.Append("Skin = :Skin, ");
sqlCommand.Append("Logo = :Logo, ");
sqlCommand.Append("Icon = :Icon, ");
sqlCommand.Append("AllowNewRegistration = :AllowNewRegistration, ");
sqlCommand.Append("AllowUserSkins = :AllowUserSkins, ");
sqlCommand.Append("AllowPageSkins = :AllowPageSkins, ");
sqlCommand.Append("AllowHideMenuOnPages = :AllowHideMenuOnPages, ");
sqlCommand.Append("UseSecureRegistration = :UseSecureRegistration, ");
sqlCommand.Append("EnableMyPageFeature = :EnableMyPageFeature, ");
sqlCommand.Append("UseSSLOnAllPages = :UseSSLOnAllPages, ");
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("ReallyDeleteUsers = :ReallyDeleteUsers, ");
sqlCommand.Append("EditorProvider = :EditorProvider, ");
sqlCommand.Append("EditorSkin = :EditorSkin, ");
sqlCommand.Append("DefaultFriendlyUrlPatternEnum = :DefaultFriendlyUrlPattern, ");
sqlCommand.Append("DatePickerProvider = :DatePickerProvider, ");
sqlCommand.Append("CaptchaProvider = :CaptchaProvider, ");
sqlCommand.Append("RecaptchaPrivateKey = :RecaptchaPrivateKey, ");
sqlCommand.Append("RecaptchaPublicKey = :RecaptchaPublicKey, ");
sqlCommand.Append("WordpressAPIKey = :WordpressAPIKey, ");
sqlCommand.Append("WindowsLiveAppID = :WindowsLiveAppID, ");
sqlCommand.Append("WindowsLiveKey = :WindowsLiveKey, ");
sqlCommand.Append("AllowOpenIDAuth = :AllowOpenIDAuth, ");
sqlCommand.Append("AllowWindowsLiveAuth = :AllowWindowsLiveAuth, ");
sqlCommand.Append("DisableDbAuth = :DisableDbAuth, ");
sqlCommand.Append("DefaultPageKeywords = :DefaultPageKeywords, ");
sqlCommand.Append("DefaultPageDescription = :DefaultPageDescription, ");
sqlCommand.Append("DefaultPageEncoding = :DefaultPageEncoding, ");
sqlCommand.Append("DefaultAdditionalMetaTags = :DefaultAdditionalMetaTags, ");
sqlCommand.Append("GmapApiKey = :GmapApiKey, ");
sqlCommand.Append("ApiKeyExtra1 = :ApiKeyExtra1, ");
sqlCommand.Append("ApiKeyExtra2 = :ApiKeyExtra2, ");
sqlCommand.Append("ApiKeyExtra3 = :ApiKeyExtra3, ");
sqlCommand.Append("ApiKeyExtra4 = :ApiKeyExtra4, ");
sqlCommand.Append("ApiKeyExtra5 = :ApiKeyExtra5 ");
sqlCommand.Append(" WHERE SiteID = :SiteID ;");
SQLiteParameter[] arParams = new SQLiteParameter[46];
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 = adminSite;
arParams[3] = new SQLiteParameter(":Skin", DbType.String);
arParams[3].Value = skin;
arParams[4] = new SQLiteParameter(":Logo", DbType.String);
arParams[4].Value = logo;
arParams[5] = new SQLiteParameter(":Icon", DbType.String);
arParams[5].Value = icon;
arParams[6] = new SQLiteParameter(":AllowNewRegistration", DbType.Int32);
arParams[6].Value = allowNew;
arParams[7] = new SQLiteParameter(":AllowUserSkins", DbType.Int32);
arParams[7].Value = allowSkins;
arParams[8] = new SQLiteParameter(":UseSecureRegistration", DbType.Int32);
arParams[8].Value = secure;
arParams[9] = new SQLiteParameter(":EnableMyPageFeature", DbType.Int32);
arParams[9].Value = enableMy;
arParams[10] = new SQLiteParameter(":UseSSLOnAllPages", DbType.Int32);
arParams[10].Value = ssl;
arParams[11] = new SQLiteParameter(":DefaultPageKeywords", DbType.String);
arParams[11].Value = defaultPageKeywords;
arParams[12] = new SQLiteParameter(":DefaultPageDescription", DbType.String);
arParams[12].Value = defaultPageDescription;
arParams[13] = new SQLiteParameter(":DefaultPageEncoding", DbType.String);
arParams[13].Value = defaultPageEncoding;
arParams[14] = new SQLiteParameter(":DefaultAdditionalMetaTags", DbType.String);
arParams[14].Value = defaultAdditionalMetaTags;
arParams[15] = new SQLiteParameter(":AllowPageSkins", DbType.Int32);
arParams[15].Value = pageSkins;
arParams[16] = new SQLiteParameter(":AllowHideMenuOnPages", DbType.Int32);
arParams[16].Value = allowHide;
arParams[17] = new SQLiteParameter(":UseLdapAuth", DbType.Int32);
arParams[17].Value = uldapp;
arParams[18] = new SQLiteParameter(":AutoCreateLDAPUserOnFirstLogin", DbType.Int32);
arParams[18].Value = autoldapp;
arParams[19] = new SQLiteParameter(":LdapServer", DbType.String);
arParams[19].Value = ldapServer;
arParams[20] = new SQLiteParameter(":LdapPort", DbType.Int32);
arParams[20].Value = ldapPort;
arParams[21] = new SQLiteParameter(":LdapRootDN", DbType.String);
arParams[21].Value = ldapRootDN;
arParams[22] = new SQLiteParameter(":LdapUserDNKey", DbType.String);
arParams[22].Value = ldapUserDNKey;
arParams[23] = new SQLiteParameter(":AllowUserFullNameChange", DbType.Int32);
arParams[23].Value = allowNameChange;
arParams[24] = new SQLiteParameter(":UseEmailForLogin", DbType.Int32);
arParams[24].Value = emailForLogin;
arParams[25] = new SQLiteParameter(":ReallyDeleteUsers", DbType.Int32);
arParams[25].Value = deleteUsers;
arParams[26] = new SQLiteParameter(":EditorSkin", DbType.String);
arParams[26].Value = editorSkin;
arParams[27] = new SQLiteParameter(":DefaultFriendlyUrlPattern", DbType.String);
arParams[27].Value = defaultFriendlyUrlPattern;
arParams[28] = new SQLiteParameter(":LdapDomain", DbType.String);
arParams[28].Value = ldapDomain;
arParams[29] = new SQLiteParameter(":EditorProvider", DbType.String);
arParams[29].Value = editorProvider;
arParams[30] = new SQLiteParameter(":DatePickerProvider", DbType.String);
arParams[30].Value = datePickerProvider;
arParams[31] = new SQLiteParameter(":CaptchaProvider", DbType.String);
arParams[31].Value = captchaProvider;
arParams[32] = new SQLiteParameter(":RecaptchaPrivateKey", DbType.String);
arParams[32].Value = recaptchaPrivateKey;
arParams[33] = new SQLiteParameter(":RecaptchaPublicKey", DbType.String);
arParams[33].Value = recaptchaPublicKey;
arParams[34] = new SQLiteParameter(":WordpressAPIKey", DbType.String);
arParams[34].Value = wordpressApiKey;
arParams[35] = new SQLiteParameter(":WindowsLiveAppID", DbType.String);
arParams[35].Value = windowsLiveAppId;
arParams[36] = new SQLiteParameter(":WindowsLiveKey", DbType.String);
arParams[36].Value = windowsLiveKey;
arParams[37] = new SQLiteParameter(":AllowOpenIDAuth", DbType.Int32);
arParams[37].Value = oidauth;
arParams[38] = new SQLiteParameter(":AllowWindowsLiveAuth", DbType.Int32);
arParams[38].Value = winliveauth;
arParams[39] = new SQLiteParameter(":GmapApiKey", DbType.String);
arParams[39].Value = gmapApiKey;
arParams[40] = new SQLiteParameter(":ApiKeyExtra1", DbType.String);
arParams[40].Value = apiKeyExtra1;
arParams[41] = new SQLiteParameter(":ApiKeyExtra2", DbType.String);
arParams[41].Value = apiKeyExtra2;
arParams[42] = new SQLiteParameter(":ApiKeyExtra3", DbType.String);
arParams[42].Value = apiKeyExtra3;
arParams[43] = new SQLiteParameter(":ApiKeyExtra4", DbType.String);
arParams[43].Value = apiKeyExtra4;
arParams[44] = new SQLiteParameter(":ApiKeyExtra5", DbType.String);
arParams[44].Value = apiKeyExtra5;
arParams[45] = new SQLiteParameter(":DisableDbAuth", DbType.Int32);
arParams[45].Value = intDisableDbAuth;
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 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);
}
private bool Update(
int siteID,
string keyName,
string keyValue)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_SiteSettingsEx ");
sqlCommand.Append("SET ");
sqlCommand.Append("KeyValue = :KeyValue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SiteID = :SiteID AND ");
sqlCommand.Append("KeyName = :KeyName ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[3];
arParams[0] = new SQLiteParameter(":SiteID", DbType.Int32);
arParams[0].Value = siteID;
arParams[1] = new SQLiteParameter(":KeyName", DbType.String);
arParams[1].Value = keyName;
arParams[2] = new SQLiteParameter(":KeyValue", DbType.Object);
arParams[2].Value = keyValue;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return (rowsAffected > -1);
}
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 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 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);
}
