Ejemplo n.º 1
0
        public async Task <XDocument> GetListFetchXml(SalesOrderListRequest salesOrderListRequest)
        {
            return(await Task <XDocument> .Run(() =>
            {
                var filterStr = "";
                var fetchXml = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
  <entity name='mcs_tc_productorderitem'>
    <attribute name='mcs_tc_productorderitemid' />
    <attribute name='mcs_name' />
    <attribute name='createdon' />
    <attribute name='mcs_productsku' />
    <attribute name='mcs_totalprice' />
    <attribute name='transactioncurrencyid' />
    <attribute name='ownerid' />
    <attribute name='mcs_order' />
    <attribute name='mcs_totalintegral' />
    <attribute name='mcs_unitintegral' />
    <attribute name='statuscode' />
    <attribute name='statecode' />
    <attribute name='exchangerate' />
    <attribute name='mcs_itemtype' />
    <attribute name='mcs_count' />
    <attribute name='mcs_paytype' />
    <attribute name='mcs_suborder' />
    <attribute name='mcs_product' />
    <attribute name='mcs_unitprice_base' />
    <attribute name='mcs_unitprice' />
    <attribute name='overriddencreatedon' />
    <attribute name='createdonbehalfby' />
    <attribute name='createdby' />
    <attribute name='modifiedonbehalfby' />
    <attribute name='modifiedby' />
    <attribute name='modifiedon' />
    <attribute name='mcs_totalprice_base' />
    <order attribute='mcs_name' descending='false' />
    <link-entity name='mcs_tc_order' from='mcs_tc_orderid' to='mcs_order' link-type='inner' alias='aa'>
      <attribute name='mcs_paystatus' />
      <filter type='and'>
        <condition attribute='mcs_orderclass' operator='eq' value='100' />
        <condition attribute='mcs_userid' operator='eq' value='{salesOrderListRequest.UserId}' />
      </filter>
    </link-entity>
    <link-entity name='mcs_tc_product' from='mcs_tc_productid' to='mcs_product' link-type='inner' alias='bb'>
      <attribute name='mcs_type' />
      <filter type='and'>
        <condition attribute='mcs_type' operator='eq' value='1' />
      </filter>
    </link-entity>
  </entity>
</fetch>";
                return XDocument.Parse(fetchXml);
            }));
        }
Ejemplo n.º 2
0
        public async Task <SalesOrderListResponse> getlist(SalesOrderListRequest salesOrderListRequest)
        {
            try
            {
                var crmRequestHelper = new CrmRequestHelper();
                var response         = new SalesOrderListResponse()
                {
                };
                XDocument fetchXdoc = null;
                fetchXdoc = await _salesorderRepository.GetListFetchXml(salesOrderListRequest);

                var entities = await crmRequestHelper.ExecuteAsync(_crmService, entityName, fetchXdoc);

                response.orders        = entities.Results;;
                response.ALLTotalCount = entities.Count;
                response.PageSize      = salesOrderListRequest.PageSize;
                response.CurrentPage   = salesOrderListRequest.PageIndex;
                return(response);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 3
0
 public async Task <SalesOrderListResponse> getlist(SalesOrderListRequest salesOrderListRequest)
 {
     return(await _salesorderService.getlist(salesOrderListRequest));
 }
Ejemplo n.º 4
0
 public async Task <NewtonsoftJsonActionResult <SalesOrderListResponse> > getlist(SalesOrderListRequest salesOrderListRequest)
 {
     return(await _appSalesOrder.getlist(salesOrderListRequest));
 }