public bool UpdateRelatedSitesProperty(
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 ");
sqlCommand.Append("AND KeyName = @KeyName ");
sqlCommand.Append(";");
FbParameter[] arParams = new FbParameter[3];
arParams[0] = new FbParameter("@SiteID", FbDbType.Integer);
arParams[0].Value = siteId;
arParams[1] = new FbParameter("@KeyName", FbDbType.VarChar, 128);
arParams[1].Value = keyName;
arParams[2] = new FbParameter("@KeyValue", FbDbType.VarChar);
arParams[2].Value = keyValue;
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
CommandType.Text,
sqlCommand.ToString(),
true,
arParams);
return(rowsAffected > -1);
}
public bool RunScript(
string script,
string overrideConnectionInfo)
{
if ((script == null) || (script.Length == 0))
{
return(true);
}
bool result = false;
FbConnection connection;
if (
(overrideConnectionInfo != null) &&
(overrideConnectionInfo.Length > 0)
)
{
connection = new FbConnection(overrideConnectionInfo);
}
else
{
connection = new FbConnection(writeConnectionString);
}
connection.Open();
FbTransaction transaction = connection.BeginTransaction();
try
{
AdoHelper.ExecuteNonQuery(transaction, CommandType.Text, script, null);
transaction.Commit();
result = true;
}
catch (FbException ex)
{
transaction.Rollback();
log.LogError("Db.RunScript failed", ex);
throw;
}
finally
{
connection.Close();
}
return(result);
}
/// <summary>
/// Inserts a row in the mp_UserLocation table. Returns rows affected count.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="iPAddress"> iPAddress </param>
/// <param name="iPAddressLong"> iPAddressLong </param>
/// <param name="hostname"> hostname </param>
/// <param name="longitude"> longitude </param>
/// <param name="latitude"> latitude </param>
/// <param name="iSP"> iSP </param>
/// <param name="continent"> continent </param>
/// <param name="country"> country </param>
/// <param name="region"> region </param>
/// <param name="city"> city </param>
/// <param name="timeZone"> timeZone </param>
/// <param name="captureCount"> captureCount </param>
/// <param name="firstCaptureUTC"> firstCaptureUTC </param>
/// <param name="lastCaptureUTC"> lastCaptureUTC </param>
/// <returns>int</returns>
public int Create(
Guid rowID,
Guid userGuid,
Guid siteGuid,
string iPAddress,
long iPAddressLong,
string hostname,
double longitude,
double latitude,
string iSP,
string continent,
string country,
string region,
string city,
string timeZone,
int captureCount,
DateTime firstCaptureUTC,
DateTime lastCaptureUTC)
{
#region Bit Conversion
#endregion
FbParameter[] arParams = new FbParameter[17];
arParams[0] = new FbParameter("@RowID", FbDbType.Char, 36);
arParams[0].Value = rowID.ToString();
arParams[1] = new FbParameter("@UserGuid", FbDbType.Char, 36);
arParams[1].Value = userGuid.ToString();
arParams[2] = new FbParameter("@SiteGuid", FbDbType.Char, 36);
arParams[2].Value = siteGuid.ToString();
arParams[3] = new FbParameter("@IPAddress", FbDbType.VarChar, 50);
arParams[3].Value = iPAddress;
arParams[4] = new FbParameter("@IPAddressLong", FbDbType.BigInt);
arParams[4].Value = iPAddressLong;
arParams[5] = new FbParameter("@Hostname", FbDbType.VarChar, 255);
arParams[5].Value = hostname;
arParams[6] = new FbParameter("@Longitude", FbDbType.Float);
arParams[6].Value = longitude;
arParams[7] = new FbParameter("@Latitude", FbDbType.Float);
arParams[7].Value = latitude;
arParams[8] = new FbParameter("@ISP", FbDbType.VarChar, 255);
arParams[8].Value = iSP;
arParams[9] = new FbParameter("@Continent", FbDbType.VarChar, 255);
arParams[9].Value = continent;
arParams[10] = new FbParameter("@Country", FbDbType.VarChar, 255);
arParams[10].Value = country;
arParams[11] = new FbParameter("@Region", FbDbType.VarChar, 255);
arParams[11].Value = region;
arParams[12] = new FbParameter("@City", FbDbType.VarChar, 255);
arParams[12].Value = city;
arParams[13] = new FbParameter("@TimeZone", FbDbType.VarChar, 255);
arParams[13].Value = timeZone;
arParams[14] = new FbParameter("@CaptureCount", FbDbType.Integer);
arParams[14].Value = captureCount;
arParams[15] = new FbParameter("@FirstCaptureUTC", FbDbType.TimeStamp);
arParams[15].Value = firstCaptureUTC;
arParams[16] = new FbParameter("@LastCaptureUTC", FbDbType.TimeStamp);
arParams[16].Value = lastCaptureUTC;
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_UserLocation (");
sqlCommand.Append("RowID, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("IPAddress, ");
sqlCommand.Append("IPAddressLong, ");
sqlCommand.Append("Hostname, ");
sqlCommand.Append("Longitude, ");
sqlCommand.Append("Latitude, ");
sqlCommand.Append("ISP, ");
sqlCommand.Append("Continent, ");
sqlCommand.Append("Country, ");
sqlCommand.Append("Region, ");
sqlCommand.Append("City, ");
sqlCommand.Append("TimeZone, ");
sqlCommand.Append("CaptureCount, ");
sqlCommand.Append("FirstCaptureUTC, ");
sqlCommand.Append("LastCaptureUTC )");
sqlCommand.Append(" VALUES (");
sqlCommand.Append("@RowID, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@IPAddress, ");
sqlCommand.Append("@IPAddressLong, ");
sqlCommand.Append("@Hostname, ");
sqlCommand.Append("@Longitude, ");
sqlCommand.Append("@Latitude, ");
sqlCommand.Append("@ISP, ");
sqlCommand.Append("@Continent, ");
sqlCommand.Append("@Country, ");
sqlCommand.Append("@Region, ");
sqlCommand.Append("@City, ");
sqlCommand.Append("@TimeZone, ");
sqlCommand.Append("@CaptureCount, ");
sqlCommand.Append("@FirstCaptureUTC, ");
sqlCommand.Append("@LastCaptureUTC )");
sqlCommand.Append(";");
int rowsAffected = AdoHelper.ExecuteNonQuery(
writeConnectionString,
CommandType.Text,
sqlCommand.ToString(),
true,
arParams);
return(rowsAffected);
}