public static string loadKeysFromFile()
        {
            FileStream pFSmInput = null;

            try
            {
                pFSmInput = new FileStream(SAFConfiguration.readParameter(SAFConfiguration.cSAFConfigurationKeyParsPath), FileMode.Open, FileAccess.Read);
                byte[] pBytData = new byte[pFSmInput.Length];
                pFSmInput.Read(pBytData, 0, (int)pFSmInput.Length);
                string pStrData = Encoding.ASCII.GetString(pBytData);
                pFSmInput.Close();
                return(pStrData);
            }
            catch
            {
                return(null);
            }
            finally
            {
                if (pFSmInput != null)
                {
                    pFSmInput.Close();
                }
            }
        }
 public static SecurityInfo getSecurityInfoFromWConfig()
 {
     return(new SecurityInfo(
                SAFConfiguration.readMasterKey(),
                SAFConfiguration.readInfoKey(),
                SAFConfiguration.readInfoIV()));
 }
        private static int _updateParameterBusiness(string userName, string parameterName, string parameterValue)
        {
            int rowsAffected = 0;

            try
            {
                string connStr = SAFConfiguration.readConnectionStringBusiness();

                using (IDbConnection connection = new SqlConnection(connStr))
                {
                    connection.Open();
                    using (IDbCommand command = connection.CreateCommand())
                    {
                        command.CommandType = CommandType.StoredProcedure;
                        command.CommandText = "SetConfigurationParameter";
                        command.Parameters.Add(new SqlParameter("@UserName", userName));
                        command.Parameters.Add(new SqlParameter("@ParameterName", parameterName));
                        command.Parameters.Add(new SqlParameter("@ParameterValue", parameterValue));
                        rowsAffected = (int)command.ExecuteScalar();
                    }
                }
            }
            catch (Exception ex)
            {
                LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::_updateParameterBusiness failed. Err:" + ex.Message, ex);
            }

            //Refresh parameters
            _CheckCache(0);

            return(rowsAffected);
        }
Пример #4
0
        /// <summary>
        /// StoreStackLog Logs to storage.
        /// Remember that it will be automatically called during Dispose (even if explicitly being called once) if suppressLog is false.
        /// </summary>
        /// <remarks>
        /// Remember that it will be automatically called during Dispose (even if explicitly being called once) if suppressLog is false.
        /// </remarks>
        /// <returns></returns>
        public virtual bool StoreStackLog()
        {
            if (disposed)
            {
                return(false);
            }
            if (stackData.suppressLog)
            {
                return(true);
            }

            try
            {
                short trnRes = stackData.StatsData.TrnRes;
                if (trnRes < 0)
                {
                    stackData.LogData.LevelName = "ERROR";
                }
                else
                {
                    stackData.LogData.LevelName = "INFO";
                }

                SAFDbLog dbLog = new SAFDbLog(SAFConfiguration.readConnectionStringBusiness());

                int idLog = dbLog.AppendLog(stackData.LogData);

                return(idLog != -1);
            }
            catch (Exception ex)
            {
                LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Utils.WSStacker::StoreStackLog. Err:" + ex.Message, ex);
            }
            return(false);
        }
        private static SAFConfigurationParametersMap GetAllParametersFromDB()
        {
            SAFConfigurationParametersMap cacheData = new SAFConfigurationParametersMap();

            try
            {
                string connStr = SAFConfiguration.readConnectionStringBusiness();

                using (IDbConnection connection = new SqlConnection(connStr))
                {
                    connection.Open();

                    using (IDbCommand command = connection.CreateCommand())
                    {
                        command.CommandType = CommandType.StoredProcedure;
                        command.CommandText = "GetAllConfiguration";

                        IDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
                        while (dr.Read())
                        {
                            SAFConfigurationParameter par = new SAFConfigurationParameter();
                            par.section       = dr.GetString(0);
                            par.name          = dr.GetString(1);
                            par.value         = dr.IsDBNull(2) ? null : dr.GetString(2);
                            par.lastUTCupdate = dr.GetDateTime(3);
                            par.frozen        = dr.GetBoolean(4);
                            par.hidden        = dr.GetBoolean(5);

                            string fullname = par.section + "@" + par.name;

                            cacheData.Add(fullname, par);
                        }
                    }
                }
                //All went fine
                return(cacheData);
            }
            catch (Exception ex)
            {
                LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::GetAllParameters failed. Err:" + ex.Message, ex);
                return(null);
            }
        }