/// <summary>
/// Deletes a row from the mp_UserLocation table. Returns true if row deleted.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <returns>bool</returns>
public bool Delete(Guid rowID)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLocation ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowID = :RowID ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[1];
arParams[0] = new SQLiteParameter(":RowID", DbType.String);
arParams[0].Value = rowID.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the mp_GeoZone table. Returns true if row deleted.
/// </summary>
/// <param name="guid"> guid </param>
/// <returns>bool</returns>
public bool Delete(Guid guid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_GeoZone ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = :Guid ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[1];
arParams[0] = new SQLiteParameter(":Guid", DbType.String);
arParams[0].Value = guid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool DeleteByUser(Guid userGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLocation ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("UserGuid = :UserGuid ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":UserGuid", DbType.String);
arParams[0].Value = userGuid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool DeleteByType(string taskType)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_TaskQueue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SerializedTaskType LIKE ?TaskType ");
sqlCommand.Append(";");
MySqlParameter[] arParams = new MySqlParameter[1];
arParams[0] = new MySqlParameter("?TaskType", MySqlDbType.VarChar, 266);
arParams[0].Value = taskType + "%";
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool DeleteBySite(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserClaims ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SiteId = :SiteId ");
sqlCommand.Append(";");
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);
}
/// <summary>
/// Deletes rows from the mp_SystemLog table. Returns true if rows deleted.
/// </summary>
/// <param name="id"> id </param>
/// <returns>bool</returns>
public bool DeleteByLevel(string logLevel)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SystemLog ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("LogLevel = :LogLevel ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":LogLevel", DbType.String);
arParams[0].Value = logLevel;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
/// <summary>
/// Deletes rows from the mp_SystemLog table. Returns true if rows deleted.
/// </summary>
/// <param name="id"> id </param>
/// <returns>bool</returns>
public bool DeleteOlderThan(DateTime cutoffDate)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SystemLog ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("LogDate < :CutoffDate ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":CutoffDate", DbType.DateTime);
arParams[0].Value = cutoffDate;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the mp_SystemLog table. Returns true if row deleted.
/// </summary>
/// <param name="id"> id </param>
/// <returns>bool</returns>
public bool Delete(int id)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SystemLog ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("ID = :ID ");
sqlCommand.Append(";");
SqliteParameter[] arParams = new SqliteParameter[1];
arParams[0] = new SqliteParameter(":ID", DbType.Int32);
arParams[0].Value = id;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool DeleteByUser(Guid userGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLocation ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("UserGuid = @UserGuid ");
sqlCommand.Append(";");
FbParameter[] arParams = new FbParameter[1];
arParams[0] = new FbParameter("@UserGuid", FbDbType.Char, 36);
arParams[0].Value = userGuid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Deletes a row from the mp_RedirectList table. Returns true if row deleted.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <returns>bool</returns>
public bool Delete(Guid rowGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_RedirectList ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowGuid = ?RowGuid ");
sqlCommand.Append(";");
MySqlParameter[] arParams = new MySqlParameter[1];
arParams[0] = new MySqlParameter("?RowGuid", MySqlDbType.VarChar, 36);
arParams[0].Value = rowGuid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
/// <summary>
/// Updates a row in the mp_BannedIPAddresses table. Returns true if row updated.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="bannedIP"> bannedIP </param>
/// <param name="bannedUTC"> bannedUTC </param>
/// <param name="bannedReason"> bannedReason </param>
/// <returns>bool</returns>
public bool Update(
int rowId,
string bannedIP,
DateTime bannedUtc,
string bannedReason)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_BannedIPAddresses ");
sqlCommand.Append("SET ");
sqlCommand.Append("BannedIP = @BannedIP, ");
sqlCommand.Append("BannedUTC = @BannedUTC, ");
sqlCommand.Append("BannedReason = @BannedReason ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowID = @RowID ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@RowID", SqlDbType.Int);
arParams[0].Value = rowId;
arParams[1] = new SqlCeParameter("@BannedIP", SqlDbType.NVarChar, 50);
arParams[1].Value = bannedIP;
arParams[2] = new SqlCeParameter("@BannedUTC", SqlDbType.DateTime);
arParams[2].Value = bannedUtc;
arParams[3] = new SqlCeParameter("@BannedReason", SqlDbType.NVarChar, 255);
arParams[3].Value = bannedReason;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_GeoCountry table. Returns true if row updated.
/// </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 Update(
Guid guid,
string name,
string iSOCode2,
string iSOCode3)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_GeoCountry ");
sqlCommand.Append("SET ");
sqlCommand.Append("Name = @Name, ");
sqlCommand.Append("ISOCode2 = @ISOCode2, ");
sqlCommand.Append("ISOCode3 = @ISOCode3 ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = @Guid ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@Name", SqlDbType.NVarChar, 255);
arParams[1].Value = name;
arParams[2] = new SqlCeParameter("@ISOCode2", SqlDbType.NChar, 2);
arParams[2].Value = iSOCode2;
arParams[3] = new SqlCeParameter("@ISOCode3", SqlDbType.NChar, 3);
arParams[3].Value = iSOCode3;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_RedirectList table. Returns true if row updated.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <param name="oldUrl"> oldUrl </param>
/// <param name="newUrl"> newUrl </param>
/// <param name="expireUtc"> expireUtc </param>
/// <returns>bool</returns>
public bool Update(
Guid rowGuid,
string oldUrl,
string newUrl,
DateTime expireUtc)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_RedirectList ");
sqlCommand.Append("SET ");
sqlCommand.Append("OldUrl = ?OldUrl, ");
sqlCommand.Append("NewUrl = ?NewUrl, ");
sqlCommand.Append("ExpireUtc = ?ExpireUtc ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowGuid = ?RowGuid ");
sqlCommand.Append(";");
MySqlParameter[] arParams = new MySqlParameter[4];
arParams[0] = new MySqlParameter("?RowGuid", MySqlDbType.VarChar, 36);
arParams[0].Value = rowGuid.ToString();
arParams[1] = new MySqlParameter("?OldUrl", MySqlDbType.VarChar, 255);
arParams[1].Value = oldUrl;
arParams[2] = new MySqlParameter("?NewUrl", MySqlDbType.VarChar, 255);
arParams[2].Value = newUrl;
arParams[3] = new MySqlParameter("?ExpireUtc", MySqlDbType.DateTime);
arParams[3].Value = expireUtc;
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public bool Update(
int id,
string userId,
string claimType,
string claimValue)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_UserClaims ");
sqlCommand.Append("SET ");
sqlCommand.Append("UserId = @UserId, ");
sqlCommand.Append("ClaimType = @ClaimType, ");
sqlCommand.Append("ClaimValue = @ClaimValue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Id = @Id ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@Id", SqlDbType.Int);
arParams[0].Value = id;
arParams[1] = new SqlCeParameter("@UserId", SqlDbType.NVarChar, 128);
arParams[1].Value = userId;
arParams[2] = new SqlCeParameter("@ClaimType", SqlDbType.NVarChar);
arParams[2].Value = claimType;
arParams[3] = new SqlCeParameter("@ClaimValue", SqlDbType.NVarChar);
arParams[3].Value = claimValue;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_RedirectList table. Returns true if row updated.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <param name="oldUrl"> oldUrl </param>
/// <param name="newUrl"> newUrl </param>
/// <param name="expireUtc"> expireUtc </param>
/// <returns>bool</returns>
public bool Update(
Guid rowGuid,
string oldUrl,
string newUrl,
DateTime expireUtc)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_RedirectList ");
sqlCommand.Append("SET ");
sqlCommand.Append("OldUrl = :OldUrl, ");
sqlCommand.Append("NewUrl = :NewUrl, ");
sqlCommand.Append("ExpireUtc = :ExpireUtc ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowGuid = :RowGuid ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[4];
arParams[0] = new SQLiteParameter(":RowGuid", DbType.String);
arParams[0].Value = rowGuid.ToString();
arParams[1] = new SQLiteParameter(":OldUrl", DbType.String);
arParams[1].Value = oldUrl;
arParams[2] = new SQLiteParameter(":NewUrl", DbType.String);
arParams[2].Value = newUrl;
arParams[3] = new SQLiteParameter(":ExpireUtc", DbType.DateTime);
arParams[3].Value = expireUtc;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_Language table. Returns true if row updated.
/// </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 Update(
Guid guid,
string name,
string code,
int sort)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Language ");
sqlCommand.Append("SET ");
sqlCommand.Append("Name = @Name, ");
sqlCommand.Append("Code = @Code, ");
sqlCommand.Append("Sort = @Sort ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = @Guid ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@Name", SqlDbType.NVarChar, 255);
arParams[1].Value = name;
arParams[2] = new SqlCeParameter("@Code", SqlDbType.NChar, 2);
arParams[2].Value = code;
arParams[3] = new SqlCeParameter("@Sort", SqlDbType.Int);
arParams[3].Value = sort;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Deletes a row from the mp_UserLocation table. Returns true if row deleted.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <returns>bool</returns>
public bool Delete(Guid rowID)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLocation ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowID = @RowID ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[1];
arParams[0] = new SqlCeParameter("@RowID", SqlDbType.UniqueIdentifier);
arParams[0].Value = rowID;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public bool Delete(int id)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserClaims ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Id = @Id ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[1];
arParams[0] = new SqlCeParameter("@Id", SqlDbType.Int);
arParams[0].Value = id;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public bool Delete(
int siteId,
string loginProvider,
string providerKey,
string userId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLogins ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("((@SiteId = -1) OR (SiteId = @SiteId)) ");
sqlCommand.Append(" AND ");
sqlCommand.Append("LoginProvider = @LoginProvider AND ");
sqlCommand.Append("ProviderKey = @ProviderKey AND ");
sqlCommand.Append("UserId = @UserId ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@LoginProvider", SqlDbType.NVarChar, 128);
arParams[0].Value = loginProvider;
arParams[1] = new SqlCeParameter("@ProviderKey", SqlDbType.NVarChar, 128);
arParams[1].Value = providerKey;
arParams[2] = new SqlCeParameter("@UserId", SqlDbType.NVarChar, 128);
arParams[2].Value = userId;
arParams[3] = new SqlCeParameter("@SiteId", SqlDbType.Int);
arParams[3].Value = siteId;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_GeoCountry table. Returns true if row updated.
/// </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 Update(
Guid guid,
string name,
string iSOCode2,
string iSOCode3)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_GeoCountry ");
sqlCommand.Append("SET ");
sqlCommand.Append("Name = :Name, ");
sqlCommand.Append("ISOCode2 = :ISOCode2, ");
sqlCommand.Append("ISOCode3 = :ISOCode3 ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = :Guid ");
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 > -1);
}
/// <summary>
/// Deletes a row from the mp_RedirectList table. Returns true if row deleted.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <returns>bool</returns>
public bool Delete(Guid rowGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_redirectlist ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("rowguid = :rowguid ");
sqlCommand.Append(";");
NpgsqlParameter[] arParams = new NpgsqlParameter[1];
arParams[0] = new NpgsqlParameter("rowguid", NpgsqlTypes.NpgsqlDbType.Char, 36);
arParams[0].Value = rowGuid.ToString();
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Deletes a row from the mp_BannedIPAddresses table. Returns true if row deleted.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <returns>bool</returns>
public bool Delete(int rowId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_BannedIPAddresses ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowID = @RowID ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[1];
arParams[0] = new SqlCeParameter("@RowID", SqlDbType.Int);
arParams[0].Value = rowId;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public bool DeleteByType(string taskType)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_TaskQueue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("SerializedTaskType LIKE @TaskType + '%' ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[1];
arParams[0] = new SqlCeParameter("@TaskType", SqlDbType.NVarChar, 255);
arParams[0].Value = taskType;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_Language table. Returns true if row updated.
/// </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 Update(
Guid guid,
string name,
string code,
int sort)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Language ");
sqlCommand.Append("SET ");
sqlCommand.Append("Name = :Name, ");
sqlCommand.Append("Code = :Code, ");
sqlCommand.Append("Sort = :Sort ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = :Guid ");
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 > -1);
}
/// <summary>
/// Deletes a row from the mp_GeoCountry table. Returns true if row deleted.
/// </summary>
/// <param name="guid"> guid </param>
/// <returns>bool</returns>
public bool Delete(Guid guid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_GeoCountry ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = @Guid ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[1];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public bool DeleteByType(string taskType)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_taskqueue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("serializedtasktype LIKE :tasktype ");
sqlCommand.Append(";");
NpgsqlParameter[] arParams = new NpgsqlParameter[1];
arParams[0] = new NpgsqlParameter("tasktype", NpgsqlTypes.NpgsqlDbType.Varchar, 255);
arParams[0].Value = taskType + "%";
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the mp_BannedIPAddresses table. Returns true if row updated.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="bannedIP"> bannedIP </param>
/// <param name="bannedUTC"> bannedUTC </param>
/// <param name="bannedReason"> bannedReason </param>
/// <returns>bool</returns>
public bool Update(
int rowId,
string bannedIP,
DateTime bannedUtc,
string bannedReason)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_BannedIPAddresses ");
sqlCommand.Append("SET ");
sqlCommand.Append("BannedIP = :BannedIP, ");
sqlCommand.Append("BannedUTC = :BannedUTC, ");
sqlCommand.Append("BannedReason = :BannedReason ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RowID = :RowID ;");
SQLiteParameter[] arParams = new SQLiteParameter[4];
arParams[0] = new SQLiteParameter(":RowID", DbType.Int32);
arParams[0].Value = rowId;
arParams[1] = new SQLiteParameter(":BannedIP", DbType.String);
arParams[1].Value = bannedIP;
arParams[2] = new SQLiteParameter(":BannedUTC", DbType.DateTime);
arParams[2].Value = bannedUtc;
arParams[3] = new SQLiteParameter(":BannedReason", DbType.String);
arParams[3].Value = bannedReason;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public int ExcuteSQL(string strSQL, ParamMap param)
{
object val = 0;
IDbTransaction transaction = null;
IDbConnection connection = null;
try
{
//获取数据库连接，如果开启了事务，从事务中获取
connection = GetConnection();
transaction = GetTransaction();
IDbDataParameter[] parms = param.toDbParameters();
if (AdoHelper.DbType == DatabaseType.ACCESS)
{
strSQL = SQLBuilderHelper.builderAccessSQL(strSQL, parms);
val = AdoHelper.ExecuteNonQuery(connection, transaction, CommandType.Text, strSQL);
}
else
{
val = AdoHelper.ExecuteNonQuery(connection, transaction, CommandType.Text, strSQL, parms);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (m_Transaction == null)
{
connection.Close();
}
}
return(Convert.ToInt32(val));
}
public bool Delete(
int siteId,
string loginProvider,
string providerKey,
string userId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_UserLogins ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("((:SiteId = -1) OR (SiteId = :SiteId)) ");
sqlCommand.Append(" AND ");
sqlCommand.Append("LoginProvider = :LoginProvider AND ");
sqlCommand.Append("ProviderKey = :ProviderKey AND ");
sqlCommand.Append("UserId = :UserId ");
sqlCommand.Append(";");
SQLiteParameter[] arParams = new SQLiteParameter[4];
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;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool Update(int roleId, string roleName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Roles ");
sqlCommand.Append("SET DisplayName = :RoleName ");
sqlCommand.Append("WHERE RoleID = :RoleID ;");
SQLiteParameter[] arParams = new SQLiteParameter[2];
arParams[0] = new SQLiteParameter(":RoleID", DbType.Int32);
arParams[0].Value = roleId;
arParams[1] = new SQLiteParameter(":RoleName", DbType.String);
arParams[1].Value = roleName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
