public List <PRQChemFrgnPurcOrdr> GetOrderInformationForLOV() { var Orders = (from o in _context.PRQ_ChemFrgnPurcOrdr.AsEnumerable() where o.RecordStatus == "CNF" & o.OrderState == "RNG" & o.OrderCategory == "FPO" from s1 in _context.Sys_Supplier.Where(x => x.SupplierID == o.SupplierID).DefaultIfEmpty() join sa in _context.Sys_SupplierAddress.Where(x => x.IsActive && !x.IsDelete) on o.SupplierID equals sa.SupplierID into SupplierAddress from sa2 in SupplierAddress.DefaultIfEmpty() from s2 in _context.Sys_Supplier.Where(x => x.SupplierID == o.LocalAgent).DefaultIfEmpty() join la in _context.Sys_SupplierAddress.Where(x => x.IsActive && !x.IsDelete) on o.LocalAgent equals la.SupplierID into LocalAgentAddress from la2 in LocalAgentAddress.DefaultIfEmpty() from s3 in _context.Sys_Supplier.Where(x => x.SupplierID == o.ForeignAgent).DefaultIfEmpty() join fa in _context.Sys_SupplierAddress.Where(x => x.IsActive && !x.IsDelete) on o.ForeignAgent equals fa.SupplierID into ForeignAgentAddress from fa2 in ForeignAgentAddress.DefaultIfEmpty() orderby o.OrderID descending select new PRQChemFrgnPurcOrdr { OrderID = o.OrderID, OrderNo = o.OrderNo, OrderTo = DalCommon.ReturnOrderTo(o.OrderTo), OrderDate = (Convert.ToDateTime(o.OrderDate)).ToString("dd'/'MM'/'yyyy"), OrderType = DalCommon.ReturnOrderType(o.OrderType), SupplierID = Convert.ToInt32((s1 == null ? null : (s1.SupplierID).ToString())), SupplierName = (s1 == null ? null : s1.SupplierName), SupplierCode = (s1 == null ? null : s1.SupplierCode), SupplierAddress = (sa2 == null? null: sa2.Address), SupplierContactNumber = (sa2 == null ? null : sa2.ContactNumber), LocalAgent = Convert.ToInt32((la2 == null ? null : (la2.SupplierID).ToString())), LocalAgentName = (s2 == null ? null : s2.SupplierName), LocalAgentCode = (s2 == null ? null : s2.SupplierCode), LocalAgentAddress = (la2 == null ? null : la2.Address), LocalAgentContactNumber = (la2 == null ? null : la2.ContactNumber), ForeignAgent = Convert.ToInt32((s3 == null ? null : (s3.SupplierID).ToString())), ForeignAgentName = (s3 == null ? null : s3.SupplierName), ForeignAgentCode = (s3 == null ? null : s3.SupplierCode), ForeignAgentAddress = (fa2 == null ? null : fa2.Address), ForeignAgentContactNumber = (fa2 == null ? null : fa2.ContactNumber), OrderNote = o.OrderNote }).ToList(); return(Orders); }