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; }
}
public void SeedData(int nCust, int nOrders)
{
if (!_ctx.Customers.Any())
{
SeedCustomers(nCust);
_ctx.SaveChanges();
}
if (!_ctx.Orders.Any())
{
SeedOrders(nOrders);
_ctx.SaveChanges();
}
if (!_ctx.Servers.Any())
{
SeedServers();
_ctx.SaveChanges();
}
}
public IActionResult Message(int id, [FromBody] ServerMessage msg)
{
var server = ctx.Servers.Find(id);
if (server == null)
{
return(NotFound());
}
if (msg.payLoad == "activate")
{
server.isOnline = true;
ctx.SaveChanges();
}
if (msg.payLoad == "deactivate")
{
server.isOnline = false;
ctx.SaveChanges();
}
return(new NoContentResult());
}
public IActionResult Post([FromBody] Customer customer)
{
if (customer == null)
{
return(BadRequest());
}
ctx.Customers.Add(customer);
ctx.SaveChanges();
return(CreatedAtAction("GetCustomer", new Customer {
id = customer.id
}, customer));
}