C#

Member 1439977 wrote:

Has anyone seen this type of problem?

SomeCommand.CommandText = @"
SELECT *
  FROM Bla
 WHERE SomeDate BETWEEN @StartDate AND @EndDate";
SomeCommand.Parameters.AddWithValue("@StartDate", DateTime.Now);
SomeCommand.Parameters.AddWithValue("@EndDate", DateTime.Now.AddDays(-30));

Bastard Programmer from Hell

string filter = " (Date >= #" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "# And Date <= #" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "# ) ";

Font font = new Font("Verdana", 12.0F);
private void myPanel_Paint(object sender, PaintEventArgs e)
    {
    Graphics g = e.Graphics;
    g.DrawString("Hello", font, Brushes.Black, 10, 10);
    Matrix m = new Matrix();
    m.Scale(2, 1);
    g.Transform = m;
    g.DrawString("Hello", font, Brushes.Black, 10, 30);
    g.ResetTransform();
    m = new Matrix();
    m.Scale(1.5F, 1);
    g.Transform = m;
    g.DrawString("Hello", font, Brushes.Black, 10, 60);
    g.ResetTransform();
    }

turbosupramk3 wrote:

a unique identifier

turbosupramk3 wrote:

get all of the account related objects for that account.

turbosupramk3 wrote:

An example would be first name, last name, phone, email, any status codes/custom
attributes, etc.

using (var rootDirectory = new DirectoryEntry("LDAP://[Server IP or Host name]", "[user name in the directory]", "[User Password]")) {
           using (var directorySearch = new DirectorySearcher(rootDirectory)) {
              // your filter should be an LDAP Query, the one i put in the sample look a matching name or sAMAccountName
              directorySearch.Filter = string.Format("(|(sAMAccountName={0})(name={0}))", "[User Name you want or account you want]");
              // you can add non standard properties to your query:
              // some samples are "memberOf" for getting all groups the entry you want are related to (1 level up only)
              // or "member" for all members of a group (1 level down only
              directorySearch.PropertiesToLoad.Add("[Name of the property you want, exactly as it appears in the AD]");

              // return an entry if there's a match
              var result = directorySearch.FindOne();

              if (result != null) {
                 // by the search result, get the associated directory entry, as the result object can be complex to work with.
                 var directoryEntry = result.GetDirectoryEntry();

                 // Note that entries contain between 40-60 properties by default, plus whatever properties you asked to load
                 // in the directory search, as long as your domain admin did not restrict access to them
                 // (in which case the root user you used to start this chain need to have permissions to read those properties)
                 var propertyIwant = directoryEntry.Properties["Name of the property you want"];
              }
           }
        }

using (var rootDirectory = new DirectoryEntry("LDAP://" + domain))//, "[user name in the directory]", "[User Password]"))
                    {
                        using (var directorySearch = new DirectorySearcher(rootDirectory))
                        {
                            if (tBoxPin.Text != "")
                            {
                                directorySearch.Filter = string.Format("(|(sAMAccountName={0}))", tBoxPin.Text);
                            }
                            if (tBoxLastName.Text != "")
                            {
                                directorySearch.Filter = string.Format("((sn={0}))", tBoxLastName.Text);

                            }
                            if (tBoxEmail.Text != "")
                            {
                                directorySearch.Filter = string.Format("((mail={0}))", tBoxEmail.Text);
                            }

                            var result = directorySearch.FindOne();

                            if (tBoxLastName.Text != "")
                            {
                                SearchResultCollection searchResults = directorySearch.FindAll();
                                foreach (SearchResult searchResult in searchResults)
                                {
                                    foreach (string propertyKey in searchResult.Properties.PropertyNames)
                                    {
                                        ResultPropertyValueCollection valueCollection = searchResult.Properties[propertyKey];
                                        ResultPropertyValueCollection accountCollection = searchResult.Properties["userprincipalname"];
                                        foreach (Object propertyValue in valueCollection)
                                        {
                                            if (propertyKey == "name")
                                            {
                                                lastNames.Add(propertyValue.ToString());
                                                if (tBoxLastName.Text != "")
                                                {
                                                    tBoxDomains.Text += (propertyValue.ToString()) + " - ";
                                                    foreach (Object account in accountCollection)
                                                    {
                                                        tBoxDomains.Text += account.ToString() + System.Environment.NewLine;
                                                        //MessageBox.Show(account.ToString());
                                                    }
                                                }
                                            }
                                        }

                                        //ResultPropertyValueCollection valueCollection = searchResult.Properties["name"];
                                        //lastNames.Add(item);
                                    }
                                }
                            }


                            //foreach (SearchResult item in searchResults)
                            //{
                            //    tBoxDomains.Text += item.Properties.PropertyNames + System.Environment.NewLine;
                            //}

                            if (lastNames.Count > 1)
                            {
                                return;
                            }

                            if (result != null)
                            {
                                DirectoryEntry myDirectoryEntry = result.GetDirectoryEntry();

                                ResultPropertyCollection myResultPropColl;
                                myResultPropColl = result.Properties;

                                foreach (string myKey in myResultPropColl.PropertyNames)
                                {

                                    if ((myKey == "samaccountname"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            tBoxPin.Text = (myCollection.ToString());
                                        }
                                    }

                                    if ((myKey == "name"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            tBoxLastName.Text = (myCollection.ToString());
                                        }
                                    }

                                    if ((myKey == "mail"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            tBoxEmail.Text = (myCollection.ToString());
                                        }
                                    }

                                    if ((myKey == "name"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            tBoxTopSecret.Text = (myCollection.ToString().ToUpper());
                                        }
                                    }

                                    if ((myKey == "homemdb"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            int delimiter = myCollection.ToString().IndexOf(",");
                                            string trimmed = myCollection.ToString();
                                            trimmed = trimmed.Remove(delimiter);
                                            trimmed = trimmed.Replace("CN=", "");
                                            tBoxExchangeServer.Text = (trimmed);
                                        }
                                    }

                                    if ((myKey == "telephonenumber"))
                                    {
                                        foreach (Object myCollection in myResultPropColl[myKey])
                                        {
                                            tBoxPhone.Text = (myCollection.ToString());
                                        }
                                    }
                                }
                            }
                        }
                    }