public void PopulateSelectLists(TopazDbContext context, object selectedStreetTerritory = null, object selectedPublisher = null)
{
var streetTerritoriesQuery = context.StreetTerritories.OrderBy(x => x.TerritoryCode).Select(x => x);
SelectListStreetTerritory = new SelectList(streetTerritoriesQuery.AsNoTracking(), "TerritoryId", "TerritoryCode", selectedStreetTerritory);
var publishersQuery = context.Publishers.OrderBy(x => x.LastName).ThenBy(x => x.FirstName).Select(x => new { Value = x.PublisherId, Text = $"{x.LastName}, {x.FirstName}" });
SelectListPublisher = new SelectList(publishersQuery.AsNoTracking(), "Value", "Text", selectedPublisher);
}
public void PopulateTerritory(TopazDbContext context, object selectedTerritory = null)
{
var territoriesQuery = context.InaccessibleTerritories
.Include(x => x.StreetTerritory)
.OrderBy(x => x.StreetTerritory.TerritoryCode)
.ThenBy(x => x.TerritoryCode)
.Select(x => new
{
Value = x.TerritoryId,
Text = $"{x.StreetTerritory.TerritoryCode} / {x.TerritoryCode}"
});
SelectListTerritory = new SelectList(territoriesQuery.AsNoTracking(), "Value", "Text", selectedTerritory);
}
public ConsoleApp(TopazDbContext db)
{
_db = db;
}
public void PopulateStreetTerritory(TopazDbContext context, object selectedStreetTerritory = null)
{
var streetTerritoriesQuery = context.StreetTerritories.OrderBy(x => x.TerritoryCode).Select(x => x);
SelectListStreetTerritory = new SelectList(streetTerritoriesQuery.AsNoTracking(), "TerritoryId", "TerritoryCode", selectedStreetTerritory);
}
public ConsoleApp(LegacyDbContext legacyDb, SourceDbContext sourceDb, TargetDbContext targetDb)
{
_legacyDb = legacyDb;
_sourceDb = sourceDb;
_targetDb = targetDb;
}
public PublisherModel(TopazDbContext context, UserManager <AppUser> userManager)
{
_context = context;
_userManager = userManager;
}
