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(";");
FbParameter[] arParams = new FbParameter[2];
arParams[0] = new FbParameter("@SiteID", FbDbType.Integer);
arParams[0].Value = siteID;
arParams[1] = new FbParameter("@KeyName", FbDbType.VarChar, 128);
arParams[1].Value = keyName;
return(Convert.ToInt32(AdoHelper.ExecuteScalar(
readConnectionString,
sqlCommand.ToString(),
arParams)));
}
/// <summary>
/// Gets a count of rows in the mp_UserLocation table.
/// </summary>
/// <param name="userGuid"> userGuid </param>
public int GetCountByUser(Guid userGuid)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT Count(*) ");
sqlCommand.Append("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();
return(Convert.ToInt32(AdoHelper.ExecuteScalar(
readConnectionString,
sqlCommand.ToString(),
arParams)));
}
/// <summary>
/// Inserts a row in the mp_SystemLog table. Returns new integer id.
/// </summary>
/// <param name="logDate"> logDate </param>
/// <param name="ipAddress"> ipAddress </param>
/// <param name="culture"> culture </param>
/// <param name="url"> url </param>
/// <param name="shortUrl"> shortUrl </param>
/// <param name="thread"> thread </param>
/// <param name="logLevel"> logLevel </param>
/// <param name="logger"> logger </param>
/// <param name="message"> message </param>
/// <returns>int</returns>
public int Create(
DateTime logDate,
string ipAddress,
string culture,
string url,
string shortUrl,
string thread,
string logLevel,
string logger,
string message)
{
FbParameter[] arParams = new FbParameter[9];
arParams[0] = new FbParameter(":LogDate", FbDbType.TimeStamp);
arParams[0].Value = logDate;
arParams[1] = new FbParameter(":IpAddress", FbDbType.VarChar, 50);
arParams[1].Value = ipAddress;
arParams[2] = new FbParameter(":Culture", FbDbType.VarChar, 10);
arParams[2].Value = culture;
arParams[3] = new FbParameter(":Url", FbDbType.VarChar);
arParams[3].Value = url;
arParams[4] = new FbParameter(":ShortUrl", FbDbType.VarChar, 255);
arParams[4].Value = shortUrl;
arParams[5] = new FbParameter(":Thread", FbDbType.VarChar, 255);
arParams[5].Value = thread;
arParams[6] = new FbParameter(":LogLevel", FbDbType.VarChar, 20);
arParams[6].Value = logLevel;
arParams[7] = new FbParameter(":Logger", FbDbType.VarChar, 255);
arParams[7].Value = logger;
arParams[8] = new FbParameter(":Message", FbDbType.VarChar);
arParams[8].Value = message;
int newID = Convert.ToInt32(AdoHelper.ExecuteScalar(
writeConnectionString,
CommandType.StoredProcedure,
"EXECUTE PROCEDURE MP_SYSTEMLOG_INSERT ("
+ AdoHelper.GetParamString(arParams.Length) + ")",
true,
arParams));
return(newID);
}
public int GetCountOfSiteRoles(int siteId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT COUNT(*) ");
sqlCommand.Append("FROM mp_Roles ");
sqlCommand.Append("WHERE SiteID = @SiteID ");
sqlCommand.Append(";");
FbParameter[] arParams = new FbParameter[1];
arParams[0] = new FbParameter("@SiteID", FbDbType.Integer);
arParams[0].Value = siteId;
return(Convert.ToInt32(AdoHelper.ExecuteScalar(
readConnectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams)));
}
public string GetInfoByErrorCode(int errorCode)
{
string info = "";
try
{
FDBFileCheck();
#if true
int langId = Thread.CurrentThread.CurrentUICulture.LCID;
FbParameter[] fbParams = new FbParameter[4];
fbParams[0] = new FbParameter("@ERR_CODE", FbDbType.Integer);
fbParams[0].Value = errorCode;
fbParams[1] = new FbParameter("@VENDER_ID", FbDbType.Integer);
fbParams[1].Value = 0;
fbParams[2] = new FbParameter("@PID", FbDbType.Integer);
fbParams[2].Value = 0;
fbParams[3] = new FbParameter("@LANG_ID", FbDbType.Integer);
fbParams[3].Value = langId;
var ret = firebird.ExecuteScalar(System.Data.CommandType.StoredProcedure, "GET_INFO_BY_CODE", fbParams);
info = Convert.ToString(ret);
#else
string sql = "SELECT * FROM ERROR_INFO WHERE 1=1";
{
//int errCode;
//if (int.TryParse(errorCode, System.Globalization.NumberStyles.HexNumber, null, out errCode))
{
sql += " AND ERROR_CODE=" + errorCode;
}
}
DataTable tbErrorInfo = firebird.ExecuteDataTable(sql);
info = tbErrorInfo.ToString();
#endif
}
catch (Exception ex)
{
info = "";
}
return(info);
}