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); }