コード例 #1
0
        private void ExchangeContactsBtn_Click(object sender, EventArgs e)
        {
            var con = new SqlConnection("Data Source=192.160.0.120;Initial Catalog=zeebregtsdb;User ID=daan;Password=Bl22sk22k!");

            con.Open();
            SqlCommand command = new SqlCommand(@"SELECT persoon.voornaam,persoon.tussenvoegsel,persoon.achternaam,
                                                persoon.zaemail,persoon.telefoon_nr_1,persoon.telefoon_nr_2,
                                                persoon.telefoon_nr_3, persoon.telefoon_nr_settings, bedrijf.naam
                                                FROM persoon  INNER JOIN
                                                bedrijf ON persoon.bedrijf_nr = bedrijf.bedrijf_nr
                                                WHERE persoon.NIETactief = 'FALSE' ", con);
            var        reader  = command.ExecuteReader();

            var service = ExchangeComs.EWSFunctions.GetNewServiceHook();



            while (reader.Read())
            {
                try
                {
                    var cont = new ExchangeComs.ExchangeContactItem();

                    cont.Voornaam = reader[0] != null?String.IsNullOrEmpty(reader[0].ToString()) == false ? reader[0].ToString() : "" : "";

                    cont.Tussenvoegsel = reader[1] != null?String.IsNullOrEmpty(reader[1].ToString()) == false ? reader[1].ToString() : "" : "";

                    cont.Achternaam = reader[2] != null?String.IsNullOrEmpty(reader[2].ToString()) == false ? reader[2].ToString() : "" : "";

                    cont.Email1 = reader[3] != null?String.IsNullOrEmpty(reader[3].ToString()) == false ? reader[3].ToString() : "" : "";  // reader[12].ToString();

                    cont.TelNr1 = reader[4] != null?String.IsNullOrEmpty(reader[4].ToString()) == false ? reader[4].ToString() : "" : "";  //reader[20].ToString();

                    cont.TelNr2 = reader[5] != null?String.IsNullOrEmpty(reader[5].ToString()) == false ? reader[5].ToString() : "" : "";

                    cont.TelNr3 = reader[6] != null?String.IsNullOrEmpty(reader[6].ToString()) == false ? reader[6].ToString() : "" : "";

                    cont.BedrijfNaam = reader[8] != null?String.IsNullOrEmpty(reader[8].ToString()) == false ? reader[8].ToString() : "" : "";

                    //var contactId = ExchangeComs.EWSFunctions.FindContact(service, achternaam + "," + voornaam);
                    //if (contactId.ToString() != "0")
                    //{
                    //    ExchangeComs.EWSFunctions.DeleteContact(service, contactId);
                    //}
                    ExchangeComs.EWSFunctions.MakeNewContact(service, cont);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
        }
コード例 #2
0
        public static void MakeNewContact(Microsoft.Exchange.WebServices.Data.ExchangeService service, ExchangeContactItem contactinfo)
        {
            var     f_id    = FindFolder(service);
            Contact contact = new Contact(service);

            Console.WriteLine("Making new contact: " + contactinfo.Achternaam + "," + contactinfo.Voornaam);
            // Specify the name and how the contact should be filed.
            contact.GivenName     = String.IsNullOrEmpty(contactinfo.Voornaam) == false ? contactinfo.Voornaam : "";
            contact.MiddleName    = String.IsNullOrEmpty(contactinfo.Tussenvoegsel) == false ? contactinfo.Tussenvoegsel : "";
            contact.Surname       = String.IsNullOrEmpty(contactinfo.Achternaam) == false ? contactinfo.Achternaam : "";
            contact.FileAsMapping = FileAsMapping.SurnameCommaGivenName;

            // Specify the company name.
            contact.CompanyName = String.IsNullOrEmpty(contactinfo.BedrijfNaam) == false ? contactinfo.BedrijfNaam : "";

            // Specify the business, home, and car phone numbers.
            var phone1type = PhoneNumberKey.PrimaryPhone;
            var phone2type = PhoneNumberKey.MobilePhone;
            var phone3type = PhoneNumberKey.BusinessPhone;

            if (!String.IsNullOrEmpty(contactinfo.TelNrTypes))
            {
                var sets = contactinfo.TelNrTypes.Split(',');
                var nr1  = int.Parse(sets[0].Substring(0, 1));
                var nr2  = int.Parse(sets[1].Substring(0, 1));
                var nr3  = int.Parse(sets[2].Substring(0, 1));
                if (nr2 == nr1)
                {
                    nr2 = 6;
                }
                if (nr3 == nr2 || nr3 == nr1)
                {
                    nr3 = 7;
                }

                phone1type = ConvertTelTypes(nr1);
                phone2type = ConvertTelTypes(nr2);
                phone3type = ConvertTelTypes(nr3);
            }

            contact.PhoneNumbers[phone1type] = String.IsNullOrEmpty(contactinfo.TelNr1) == false ? contactinfo.TelNr1 : "";
            contact.PhoneNumbers[phone2type] = String.IsNullOrEmpty(contactinfo.TelNr2) == false ? contactinfo.TelNr2 : "";
            contact.PhoneNumbers[phone3type] = String.IsNullOrEmpty(contactinfo.TelNr3) == false ? contactinfo.TelNr3 : "";

            // Specify email addresses.
            contact.EmailAddresses[EmailAddressKey.EmailAddress1] = new EmailAddress(String.IsNullOrEmpty(contactinfo.Email1) == false ? contactinfo.Email1 : "*****@*****.**");


            //functie
            contact.JobTitle = String.IsNullOrEmpty(contactinfo.Functie) == false ? contactinfo.Functie : "";
            // Save the contact.
            contact.Save(f_id);
        }
コード例 #3
0
        public static void UpdateContact(Microsoft.Exchange.WebServices.Data.ExchangeService service, ItemId contactUniId, ExchangeContactItem contactinfo)
        {
            // Bind to an existing meeting request by using its unique identifier.
            Contact contact = Contact.Bind(service, contactUniId);

            // Specify the name and how the contact should be filed.
            if (String.IsNullOrEmpty(contactinfo.Voornaam) == false && contact.GivenName != contactinfo.Voornaam)
            {
                contact.GivenName = contactinfo.Voornaam;
            }
            if (String.IsNullOrEmpty(contactinfo.Tussenvoegsel) == false && contact.MiddleName != contactinfo.Tussenvoegsel)
            {
                contact.MiddleName = contactinfo.Tussenvoegsel;
            }
            if (String.IsNullOrEmpty(contactinfo.Achternaam) == false && contactinfo.Achternaam != contact.Surname)
            {
                contact.Surname = contactinfo.Achternaam;
            }

            // Specify the company name.
            if (String.IsNullOrEmpty(contactinfo.BedrijfNaam) == false && contact.CompanyName != contactinfo.BedrijfNaam)
            {
                contact.CompanyName = contactinfo.BedrijfNaam;
            }


            // Specify the phone numbers.

            var phone1type = PhoneNumberKey.PrimaryPhone;
            var phone2type = PhoneNumberKey.MobilePhone;
            var phone3type = PhoneNumberKey.BusinessPhone;

            if (!String.IsNullOrEmpty(contactinfo.TelNrTypes))
            {
                var sets = contactinfo.TelNrTypes.Split(',');
                var nr1  = int.Parse(sets[0]);
                var nr2  = int.Parse(sets[1]);
                var nr3  = int.Parse(sets[2]);
                if (nr2 == nr1)
                {
                    nr2 = 6;
                }
                if (nr3 == nr2 || nr3 == nr1)
                {
                    nr3 = 7;
                }

                phone1type = ConvertTelTypes(nr1);
                phone2type = ConvertTelTypes(nr2);
                phone3type = ConvertTelTypes(nr3);
                if (phone1type == PhoneNumberKey.BusinessFax)
                {
                    contactinfo.TelNr1 = "Fax:" + contactinfo.TelNr1;
                    phone1type         = PhoneNumberKey.Pager;
                }
                if (phone2type == PhoneNumberKey.BusinessFax)
                {
                    contactinfo.TelNr2 = "Fax:" + contactinfo.TelNr2;
                    phone2type         = PhoneNumberKey.Pager;
                }

                if (phone3type == PhoneNumberKey.BusinessFax)
                {
                    contactinfo.TelNr3 = "Fax:" + contactinfo.TelNr3;
                    phone3type         = PhoneNumberKey.Pager;
                }
            }

            if (String.IsNullOrEmpty(contactinfo.TelNr1) == false)
            {
                if (contact.PhoneNumbers.Contains(phone1type) == true)
                {
                    if (contact.PhoneNumbers[phone1type] != contactinfo.TelNr1)
                    {
                        contact.PhoneNumbers[phone1type] = contactinfo.TelNr1;
                    }
                }
                else
                {
                    contact.PhoneNumbers[phone1type] = contactinfo.TelNr1;
                }
            }
            if (String.IsNullOrEmpty(contactinfo.TelNr2) == false)
            {
                if (contact.PhoneNumbers.Contains(phone2type) == true)
                {
                    if (contact.PhoneNumbers[phone2type] != contactinfo.TelNr2)
                    {
                        contact.PhoneNumbers[phone2type] = contactinfo.TelNr2;
                    }
                }
                else
                {
                    contact.PhoneNumbers[phone2type] = contactinfo.TelNr2;
                }
            }
            if (String.IsNullOrEmpty(contactinfo.TelNr3) == false)
            {
                if (contact.PhoneNumbers.Contains(phone3type) == true)
                {
                    if (contact.PhoneNumbers[phone3type] != contactinfo.TelNr3)
                    {
                        contact.PhoneNumbers[phone3type] = contactinfo.TelNr3;
                    }
                }
                else
                {
                    contact.PhoneNumbers[phone3type] = contactinfo.TelNr3;
                }
            }


            // Specify two email addresses.
            contact.EmailAddresses[EmailAddressKey.EmailAddress1] = new EmailAddress(String.IsNullOrEmpty(contactinfo.Email1) == false ? contactinfo.Email1 : "*****@*****.**");

            //save the changes
            contact.Update(ConflictResolutionMode.AlwaysOverwrite);
        }