/*---------------------------------------------------------------------------------------------------------*/ /*---------------------------------Effective Spread API!!!-------------------------------------------------*/ public IActionResult EffectiveSpread(string symbol) { //Set ViewBag variable first ViewBag.dbSuccessChart = 0; List <EffectiveSpread> effectivespreads = new List <EffectiveSpread>(); if (symbol != null) { effectivespreads = GetEffctiveSpreads(symbol); } EffectiveSpreadVM effectiveSpreadViewModel = getEffectiveSpreadVM(effectivespreads); return(View(effectiveSpreadViewModel)); }
public IActionResult SaveEffectiveSpreads(string symbol) { List <EffectiveSpread> effectivespreads = GetEffctiveSpreads(symbol); foreach (EffectiveSpread effectivespread in effectivespreads) { //Database will give PK constraint violation error when trying to insert record with existing PK. if (dbContext.EffectiveSpreads.Where(c => c.EffectiveSpreadId.Equals(effectivespread.EffectiveSpreadId)).Count() == 0) { dbContext.EffectiveSpreads.Add(effectivespread); } } // persist the data dbContext.SaveChanges(); // populate the models to render in the view ViewBag.dbSuccessChart = 1; EffectiveSpreadVM effectiveSpreadViewModel = getEffectiveSpreadVM(effectivespreads); return(View("EffectiveSpread", effectiveSpreadViewModel)); }