public static int CreatePortfolioTransactionSummary(int portfolioId)
{
using (var scope = ApplicationContext.Container.BeginLifetimeScope())
{
using (var context = scope.Resolve <DbContext>())
{
var entity = new PortfolioTransactionsSummary()
{
PortfolioId = portfolioId,
CloseAmount = 10,
OpenAmount = 11,
CloseDate = DateTime.Now,
OpenDate = DateTime.Now.AddDays(-21),
};
context.Add(entity);
context.SaveChanges();
return(entity.Id);
}
}
}
protected override void When()
{
using (var scope = ApplicationContext.Container.BeginLifetimeScope(ScopeKey))
{
_saveResponse = scope.ResolveKeyed <IExecutionPipelineHandlers>("ImportProfile")
.Execute <CreateImportXlsDto, ImportXlsPipelineResponse>(_dto);
_portfolio = scope.Resolve <IRepository>()
.GetOne <Portfolio>(a => a.Id == _saveResponse.Result.PortfolioId);
_portfolioTransactionsSummary = scope.Resolve <IRepository>()
.GetOne <PortfolioTransactionsSummary>(a =>
a.Id == _saveResponse.Result.PortfolioTransactionsSummaryId);
var x = scope.Resolve <IRepository>()
.GetAll <PortfolioTransactionsConsolidation>();
_portfolioTransactionsConsolidation = scope.Resolve <IRepository>()
.Get <PortfolioTransactionsConsolidation>(a =>
a.PortfolioTransactionsSummaryId == _saveResponse.Result.PortfolioTransactionsSummaryId);
}
}
internal static void InitializeDataBase()
{
using (var scope = ApplicationContext.Container.BeginLifetimeScope("ExecutionPipeline"))
{
using (var context = scope.Resolve <DbContext>())
{
//context.Database.EnsureDeleted();
if ((context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
{
return;
}
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
//context.Database.Migrate();
var organization = new EntityOrganization()
{
Name = "Default", CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now
};
var adminRole = new AuthorizationRole()
{
Id = 1, Name = "Administrator", EntityOrganization = organization
};
var agentRole = new AuthorizationRole()
{
Id = 2, Name = "Agent", EntityOrganization = organization
};
var advisoryRole = new AuthorizationRole()
{
Id = 3, Name = "Advisor", EntityOrganization = organization
};
var workflowRole = new AuthorizationRole()
{
Id = 4, Name = "Workflow", EntityOrganization = organization
};
var applicationUser = new ApplicationUser()
{
Name = "Default", Email = "*****@*****.**",
Password = "******",
CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now
};
var workflowUser = new ApplicationUser()
{
Name = "Workflow", Email = "*****@*****.**",
Password = "******",
CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now
};
var schedulerFlowUser = new ApplicationUser()
{
Name = "Scheduler", Email = "*****@*****.**",
Password = "******",
CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now
};
var currentAdviser = new CurrentAdvisor()
{
Id = 1, Description = "Advisor A", EntityOrganization = organization
};
var gender = new Gender()
{
Id = 1, Description = "Male", EntityOrganization = organization
};
var occupation = new Occupation()
{
Id = 1, Description = "Unemployed", EntityOrganization = organization
};
var addressType = new AddressType()
{
Id = 1, Description = "Complex", EntityOrganization = organization
};
var phoneCallActivityType = new LeadScheduledActivityType()
{
Id = 1, Description = "Phone Call", EntityOrganization = organization
};
var meetingActivityType = new LeadScheduledActivityType()
{
Id = 2, Description = "Meeting", EntityOrganization = organization
};
var authorizationGroupA = new AuthorizationGroup()
{
Id = 1, Name = "Group A", EntityOrganization = organization
};
var authorizationGroupB = new AuthorizationGroup()
{
Id = 2, Name = "Group B", EntityOrganization = organization
};
var portfolioTransactionTypeOpen = new PortfolioTransactionType()
{
Id = 1,
Description = "Open",
};
var portfolioTransactionTypeClose = new PortfolioTransactionType()
{
Id = 2,
Description = "Close",
};
var portfolioShareA = new PortfolioShare()
{
Description = "ABC short",
Code = "ABC"
};
var portfolioShareB = new PortfolioShare()
{
Description = "XYZ short",
Code = "XXZ"
};
context.Add(portfolioTransactionTypeClose);
context.Add(portfolioTransactionTypeOpen);
var portfolios = new List <Portfolio>()
{
new Portfolio()
{
OpenDate = DateTime.Now, Name = "Test A"
},
new Portfolio()
{
OpenDate = DateTime.Now, Name = "Test B"
},
new Portfolio()
{
OpenDate = DateTime.Now, Name = "Test C"
},
new Portfolio()
{
OpenDate = DateTime.Now, Name = "Test D"
},
};
foreach (var portfolio in portfolios)
{
var summaryDate = DateTime.Now;
for (int i = 0; i < 10; i++)
{
var summary = new PortfolioTransactionsSummary()
{
CloseAmount = (decimal) new Random(i).NextDouble() *
((decimal) new Random(i).NextDouble() * 10),
OpenAmount =
(decimal) new Random(i).NextDouble() * ((decimal) new Random(i).NextDouble() * 10),
CloseDate = summaryDate,
OpenDate = summaryDate.AddDays(-30),
Portfolio = portfolio
};
context.Add(summary);
summaryDate = summaryDate.AddDays(-30);
}
var transactionDate = DateTime.Now;
for (int i = 0; i < 10; i++)
{
var transaction = new PortfolioTransaction()
{
Total = (decimal) new Random(i).NextDouble() * 10,
Price = (decimal) new Random(i).NextDouble() *
((decimal) new Random(i).NextDouble() * 10),
Quantity = Math.Abs(new Random(i).Next()),
Date = transactionDate,
Portfolio = portfolio,
PortfolioShare = portfolioShareA,
PortfolioTransactionType = portfolioTransactionTypeClose
};
context.Add(transaction);
transactionDate = transactionDate.AddDays(-1);
}
context.Add(portfolio);
}
applicationUser.AddEntityOrganization(organization);
applicationUser.ActiveEntityOrganizationId = 1;
applicationUser.AddAuthorizationGroup(authorizationGroupA);
applicationUser.AuthorizationRole = adminRole;
context.Add(organization);
context.Add(adminRole);
context.Add(advisoryRole);
context.Add(agentRole);
context.Add(workflowRole);
context.Add(applicationUser);
context.Add(workflowUser);
context.Add(schedulerFlowUser);
context.Add(currentAdviser);
context.Add(gender);
context.Add(occupation);
context.Add(addressType);
context.Add(phoneCallActivityType);
context.Add(meetingActivityType);
context.Add(authorizationGroupA);
//context.Add(authorizationGroupB);
for (int i = 0; i < 1000; i++)
{
var user = new ApplicationUser()
{
Name = "Default", Email = $"testB@test{i}.com",
Password = "******",
CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now
};
user.AddEntityOrganization(organization);
user.ActiveEntityOrganizationId = 1;
user.AddAuthorizationGroup(authorizationGroupA);
user.AuthorizationRole = adminRole;
context.Add(user);
}
context.SaveChanges();
}
}
}
private static string S(IConfiguration configuration, PortfolioTransactionsSummary s)
{
var x = s.OpenDate.ToString(configuration["DateFormat"]);
return(x);
}
