public AppCrmProduct AppGetProductById(string productId) { ProductOperation po = new ProductOperation(); AppCrmProduct product = po.AppGetProductById(productId); return(product); }
public List <AppCrmProduct> AppGetAllProduct() { log.Info("GetAllProduct:"); CrmUtil cu = new CrmUtil(); OrganizationServiceProxy organizationProxy = cu.getCrmService(); List <AppCrmProduct> products = new List <AppCrmProduct>(); try { //Update Account TradeRegistration QueryExpression qe = new QueryExpression(); qe.EntityName = "product"; qe.ColumnSet = new ColumnSet(true); //qe.LinkEntities.Add(new LinkEntity("account", "contact", "primarycontactid", "contactid", JoinOperator.Inner)); //qe.LinkEntities[0].Columns.AddColumns("firstname", "lastname"); //qe.LinkEntities[0].EntityAlias = "primarycontact"; EntityCollection ec = organizationProxy.RetrieveMultiple(qe); foreach (Entity product in ec.Entities) { AppCrmProduct res_product = new AppCrmProduct(); res_product.ProductId = product.GetAttributeValue <Guid>("productid").ToString(); res_product.ProductName = product.GetAttributeValue <string>("productnumber"); res_product.ProductSku = product.GetAttributeValue <string>("name"); res_product.Brand = product.GetAttributeValue <string>("suppliername"); res_product.Quantity = product.GetAttributeValue <decimal>("quantityonhand").ToString("#.##"); res_product.PictureList = product.GetAttributeValue <string>("new_picturelist"); if (product.Contains("price") && product["price"] != null) { res_product.ListPrice = product.GetAttributeValue <Money>("price").Value.ToString("#.##"); } if (product.Contains("new_rrp") && product["new_rrp"] != null) { res_product.RRP = product.GetAttributeValue <Money>("new_rrp").Value.ToString("#.##"); } res_product.ProductColor = product.GetAttributeValue <string>("new_colour"); res_product.ProductBarcode = product.GetAttributeValue <string>("new_productbarcode"); res_product.ProductDimensions = product.GetAttributeValue <string>("new_size"); res_product.ProductWeight = product.GetAttributeValue <string>("new_productweight"); res_product.IdenticalUnitPerCase = product.GetAttributeValue <string>("new_casequantity"); res_product.CaseBarcode = product.GetAttributeValue <string>("new_casebarcode"); res_product.CaseDimensions = product.GetAttributeValue <string>("new_casedimensions"); res_product.CaseWeight = product.GetAttributeValue <string>("new_caseweight"); res_product.CTNDetails = product.GetAttributeValue <string>("new_ctndetails"); if (product.Contains("new_parentcatalog") && product["new_parentcatalog"] != null) { res_product.ParentCatalog = product.FormattedValues["new_parentcatalog"]; } if (product.Contains("new_subcatelog") && product["new_subcatelog"] != null) { res_product.SubCatalog = product.FormattedValues["new_subcatelog"]; } if (product.Contains("new_additionalcatelog") && product["new_additionalcatelog"] != null) { res_product.AdditionalCatalog = product.FormattedValues["new_additionalcatelog"]; } res_product.ProductDescription = product.GetAttributeValue <string>("description"); res_product.ProductCreatedon = product.GetAttributeValue <DateTime>("createdon").ToLocalTime().ToString("yyyyMMddHHmmss"); products.Add(res_product); } } catch (Exception ex) { log.Info(ex + "--" + ex.Message + "--" + ex.ToString()); } return(products); }
public List <AppCrmProduct> AppGetProductsByCategory(AppCrmProductCategoryRequest request) { log.Info("AppGetProductsByCategory:"); CrmUtil cu = new CrmUtil(); OrganizationServiceProxy organizationProxy = cu.getCrmService(); List <AppCrmProduct> products = new List <AppCrmProduct>(); try { QueryExpression qe = new QueryExpression(); qe.EntityName = "product"; qe.ColumnSet = new ColumnSet(true); ConditionExpression condition1 = new ConditionExpression(); condition1.AttributeName = request.categoryType; condition1.Operator = ConditionOperator.Equal; condition1.Values.Add(request.categoryValue); FilterExpression filter1 = new FilterExpression(); filter1.Conditions.Add(condition1); qe.Criteria.AddFilter(filter1); EntityCollection ec = organizationProxy.RetrieveMultiple(qe); foreach (Entity product in ec.Entities) { AppCrmProduct res_product = new AppCrmProduct(); res_product.ProductId = product.GetAttributeValue <Guid>("productid").ToString(); res_product.ProductName = product.GetAttributeValue <string>("productnumber"); res_product.ProductSku = product.GetAttributeValue <string>("name"); res_product.Brand = product.GetAttributeValue <string>("suppliername"); res_product.Quantity = product.GetAttributeValue <decimal>("quantityonhand").ToString("#.##"); res_product.PictureList = product.GetAttributeValue <string>("new_picturelist"); if (product.Contains("price") && product["price"] != null) { res_product.ListPrice = product.GetAttributeValue <Money>("price").Value.ToString("#.##"); } if (product.Contains("new_rrp") && product["new_rrp"] != null) { res_product.RRP = product.GetAttributeValue <Money>("new_rrp").Value.ToString("#.##"); } res_product.ProductColor = product.GetAttributeValue <string>("new_colour"); res_product.ProductBarcode = product.GetAttributeValue <string>("new_productbarcode"); res_product.ProductDimensions = product.GetAttributeValue <string>("new_size"); res_product.ProductWeight = product.GetAttributeValue <string>("new_productweight"); res_product.IdenticalUnitPerCase = product.GetAttributeValue <string>("new_casequantity"); res_product.CaseBarcode = product.GetAttributeValue <string>("new_casebarcode"); res_product.CaseDimensions = product.GetAttributeValue <string>("new_casedimensions"); res_product.CaseWeight = product.GetAttributeValue <string>("new_caseweight"); res_product.CTNDetails = product.GetAttributeValue <string>("new_ctndetails"); if (product.Contains("new_parentcatalog") && product["new_parentcatalog"] != null) { res_product.ParentCatalog = product.FormattedValues["new_parentcatalog"]; } if (product.Contains("new_subcatelog") && product["new_subcatelog"] != null) { res_product.SubCatalog = product.FormattedValues["new_subcatelog"]; } if (product.Contains("new_additionalcatelog") && product["new_additionalcatelog"] != null) { res_product.AdditionalCatalog = product.FormattedValues["new_additionalcatelog"]; } res_product.ProductDescription = product.GetAttributeValue <string>("description"); res_product.ProductCreatedon = product.GetAttributeValue <DateTime>("createdon").ToLocalTime().ToString("yyyyMMddHHmmss"); products.Add(res_product); } } catch (Exception ex) { log.Info(ex + "--" + ex.Message + "--" + ex.ToString()); } return(products); }
public AppCrmProduct AppGetProductById(String productId) { log.Info("AppGetProductById:" + productId); CrmUtil cu = new CrmUtil(); OrganizationServiceProxy organizationProxy = cu.getCrmService(); AppCrmProduct res_product = new AppCrmProduct(); try { //Update Account TradeRegistration Entity product = new Entity("product"); ColumnSet attributes = new ColumnSet(true); product = organizationProxy.Retrieve(product.LogicalName, new Guid(productId), attributes); res_product.ProductName = product.GetAttributeValue <string>("productnumber"); res_product.ProductSku = product.GetAttributeValue <string>("name"); res_product.Brand = product.GetAttributeValue <string>("suppliername"); res_product.Quantity = product.GetAttributeValue <decimal>("quantityonhand").ToString("#.##"); res_product.PictureList = product.GetAttributeValue <string>("new_picturelist"); if (product.Contains("price") && product["price"] != null) { res_product.ListPrice = product.GetAttributeValue <Money>("price").Value.ToString("#.##"); } if (product.Contains("new_rrp") && product["new_rrp"] != null) { res_product.RRP = product.GetAttributeValue <Money>("new_rrp").Value.ToString("#.##"); } res_product.ProductColor = product.GetAttributeValue <string>("new_colour"); res_product.ProductBarcode = product.GetAttributeValue <string>("new_productbarcode"); res_product.ProductDimensions = product.GetAttributeValue <string>("new_size"); res_product.ProductWeight = product.GetAttributeValue <string>("new_productweight"); res_product.IdenticalUnitPerCase = product.GetAttributeValue <string>("new_casequantity"); res_product.CaseBarcode = product.GetAttributeValue <string>("new_casebarcode"); res_product.CaseDimensions = product.GetAttributeValue <string>("new_casedimensions"); res_product.CaseWeight = product.GetAttributeValue <string>("new_caseweight"); res_product.CTNDetails = product.GetAttributeValue <string>("new_ctndetails"); if (product.Contains("new_parentcatalog") && product["new_parentcatalog"] != null) { res_product.ParentCatalog = product.FormattedValues["new_parentcatalog"]; } if (product.Contains("new_subcatelog") && product["new_subcatelog"] != null) { res_product.SubCatalog = product.FormattedValues["new_subcatelog"]; } if (product.Contains("new_additionalcatelog") && product["new_additionalcatelog"] != null) { res_product.AdditionalCatalog = product.FormattedValues["new_additionalcatelog"]; } res_product.ProductDescription = product.GetAttributeValue <string>("description"); res_product.ProductCreatedon = product.GetAttributeValue <DateTime>("createdon").ToLocalTime().ToString("yyyyMMddHHmmss"); //EntityReference subject = (EntityReference)product["subjectid"]; //res_product.ProductCategory = subject.Name; //res_product.ProductPrice = ((Money)product["new_rrp"]).Value.ToString(); } catch (Exception ex) { log.Info(ex.Message + "--" + ex.ToString()); } return(res_product); }