public EvektorController(ApplicationDbContext db,
EvektorDbContext eveDb,
EvektorDochnaDbContext eveDbDochna,
IWebHostEnvironment hostEnvironment) : base(hostEnvironment)
{
_db = db;
_eveDb = eveDb;
_eveDbDochna = eveDbDochna;
_env = hostEnvironment;
}
public async Task <List <SelectListItem> > getOrderCodesAsync(EvektorDbContext _eveDb)
{
IOrderedQueryable <SelectListItem> eveOrderCodes = _eveDb.cOrders
.Select(m => new SelectListItem {
// Text = string.Format($"{m.OrderCode} - {m.OrderName}"),
// Text = m.OrderCode,
Text = m.OrderCode + " - " + m.OrderName,
Value = m.OrderCode
})
.OrderBy(x => x.Value);
return(await eveOrderCodes.ToListAsync());
}
public SelectList getOrderCodes(EvektorDbContext _eveDb)
{
IOrderedEnumerable <SelectListItem> eveOrderCodes = _eveDb.cOrders
.AsEnumerable()
.Select(m => new SelectListItem
{
Text = string.Format($"{m.OrderCode} - {m.OrderName}"),
Value = m.OrderCode
})
.OrderBy(x => x.Value);
return(new SelectList(eveOrderCodes, "Value", "Text"));
}
