public static void Initialize(SenaVMSContext context)
{
context.Database.EnsureCreated();
//look for trafficinfos
if (context.TrafficInfos.Any())
{
return; //db has been seeded
}
var trafficInfos = new TrafficInfo[]
{
new TrafficInfo {
InfoProviderID = 1, Board = "1", Event = "1", TravelTime = "32", PointA = "VZ001", PointB = "TIMES SQUARE", NowDateTime = DateTime.Now
},
new TrafficInfo {
InfoProviderID = 2, Board = "1", Event = "1", TravelTime = "18", PointA = "VZ001", PointB = "MID VALLEY", NowDateTime = DateTime.Now
},
new TrafficInfo {
InfoProviderID = 1, Board = "2", Event = "1", TravelTime = "42", PointA = "VZ002", PointB = "LOT 10", NowDateTime = DateTime.Now
},
new TrafficInfo {
InfoProviderID = 2, Board = "2", Event = "1", TravelTime = "8", PointA = "VZ002", PointB = "FAHRENHEIT88", NowDateTime = DateTime.Now
}
};
foreach (TrafficInfo t in trafficInfos)
{
context.TrafficInfos.Add(t);
}
context.SaveChanges();
}
//Method post for clearing alert for board that has "alert == true" in db
public async Task <IActionResult> OnPostClearAlert()
{
int alertonboard = Board.ID;
var alertBoarddb = await _context.Boards
.Include(b => b.Display)
.FirstOrDefaultAsync(m => m.ID == alertonboard);
alertBoarddb.Display.HasAlert = false;
_context.Update(alertBoarddb);
_context.SaveChanges();
return(Page());
}
