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); }