/// <summary> /// Gets sql connection /// </summary> /// <param name="iLog">ILog object reference to be used for logging</param> /// <returns></returns> public static string _fx_GetConnectionString(LoggingFramework.ILog iLog) { string ConnectionString = string.Empty; try { IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile(Path.Combine(Directory.GetCurrentDirectory(), "appsettings.json")); var root = builder.Build(); var connString = root.GetConnectionString("WaliedCheetos-HERE_DB"); ConnectionString = EncryptDecrypt._fx_Decrypt( connString, EncryptDecrypt._enum_EncryptionDecryptionSecret.SECRET1, iLog, string.Empty); iLog.WriteDebug("Connection String: {0}", ConnectionString); } catch (Exception exception) { iLog.WriteError(exception.ToString()); } finally { } return(ConnectionString); }
public Startup(IConfiguration configuration) { Configuration = configuration; //create global logger. //string LogFilePath = ConfigurationManager.AppSettings["LogPath"] + "\\WebServiceAPILog.txt"; string LogFilePath = Path.Join(Configuration["LogPath"], "WebServiceAPILog.txt"); bool useBufferedLog = false; bool enableDebugLog = false; try { //useBufferedLog = Convert.ToBoolean(ConfigurationManager.AppSettings["UseBufferedLog"].ToString()); useBufferedLog = Convert.ToBoolean(Configuration["UseBufferedLog"].ToString()); } catch (Exception exception) { useBufferedLog = false; } try { //EnableLog = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableLog"].ToString()); enableDebugLog = Convert.ToBoolean(Configuration["EnableDebugLog"].ToString()); } catch (Exception exception) { enableDebugLog = false; } if (useBufferedLog) { _iLog = new LoggingFramework.BufferedFileLog(LogFilePath, true, enableDebugLog); } else { _iLog = new LoggingFramework.FileLog(LogFilePath, true, enableDebugLog); } _iLog.WriteTrace("Webservice API global logger created on Application Start."); }
//private static string _connectionString = //private static string _connectionString = ConnectionString(); /// <summary> /// Gets sql connection for any CRUD operation that could happen /// </summary> /// <param name="iLog">ILog object reference to be used for logging</param> /// <returns></returns> public static SqlConnection _fx_GetSqlConnection(LoggingFramework.ILog iLog, string UserTag) { SqlConnection sqlConnection = null; try { sqlConnection = new SqlConnection(_fx_GetConnectionString(iLog)); if (sqlConnection.State != System.Data.ConnectionState.Open) { sqlConnection.Open(); } iLog.WriteDebug("Database connection with connection String: {0} has been opened", sqlConnection.ConnectionString); } catch (Exception exception) { iLog.WriteError(exception.ToString()); } finally { } return(sqlConnection); }
public static string _fx_Decrypt(string EncryptedString, _enum_EncryptionDecryptionSecret EncryptionDecryptionSecret, LoggingFramework.ILog iLog, string UserTag) { string DecryptedString = string.Empty; try { iLog.WriteDebug("Decryption - Encrypted String {0}", EncryptedString); switch (EncryptionDecryptionSecret) { case _enum_EncryptionDecryptionSecret.SECRET1: case _enum_EncryptionDecryptionSecret.SECRET2: case _enum_EncryptionDecryptionSecret.SECRET3: default: DecryptedString = EncryptedString; break; } } catch (Exception exception) { iLog.WriteError(exception.ToString()); } finally { } return(DecryptedString); }
public static string _fx_GetToSpeedDataByLinkIds(BusinessEntities.Entities.HERE_TrafficAnalyticsRequests.ToSpeedDataByLinkIds toSpeedDataByLinkIds, LoggingFramework.ILog iLog, string Usertag) { string Result = string.Empty; try { Result = DataAccess.Operations.HERE_TrafficAnalytics._fx_GetToSpeedDataByLinkIds(toSpeedDataByLinkIds, iLog, Usertag); } catch (Exception exception) { iLog.WriteError(exception.ToString()); } finally { } return(Result); }
public static string _fx_GetCongestionFactorByLinkIds(BusinessEntities.Entities.HERE_TrafficAnalyticsRequests.CongestionFactorByLinkIds congestionFactorByLinkIds, LoggingFramework.ILog iLog, string Usertag) { string Result = string.Empty; try { using (SqlConnection sqlConnection = DataAccess.Admin.DataAccessManager._fx_GetSqlConnection(iLog, string.Empty)) { SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("_spt_GetCongestionFactorByLinkIds", sqlConnection); sqlDataAdapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@_param_LinkIds", congestionFactorByLinkIds.LinkIds); sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@_param_TimePattern", congestionFactorByLinkIds.TimePattern); sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@_param_Direction", congestionFactorByLinkIds.Direction); using (DataTable dataTable = new DataTable()) { sqlDataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { Result = Newtonsoft.Json.JsonConvert.SerializeObject(dataTable); } } } } catch (Exception exception) { Result = exception.ToString(); iLog.WriteError(exception.ToString()); } finally { } return(Result); }