public List <Models.MViewModels.MViewRecievables> GetAll() { List <Models.MViewModels.MViewRecievables> Get = new List <Models.MViewModels.MViewRecievables>(); var query = from o in obj.Payments where o.PaymentType == Common.Constants.PaymentTypes.Partial.ToString() && o.ClientId != -1 && o.OrderId != 0 && o.VendorId == -1 select o; Classes.CClients cc = new CClients(); Classes.COrders co = new COrders(); string clientName = string.Empty; string orderName = string.Empty; foreach (var item in query) { clientName = cc.ReturnClientNameById(item.ClientId.ToString()); orderName = co.GetOrderNameById(item.OrderId.ToString()); } return(Get); }