Example #1
0
 protected CommissionStatementBase(string endDate, string connectionString, TaskMetaDataDataModel metaData)
 {
     _endDate          = DateTime.ParseExact(endDate, "yyyyMMdd", null);
     _connectionString = connectionString;
     _metaData         = metaData;
     _rateInfo         = InitRateInfo();
     _rateInfo         = InitRateInfo();
     _regionalDirector = InitRegionalDirectors();
 }
Example #2
0
        public GenevaSmaStatementOld(string startDate, string endDate, string connectionString, TaskMetaDataDataModel metaData)
        {
            _startDate        = DateTime.ParseExact(startDate, "yyyyMMdd", null);
            _endDate          = DateTime.ParseExact(endDate, "yyyyMMdd", null);
            _connectionString = connectionString;
            _metaData         = metaData;

            NewAssetsItems = InitNewAssetsItems();
            AumItems       = InitAumItems();
        }
        public UmaMerrillStatement(string startDate, string endDate, string connectionString, TaskMetaDataDataModel metaData)
        {
            _startDate        = DateTime.ParseExact(startDate, "yyyyMMdd", null);
            _endDate          = DateTime.ParseExact(endDate, "yyyyMMdd", null);
            _connectionString = connectionString;
            _metaData         = metaData;

            _merrillData     = InitMerrillData();
            _newAssetsDetail = BuildNewAssetsDetail();
        }
Example #4
0
        public Etl_Broadridge(TaskMetaDataDataModel metaData, IConfigurationRoot configuration, string connectionString, string reportingDate)
        {
            _metaData         = metaData;
            _configuration    = configuration;
            _connectionString = connectionString;
            _reportingDate    = reportingDate;

            string fyle = string.Format(_metaData.inboundFile, _reportingDate);

            _path = $@"{_metaData.inboundFolder}\{fyle}";
        }
Example #5
0
        private static int Main(string[] args)
        {
            IConfigurationBuilder builder = new ConfigurationBuilder()
                                            .SetBasePath(Directory.GetCurrentDirectory())
                                            .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);

            _configuration    = builder.Build();
            _connectionString = _configuration["Database:ConnectionString"];

            try
            {
                //Load task metadata
                _dal = new DapperDatabaseAccess <TaskMetaDataDataModel>(_connectionString);
                var parms = new DynamicParameters();
                parms.Add("@ObjectCode", args[0]);
                _metaData = _dal.SqlServerFetch("dbo.prc_TaskMetaData_Fetch_By_ObjectCode", parms).FirstOrDefault();

                switch (_metaData.objectCode)
                {
                case "ETL.BROADRIDGE.SALES":
                    var broadridgeSales = new Etl_Broadridge(_metaData, _configuration, _connectionString, args[1]);
                    broadridgeSales.ProcessInboundSalesFile();
                    break;

                case "ETL.BROADRIDGE.ASSETS":
                    var broadridgeAssets = new Etl_Broadridge(_metaData, _configuration, _connectionString, args[1]);
                    broadridgeAssets.ProcessInboundAssetsFile();
                    break;

                case "ETL.GENEVA.SMA":
                    var genevaSales = new Etl_Geneva(_metaData, _configuration, _connectionString, args[1]);
                    genevaSales.ProcessInboundSalesFile();
                    break;

                case "ETL.GENEVA.AUM":
                    var genevaAum = new Etl_Geneva(_metaData, _configuration, _connectionString, args[1]);
                    genevaAum.ProcessInboundAumFile();
                    break;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }

            Console.WriteLine("Closing the application");
            Console.WriteLine("Hit enter...");
            Console.ReadLine();
            return((int)ExeRunStatus.Success);
        }
Example #6
0
        private static int Main(string[] args)
        {
            //Initialize system from appsettings.json
            IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");

            _configuration    = builder.Build();
            _connectionString = _configuration["Database:ConnectionString"];

            //Load task metadata
            _dal = new DapperDatabaseAccess <TaskMetaDataDataModel>(_connectionString);
            var parms = new DynamicParameters();

            parms.Add("@ObjectCode", args[0]);
            _metaData = _dal.SqlServerFetch("dbo.prc_TaskMetaData_Fetch_By_ObjectCode", parms).FirstOrDefault();

            switch (_metaData.objectCode)
            {
            case "COMM.GENEVA.SMA":
                var smaReport = new GenevaSmaStatement(args[1], args[2], _connectionString, _metaData);
                smaReport.ProduceReport();
                break;

            case "COMM.BROADRIDGE.UMA":
                var broadRidgeStatement = new BroadridgeStatement(args[1], args[2], _connectionString, _metaData, true);
                broadRidgeStatement.ProduceNonMerrillMorganReport();
                break;

            case "COMM.BROADRIDGE.MERRILL_MORGAN.UMA":
                var broadRidgeMerrillMorganStatement = new BroadridgeMerrillMorganStatement(args[1], _connectionString, _metaData);
                broadRidgeMerrillMorganStatement.ProduceReport();
                break;

            case "COMM.BROADRIDGE.MUTUALFUNDS":
//                    var broadRidgeMfStatement = new BroadridgeStatement(args[1], args[2], _connectionString, _metaData, false);
//                    broadRidgeMfStatement.ProduceReport();
                break;
            }

            return(0);
        }
 public BroadridgeMerrillMorganStatement(string endDate, string connectionString, TaskMetaDataDataModel metaData) : base(endDate, connectionString, metaData)
 {
     InitializeNewAssetsData(endDate);
 }
 public GenevaSmaStatement(string startDate, string endDate, string connectionString, TaskMetaDataDataModel metaData) : base(startDate, endDate, connectionString, metaData)
 {
     _genevaSales = InitNewAssetsItems();
     _genevaFlows = InitNewAssetsFlows();
     _aumItems    = InitAumItems();
 }
 public BroadridgeStatement(string startDate, string endDate, string connectionString, TaskMetaDataDataModel metaData, bool isUma) : base(startDate, endDate, connectionString, metaData)
 {
     _isUma = isUma;
     InitializeSalesData(endDate);
     InitializeAssetsData(endDate);
 }