protected IEnumerable <RegionalDirectorRateInfoRevisedDataModel> LoadRegionalDirectorRateInfoRevised()
{
var dal = new DapperDatabaseAccess <RegionalDirectorRateInfoRevisedDataModel>(_connectionString);
var result = dal.SqlServerFetch("dbo.prc_RegionalDirector_RateInfo_Revised_Fetch_All", null);
return(result);
}
protected IEnumerable <AristotleExcelStyle> ExcelColumnProperties(string reportName)
{
var dal = new DapperDatabaseAccess <AristotleExcelStyle>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportName", reportName);
return(dal.SqlServerFetch("dbo.prc_ColumnStyles_Fetch", parms));
}
protected void InitializeNewAssetsData(string endDate)
{
var dal = new DapperDatabaseAccess <BroadridgeAssets>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportingDate", endDate);
_broadridgeNewAssets = dal.SqlServerFetch("dbo.prc_BroadridgeAssets_MorganMerrill_Fetch", parms);
}
private IEnumerable <GenevaFlows> InitNewAssetsFlows()
{
var dal = new DapperDatabaseAccess <GenevaFlows>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportEndDate", _endDate, DbType.Date, ParameterDirection.Input);
return(dal.SqlServerFetch("dbo.prc_GenevaFlows", parms));
}
protected void InitializeAumData(string endDate)
{
var dal = new DapperDatabaseAccess <GenevaSmaAumDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportingDate", endDate);
_aumItems = dal.SqlServerFetch("dbo.prc_GenevaAum", parms);
}
protected void InitializeSalesData(string endDate)
{
var dal = new DapperDatabaseAccess <GenevaSmaAssetsDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportingDate", endDate);
_genevaSales = dal.SqlServerFetch("dbo.prc_GenevaSmaAssets_DetailRows", parms).Distinct();
}
private RegionalDirectorRateInfoDataModel RegionalDirectorRateInfo(string rd, int rateType, int commissionType)
{
var dal = new DapperDatabaseAccess <RegionalDirectorRateInfoDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@RegionalDirectorKey", rd);
parms.Add("@RateTypeIid", rateType);
parms.Add("@CommissionTypeIid", commissionType);
return(dal.SqlServerFetch("dbo.prc_RegionalDirector_RateInfo_Fetch", parms).FirstOrDefault());
}
private IEnumerable <UmaMerrillDataModel> InitMerrillData()
{
var dal = new DapperDatabaseAccess <UmaMerrillDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@StartDate", _startDate, DbType.Date, ParameterDirection.Input);
parms.Add("@EndDate", _endDate, DbType.Date, ParameterDirection.Input);
return(dal.SqlServerFetch("dbo.prc_Uma_Merrill_Data_Fetch", parms));
}
private IEnumerable <GenevaSmaAssetsDataModel> InitNewAssetsItems()
{
var dal = new DapperDatabaseAccess <GenevaSmaAssetsDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@StartDate", _startDate, DbType.Date, ParameterDirection.Input);
parms.Add("@EndDate", _endDate, DbType.Date, ParameterDirection.Input);
return(dal.SqlServerFetch("dbo.prc_GenevaSmaAssets_DetailRows", parms).Distinct());
}
private IEnumerable <GenevaSmaFlowsDataModel> BuildFlowsDetail()
{
var dal = new DapperDatabaseAccess <GenevaSmaFlowsDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@StartDate", _startDate, DbType.Date, ParameterDirection.Input);
parms.Add("@EndDate", _endDate, DbType.Date, ParameterDirection.Input);
return(dal.SqlServerFetch("dbo.prc_GenevaSma_Ongoing_Flows", parms));
}
protected void InitializeSalesData(string endDate)
{
var dal = new DapperDatabaseAccess <BroadridgeSales>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@ReportingDate", endDate);
parms.Add("@IsUma", _isUma);
_broadridgeSales = dal.SqlServerFetch("dbo.prc_BroadridgeSales_Fetch", parms);
}
protected RegionalDirectorRateInfoDataModel RegionalDirectorRateInfo(string rd, int rateType, int commissionType)
{
var dal = new DapperDatabaseAccess <RegionalDirectorRateInfoDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@RegionalDirectorKey", rd);
parms.Add("@RateTypeIid", rateType);
parms.Add("@CommissionTypeIid", commissionType);
var result = dal.SqlServerFetch("dbo.prc_RegionalDirector_RateInfo_Revised_Fetch_All", null).FirstOrDefault() ?? new RegionalDirectorRateInfoDataModel();
return(result);
}
protected IEnumerable <RegionalDirectorRateInfoRevisedDataModel> InitRateInfo()
{
try
{
var dal = new DapperDatabaseAccess <RegionalDirectorRateInfoRevisedDataModel>(_connectionString);
return(dal.SqlServerFetch("dbo.prc_RegionalDirector_RateInfo_Revised_Fetch_All", null));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
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 IEnumerable <GenevaSmaAumDataModel> InitAumItems()
{
try
{
var dal = new DapperDatabaseAccess <GenevaSmaAumDataModel>(_connectionString);
var parms = new DynamicParameters();
parms.Add("@EndDate", _endDate, DbType.Date, ParameterDirection.Input);
return(dal.SqlServerFetch("dbo.prc_GenevaAum_DetailRows", parms));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
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);
}
