SODEVE

Oxford United secured their place back in the Football League after a four-year absence with victory over York at rain-lashed Wembley.

Two goals in the space of five first-half minutes put the U’s in charge, Matt Green firing them in front from 18 yards with a neat half-volley.

James Constable doubled their lead with a fierce left-foot drive.

U’s keeper Ryan Clarke fumbled in Ben Purkiss’s cross to give York a lifeline only for Alfie Potter to wrap it up.
Given that Oxford finished third in the Blue Square Premier, eight points clear of York, after topping the league for so much of the season, it was perhaps fitting that they went up.

It was certainly a much better experience of the play-offs for U’s boss Chris Wilder, whose Halifax side lost to Hereford in the 2006 final.

Read the complete story

I followed the game Live Report on BBC and wanted to post earlier. But too bad no good clips found on YouTube. And now that I found it, I will put it here for me to view over and over The DVD of the match is coming soon.

I needed to retrieve list of active users with email address from Active Directory. After scratching head, and googling for a while, the following page helped me immensely:

• How do I get “lastLogon” from ActiveDirectory
• Howto: (Almost) Everything In Active Directory via C#

Note: You need to include Active DS COM Library in your project references. Your project references should roughly similar to the picture on the left.

Here are teh codez:

using System;
using System.Collections.Generic;
using System.Text;
using System.DirectoryServices;
using System.DirectoryServices.ActiveDirectory;
using System.IO;

namespace ActiveDirectoryQuery
{
    class Program
    {
        static void Main(string[] args)
        {
            DirectorySearcher ds = new DirectorySearcher();
            ds.SearchRoot = new DirectoryEntry("");
            ds.Filter = "objectCategory=user";
            ds.PropertiesToLoad.Add("name");
            ds.PropertiesToLoad.Add("email");
            ds.PropertyNamesOnly = true;
            ds.Sort = new SortOption("name", SortDirection.Ascending);
            SearchResultCollection results = ds.FindAll();

            //Write output
            StreamWriter writer = new StreamWriter(@"c:\ad.output.txt");        

            foreach (SearchResult sr in results)
            {
                DirectoryEntry entry = sr.GetDirectoryEntry();
                if (entry.Properties["name"].Value != null && entry.Properties["mail"].Value != null && entry.Properties["accountExpires"].Value != null)
                {
                    //Must Add COM Active DS Library in the reference (ActiveDS.TLB)
                    ActiveDs.LargeInteger li = (ActiveDs.LargeInteger)entry.Properties["accountExpires"].Value;
                    Int64 liTicks = li.HighPart * 0x100000000 + li.LowPart;
                    Int64 curTicks = DateTime.Now.Ticks;

                    //List only those account with no expiration/expired in the future
                    if (liTicks == 0 || liTicks > curTicks)
                    {
                        writer.Write(entry.Properties["name"].Value + ";" + entry.Properties["mail"].Value);
                        writer.WriteLine();
                        writer.Flush();
                    }
                }               

            }
            writer.Close();
        }
    }
}

I am currently doing a project utilizing NHibernate to connect to a legacy Oracle DB. Everything was nice and easy until I hit this problem. I need to retrieve a particular information, but to do this I must connect a number of tables. This means I need to create more persistent classes, more mapping files, which is sucks because I can actually just execute a stored function and get what I need.

So after scratching my head for quite sometimes, I found out that the solution was quite simple.

Using sessFact As ISessionFactory = CreateSessionFactory()
   Using sess As ISession = sessFact.OpenSession()
      Using transact As ITransaction = sess.BeginTransaction()
         '....
         Dim con As IDbConnection = sess.Connection
         Dim cmd As IDbCommand = con.CreateCommand()
         sess.Transaction.Enlist(cmd)
         cmd.CommandText = "select MyPackageName.MyFunction(" & myFunctionParam & ") from dual"
         dim objResult as Objetc = cmd.ExecuteScalar()
         '.....
      End Using
   End Using
End Using

I know this is not the right way, but I need to make compromise considering that this is a legacy database.