protected CommissionStatementBase(string endDate, string connectionString, TaskMetaDataDataModel metaData) { _endDate = DateTime.ParseExact(endDate, "yyyyMMdd", null); _connectionString = connectionString; _metaData = metaData; _rateInfo = InitRateInfo(); _rateInfo = InitRateInfo(); _regionalDirector = InitRegionalDirectors(); }
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(); }
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}"; }
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); }
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); }