/// <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();
}