public async Task <List <HearderTable> > GetPOHeaders()
{
List <HearderTable> listaHeader = new List <HearderTable>();
if (_context != null)
{
var headerList = await(from h in _context.POHeader
join c in _context.customerCatalog on h.CustomeridCustomer equals c.idCustomer
join s in _context.statusOrder on h.StatusPurchaseOrderidStatus equals s.idStatus
select new
{
h.idPO
,
c.CustomerName
,
s.StatusName
,
h.OrderDate
}).ToListAsync();
if (headerList != null)
{
foreach (var item in headerList)
{
HearderTable headerTable = new HearderTable();
headerTable.idPo = item.idPO;
headerTable.Customer = item.CustomerName;
headerTable.Status = item.StatusName;
headerTable.OrderDate = item.OrderDate;
listaHeader.Add(headerTable);
}
}
return(listaHeader);
}
return(null);
}
public async Task <HearderTable> GetPOHeaderById(int id)
{
HearderTable headerTable = new HearderTable();
if (id > 0)
{
var headerList = await(from h in _context.POHeader
join c in _context.customerCatalog on h.CustomeridCustomer equals c.idCustomer
join s in _context.statusOrder on h.StatusPurchaseOrderidStatus equals s.idStatus
where h.idPO == id
select new
{
h.idPO
,
c.CustomerName
,
s.StatusName
,
h.OrderDate
}).ToListAsync();
if (headerList != null)
{
foreach (var item in headerList)
{
headerTable.idPo = item.idPO;
headerTable.Customer = item.CustomerName;
headerTable.Status = item.StatusName;
headerTable.OrderDate = item.OrderDate;
}
}
return(headerTable);
}
return(null);
}
