//Store list of basic quotes
public static void storeData(List <TestFinanceModel> vehicleList)
{
using (FinanceVehiclesDbContext context = new FinanceVehiclesDbContext())
{
context.FinanceModelSet.AddRange(vehicleList);
context.SaveChanges();
}
}
//Store list of monthly quotes
public static void storeData(MonthlyFinanceTimeSeriesParentModel vehicle)
{
using (FinanceVehiclesDbContext context = new FinanceVehiclesDbContext())
{
context.MonthlyFinanceModelSet.AddRange(vehicle.monthlyFinanceTimeSeriesParentModel);
context.SaveChanges();
}
}
//Store basic quote data
public static void storeData(TestFinanceModel vehicle)
{
using (FinanceVehiclesDbContext context = new FinanceVehiclesDbContext())
{
context.FinanceModelSet.Add(vehicle);
context.SaveChanges();
}
}
public IActionResult MyPortfolio()
{
using (FinanceVehiclesDbContext con = new FinanceVehiclesDbContext())
{
//All elements
var financeTimeSeriesParentModel = con.FinanceModelSet.Where(f => f.Id >= 0);
return(View(financeTimeSeriesParentModel.Select(x => x).ToList()));
}
}
public static bool checkIfDuplicate(string tickerTag)
{
using (FinanceVehiclesDbContext context = new FinanceVehiclesDbContext())
{
if (context.FinanceModelSet.Any(t => t.MarketTicker == tickerTag))
{
return(true);
}
return(false);
}
}
public static void seedInitial(FinanceVehiclesDbContext context)
{
if (!context.FinanceModelSet.Any())
{
var investments = new List <TestFinanceModel>
{
new TestFinanceModel("TSLA", 0, "0"),
new TestFinanceModel("VAB", 0, "0"),
new TestFinanceModel("VIDY", 0, "0"),
new TestFinanceModel("VNQ", 0, "0"),
new TestFinanceModel("VGH", 0, "0")
};
context.FinanceModelSet.AddRange(investments);
context.SaveChanges();
}
}
