public async Task <IActionResult> AddPortfolioTransaction([FromBody] Transaction transaction)
{
var coin = _context.Coins.Find(transaction.Coinid);
if (coin == null)
{
return(BadRequest("This coin was not found in the database. Please add it to your portfolio and try again."));
}
var user = await _utilityService.GetUser();
var portfolio = await _context.UserPortfolios.FirstOrDefaultAsync <UserPortfolio>(u => u.UserId == user.Id && u.CurrentlySelected == true);
if (!await _context.PortfolioCoins.AnyAsync <PortfolioCoin>(p => p.UserPortfolioId == portfolio.Id && p.Coinid == coin.id))
{
return(BadRequest("Please add this coin to your portfolio first and then create the transactions for it."));
}
await _context.Transactions.AddAsync(transaction);
_context.SaveChanges();
PortfolioTransaction portfolioTransaction = new PortfolioTransaction()
{
UserPortfolioId = portfolio.Id,
TransactionId = transaction.Id
};
await _context.PortfolioTransactions.AddAsync(portfolioTransaction);
_context.SaveChanges();
return(Ok(portfolioTransaction));
}
public static int GetPortfolioTransaction(int portfolioId)
{
using (var scope = ApplicationContext.Container.BeginLifetimeScope())
{
using (var context = scope.Resolve <DbContext>())
{
var entity = new PortfolioTransaction()
{
PortfolioId = portfolioId,
Date = DateTime.Now,
Price = 11.4m,
Quantity = 2342,
PortfolioShareId = 1,
PortfolioTransactionTypeId = 1,
Total = 434,
ModifiedDate = DateTime.Now,
CreatedDate = DateTime.Now,
ModifiedBy = "",
CreatedBy = "",
};
context.Add(entity);
context.SaveChanges();
return(entity.Id);
}
}
}
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();
}
}
}
