public static async Task <InvestmentOutput> GetInvestmentDetails(NuixContext _context, int id)
{ /*We get the record from both the investment and the investment details table by the id.
* We then do a linq statement to join the two tables based on the id*/
return((from investments in _context.Investments
join investmentDetails in _context.InvestmentDetails
on investments.Id equals investmentDetails.Id
where investments.Id == id
select(new InvestmentOutput()
{
Id = investments.Id,
Name = investments.InvestmentName,
NumberOfShares = investmentDetails.NumberOfSharesOwned,
CostBasisPerShare = investmentDetails.PriceWhenPurchased,
CurrentPrice = investmentDetails.CurrentPrice,
Term = investmentDetails.DatePurchased.AddDays(366) > DateTime.Today ? "Short Term" : "Long Term", //If less than 1 year then it is short term otherwise it is long term
CurrentValue = investmentDetails.CurrentPrice * investmentDetails.NumberOfSharesOwned,
GainOrLoss = (investmentDetails.CurrentPrice * investmentDetails.NumberOfSharesOwned) - (investmentDetails.PriceWhenPurchased * investmentDetails.NumberOfSharesOwned)
})).FirstOrDefault());
}
/*This class will load a sample set of data into the in memory database.*/
public static void Initialize(IServiceProvider serviceProvider)
{
// Get the database context
using (var context = new NuixContext(serviceProvider.GetRequiredService <DbContextOptions <NuixContext> >()))
{
if (context.Investments.Any())
{
return;
}
context.Investments.Add(
new Investment
{
Id = 1,
InvestmentName = "PNC"
});
context.Investments.Add(
new Investment
{
Id = 2,
InvestmentName = "Google"
});
context.Investments.Add(
new Investment
{
Id = 3,
InvestmentName = "Microsoft"
});
context.Investments.Add(
new Investment
{
Id = 4,
InvestmentName = "Apple"
});
context.Investments.Add(
new Investment
{
Id = 5,
InvestmentName = "Peleton"
});
context.InvestmentDetails.Add(
new InvestmentDetails
{
Id = 1,
PriceWhenPurchased = 125.75,
CurrentPrice = 137.43,
DatePurchased = Convert.ToDateTime("5/15/2019"),
NumberOfSharesOwned = 500
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 2,
PriceWhenPurchased = 2500,
CurrentPrice = 2365,
DatePurchased = Convert.ToDateTime("1/31/2020"),
NumberOfSharesOwned = 25
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 3,
PriceWhenPurchased = 232.90,
CurrentPrice = 232.50,
DatePurchased = Convert.ToDateTime("1/27/2021"),
NumberOfSharesOwned = 250
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 4,
PriceWhenPurchased = 38.74,
CurrentPrice = 137.43,
DatePurchased = Convert.ToDateTime("5/25/2017"),
NumberOfSharesOwned = 100
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 5,
PriceWhenPurchased = 140.69,
CurrentPrice = 143.50,
DatePurchased = Convert.ToDateTime("1/27/2021"),
NumberOfSharesOwned = 750
});
context.SaveChanges();
}
}
private NuixContext LoadSampleDatabaseAndReturnContext()
{
var options = new DbContextOptionsBuilder <NuixContext>()
.UseInMemoryDatabase(databaseName: "InvestmentDatabase")
.Options;
// Get the database context
var context = new NuixContext(options);
if (context.Investments.Any())
{
return(context);
}
context.Investments.Add(
new Investment
{
Id = 1,
InvestmentName = "PNC"
});
context.Investments.Add(
new Investment
{
Id = 2,
InvestmentName = "Google"
});
context.Investments.Add(
new Investment
{
Id = 3,
InvestmentName = "Microsoft"
});
context.Investments.Add(
new Investment
{
Id = 4,
InvestmentName = "Apple"
});
context.Investments.Add(
new Investment
{
Id = 5,
InvestmentName = "Peleton"
});
context.InvestmentDetails.Add(
new InvestmentDetails
{
Id = 1,
PriceWhenPurchased = 125.75,
CurrentPrice = 137.43,
DatePurchased = Convert.ToDateTime("5/15/2019"),
NumberOfSharesOwned = 500
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 2,
PriceWhenPurchased = 2500,
CurrentPrice = 2365,
DatePurchased = Convert.ToDateTime("1/31/2020"),
NumberOfSharesOwned = 25
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 3,
PriceWhenPurchased = 232.90,
CurrentPrice = 232.50,
DatePurchased = Convert.ToDateTime("1/27/2021"),
NumberOfSharesOwned = 250
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 4,
PriceWhenPurchased = 38.74,
CurrentPrice = 137.43,
DatePurchased = Convert.ToDateTime("5/25/2017"),
NumberOfSharesOwned = 100
});
context.InvestmentDetails.Add(new InvestmentDetails
{
Id = 5,
PriceWhenPurchased = 140.69,
CurrentPrice = 143.50,
DatePurchased = Convert.ToDateTime("1/27/2021"),
NumberOfSharesOwned = 750
});
context.SaveChanges();
return(context);
}
public InvestmentsController(NuixContext context)
{
_context = context;
}
public NuixBusinessLogic(NuixContext context)
{
_context = context;
}
