public void SetTopSecurityFeeds(List <string> Ids, List <string> DeselectedIds) { foreach (var item in Ids) { var id = Convert.ToInt64(item); var SecurityFeed = _ABIDBContext.SecurityFeeds.Where(s => s.SecurityFeedID == id).FirstOrDefault(); if (SecurityFeed != null) { using (var dbContext = new APIdbContext()) { SecurityFeed.IsTop = true; _ABIDBContext.Set <SecurityFeeds>().Attach(SecurityFeed); _ABIDBContext.Entry(SecurityFeed).State = EntityState.Modified; _ABIDBContext.SaveChanges(); } } } foreach (var item in DeselectedIds) { var id = Convert.ToInt64(item); var SecurityFeed = _ABIDBContext.SecurityFeeds.Where(s => s.SecurityFeedID == id).FirstOrDefault(); if (SecurityFeed != null) { using (var dbContext = new APIdbContext()) { SecurityFeed.IsTop = false; _ABIDBContext.Set <SecurityFeeds>().Attach(SecurityFeed); _ABIDBContext.Entry(SecurityFeed).State = EntityState.Modified; _ABIDBContext.SaveChanges(); } } } }
public void SaveSecurityFeeds(SecurityFeeds securityfeeds) { try { if (securityfeeds != null) { using (var dbContext = new APIdbContext()) { if (securityfeeds.SecurityFeedID == 0 || securityfeeds.SecurityFeedID == null) { // _context.OrderEntryHeader.Add(orderheadermaster); dbContext.Entry(securityfeeds).State = EntityState.Added; dbContext.Set <SecurityFeeds>().Add(securityfeeds); } else if (securityfeeds.SecurityFeedID > 0) { // _context.Entry(orderheadermaster).State = EntityState.Modified; dbContext.Set <SecurityFeeds>().Attach(securityfeeds); dbContext.Entry(securityfeeds).State = EntityState.Modified; } dbContext.SaveChanges(); } } } catch (Exception ex) { throw ex; } }