/// <summary> /// /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool AddEntity(T entity) { dbContext.Set <T>().Add(entity); bool res = dbContext.SaveChanges() > 0 ? true : false; return(res); }
public static void Initialize(ShareContext context) { context.Database.EnsureCreated(); if (context.Shares.Any()) { return; // Database already seeded } List <ShareModel> sharesList = new List <ShareModel>(); for (int i = 0; i < 20; i++) { sharesList.Add(new ShareModel { TickerSymbol = "NVO", Owner = 1 }); sharesList.Add(new ShareModel { TickerSymbol = "GOOG", Owner = 2 }); sharesList.Add(new ShareModel { TickerSymbol = "VWS", Owner = 3 }); sharesList.Add(new ShareModel { TickerSymbol = "DANSKE", Owner = 4 }); sharesList.Add(new ShareModel { TickerSymbol = "MAERSK A", Owner = 5 }); sharesList.Add(new ShareModel { TickerSymbol = "DENERG", Owner = 6 }); } context.Shares.AddRange(sharesList); context.SaveChanges(); }
public IActionResult ChangeOwnership([FromBody] BuyModel buyModel) { if (buyModel.BuyerId == 0 || buyModel.Quantity == 0 || buyModel.SellerId == 0 || string.IsNullOrWhiteSpace(buyModel.TickerSymbol)) { Response.StatusCode = 400; var insufficientParametersGiven = "Insufficient parameters given"; Console.Out.WriteLine(insufficientParametersGiven); return(Json(new { errorMessage = insufficientParametersGiven })); } var shares = _context.Shares.Where(share => share.Owner == buyModel.SellerId && share.TickerSymbol == buyModel.TickerSymbol); if (shares.Count() < buyModel.Quantity) { var insufficientSharesOwned = "Insufficient shares owned"; Console.Out.WriteLine(insufficientSharesOwned); return(Json(new { errorMessage = insufficientSharesOwned })); } var sharesToBeSold = shares.Take(buyModel.Quantity); foreach (var share in sharesToBeSold) { share.Owner = buyModel.BuyerId; } _context.Shares.UpdateRange(sharesToBeSold); _context.SaveChanges(); var sharesSold = "Shares sold"; Console.Out.WriteLine(sharesSold); return(Json(new { Message = sharesSold })); }
public void Add(ShareModel entity) { db.Shares.Add(entity); db.SaveChanges(); }