ITDevSpace - Development Tips & Tricks

C# Runtime Error: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

2012-01-24T15:11:00.001Z

Add <startup> tag to the bottom of app.config file

<?xml version="1.0"?>
<configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>
</configuration>

C# Get server IP address

2012-01-19T11:42:00.001Z

public static string GetIPAddress(string server)
{
    var host = Dns.GetHostEntry(server);
    if(host.AddressList.Length>0)
    {
        return host.AddressList[0].ToString();
    }
    return null;
}

C# T4 Templating Engine

2012-01-12T10:43:00.001Z

VS2010 build in templating engine.

Add new ‘Preprocessed Text Template’ called T4Template.tt to your project that looks like that

<#@ template debug="true" language="C#"#>
<#@ parameter name="FirstName" type="System.String" #>
Now: <#= DateTime.Now.ToString() #>
FirstName: <#= FirstName #>

This is a sample program to run the template

class Program
{
    private static void Main(string[] args)
    {
        var template = new T4Template();
        template.Session = new Dictionary<string, object>();
        template.Session.Add("FirstName", "John");
        template.Initialize();
        Console.WriteLine(template.TransformText());
    }
}

and output

Now: 12/01/2012 10:42:07
FirstName: John

C# Razor Templating Engine

2012-01-12T10:15:00.001Z

Templating engine built upon Microsoft's Razor parsing technology
http://razorengine.codeplex.com/

Add new text file to your project called ‘RazorTemplate.txt’ that looks like that

Hello @Model.Name! Welcome to Razor!

This is a sample program to run the template

class Program
{
    private static void Main()
    {
        var template = File.ReadAllText("RazorTemplate.txt");
        var result = Razor.Parse(template, new {Name = "John"});
        Console.WriteLine(result);
    }
}

and output

Hello John! Welcome to Razor!

another example with custom model

//template
@inherits RazorEngine.Templating.TemplateBase<RazorSample.RazorModel> 
Hello @Model.Name! Welcome to Razor!
//Test
namespace RazorSample
{
    [TestFixture]
    class Tests
    {
        [Test]
        public void Test()
        {
            var template = File.ReadAllText("RazorTemplate.txt");
            var result = Razor.Parse(template, new RazorModel(){Name="John"});
            Console.WriteLine(result);
        }
    }
    public class RazorModel
    {
        public string Name { get; set; }
    }
}

Migrating from Subversion to Mercurial

2011-10-24T11:53:00.001+01:00

This is an alternative way of migrating from SVN to Mercurial using HgSubversion as oppose to using convert extension. It allows you to push changes from local Mercurial repository to both Subversion and Mercurial during the transition period.

Install HgSubversion

hg clone http://bitbucket.org/durin42/hgsubversion/ <local-path>\hgsubversion

Add HgSubversion extension to your main hgrc file

[extensions]
hgsubversion = <local-path>\hgsubversion\hgsubversion

Clone existing subversion repository

hg clone http://<username>@<svn-project-path> <local-project-folder>

Edit project .hgrc file (/hg/.hgrc)

[paths]
default = http://<username>@<hg-remote-project-path>
svn = http://<username>@<svn-project-path>

Create new mercurial project in your remote Hg repository (see Rhodecode)
Pushing the project to remote mercurial repository

hg push

Pushing to subversion

hg push svn

If you’re using mercurial_keyring extension to store Hg passwords and your Svn username is the same as Hg one you need to have the same password for both.

Save window size & position in WPF

2011-10-18T11:29:00.001+01:00

* Right Click on Settings.settings and Open With XML (Text) Editor

* Add Top, Left, Height, Width & WindowState settings

<Settings>
  <Setting Name="Top" Type="System.Double" Scope="User">
    <Value Profile="(Default)">50</Value>
  </Setting>
  <Setting Name="Left" Type="System.Double" Scope="User">
    <Value Profile="(Default)">50</Value>
  </Setting>
  <Setting Name="Height" Type="System.Double" Scope="User">
    <Value Profile="(Default)">800</Value>
  </Setting>
  <Setting Name="Width" Type="System.Double" Scope="User">
    <Value Profile="(Default)">1200</Value>
  </Setting>
  <Setting Name="WindowState" Type="System.Windows.WindowState" Scope="User">
    <Value Profile="(Default)">Normal</Value>
  </Setting>
</Settings>

* Add Settings property to App.xml

<Application.Resources>
    <properties:Settings x:Key="Settings" />
</Application.Resources>

* Add OnExit override to persist the settings when exiting application

protected override void OnExit(ExitEventArgs e)
{
    base.OnExit(e);
    Settings.Default.Save();
}

* Add Top, Left, Height, Width & WindowState bindings to your MainWindow

<Window x:Class="TestApp.MainWindow"
  xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
  Title="MainWindow"
  Top="{Binding Source={StaticResource Settings}, Path=Default.Top, Mode=TwoWay}"
  Left="{Binding Source={StaticResource Settings}, Path=Default.Left, Mode=TwoWay}"
  Width="{Binding Source={StaticResource Settings}, Path=Default.Width, Mode=TwoWay}"
  Height="{Binding Source={StaticResource Settings}, Path=Default.Height, Mode=TwoWay}"
  WindowState="{Binding Source={StaticResource Settings}, Path=Default.WindowState}">

RhodeCode open source HG (Mercurial) server

2011-09-19T10:36:00.001+01:00

Download RhodeCode
* http://rhodecode.org/

Prerequisites
* Install Python 2.5 or later http://www.python.org/download/
* Add to PATH \Python27 and \Python27\Scripts folders
* Install SetupTools http://pypi.python.org/packages/2.7/s/setuptools/

Create \RhodeCode folder

Install RhodeCode
* easy_install rhodecode

Configure RhodeCode
* paster make-config RhodeCode production.ini
* paster setup-app production.ini

Run RhodeCode
* paster serve production.ini

Server is now running here http://localhost:8000

To change default host:port edit production.ini file

More info about installation and setup
http://packages.python.org/RhodeCode/installation.html
http://packages.python.org/RhodeCode/setup.html

C# Deep & Shallow Copy/Clone

2011-09-16T13:31:00.001+01:00

class Program
{
  static void Main(string[] args)
  {
    var parent1 = new Parent() {Id = 1};
    parent1.Children = new List<Child>();
    parent1.Children.Add(new Child() { Name = "One" });
    parent1.Children.Add(new Child() { Name = "Two" });
    var parent2 = new Parent() { Id = 2 };
    parent2.Children = new List<Child>();
    parent2.Children.Add(new Child() { Name = "One" });
    parent2.Children.Add(new Child() { Name = "Two" });
    var parent3 = new Parent() { Id = 3 };
    parent3.Children = new List<Child>();
    parent3.Children.Add(new Child() { Name = "One" });
    parent3.Children.Add(new Child() { Name = "Two" });
    var parentShallowCopy = parent1.ShallowCopy();
    var parentDeepCopy = parent2.DeepCopy();
    var parentDeepClone = parent3.DeepClone();
    Console.WriteLine("ORIGINAL(1) : {0}", parent1);
    Console.WriteLine("SHALLOW COPY: {0}", parentShallowCopy);
    Console.WriteLine("ORIGINAL(2) : {0}", parent2);
    Console.WriteLine("DEEP COPY   : {0}", parentDeepCopy);
    Console.WriteLine("ORIGINAL(3) : {0}", parent3);
    Console.WriteLine("DEEP CLONE  : {0}", parentDeepClone);            
    parentShallowCopy.Children[0].Name = "Zero";
    parentDeepCopy.Children[0].Name = "Zero";
    parentDeepClone.Children[0].Name = "Zero";
    Console.WriteLine("");
    Console.WriteLine("ORIGINAL(1) : {0}", parent1);
    Console.WriteLine("SHALLOW COPY: {0}", parentShallowCopy);
    Console.WriteLine("ORIGINAL(2) : {0}", parent2);
    Console.WriteLine("DEEP COPY   : {0}", parentDeepCopy);
    Console.WriteLine("ORIGINAL(3) : {0}", parent3);
    Console.WriteLine("DEEP CLONE  : {0}", parentDeepClone); 
    Console.ReadLine();
  }
}
[Serializable]
class Parent
{
  public int Id { get; set; }
  public List<Child> Children { get; set; }
  public Parent ShallowCopy()
  {
    return (Parent)this.MemberwiseClone();
  }
  public Parent DeepCopy()
  {
    Parent other = (Parent)this.MemberwiseClone();
    other.Children = new List<Child>();
    this.Children.ForEach(x => other.Children.Add(x.DeepCopy()));            
    return other;
  }
  public override string ToString()
  {
    var sb = new StringBuilder();
    sb.AppendFormat("[Id:{0},Children:[", Id);
    Children.ForEach(x => sb.AppendFormat("{0},", x.ToString()));
    sb.Remove(sb.Length - 1, 1);
    sb.AppendFormat("]]");
    return sb.ToString();
  }
}
[Serializable]
class Child
{
  public string Name { get; set; }
  public override string ToString()
  {
    return string.Format("{0}", Name);
  }
  public Child ShallowCopy()
  {
    return (Child)this.MemberwiseClone();
  }
  public Child DeepCopy()
  {
    return (Child)this.MemberwiseClone();                        
  }
}
//extends classes that are marked [Serializable]
public static class ExtensionMethods
{        
  public static T DeepClone<T>(this T a)
  {
    using (MemoryStream stream = new MemoryStream())
    {
      BinaryFormatter formatter = new BinaryFormatter();
      formatter.Serialize(stream, a);
      stream.Position = 0;
      return (T)formatter.Deserialize(stream);
    }
  }
}

HG Mercurial Quick Setup Tutorial

2011-09-13T11:44:00.001+01:00

Setting up Remote (build in) http server for multiple repositories

* Create Directory Structure

- repo-root
   |- Project1.hg
   |- Project2.hg
   hgweb.config
   run.bat

* Edit hgweb.config as follows

[collections]
repos/ = .

[web]
style = gitweb
push_ssl = false
allow_push = *

* Edit run.bat as follows and run it

hg serve --webdir-conf hgweb.config

Http Server is running on http://localhost:8000/

Setting up Remote Repository

* Create Folder /repo-root/Project1.hg
* Run hg init from within that folder

Setting up Local Repository

* Go to your local project directory /projects
* Clone remote repository locally

hg clone http://localhost:8000/Project1.hg Project1

If you have an existing project and want to push it to remote repository

* Run hg push http://localhost:8000/Project1.hg

Or set default remote repository

* Create file /projects/Project1/.hg/hgrc
* Add this to file

[paths]
default = http://localhost:8000/Project1.hg

* Now you can use hg push

Basic Commands

hg add (schedule files to be added to local repository)
hg commit (add files to local repository)
hg revert (revert changes to last commit)
hg push (push changes from remote repository)
hg pull (get changes from remote repository)

For more info look at Joel Spolsky Hg Init Mercurial Tutorial

Simple XML based C# Database

2011-09-08T14:41:00.001+01:00

public class DatabaseMgr
{
  public Database Database { get; set; }
  private static DatabaseMgr instance;
  private DatabaseMgr() { }
  public static DatabaseMgr Instance
  {
    get
    {
      if (instance == null)
      {
        instance = new DatabaseMgr();
      }
      return instance;
    }
  }
  //use temp path
  private static string PATH = Path.Combine(Path.GetTempPath(), "UserDatabase.xml");
  public void Reload()
  {
    if (File.Exists(PATH))
    {
      XmlSerializer xs = new XmlSerializer(typeof(Database));
      using (TextReader reader = new StreamReader(PATH))
      {
        Database = (Database)xs.Deserialize(reader);
        reader.Close();
      }
    }
    else
    {
      Database = new Database();                
    }
  }
  public void Save()
  {
    XmlSerializer xmlSerializer = new XmlSerializer(typeof(Database));
    using (TextWriter writer = new StreamWriter(PATH))
    {
      xmlSerializer.Serialize(writer, Database);
      writer.Close();
    }
  }
}
[Serializable]
public class Database
{
  public Database()
  {
    Users = new List<User>();            
  }
  [XmlArray]
  [XmlArrayItem(ElementName = "User")]
  public List<User> Users { get; set; }
}
[Serializable]
public class User
{
  [XmlElement]
  public string Name { get; set; }
  [XmlElement]
  public int Age { get; set; }
}
[Test]
public void Test()
{
  DatabaseMgr.Instance.Reload();
  DatabaseMgr.Instance.Database.Users.Add(new User() { Name = "John", Age = 25 });
  DatabaseMgr.Instance.Save();
  foreach (var user in DatabaseMgr.Instance.Database.Users)
  {
    Console.WriteLine("{0}=>{1}",user.Name,user.Age);
  }
}

C# Log4Net configuration for multiple processes with date rolling

2011-08-30T10:00:00.001+01:00

This example uses MinimalLock locking Model to allow multiple processes to write to the same file

<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
  <file value="Log\\MyApp.log"/>
  <appendToFile value="true"/>
  <rollingStyle value="Date"/>
  <datePattern value=".yyyyMMdd"/>
  <maxSizeRollBackups value="7"/>
  <staticLogFileName value="true"/>
  <threshold value="INFO"/>
  <lockingModel type="log4net.Appender.FileAppender+MinimalLock" />                       
  <layout type="log4net.Layout.PatternLayout">
    <conversionPattern value="%d [%t] %-5p %c.%M():%L - %m%n"/>
  </layout>
</appender>

Click here for more detailed post about Log4Net configuration in console apps

C# Send email with embedded image

2011-08-26T11:30:00.001+01:00

string mailserver = "mymailserver";
            
string subject = "Email with picture";
string body = "<html><body><h1>Picture</h1><br><img src=\"cid:Pic1\"></body></html>";
string to = "to@email.com";
string from = "from@email.com";
string imagePath = @"c:\temp\myimage.png";
            
AlternateView view = AlternateView.CreateAlternateViewFromString(body, null, MediaTypeNames.Text.Html);
LinkedResource pic = new LinkedResource(imagePath, MediaTypeNames.Image.Gif);
pic.ContentId = "Pic";
view.LinkedResources.Add(pic);
            
MailMessage m = new MailMessage();
m.AlternateViews.Add(view);
            
m.From = new MailAddress(from);
m.To.Add(new MailAddress(to));
m.Subject = subject;
SmtpClient client = new SmtpClient(mailserver);
client.Send(m);

SQL Delete in batches based on date

2011-08-19T10:30:00.001+01:00

This is a sample how to delete data in batches to avoid large transaction log. This is a simpler version of this example when I used 2 tables.

DECLARE @MyTable TABLE 
( 
	Id int,
	DateUpdated DATETIME
)
INSERT INTO @MyTable
SELECT 1,DATEADD(d,-1,GETDATE())
UNION SELECT 2,DATEADD(d,-2,GETDATE())
UNION SELECT 3,DATEADD(d,1,GETDATE())
UNION SELECT 4,DATEADD(d,2,GETDATE())
UNION SELECT 5,DATEADD(d,-3,GETDATE())
UNION SELECT 6,DATEADD(d,-2,GETDATE())
UNION SELECT 7,DATEADD(d,-4,GETDATE())
DECLARE @date DATETIME
SET @date = GETDATE()
PRINT CONVERT(CHAR(19),GETDATE(),120) +' Deleting data in batches' 
WHILE (Exists(SELECT 1 FROM @MyTable WHERE DateUpdated < @date))
BEGIN TRY    
    BEGIN TRAN     
       PRINT CONVERT(CHAR(19),GETDATE(),120) +'   Deleting 2..'   
       DELETE TOP(2) @MyTable FROM @MyTable WHERE DateUpdated < @date
    COMMIT TRAN 
END TRY
BEGIN CATCH 
    ROLLBACK
END CATCH
--SELECT * FROM @MyTable

Retry class implemented in functional C#

2011-08-12T16:08:00.001+01:00

public class Retry
{
  public static ILog _log = LogManager.GetLogger(MethodInfo.GetCurrentMethod().DeclaringType);
  int _retryAttempts = 3;
  int _retryWaitSeconds = 1;
  public Retry() { }
  public Retry(int retryAttempts, int retryWaitSeconds)
  {
    _retryAttempts = retryAttempts;
    _retryWaitSeconds = retryWaitSeconds;
  }
  public void Execute(Action action)
  {
    int attempt = 0;
    while (attempt++ < _retryAttempts)
    {
      try
      {
        if (_log.IsDebugEnabled)
        {
          _log.DebugFormat("Retry attempt {0}/{1}", attempt, _retryAttempts);
        }
        action();
        return;
      }
      catch (Exception e)
      {
        if (attempt >= _retryAttempts)
        {
          _log.ErrorFormat("Retry failed with {0} attempts", _retryAttempts);
          throw e;
        }
        int wait = _retryWaitSeconds * attempt;
        _log.Warn(string.Format("Retry attempt {0}/{1} failed, waiting {2}s", attempt, _retryAttempts, wait), e);
        Thread.Sleep(1000 * wait);
      }
    }
  }
  public TResult Execute<TResult>(Func<TResult> func)
  {
    int attempt = 0;
    while (attempt++ < _retryAttempts)
    {
      try
      {
        if (_log.IsDebugEnabled)
        {
          _log.DebugFormat("Retry attempt {0}/{1}", attempt, _retryAttempts);
        }
        return func();
      }
      catch (Exception e)
      {
        if (attempt >= _retryAttempts)
        {
          _log.ErrorFormat("Retry failed with {0} attempts", _retryAttempts);
          throw e;
        }
        int wait = _retryWaitSeconds * attempt;
        _log.Warn(string.Format("Retry attempt {0}/{1} failed, waiting {2}s", attempt, _retryAttempts, wait), e);
        Thread.Sleep(1000 * wait);
      }
    }
    throw new Exception("Retry failed");
  }
}

[TestFixture]
public class TestRetry
{
  [Test]
  public void Test()
  {
    new Retry(3, 1).Execute(SuccessAction);
    try
    {
      new Retry(3, 1).Execute(FailureAction);
    }catch(Exception ex)
    {
      Console.WriteLine("Failed");
    }
    Console.WriteLine(new Retry(3, 1).Execute(() => ComplexAction("1", "2")));
    Console.WriteLine(new Retry(3, 1).Execute(() => ObjectAction("John")).ToString());
    Func<Person> func = () =>
    {
      return new Person() { Name = "John" };
    };
    Console.WriteLine(new Retry(3, 1).Execute(func));
  }
  private void FailureAction()
  {
    Console.WriteLine("{0}: Failed", DateTime.Now);
    throw new Exception("Failed Exception");
  }
  private void SuccessAction()
  {
    Console.WriteLine("{0}: OK", DateTime.Now);
  }
  private string ComplexAction(string a, string b)
  {
    return String.Format("{0} {1}", a, b);
  }
  private Person ObjectAction(string name)
  {
    return new Person() { Name = name };
  }
}
class Person
{
  public string Name { get; set; }
  public override string ToString()
  {
    return "My name is : " + Name;
  }
}

Visual Studio Web Server not updating/caching pages

2011-08-03T17:21:00.001+01:00

I came across a problem today when visual studio development web server was not updating when compiling new code. After deleting bin folder from my Web project I got this error:

The problem was with build output location. For web projects the Output path in web project properties should be just bin not bin\Debug or bin\x86\Debug because web server root folder is your Web project folder.

C# MVC3 Log4Net configuration

2011-08-03T17:07:00.001+01:00

Add log4net section to top level Web.config

<configuration>
  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
  </configSections>
  [...]
  <log4net>
   <appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
      <param name="File" value="Log\\MyProject.log" />
      <param name="AppendToFile" value="true" />
      <param name="RollingStyle" value="Size" />
      <param name="MaxSizeRollBackups" value="10" />
      <param name="MaximumFileSize" value="500KB" />
      <param name="StaticLogFileName" value="true" />
      <param name="Threshold" value="INFO"/>
      <layout type="log4net.Layout.PatternLayout">
        <param name="ConversionPattern" value="%d [%t] %-5p %c.%M():%L - %m%n" />
      </layout>
    </appender>
    <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
      <param name="Threshold" value="DEBUG"/>
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%d [%t] %-5p %c.%M():%L - %m%n" />
      </layout>
    </appender>
    <logger name="MyCompany">
      <appender-ref ref="RollingFileAppender" />      
      <appender-ref ref="ConsoleAppender" /> 
    </logger>
  </log4net>
</configuration>

Initialize log4net from Application_Start() method in Global.asax.cs

protected void Application_Start()
{
  [...]
  log4net.Config.XmlConfigurator.Configure();
}

Click here for more detailed post about Log4Net configuration in console apps

Dynamic keyword in .Net 4.0 with ExpandoObject

2011-07-27T17:38:00.001+01:00

[TestFixture]
public class TestDynamic
{
    [Test]
    public void Test()
    {
        dynamic test = new ExpandoObject();
        test.FirstName = "Michael";
        test.SecondName = "Jordan";
        Console.WriteLine(string.Format("{0} {1}",test.FirstName,test.SecondName));
    }
}

C# Stopwatch to measure time

2011-07-22T13:30:00.001+01:00

    [TestFixture]
    public class TestStopwatch
    {
        [Test]
        public void test()
        {
            //using System.Diagnostics;
            Stopwatch stopwatch = new Stopwatch();
            stopwatch.Start();
            //long running task
            int sleeptime = new Random().Next(1, 3)*1000;
            Console.WriteLine("Running for ~{0}ms:",sleeptime);
            Thread.Sleep(sleeptime);            
            stopwatch.Stop();
            Console.WriteLine(stopwatch.Elapsed.ToString());
            Console.WriteLine(new DateTime(stopwatch.Elapsed.Ticks).ToString("ss:fff"));
        }
    }

Video: Mastering Git Basics By Tom Preston-Werner

2011-06-29T17:19:00.001+01:00

Tom Preston-Werner - Mastering Git Basics from Erlang Solutions on Vimeo.

Notepad++ Scala syntax highlighting

2011-06-27T16:45:00.001+01:00

Scala comes with Notepad++ plugin for syntax highlighting.

To install the plugin copy SCALA_HOME/misc/scala-tool-support/notepad-plus/userDefineLang.xml file to %APPDATA%\Notepad++ folder and restart Notepad++.

scala-tool-support folder contains plugins for other tools as well like textmate, emacs etc..

.NET 4.0 Parallel programming (PFX)

2011-06-24T11:15:00.001+01:00

Great overview of multithreading APIs in Framework 4.0 for leveraging multicore processors known as PFX (Parallel Framework)

Functional Programming in C# 3.0

2011-06-24T10:36:00.001+01:00

Tutorial on using Functional Programming (FP) techniques
Query Composition using Functional Programming Techniques in C# 3.0

How to filter sp_helprotect information

2011-06-15T07:28:00.001+01:00

DECLARE @sp_helprotect TABLE 
( 
    [Owner] VARCHAR(255), 
    [Object] VARCHAR(255) NULL, 
    [Grantee] VARCHAR(255) NULL, 
    [Grantor] VARCHAR(255) NULL,     
    [ProtectType] VARCHAR(255) NULL, 
    [Action] VARCHAR(255) NULL, 
    [Column] VARCHAR(255) NULL
) 
 
INSERT @sp_helprotect EXEC sp_helprotect 
SELECT * FROM @sp_helprotect
WHERE [Object] = 'table-name'
 ORDER BY [Object], [Grantee], [Action]

How to Setup Local/Remote Git Repository in Windows

2011-06-10T16:17:00.001+01:00

* Prerequisites
- Install Cygwin http://cygwin.com
- Add Cygwin git package

* Create Remote Repository in (/cygdrive/c/repository)
- Got to /cygdrive/c/repository and create folder samplegit.git (/cygdrive/c/repository/samplegit.git)
- Go to that folder and run 'git init --bare'

* Create Local Repository in (/cygdrive/c/projects)
- Got to /cygdrive/c/projects and create folder samplegit (/cygdrive/c/projects/samplegit)
- Create new Project, run 'sbt' or do it in your favourity IDE
- Go to that folder /cygdrive/c/projects/samplegit and run 'git init'
- Associate with remote repository 'git remote add origin /cygdrive/c/repository/samplegit.git'
- Add all files & folders 'git add .'
- Commit to local repository 'git commit -m "initial commit"'
- Push to remote repository 'git push origin master'

* To test if all ok clone it in another location (/cygdrive/c/temp)
- Run 'git clone /cygdrive/c/repository/samplegit.git samplegit'

* To get latest updates
- Run 'git pull origin master'

Play Web Framework for Scala

2011-06-10T16:06:00.001+01:00

This is a guide how to setup version 1.2.2 that supports scala template engine.

- Download play framework 1.2.2RC1 from http://www.playframework.org/download
- Install scala module 'play install scala-0.9.1' (http://scala.playframework.org/)
- Create new application 'play new myapp --with scala'
- Create IntelliJ IDEA module 'play idealize myapp'
- Test application 'play run' and go to 'http://localhost:9000'

for more info check the documentation
http://scala.playframework.org/documentation/scala-0.9.1/home

if you’re new to Play watch this video

A web app in 10 minutes using Play framework from zenexity on Vimeo.

C# Functional programming

2011-05-04T15:49:00.001+01:00

namespace Test
{
    public static class Extensions
    {
        //ForEach IEnumerable extension
        public static void ForEach<T>(this IEnumerable<T> source, Action<T> action)
        {
            foreach (var item in source)
            {
                action(item);
            }
        }
    }
    class Person
    {
        public string Name { get; set; }
        public string City { get; set; }
    }
    class Account
    {
        public string Name { get; set; }
        public string AccountName { get; set; }
        public double Amount { get; set; }
        public List<string> Cards { get; set; }
    }
    [TestFixture]
    public class TestFunc
    {
        private List<Person> people;
        private List<Account> accounts;
        [TestFixtureSetUp]
        public void SetUp()
        {
            people = new List<Person>();
            people.Add(new Person(){Name="John", City="NY"});
            people.Add(new Person() { Name = "Tom", City = "London" });
            accounts = new List<Account>();
            accounts.Add(new Account() { Name = "John", Amount = 1, AccountName = "Savings", Cards = new List<string>(){"Amex","Visa"}});
            accounts.Add(new Account() { Name = "Tom", Amount = 2, AccountName = "Current", Cards = new List<string>() { "Amex" } });
            accounts.Add(new Account() { Name = "John", Amount = 3, AccountName = "Savings", Cards = new List<string>() { "Mastercard" } });
            accounts.Add(new Account() { Name = "Tom", Amount = 4, AccountName = "Current", Cards = new List<string>() { "Mastercard", "Visa" } });
            accounts.Add(new Account() { Name = "John", Amount = 5, AccountName = "Mortgage", Cards = new List<string>() { "Visa" } });            
        }
        [Test]
        public void TestLinq()
        {            
            Console.WriteLine("Total Amount in All acounts:\n{0}", accounts.Sum(item => item.Amount));
            Console.WriteLine("\nTotal Amount in John's accounts:\n{0}", accounts.Where(x => x.Name.Equals("John")).Sum(item => item.Amount));
            Console.WriteLine("\nSum using Aggregate function:\n{0}", accounts.Select((x) => x.Amount).Aggregate((double)10, (x, y) => x + y));
            Console.WriteLine("\nMultiply using Aggregate function:\n{0}", accounts.Select((x) => x.Amount).Aggregate((x, y) => x * y));            
            Console.WriteLine("\nIterate John's accounts:");
            accounts.Where(x => x.Name.Equals("John")).ForEach((x) => Console.Write("{0},",x.Amount));
            Console.WriteLine("\n\nIterate John's accounts (with transform)");
            accounts.Where(x => x.Name.Equals("John")).Select((x)=>x.Amount).ForEach(Console.WriteLine);
            Console.WriteLine("\nMaping to new anonymous class:");
            accounts.Select((x) => new { Upper = x.Name.ToUpper(), Lower =x.Name.ToLower()}).ForEach((x) => Console.WriteLine("{0}", x.Upper));
            Console.WriteLine("\nMaping to new anonymous class (with index):");
            accounts.Select((x, index) => new { Index = index, Upper = x.Name.ToUpper() }).ForEach((x) => Console.WriteLine("{0}->{1}", x.Index, x.Upper));
            
            Console.WriteLine("\nFlatten Children (single loop):");
            accounts.SelectMany(x => x.Cards).ForEach(Console.WriteLine);  
            
            Console.WriteLine("\nConcat two lists:");
            accounts.Select(x => x.Name).Concat(accounts.SelectMany(x=>x.Cards)).ForEach(Console.WriteLine);
            
            Console.WriteLine("\nGroupBy with Count:");
            accounts.GroupBy(x => x.Name, x => x.Amount).ToList().Select((x) => new { Key = x.Key, Count = x.Count() }).ForEach((x) => Console.WriteLine("{0}->{1}", x.Key, x.Count));
            Console.WriteLine("\nConcat with Sum:");
            accounts.GroupBy(x => x.Name, x => x.Amount).ToList().Select((x) => new { Key = x.Key, Sum = x.Sum() }).ForEach((x) => Console.WriteLine("{0}->{1}", x.Key, x.Sum));
            
            Console.WriteLine("\nTake all values until condition met:");
            accounts.TakeWhile(x => x.Amount < 3).ForEach((x) => Console.WriteLine("{0}->{1}", x.Name, x.Amount));
            Console.WriteLine("\nTake all values from condition met:");
            accounts.SkipWhile(x => x.Amount < 4).ForEach((x) => Console.WriteLine("{0}->{1}", x.Name, x.Amount));
             
            Console.WriteLine("\nOrder by Name then Amount:");
            accounts.OrderBy((x) => x.Name).ThenBy((x) => x.Amount).ForEach((x) => Console.WriteLine("{0}->{1}", x.Name, x.Amount));
            Console.WriteLine("\nCheck if John has an account:\n{0}",accounts.Any(x => x.Name.Equals("John")));
            Console.WriteLine("\nCheck if all accounts belong to John:\n{0}",accounts.All(x => x.Name.Equals("John")));
            Console.WriteLine("\nPopulate Range:");
            Enumerable.Range(1, 3).ForEach(Console.WriteLine);
            Console.WriteLine("\nDuplicate Number:");
            Enumerable.Repeat(1, 3).ForEach(Console.WriteLine);
            Console.WriteLine("\nJoin 2 entities:");
            accounts.Join(people, a => a.Name, p => p.Name, (a, p) => new { Name = p.Name, City = p.City, AccountName = a.AccountName, Amount = a.Amount }).ForEach((x) => Console.WriteLine("{0} from {1} -> {2} = {3}", x.Name, x.City, x.AccountName,x.Amount));            
        }
        [Test]
        public void TestFunction()
        {
            MyList<string> list = new MyList<string>();
            list.Add("One");
            list.Add("Two");
            list.Add("Three");
            Console.WriteLine("Print values that start with 'T':");
            list.PrintIf(x => x.StartsWith("T"),Console.WriteLine);
        }
    }
    
    class MyList<T>
    {
        List<T> data = new List<T>();
        public void Add(T obj)
        {
            data.Add(obj);
        }
        public void PrintIf(Func<T,bool> predicate, Action<T> action)
        {
            foreach (var d in data)
            {
                if (predicate(d))
                {
                    action(d);
                }
            }
        }
    }
}

Add JRebel to SBT

2011-04-28T15:31:00.001+01:00

This allows for continuous reloading when doing Lift development

Download JRebel (jar installer)
http://www.zeroturnaround.com/jrebel/current/
Get free JRebel license for Scala Developers
http://sales.zeroturnaround.com/
After installation add this to your sbt batch and VM parameters in IntelliJ IDEA (File/Settings/SBT)

set SCRIPT_DIR=%~dp0
java -Dhttp.proxyHost=<proxy-server> -Dhttp.proxyPort=<proxy-port> -Xmx512M -Drebel.license=<path-to-jrebel>/javarebel.lic -noverify -javaagent:<path-to-jrebel>/jrebel.jar -jar "%SCRIPT_DIR%sbt-launch-0.7.5.jar" %*

From sbt console run
> ~prepare-webapp

Setup Lift (Scala web framework)

2011-04-28T15:06:00.001+01:00

Create new folder 'LiftProject'
Run sbt command from that folder, choose 'y' to create new project (Name: LiftProject, Organization: test)
Configure Lifty (http://lifty.github.com/) Lift SBT processor - you only need to do it once
- From sbt prompt run the following (including * character)
  > *lifty is org.lifty lifty 1.6.1
  > update
Create new Lift project (when asked you can specify version 2.3 instead of 2.3-RC3)
> lifty create project-blank
Create idea project files
> idea
Refresh everything
> reload
> update
> compile
Run Jetty webserver
> ~jetty-run
Open http://localhost:8080 and you should see your lift webpage

More info about Lift
http://liftweb.net/

Lift Book
http://simply.liftweb.net/index.html
code samples: https://github.com/dpp/simply_lift

How to configure git http proxy

2011-04-28T10:52:00.001+01:00

git config --global http.proxy {servername}:{portnumber}

Setup Scala with SBT in IntelliJ IDEA

2011-04-21T14:30:00.001+01:00

Download Dependencies

Download IntelliJ IDEA Community Edition (10.0.3)
http://www.jetbrains.com/idea/download
Download Scala
http://www.scala-lang.org/downloads (2.8.1 installer)
Download SBT
http://code.google.com/p/simple-build-tool/ (0.7.5)

Setup

Setup SBT according to this page (Launching Sbt section)
http://code.google.com/p/simple-build-tool/wiki/Setup
Add Scala/SBT plugins to IntelliJ IDEA
- Go to File/Settings/Plugins, choose Available tab, right click on Scala plugin and click on 'Download and Install'. Do the same for SBT plugin.
- Restart IntelliJ IDEA
- Go to File/Settings/SBT and set location of your SBT jar file and if you're on windows behind firewall add proxy info to vm params (-Dhttp.proxyHost=<proxy_server> -Dhttp.proxyPort=<proxy_port>)

Create Project

Create new Folder ScalaProject
Run sbt command from that folder, choose 'y' to create new project (Name: ScalaProject, Organization: test)
Configure sbt-idea plugin (https://github.com/mpeltonen/sbt-idea) - you only need to do it once
- From sbt prompt run the following (including * character)
  > *sbtIdeaRepo at http://mpeltonen.github.com/maven/
  > *idea is com.github.mpeltonen sbt-idea-processor 0.4.0
  > update
Create idea project files
> idea
Open the project in IntelliJ IDEA
Configure scala plugin file for sbt-idea
- Create directory ScalaProject/project/plugins
- Create new file Plugins.scala in ScalaProject/project/plugins folder

import sbt._ 
class Plugins(info: ProjectInfo) extends PluginDefinition(info) {
  val sbtIdeaRepo = "sbt-idea-repo" at "http://mpeltonen.github.com/maven/"
  val sbtIdea = "com.github.mpeltonen" % "sbt-idea-plugin" % "0.2.0"
}

Configure sbt project definition file
- Create directory ScalaProject/project/build
- Create scala class file ScalaProject in ScalaProject/project/build folder

import sbt._ 
class ScalaProject(info: ProjectInfo) extends DefaultProject(info) with IdeaProject {
  val scalatest = "org.scalatest" % "scalatest" % "1.3"
}

Refresh project files
- Launch SBT Console (bottom of the screen) and press Run (green arrow)
- From SBT prompt run the following
  > update
  > clean
  > compile
  > idea
- Reload the project

Hello World example

Create new scala class HelloWorld in src/main/scala

object HelloWorld {
  def main(args: Array[String]){
    println(hello)
  } 
  def hello:String = {
    return "Hello World!";
  }
}

Create new scala test class HelloWorldSpec in src/test/scala

import org.scalatest.FlatSpec
import org.scalatest.matchers.ShouldMatchers
class HelloWorldSpec extends FlatSpec with ShouldMatchers {
  "Hellow World" should "show Hello World" in {
    HelloWorld.hello should equal("Hello World!")
  }
}

Testing Hello World example

Launch SBT Console to run the examples
From SBT prompt run the following
> run (searches for classes with main(args) method and executes them)
> test (searches for test classes and execute them)
> ~test (runs tests continuously as soon as it detects changes), press ENTER to exit

Enjoy Scala!

This seems like a good tutorial for beginners
http://www.scala-lang.org/docu/files/ScalaTutorial.pdf

C# SQLite Example

2011-04-01T11:43:00.001+01:00

Download Precompiled Binaries for Windows from http://www.sqlite.org/download.html
Download ADO.Net provider for SQLite http://sourceforge.net/projects/sqlite-dotnet2/. The Project page is here http://sqlite.phxsoftware.com/
Download SQLite GUI client. This is a very basic one. wxSQLite http://cfred.free.fr/download.php#wxsqliteplus

Create new SQLite database using wxSQLite or command line c:\temp\contacts.db

In Your C# Project

Add References to System.Data.SQLite
Add sqlite3.dll (as link) to your project and set Copy to Output Directory property to Copy if newer

C# Test to create table and read some data.

[TestFixture]
public class TestSqlLite
{
    #region sql
    private string createSql = @"
DROP TABLE IF EXISTS Contacts;
CREATE TABLE Contacts(
FirstName TEXT,
LastName TEXT
);
INSERT INTO Contacts
SELECT 'Michael','Jordan'
UNION SELECT 'Scottie','Pippen'
;
";
    private string selectSql = @"SELECT * FROM Contacts";
    #endregion
    [Test]
    public void Test()
    {
        //String connString = "Data Source=contacts.db"; from current directory
        String connString = "Data Source=C://temp/contacts.db"; //from specific location
                    
        using (SQLiteConnection conn = new SQLiteConnection(connString))
        {
            Console.WriteLine("Opening Connection");
            conn.Open();
            Console.WriteLine("Creating 'Contacts' Table");
            using (SQLiteCommand cmd = new SQLiteCommand(createSql, conn))
            {                    
                cmd.ExecuteNonQuery();
            }
            Console.WriteLine("Query 'Contacts' Table");
            using (SQLiteCommand cmd = new SQLiteCommand(selectSql, conn))
            {                    
                using (SQLiteDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {                            
                        Console.WriteLine("  "+dr.GetString(dr.GetOrdinal("FirstName")) + " " + dr.GetString(dr.GetOrdinal("LastName")));
                    }
                }
            }
        }            
    }
}

SQL Stored procedure with error handling using Try/Catch

2011-03-16T12:26:00.001Z

This is improved version of the script from 2009 using try/catch syntax

USE [MyDatabase]
GO
PRINT 'DROP PROCEDURE [usp_mysproc]'
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_mysproc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
  drop procedure [dbo].[usp_mysproc]
GO
PRINT 'CREATE PROCEDURE [usp_mysproc]'
GO
CREATE PROCEDURE [dbo].[usp_mysproc]
(
  @RaiseError bit = 0
)  
AS
BEGIN TRY
  BEGIN TRAN
  
  IF @RaiseError = 1
  BEGIN
    DECLARE @TEMP TABLE (Column1 varchar(2))
    INSERT INTO @TEMP(Column1) VALUES ('123')    
  END
  
  COMMIT TRAN
END TRY
BEGIN CATCH
  DECLARE @ErrorInfo VARCHAR(4000)      
  SET @ErrorInfo = 'ERROR ['+LTRIM(STR(ERROR_NUMBER()))+']['+ERROR_PROCEDURE()+':'+LTRIM(STR(ERROR_LINE()))+'] - ' + ERROR_MESSAGE() 
  
  PRINT CONVERT(VARCHAR,GETDATE(),21) + ': '+@ErrorInfo
  ROLLBACK TRAN 
  RAISERROR( @ErrorInfo, 16, 1)
  RETURN 1
END CATCH    
GO
GRANT  EXECUTE  ON [dbo].[usp_mysproc]  TO [MyDatabaseEditor]
GO
GRANT  EXECUTE  ON [dbo].[usp_mysproc]  TO [MyDatabaseAdmin]
GO
-- SUCCESS TEST
EXEC usp_mysproc
-- FAILURE TEST
EXEC usp_mysproc @RaiseError = 1
-- ERROR MESSAGE 
-- 2011-03-16 12:23:12.893: ERROR [8152][usp_mysproc:14] - String or binary data would be truncated.

Select latest data from table

2011-03-08T17:56:00.001Z

DECLARE @TEMP TABLE( 
 Ticker varchar(50), 
 Date int,
 Details varchar(50)
)
INSERT INTO @temp
SELECT 'A',20110101,'A-1'
UNION SELECT 'B',20110101,'B-1'
UNION SELECT 'A',20110102,'A-2'
UNION SELECT 'C',20110102,'C-2'
--Select whole universe
SELECT * FROM @temp a
ORDER BY a.Ticker
--Select latest data (can't include Details)
SELECT a.Ticker,MAX(a.Date) Date
FROM @temp a
GROUP BY a.Ticker
ORDER BY a.Ticker
--Select data with Details (no longer latest)
SELECT a.Ticker,MAX(a.Date) Date,Details
FROM @temp a
GROUP BY a.Ticker,Details
ORDER BY a.Ticker
--Select latest data (with Details)
SELECT a.Ticker,a.Details,a.Date
FROM @temp a inner join @temp b ON a.Ticker = b.Ticker
GROUP BY a.Ticker, a.Details, a.Date
HAVING a.Date = MAX(b.Date)
ORDER BY a.Ticker

How to Hide/Show rows dynamically in Excel

2011-02-07T15:56:00.001Z

Simple Java HttpServer / HttpHandler

2011-02-04T16:06:00.001Z

import com.sun.net.httpserver.HttpExchange;
import com.sun.net.httpserver.HttpHandler;
import com.sun.net.httpserver.HttpServer;
import java.io.IOException;
import java.net.HttpURLConnection;
import java.net.InetSocketAddress;
public class TestServer {
    private static final int PORT = 8000;
    private static final String HOST = "127.0.0.1";
    public static void main(String[] args){
        System.out.println("Starting HttpServer on port "+PORT);
        try{
            InetSocketAddress address = new InetSocketAddress(HOST, 8000);
            HttpServer httpServer = HttpServer.create(address, 0);
            System.out.println("Running..");
            HttpHandler handler = new HttpHandler() {
                public void handle(HttpExchange exchange) throws IOException {
                    String response = "Hello World!";
                    byte[] bytes = response.getBytes();
                    exchange.sendResponseHeaders(HttpURLConnection.HTTP_OK,bytes.length);
                    exchange.getResponseBody().write(bytes);
                    exchange.close();
                }
            };
            httpServer.createContext("/", handler);
            httpServer.start();
            System.out.println("Press any key to stop.");
            System.in.read();
            httpServer.stop(0);
        }catch (Exception ex){
            System.out.println("Error: "+ ex.getMessage());
        }
        System.out.println("Stopped.");
    }
}

SQL Server How to find if any stored procedure is referencing database object

2011-02-01T10:34:00.001Z

select StoredProcedureName = p.name
from sys.sql_modules sm
inner join
sys.procedures p
on sm.[object_id] = p.[object_id]
where [definition] like '%Database_Object_Name%'

SQL Server useful system stored procedures

2011-01-20T07:45:00.002Z

sp_helprotect [object_name]
Returns a report with information about user permissions for an object, or statement permissions, in the current database.

sp_helptext [view_name]
Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, computed column, or view.

Full list of System Stored Procedures

How to set Microsoft IIS to 32bit on 64bit server

2011-01-19T11:19:00.002Z

go to %systemdrive%\Inetpub\AdminScripts
run cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1
go to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
run IIS installer aspnet_regiis.exe -i
Allow 'ASP.NET v2.0.50727 (32-bit)' under Internet Information Services/Web Service Extensions
Disable 'ASP.NET v2.0' if exists (this is 64bit version)
Restart IIS

Model-View-ViewModel in WPF

2011-01-13T11:31:00.002Z

90 Minutes Video by Jason Dolinger

DataModel-View-ViewModel pattern series by Dan Crevier

Active Directory Lookup Window

2010-12-08T12:20:00.001Z

%windir%\system32\rundll32.exe dsquery.dll,OpenQueryWindow

Graph# – WPF Graph Layout Framework

2010-11-17T16:50:00.001Z

Download Graph#

Add References to

GraphSharp.dll
GraphSharp.Controls.dll
QuickGraph.dll
WPFExtensions.dll

This sample shows you how to

Visualize Data on the graph
Update Graph using notifications
Add menu items to graph object
Add events to graph object
Zoom in/out

<Window x:Class="Samples.TestGraph.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:graphsharp="clr-namespace:GraphSharp.Controls;assembly=GraphSharp.Controls"
    xmlns:zoom="clr-namespace:WPFExtensions.Controls;assembly=WPFExtensions"
    xmlns:local="clr-namespace:Samples.TestGraph"
    Title="Window1" Height="335" Width="592">
    <Grid>
            <Grid.Resources>        
                <local:ActiveConverter x:Key="activeConverter"/>
                <DataTemplate DataType="{x:Type local:SampleVertex}">
                    <Border  Background="{Binding Path=Active, Converter={StaticResource activeConverter}, NotifyOnTargetUpdated=True}"
					BorderBrush="LightGray" 
					BorderThickness="1,1,1,1"
					CornerRadius="10,10,10,10"
					Padding="10,10,10,10"
					HorizontalAlignment="Center"
					VerticalAlignment="Center"
					Cursor="Hand">
                        <Border.ContextMenu>
                            <ContextMenu>
                                <MenuItem x:Name="Change" Click="MenuItem_Click" Tag="{Binding}">
                                    <MenuItem.Header>
                                        <TextBlock HorizontalAlignment="Left">Change</TextBlock>
                                    </MenuItem.Header>
                                </MenuItem>
                            </ContextMenu>
                        </Border.ContextMenu>
                        <Border.ToolTip>
                            <ToolTip>
                                <TextBlock Text="{Binding Text}" />
                            </ToolTip>
                        </Border.ToolTip>
                        <TextBlock Text="{Binding Text}" TextAlignment="Center" TextWrapping="Wrap" />
                    </Border>
                </DataTemplate>
            </Grid.Resources>
            
            <zoom:ZoomControl Name="zoomControl">
            <graphsharp:GraphLayout x:Name="graphLayout"
                                    Graph="{Binding Path=Graph}"
                                    LayoutAlgorithmType="{Binding Path=LayoutAlgorithm}"
                                    OverlapRemovalAlgorithmType="FSA" />            
            </zoom:ZoomControl>        
    </Grid>
</Window>

namespace Samples.TestGraph
{
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
            DataContext = this;
            CreateGraph();
        }
        private readonly BidirectionalGraph<object, IEdge<object>> _graph = new BidirectionalGraph<object, IEdge<object>>();
        public IBidirectionalGraph<object, IEdge<object>> Graph
        {
            get { return _graph; }
        }
        private string _layoutAlgorithm = "EfficientSugiyama";
        public string LayoutAlgorithm
        {
            get { return _layoutAlgorithm; }
            set
            {
                if (value != _layoutAlgorithm)
                {
                    _layoutAlgorithm = value;                    
                }
            }
        }
        private void CreateGraph()
        {
            _graph.Clear();
            SampleVertex obj1 = new SampleVertex("One");
            _graph.AddVertex(obj1);
            SampleVertex obj2 = new SampleVertex("Two");
            _graph.AddVertex(obj2);
            SampleVertex obj3 = new SampleVertex("Three");
            _graph.AddVertex(obj3);
            _graph.AddEdge(new Edge<object>(obj1, obj2));
            _graph.AddEdge(new Edge<object>(obj1, obj3));
        }
        private void MenuItem_Click(object sender, RoutedEventArgs e)
        {
            var menuItem = sender as MenuItem;
            var vertex = menuItem.Tag as SampleVertex;
            vertex.Change();            
        }
    }
    public class SampleVertex : INotifyPropertyChanged
    {
        private bool _active;
        private string _text;
        public bool Active
        {
            get { return _active; }
            set
            {
                _active = value;
                NotifyChanged("Active");
            }
        }
        public string Text
        {
            get { return _text; }
            set
            {
                _text = value;
                NotifyChanged("Text");
            }
        }
        public SampleVertex(string text)
        {
            Text = text;
        }
        public void Change()
        {
            Active = !Active;
        }
        public event PropertyChangedEventHandler PropertyChanged;
        protected void NotifyChanged(string propertyName)
        {
            if (PropertyChanged != null)
                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
        }
    }
    [ValueConversion(typeof(bool), typeof(Brush))]
    public class ActiveConverter : IValueConverter
    {
        public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
        {
            var state = (bool)value;
            if(state)
            {
                return new SolidColorBrush(Colors.WhiteSmoke);
            }else
            {
                return new SolidColorBrush(Colors.LightSalmon);
            }
        }
        public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
        {
            return null;
        }
    }
}

Free WPF Docking Library (like in Visual Studio)

2010-11-15T17:04:00.002Z

AvalonDock
http://avalondock.codeplex.com/
Getting Started Tutorial

Python Reference

2010-11-11T16:37:00.001Z

#import libraries
import sys,os,shutil,glob,string,re,datetime
 
#=====================================
# IO Samples
#=====================================
 
#read file line by line
f=open('text.txt','r')
for line in f:
	print string.split(line, '\n')[0] #remove linebreak
 	
#read file all at once
f=open('text.txt','r')
text = f.read()		
print(text)
 
#current directory
print os.getcwd()
 
#list files/folders in current directory
for file in os.listdir(os.getcwd()):
	print file
	
#print directory structure
def printDir(path,indent):
	for root, dirs, files in os.walk(path):
		for name in dirs:
			print indent+name
			printDir(os.path.join(root,name),indent+" ")
		for name in files:
			print indent+name
	 
printDir(os.getcwd())	
	 
#create dir
os.mkdir("Test")
 
#delete dir
os.remove("Test")	
 
#execute command
os.system("mkdir x")
  
#execute command line and return a result
result = os.popen("ls").read()
  
#wildcard file names
print glob.glob("*.py")
  
#copy file
shutil.copy("file1.py","file2.py")
  
#movw file
shutil.move('dir1', 'dir2')
  
#command line arguments
print sys.argv
print sys.argv[1]
  
 
#=====================================
# Exception Handling
#=====================================
 
#catch error
try:
	f=open('test.py',r)
	f.readline()
except:
	print "Error:",sys.exc_info()
	print " Error:",sys.exc_info()[0]
	print " Msg  :",sys.exc_info()[1]	
 
#raise error	
try:
	raise NameError, 'Custom Error'
except:
	print "Error:",sys.exc_info()
  
 
#=====================================	
# String/Formatting Samples
#=====================================
 
#string character manipulation
sampletext = "Hello"
print sampletext[2:] #llo (everything but first 2)
print sampletext[-2:] #ll (last 2)
print sampletext #He (first 2)
print sampletext[:-2] #Hel (everything but last 2)
 
#templating string
t = string.Template("This $one is a $two")
print t.substitute(one='1',two='2')
 
#template from file
f=open('template.txt','r')
t = string.Template(f.read())
print t.substitute(param1='1',param2='2')
 
#split string
for resultline in result.split("\n"):	
	print resultline
 
#cast int to string
number = 1
text = str(number)
print text
 
 
#=====================================	
# DateTime Parsing/Formatting
#=====================================
#date
print datetime.date.today()
 
#datetime
print datetime.datetime.today()
 
#format date
print datetime.datetime.today().strftime("%y%m%d_%H%M%S")
 
#parse date
dt = datetime.datetime.strptime("21/11/06 16:30", "%d/%m/%y %H:%M")
print dt	
  
 	
#=====================================
# Math
#=====================================
val = 5
print '5 mod 2: ', val % 2
print '5 div 2: ', val / 2
 
print abs(-4)	
  
   
#=====================================	
# Regex
#=====================================
 
#regex
regexValue = "Name John"
regex = "(Name)\s*(?P<FirstName>\w+)"
m = re.match(regex,regexValue)	
if m:
 print 'First Name: ' + m.group('FirstName')
else:
 print 'FirstName not found'
 
 
#=====================================
# Custom Libraries/Modules
#=====================================
 
# Save this module to fibo.py (Fibonacci numbers)
#-------------
# write Fibonacci series up to n
def fib(n):
    a, b = 0, 1
    while b < n:
        print b,
        a, b = b, a+b
 
# return Fibonacci series up to n
def fib2(n): 
    result = []
    a, b = 0, 1
    while b < n:
        result.append(b)
        a, b = b, a+b
    return result
#-------------
 
# Calling fib methods
import fibo
s = 'This is fibo or 5: ' + str(fibo.fib2(5))
print s	
 
# Save this module to cars.py
#-------------
# Custom class
class Car:	
	def __init__(self,i):
		self.i = i
 	
	def increment(self):
		print 'incrementing'
		self.i=self.i+1
		
	def printvalue(self):
		print self.i;
		
# Calling cars class
import cars
car = cars.Car(5)
print car.i
car.printvalue()
car.increment()
car.printvalue()	
 
 
#=====================================
# Unit Tests
#=====================================
 
import unittest
 
class TestStatisticalFunctions(unittest.TestCase):
	def test_average(self):
		self.assert_(isinstance(2 + 4, int))
		self.assertEqual(abs(-4), 4)        
		self.assertRaises(ZeroDivisionError, lambda : 1/0)        
 
#run tests		
unittest.main()

C# List sorting

2010-09-22T17:12:00.001+01:00

DirectoryInfo dir = new DirectoryInfo(@"C:\temp");
List<FileInfo> files = new List<FileInfo>(dir.GetFiles());
files.Sort((x, y) => DateTime.Compare(x.LastWriteTime,y.LastWriteTime));

WPF Toolkit DataGrid & Chart example

2010-09-22T14:43:00.001+01:00

Download WPF Toolkit
Create new WPF Project
Add References to WPFTookit, WPFTookit.Design (DataGrid)
Add Reference to System.Windows.Controls.DataVisualization.Toolkit (Chart)

This is XAML

<Window x:Class="WpfDataGrid.Window2"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:toolkit="http://schemas.microsoft.com/wpf/2008/toolkit"
    xmlns:charting="clr-namespace:System.Windows.Controls.DataVisualization.Charting;assembly=System.Windows.Controls.DataVisualization.Toolkit"
    Title="WPF Toolkit DataGrid &amp; Chart" Height="357" Width="590">
    <DockPanel LastChildFill="True">                        
            <toolkit:DataGrid ItemsSource="{Binding Path=Data}" Height="118" AutoGenerateColumns="False" DockPanel.Dock="Top">
                <toolkit:DataGrid.Columns>
                    <toolkit:DataGridTextColumn Binding="{Binding Date}" Header="Date"/>
                    <toolkit:DataGridTextColumn Binding="{Binding Value}" Header="Value"/>
                </toolkit:DataGrid.Columns>
            </toolkit:DataGrid>
                    <charting:Chart DockPanel.Dock="Bottom">
                <charting:LineSeries
                    ItemsSource="{Binding Path=Data}"
                    IndependentValuePath="Date"
                    DependentValuePath="Value"/>
                <charting:AreaSeries
                    ItemsSource="{Binding Path=Data}"
                    IndependentValueBinding="{Binding Date}"
                    DependentValueBinding="{Binding Value}"/>
        </charting:Chart>                
    </DockPanel>
</Window>

And the Code Behind

namespace WpfDataGrid
{
    public partial class Window2 : Window
    {
        public Window2()
        {
            InitializeComponent();
            DataContext = this;
            Init();
        }
        private void Init()
        {
            _data.Add(new Point(new DateTime(2010, 1, 1), 20));
            _data.Add(new Point(new DateTime(2010, 2, 1), 32));
            _data.Add(new Point(new DateTime(2010, 3, 1), 55));
            _data.Add(new Point(new DateTime(2010, 4, 1), 84));
            _data.Add(new Point(new DateTime(2010, 5, 1), 68));
        }
        ObservableCollection<Point> _data = new ObservableCollection<Point>();
        public ObservableCollection<Point> Data
        {
            get{ return _data;}
        }
        public class Point : DependencyObject
        {
            public static readonly DependencyProperty _date = DependencyProperty.Register("Date", typeof(DateTime), typeof(Point));
            public Point(DateTime date, double value)
            {
                Date = date;
                Value = value;
            }
            public DateTime Date
            {
                get { return (DateTime)GetValue(_date); }
                set { SetValue(_date, value); }
            }
            public static readonly DependencyProperty _value = DependencyProperty.Register("Value", typeof(double), typeof(Point));
            public double Value
            {
                get { return (double)GetValue(_value); }
                set { SetValue(_value, value); }
            }
        }
    }
}