public static List <Model.InvoiceLineItem> Retrieve()
        {
            var request = Globals.GetRetrieveMultipleRequest(_tableName);
            var retrieveMultipleResponse = Globals.CrmServiceBroker.ExecuteRetrieveMultipleRequest(request);
            var businessEntityCollection = retrieveMultipleResponse.BusinessEntityCollection;

            var result = new List <Model.InvoiceLineItem>();

            foreach (var businessEntity in businessEntityCollection.BusinessEntities)
            {
                var dynamicEntity   = (DynamicEntity)businessEntity;
                var invoiceLineItem = new CRM.Model.InvoiceLineItem(dynamicEntity);
                result.Add(invoiceLineItem);
            }

            return(result);
        }
        public static List <Model.InvoiceLineItem> Retrieve(Model.Invoice invoice)
        {
            var criteria = new FilterExpression();

            criteria.AddCondition("new_customerinvoiceid", ConditionOperator.Equal, invoice.Id);

            var request = Globals.GetRetrieveMultipleRequest(_tableName, criteria);
            var retrieveMultipleResponse = Globals.CrmServiceBroker.ExecuteRetrieveMultipleRequest(request);
            var businessEntityCollection = retrieveMultipleResponse.BusinessEntityCollection;

            var result = new List <Model.InvoiceLineItem>();

            foreach (var businessEntity in businessEntityCollection.BusinessEntities)
            {
                var dynamicEntity   = (DynamicEntity)businessEntity;
                var invoiceLineItem = new CRM.Model.InvoiceLineItem(dynamicEntity);
                result.Add(invoiceLineItem);
            }

            return(result.FindAll(x => x.CustomerInvoiceId == invoice.Id));
        }