public void ExceptionLogger(string stackTrace, DateTime encounteredDate, AppEnums.LoggerStatus status)
        {
            try
            {
                LoggerMessage _logMessage = new LoggerMessage();
                _logMessage.StackTrace = stackTrace;
                _logMessage.EncounteredDate = encounteredDate;
                _logMessage.Status = status;

                DBHelper.Instance.RunExceptionLogger(_logMessage);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// Inserts log to database for tracing purposes.
        /// </summary>
        /// <param name="logMsg"></param>
        public void RunExceptionLogger(LoggerMessage logMsg)
        {
            InitiateDBConnection();
            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = Constants.SP_INSERT_EXCEPTION_LOGGER;
                cmd.Parameters.Add("@StackTrace", logMsg.StackTrace);
                cmd.Parameters.Add("@EncounteredDate", logMsg.EncounteredDate);
                cmd.Parameters.Add("@Status", Convert.ToBoolean(logMsg.Status));

                cmd.ExecuteNonQuery();
            }
            catch (SqlException sqlEx)
            {
                throw sqlEx;
            }
            TerminateDBConnection();
        }