public ActionResult AddOperation(Operation operation)
{
if(ModelState.IsValid)
{
var existingStock = stockServices.GetSingle(s => s.Code == operation.Code && s.PortfolioId == operation.PortfolioId);
if(existingStock == null)
{
var existingDescription = stockDescriptionServices.GetSingle(s => s.Code == operation.Code);
Stock stock = null;
if(existingDescription == null)
{
stock = new Stock(operation);
}
else
{
stock = new Stock(operation, existingDescription);
}
stockServices.CreateStock(stock);
}
else
{
existingStock.UpdateStock(operation);
stockServices.UpdateStock(existingStock);
UpdateStockDescription();
}
var stocks = stockServices.GetStockByPortfolioId(operation.PortfolioId);
operationServices.CreateOperation(operation);
return PartialView("StockListPartialView", stocks);
}
return new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { success = false }
};
}
//1) First go to Server Explorer in Visual Studio, check if the ".mdf" Data Connections for this project are connected, if so, right click and delete.
//2 )Go to Solution Explorer, click show All Files icon.
//3) Go to App_Data, right click and delete all ".mdf" files for this project.
//4) Delete Migrations folder by right click and delete.
//5) Go to SQL Server Management Studio, make sure the DB for this project is not there, otherwise delete it.
//6) Go to Package Manager Console in Visual Studio and type:
// * Enable-Migrations -Force
// * Add-Migration init
// * Update-Database
//7) Run your application
//Note: In step 6 part 3, if you get an error "Cannot attach the file...", it is possibly because you didn't delete the database files completely in SQL Server.
public static void Seed(SuiviPortefeuilleRBC.Models.ApplicationDbContext context)
{
//if(System.Diagnostics.Debugger.IsAttached == false)
// System.Diagnostics.Debugger.Launch();
try
{
#region Add user
if(!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
var userToInsert = new ApplicationUser { UserName = "******" };
userManager.Create(userToInsert, "1234GA");
}
#endregion
#region Add portfolio
Portfolio ptf = new Portfolio
{
Name = "Marge RBC",
TargetValue = 50000,
UserName = "******"
};
Portfolio ptf2 = new Portfolio
{
Name = "CELI RBC",
TargetValue = 50000,
UserName = "******"
};
Portfolio ptf3 = new Portfolio
{
Name = "REER RBC",
TargetValue = 50000,
UserName = "******"
};
context.Portfolios.AddOrUpdate(p=>p.Name, ptf);
context.Portfolios.AddOrUpdate(p => p.Name, ptf2);
context.Portfolios.AddOrUpdate(p => p.Name, ptf3);
context.SaveChanges();
#endregion
#region Add descriptions
List<StockDescription> descriptions = new List<StockDescription>
{
new StockDescription { Code = "Marge", Name = "Marge", LastTimeUpdated = DateTime.Now},
new StockDescription { Code = "EMA.TO", Name = "EMERA INCORPORATED", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "RY.TO", Name = "ROYAL BANK OF CANADA", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "POT.TO", Name = "POTASH CORP OF SASK INC", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "BMO.TO", Name = "BANK OF MONTREAL", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "TD.TO", Name = "TORONTO-DOMINION BANK", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "BNS.TO", Name = "BANK OF NOVA SCOTIA", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "AGF-B.TO", Name = "AGF MANAGEMENT LTD. CL.B NV", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "TCL-A.TO", Name = "TRANSCONTINENTAL INC. CL A SV", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "ACD.TO", Name = "ACCORD FINANCIAL", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "FTS.TO", Name = "FORTIS INC", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "MIC.TO", Name = "GENWORTH MI CANADA INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CTY.TO", Name = "CALIAN TECHNOLOGIES LTD.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CU.TO", Name = "CANADIAN UTILITIES LTD. CL.A", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "TRI.TO", Name = "THOMSON REUTERS CORPORATION", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "FTT.TO", Name = "FINNING INTL", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "RCI-B.TO", Name = "ROGERS COMMUNICATIONS INC. CL.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "BCE.TO", Name = "BCE INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CPX.TO", Name = "CAPITAL POWER CORPORATION", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "PWF.TO", Name = "POWER FINANCIAL CORP.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "LB.TO", Name = "LAURENTIAN BANK", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CM.TO", Name = "CANADIAN IMPERIAL BANK OF COMME", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "POW.TO", Name = "POWER CORPORATION OF CANADA SV", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "SXP.TO", Name = "SUPREMEX INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "TRP.TO", Name = "TRANSCANADA CORP.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "ESI.TO", Name = "ENSIGN ENERGY SERVICES INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "SDY.TO", Name = "STRAD ENERGY SERVICES LTD", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "NA.TO", Name = "NATIONAL BANK OF CANADA", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CPG.TO", Name = "CRESCENT POINT ENERGY CORP.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "FC.TO", Name = "FIRM CAPITAL MORTGAGE INV. CORP", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "AI.TO", Name = "ATRIUM MORTGAGE INVESTMENT CORP", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "AFN.TO", Name = "AG GROWTH INTERNATIONAL INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "ENF.TO", Name = "ENBRIDGE INCOME FUND HOLDINGS I", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "BDT.TO", Name = "BIRD CONSTR INC", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "NPI.TO", Name = "NORTHLAND POWER INC.", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "CJR-B.TO", Name = "CORUS ENTERTAINMENT INC. CL.B", LastTimeUpdated = DateTime.Now },
new StockDescription { Code = "AAPL", Name = "APPLE", LastTimeUpdated = DateTime.Now }
};
descriptions.ForEach(s => context.StockDescriptions.AddOrUpdate(p => p.Code, s));
context.SaveChanges();
#endregion
#region Add Stocks
var descriptionRY = context.StockDescriptions.First(p => p.Code == "RY.TO");
var descriptionNA = context.StockDescriptions.First(p => p.Code == "NA.TO");
var descriptionAAPL = context.StockDescriptions.First(p => p.Code == "AAPL");
//Add stocks
var stockRY = new Stock();
stockRY.Code = descriptionRY.Code;
stockRY.PortfolioId = ptf.PortfolioId;
stockRY.NumberOfShares = 10;
stockRY.InvestedValue = 500;
stockRY.UnitaryPrice = 50;
var stockNA = new Stock();
stockNA.Code = descriptionNA.Code;
stockNA.PortfolioId = ptf.PortfolioId;
stockNA.NumberOfShares = 10;
stockNA.InvestedValue = 500;
stockNA.UnitaryPrice = 50;
var stockAAPL = new Stock();
stockAAPL.Code = descriptionAAPL.Code;
stockAAPL.PortfolioId = ptf.PortfolioId;
stockAAPL.NumberOfShares = 10;
stockAAPL.InvestedValue = 500;
stockAAPL.UnitaryPrice = 50;
context.Stocks.AddOrUpdate(p => p.Code, new Stock[] { stockRY, stockNA, stockAAPL });
context.SaveChanges();
#endregion
}
catch(System.Data.Entity.Validation.DbEntityValidationException ex)
{
var sb = new System.Text.StringBuilder();
foreach(var failure in ex.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach(var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new System.Data.Entity.Validation.DbEntityValidationException(
"Entity Validation Failed - errors follow:\n" +
sb.ToString(), ex
); // Add the original exception as the innerException
}
}
