Send email through cdosys

using System;

namespace CdoSys
{
 class Class1
 {
  static void Main(string[] args)
  {
   try 
   {   
    CDO.Message oMsg = new CDO.Message();
    CDO.IConfiguration iConfg; 

    iConfg = oMsg.Configuration;

    ADODB.Fields oFields;
    oFields = iConfg.Fields;       

    // Set configuration.
    ADODB.Field oField = oFields["http://schemas.microsoft.com/cdo/configuration/sendusing"];
                        
    //TODO: To send by using the smart host, uncomment the following lines:
    //oField.Value = CDO.CdoSendUsing.cdoSendUsingPort;
    //oField = oFields["http://schemas.microsoft.com/cdo/configuration/smtpserver"];
    //oField.Value = "smarthost";

    // TODO: To send by using local SMTP service. 
    //oField = oFields["http://schemas.microsoft.com/cdo/configuration/sendusing"];
    //oField.Value = 1;  

    oFields.Update();

    // Set common properties from message.

    //TODO: To send text body, uncomment the following line: 
    //oMsg.TextBody = "Hello, how are you doing?";
   

    //TODO: To send HTML body, uncomment the following lines:
    //String sHtml;
    //sHtml = "\n" + 
    // "\n" +
    // "\n" +
    // "\n" +
    // "
\n" + 
    // "
Inline graphics
\n" +
    // "\n" + 
    // "";
    //oMsg.HTMLBody = sHtml;

    //TOTO: To send WEb page in an e-mail, uncomment the following lines and make changes in TODO section.
    //TODO: Replace with your preferred Web page
    //oMsg.CreateMHTMLBody("http://www.microsoft.com",
    // CDO.CdoMHTMLFlags.cdoSuppressNone, 
    // "", ""); 
    oMsg.Subject = "Test SMTP";  

    //TODO: Change the To and From address to reflect your information.                       
    oMsg.From = "someone@example.com";
    oMsg.To = "someone@example.com";
    //ADD attachment.
    //TODO: Change the path to the file that you want to attach.
    oMsg.AddAttachment("C:\\Hello.txt", "", "");
    oMsg.AddAttachment("C:\\Test.doc", "", "");
                                    oMsg.Send();
   }
   catch (Exception e)
   {
    Console.WriteLine("{0} Exception caught.", e);
   }
   return;
  }
 }
}

Retrieve the Roles for a User

This sample shows how to build a QueryExpression to for use with RetrieveMultiple to find all the roles for a user. To do this, you have to build a query for roles where you join 'role' to 'systemuserroles', and then join systemuserroles' to 'systemuser' and add a condition where systemuser.systemuserid equals the attribute UserId.

    // Retrieve the GUID of the logged on user.
WhoAmIRequest whoReq = new WhoAmIRequest();
WhoAmIResponse whoResp = (WhoAmIResponse) service.Execute(whoReq);
Guid userid = whoResp.UserId;

// Create a QueryExpression.
QueryExpression qe = new QueryExpression();
qe.EntityName = "role";
// Be aware that using AllColumns may adversely affect
// performance and cause unwanted cascading in subsequent 
// updates. A best practice is to retrieve the least amount of 
// data required.
qe.ColumnSet = new AllColumns();

// Set up the join between the role entity
// and the intersect table systemuserroles.
LinkEntity le = new LinkEntity();
le.LinkFromEntityName = "role";
le.LinkFromAttributeName = "roleid";
le.LinkToEntityName = "systemuserroles";
le.LinkToAttributeName = "roleid";

// Set up the join between the intersect table
// systemuserroles and the systemuser entity.
LinkEntity le2 = new LinkEntity();
le2.LinkFromEntityName = "systemuserroles";
le2.LinkFromAttributeName = "systemuserid";
le2.LinkToEntityName = "systemuser";
le2.LinkToAttributeName = "systemuserid";

// The condition is to find the user ID.
ConditionExpression ce = new ConditionExpression();
ce.AttributeName = "systemuserid";
ce.Operator = ConditionOperator.Equal;
ce.Values = new object[]{userid};

le2.LinkCriteria = new FilterExpression();
le2.LinkCriteria.Conditions = new ConditionExpression[]{ce};

le.LinkEntities = new LinkEntity[]{le2};
qe.LinkEntities = new LinkEntity[]{le};

// Execute the query.
BusinessEntityCollection bec = service.RetrieveMultiple(qe);                                    
                 

Retrieve the Metadata

This sample shows how to use the MetadataService Web Service. It creates an XML file that provides a snapshot of the database using the Metadata APIs. All relationships and attributes for all of the entities are retrieved.

  
using System;
using System.Xml.Serialization;
using System.Xml;
using System.IO;

using Microsoft.Crm.Sdk.Utility;
using CrmSdk;
using MetadataServiceSdk;

namespace Microsoft.Crm.Sdk.HowTo
{
   /// 

   /// This sample shows how to retrieve all the metadata and write it to a file.
   /// 
   public class HowToMetaData
   {
      static void Main(string[] args)
      {
         // TODO: Change the server URL and Organization to match your CRM Server and CRM Organization
         HowToMetaData.Run("http://localhost:5555", "CRM_SDK");
      }

      public static bool Run(string crmServerUrl, string orgName)
      {
         // Standard MetaData Service Setup
         MetadataService service = CrmServiceUtility.GetMetadataService(crmServerUrl, orgName);

         #region Setup Data Required for this Sample

         bool success = false;

         #endregion

         try
         {
            // Retrieve the Metadata
            RetrieveAllEntitiesRequest request = new RetrieveAllEntitiesRequest();
            request.MetadataItems = MetadataItems.All;
            RetrieveAllEntitiesResponse metadata = (RetrieveAllEntitiesResponse)service.Execute(request);
            
   
            // Create an instance of StreamWriter to write text to a file.
            // The using statement also closes the StreamWriter.
            using (StreamWriter sw = new StreamWriter("testfile.xml")) 
            {
               // Create Xml Writer.
               XmlTextWriter metadataWriter = new XmlTextWriter(sw);

               // Start Xml File.
               metadataWriter.WriteStartDocument();

               // Metadata Xml Node.
               metadataWriter.WriteStartElement("Metadata");
               
               AttributeMetadata currentAttribute;// Declared outside of loop
   
               // Iterate through all entities and add their attributes and relationships to the file.
               foreach(EntityMetadata currentEntity in metadata.CrmMetadata)
               {
                  // Start Entity Node
                  metadataWriter.WriteStartElement("Entity");
               
                  // Write the Entity's Information.
                  metadataWriter.WriteElementString("Name", currentEntity.LogicalName);
                  
                  if (currentEntity.DisplayName.UserLocLabel != null)
                  {
                     metadataWriter.WriteElementString("DisplayName", currentEntity.DisplayName.UserLocLabel.Label);
                  }
                  else
                  {
                     metadataWriter.WriteElementString("DisplayName", "[NONE]");
                  }
                  
                  if (currentEntity.DisplayCollectionName.UserLocLabel != null)
                  {
                     metadataWriter.WriteElementString("DisplayCollectionName", currentEntity.DisplayCollectionName.UserLocLabel.Label);
                  }
                  else
                  {
                     metadataWriter.WriteElementString("DisplayCollectionName", "[NONE]");
                  }
                  
                  metadataWriter.WriteElementString("IsCustomEntity", currentEntity.IsCustomEntity.ToString());
                  metadataWriter.WriteElementString("IsCustomizable", currentEntity.IsCustomizable.ToString());
                  metadataWriter.WriteElementString("ReportViewName", currentEntity.ReportViewName);
                  metadataWriter.WriteElementString("PrimaryField", currentEntity.PrimaryField);
                  metadataWriter.WriteElementString("PrimaryKey", currentEntity.PrimaryKey);
               
                  #region Attributes

                  // Write Entity's Attributes.
                  metadataWriter.WriteStartElement("Attributes");

                  for (int j = 0; j < currentEntity.Attributes.Length; j++)
                  {
                     // Get Current Attribute.
                     currentAttribute = currentEntity.Attributes[j];
                     // Start Attribute Node
                     metadataWriter.WriteStartElement("Attribute");

                     // Write Attribute's information.
                     metadataWriter.WriteElementString("Name", currentAttribute.LogicalName);
                     metadataWriter.WriteElementString("Type", currentAttribute.AttributeType.ToString());
                     
                     if (currentAttribute.DisplayName.UserLocLabel != null)
                     {
                        metadataWriter.WriteElementString("DisplayName", currentAttribute.DisplayName.UserLocLabel.Label);
                     }
                     else
                     {
                        metadataWriter.WriteElementString("DisplayName", "[NONE]");
                     }
                     
                     metadataWriter.WriteElementString("Description", currentAttribute.IsCustomField.ToString());
                     metadataWriter.WriteElementString("IsCustomField", currentAttribute.IsCustomField.ToString());
                     metadataWriter.WriteElementString("RequiredLevel", currentAttribute.RequiredLevel.ToString());
                     metadataWriter.WriteElementString("ValidForCreate", currentAttribute.ValidForCreate.ToString());
                     metadataWriter.WriteElementString("ValidForRead", currentAttribute.ValidForRead.ToString());
                     metadataWriter.WriteElementString("ValidForUpdate", currentAttribute.ValidForUpdate.ToString()); 

                     // Write the Default Value if it is set.
                     if (currentAttribute.DefaultValue != null)
                     {
                        metadataWriter.WriteElementString("DefualtValue", currentAttribute.DefaultValue.ToString());
                     }

                     // Write the Description if it is set.
                     if (currentAttribute.Description != null &&
                        currentAttribute.Description.UserLocLabel != null)
                     {
                        metadataWriter.WriteElementString("Description", currentAttribute.Description.UserLocLabel.Label);
                     }

                  
                     // Write Type Specific Attribute Information using helper functions.
                  
                     Type attributeType = currentAttribute.GetType();

                     if (attributeType == typeof(DecimalAttributeMetadata))
                     {
                        writeDecimalAttribute((DecimalAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(FloatAttributeMetadata))
                     {
                        writeFloatAttribute((FloatAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(IntegerAttributeMetadata))
                     {
                        writeIntegerAttribute((IntegerAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(MoneyAttributeMetadata))
                     {
                        writeMoneyAttribute((MoneyAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(PicklistAttributeMetadata))
                     {
                        writePicklistAttribute((PicklistAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(StateAttributeMetadata))
                     {
                        writeStateAttribute((StateAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(StatusAttributeMetadata))
                     {
                        writeStatusAttribute((StatusAttributeMetadata)currentAttribute, metadataWriter);
                     }
                     else if (attributeType == typeof(StringAttributeMetadata))
                     {
                        writeStringAttribute((StringAttributeMetadata)currentAttribute, metadataWriter);
                     }

                     // End Attribute Node
                     metadataWriter.WriteEndElement();

                  }
                  // End Attributes Node
                  metadataWriter.WriteEndElement();

                  #endregion

                  #region References From

                  metadataWriter.WriteStartElement("OneToMany");

                  // Get Current ReferencesFrom
                  foreach (OneToManyMetadata currentRelationship in currentEntity.OneToManyRelationships)
                  {
                     // Start ReferencesFrom Node
                     metadataWriter.WriteStartElement("From");                            
                     metadataWriter.WriteElementString("Name", currentRelationship.SchemaName);
                      metadataWriter.WriteElementString("IsCustomRelationship", currentRelationship.IsCustomRelationship.ToString());
                     metadataWriter.WriteElementString("ReferencedEntity", currentRelationship.ReferencedEntity);
                     metadataWriter.WriteElementString("ReferencingEntity", currentRelationship.ReferencingEntity);
                     metadataWriter.WriteElementString("ReferencedAttribute", currentRelationship.ReferencedAttribute);
                     metadataWriter.WriteElementString("ReferencingAttribute", currentRelationship.ReferencingAttribute);
               
                     // End ReferencesFrom Node
                     metadataWriter.WriteEndElement();
                  }

                  metadataWriter.WriteEndElement();

                  #endregion

                  #region References To

                  metadataWriter.WriteStartElement("ManyToOne");

                  foreach (OneToManyMetadata currentRelationship in currentEntity.ManyToOneRelationships)
                  {
                     // Start ReferencesFrom Node
                     metadataWriter.WriteStartElement("To");
                     metadataWriter.WriteElementString("Name", currentRelationship.SchemaName);
                     metadataWriter.WriteElementString("IsCustomRelationship", currentRelationship.IsCustomRelationship.ToString());
                     metadataWriter.WriteElementString("ReferencedEntity", currentRelationship.ReferencedEntity);
                     metadataWriter.WriteElementString("ReferencingEntity", currentRelationship.ReferencingEntity);
                     metadataWriter.WriteElementString("ReferencedAttribute", currentRelationship.ReferencedAttribute);
                     metadataWriter.WriteElementString("ReferencingAttribute", currentRelationship.ReferencingAttribute);
               
                     // End ReferencesFrom Node
                     metadataWriter.WriteEndElement();
                  }

                  metadataWriter.WriteEndElement();

                  #endregion

                  // End Entity Node
                  metadataWriter.WriteEndElement();
               }

               // End Metadata Xml Node
               metadataWriter.WriteEndElement();
               metadataWriter.WriteEndDocument();

               // Close xml writer.
               metadataWriter.Close();
            }

            #region check success

            if (metadata.CrmMetadata.Length > 0)
            {
               success = true;
            }

            #endregion
         }
         catch (System.Web.Services.Protocols.SoapException)
         {
            // Add your error handling code here.
         }

         return success;
      }


      #region Specific Attribute Helper Functions
      
      // Writes the Decimal Specific Attributes
      private static void writeDecimalAttribute (DecimalAttributeMetadata attribute, XmlTextWriter writer)
      {
         writer.WriteElementString("MinValue", attribute.MinValue.ToString());
         writer.WriteElementString("MaxValue", attribute.MaxValue.ToString());
         writer.WriteElementString("Precision", attribute.Precision.ToString());
      }

      // Writes the Float Specific Attributes
      private static void writeFloatAttribute (FloatAttributeMetadata attribute, XmlTextWriter writer)
      {
         writer.WriteElementString("MinValue", attribute.MinValue.ToString());
         writer.WriteElementString("MaxValue", attribute.MaxValue.ToString());
         writer.WriteElementString("Precision", attribute.Precision.ToString());
      }

      // Writes the Integer Specific Attributes
      private static void writeIntegerAttribute (IntegerAttributeMetadata attribute, XmlTextWriter writer)
      {
         writer.WriteElementString("MinValue", attribute.MinValue.ToString());
         writer.WriteElementString("MaxValue", attribute.MaxValue.ToString());
      }

      // Writes the Money Specific Attributes
      private static void writeMoneyAttribute (MoneyAttributeMetadata attribute, XmlTextWriter writer)
      {
         writer.WriteElementString("MinValue", attribute.MinValue.ToString());
         writer.WriteElementString("MaxValue", attribute.MaxValue.ToString());
         writer.WriteElementString("Precision", attribute.Precision.ToString());
      }

      // Writes the Picklist Specific Attributes
      private static void writePicklistAttribute (PicklistAttributeMetadata attribute, XmlTextWriter writer)
      {
         // Writes the picklist's options
         writer.WriteStartElement("Options");
      
         // Writes the attributes of each picklist option
         for (int i = 0; i < attribute.Options.Length; i++)
         {
            writer.WriteStartElement("Option");
            writer.WriteElementString("OptionValue", attribute.Options[i].Value.ToString());
            writer.WriteElementString("Description", attribute.Options[i].Label.UserLocLabel.Label);
            writer.WriteEndElement();
         }

         writer.WriteEndElement();
      }

      // Writes the State Specific Attributes
      private static void writeStateAttribute (StateAttributeMetadata attribute, XmlTextWriter writer)
      {
         // Writes the state's options
         writer.WriteStartElement("Options");
      
         // Writes the attributes of each picklist option
         for (int i = 0; i < attribute.Options.Length; i++)
         {
            writer.WriteStartElement("Option");
            writer.WriteElementString("OptionValue", attribute.Options[i].Value.ToString());
            writer.WriteElementString("Description", attribute.Options[i].Label.UserLocLabel.Label);
            writer.WriteElementString("DefaultStatus", attribute.Options[i].DefaultStatus.ToString());
            writer.WriteEndElement();
         }

         writer.WriteEndElement();
      }

      // Writes the Status Specific Attributes
      private static void writeStatusAttribute (StatusAttributeMetadata attribute, XmlTextWriter writer)
      {
         // Writes the status's options
         writer.WriteStartElement("Options");
      
         // Writes the attributes of each picklist option
         for (int i = 0; i < attribute.Options.Length; i++)
         {
            writer.WriteStartElement("Option");
            writer.WriteElementString("OptionValue", attribute.Options[i].Value.ToString());
            writer.WriteElementString("Description", attribute.Options[i].Label.UserLocLabel.Label);
            writer.WriteElementString("State", attribute.Options[i].State.ToString());
            writer.WriteEndElement();
         }

         writer.WriteEndElement();
      }

      // Writes the String Specific Attributes
      private static void writeStringAttribute (StringAttributeMetadata attribute, XmlTextWriter writer)
      {
         writer.WriteElementString("MaxLength", attribute.MaxLength.ToString());
      }
      #endregion
   }
}