public async Task <List <SupplierModel> > SupplierList()
{
var listMaterialPurchase = await _repoMaterialPurchase.FindAll(x => x.Supplier_ID.Trim() != "")
.Select(x => new
{
Supplier_ID = x.Supplier_ID
}).Distinct()
.ToListAsync();
var listHPVendor = await _repoHPVendor.FindAll(x => x.Vendor_No.Trim() != "")
.Select(x => new
{
Vendor_No = x.Vendor_No,
Vendor_Name = x.Vendor_Name
}).Distinct()
.ToListAsync();
var data = (from T1 in listMaterialPurchase
join T2 in listHPVendor
on T1.Supplier_ID.Trim() equals T2.Vendor_No.Trim()
select new SupplierModel
{
Supplier_No = T1.Supplier_ID.Trim(),
Supplier_Name = T2.Vendor_Name.Trim()
}).Distinct()
.OrderBy(x => x.Supplier_No)
.ToList();
return(data);
}
public async Task <object> GetSupplier()
{
var listMaterialPurchase = await _materialPurchaseRepository.FindAll(x => !String.IsNullOrEmpty(x.Supplier_ID))
.Select(x => x.Supplier_ID).Distinct().ToListAsync();
var listHPVendor = await _repoHPVendor.FindAll(x => !String.IsNullOrEmpty(x.Vendor_No))
.Select(x => new { x.Vendor_No, x.Vendor_Name }).Distinct().ToListAsync();
var data = (from T1 in listMaterialPurchase
join T2 in listHPVendor
on T1.Trim() equals T2.Vendor_No.Trim()
select new
{
SupplierNo = T1.Trim(),
SupplierName = T2.Vendor_Name.Trim()
}).Distinct()
.OrderBy(x => x.SupplierNo)
.ToList();
return(data);
}
