public ContractsController(ApplicationDbContext db,
EvektorDochnaDbContext eveDbDochna,
IWebHostEnvironment hostEnvironment) : base(hostEnvironment)
{
_db = db;
_eveDbDochna = eveDbDochna;
_env = hostEnvironment;
}
public async Task <List <SelectListItem> > getDepartmentListAsync2(EvektorDochnaDbContext _eveDbDochna)
{
IQueryable <SelectListItem> eveDepartmentList = _eveDbDochna.vEmployees
.Where(x => x.EVE == 1)
.Select(x => new SelectListItem {
Value = x.DepartName,
Text = x.DepartName,
})
.OrderBy(x => x.Text)
.Distinct(new SelectListItemComparer());
return(await eveDepartmentList.ToListAsync());
}
public SelectList getDepartmentList(EvektorDochnaDbContext _eveDbDochna)
{
IEnumerable <SelectListItem> eveDepartmentList = _eveDbDochna.vEmployees
.Where(x => x.EVE == 1)
.OrderBy(x => x.DepartName)
.ToList()
.Select(x => new SelectListItem {
Value = x.DepartName,
Text = x.DepartName,
})
.Distinct(new SelectListItemComparer());
return(new SelectList(eveDepartmentList, "Value", "Text"));
}
public async Task <List <SelectListItem> > getEveContactsAsync(EvektorDochnaDbContext _eveDbDochna)
{
// EVE - Del = 1 and nemáš TxAccount a nejsi IntAccType == 1 -> nepracuješ
// EVAT - Del = 0 and máš BranchID 1 a zároveň WorkMask non NULL -> pracuješ v EVATu
IOrderedQueryable <SelectListItem> eveContactsList = _eveDbDochna.vEmployees
.Where(x => x.EVE == 1)
.Select(x => new SelectListItem {
Value = x.FormatedName,
Text = x.FormatedName,
})
.OrderBy(x => x.Text);
return(await eveContactsList.ToListAsync());
}
public async Task <SelectList> getDepartmentListAsync(EvektorDochnaDbContext _eveDbDochna)
{
List <vEmployees> employees = await _eveDbDochna.vEmployees
.Where(x => x.EVE == 1)
.OrderBy(x => x.DepartName)
.ToListAsync();
IEnumerable <SelectListItem> eveDepartmentList = employees
.Select(x => new SelectListItem {
Value = x.DepartName,
Text = x.DepartName,
})
.Distinct(new SelectListItemComparer());
return(new SelectList(eveDepartmentList, "Value", "Text"));
}
public SelectList getEveContacts(EvektorDochnaDbContext _eveDbDochna)
{
// EVE - Del = 1 and nemáš TxAccount a nejsi IntAccType == 1 -> nepracuješ
// EVAT - Del = 0 and máš BranchID 1 a zároveň WorkMask non NULL -> pracuješ v EVATu
IEnumerable <SelectListItem> eveContactsList = _eveDbDochna.vEmployees
.Where(x => x.EVE == 1)
.ToList()
.Select(x => new SelectListItem {
Value = x.FormatedName,
Text = x.FormatedName,
})
.OrderBy(x => x.Text);
return(new SelectList(eveContactsList, "Value", "Text"));
}
