NuRoN Consulting, INC

So I had to do manipulate data to a PHP app that needed to be pack("H*",...) in the PHP world. After a lot of digging I found

 So you want to know if a process is running...

using System.Diagnostics;

public static bool IsProcessAlreadyRunning()
{
    Process currentProcess = Process.GetCurrentProcess();
     List<Process> processes = Process.GetProcesses().Where(x=>x.ProcessName == currentProcess.ProcessName).ToList<Process>();
     return (processes.Count > 1);
}

Enjoy!

I had a problem with one of my clients that each time i turned around the data needed to be posted to someone new...

So I decided to create an configurable posting mechanism. A UI that you place the URL and some static data for the partner and a mapping section.

What I came up with is:

1. The Admin UI has a DataList which the postback will build the XML as needed to be stored in the database.
2. Some reflection code based off the XML that build the string to post to the 3rd party.

The hardest part was figuring out the reflection so the object with the data in it, lets call it Cutomer c, to get c.FirstName dynamically it is done by c.GetType().GetProperty("FirstName").GetValue(c, null).

Not too bad at the end.

Most complete email regex I have found...

It is adaptaion of RFC 2822 from (http://www.regular-expressions.info/email.html) to allow upper & lower case & not allow comma

RegexStringValidator

x = new RegexStringValidator("(?:[a-zA-Z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-zA-Z0-9!#$%&'*+/=?^_`{|}~-]+)*|\"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x7f\x2c]|\\[\x01-\x09\x0b\x0c\x0e-\x7f\x2c])*\")@(?:(?:[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?\\.)+[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?|\\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-zA-Z0-9-]*[a-zA-Z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f\x2c]|\\[\x01-\x09\x0b\x0c\x0e-\x7f\x2c])+)\\])");

So I needed to create an audit trail on SQL with ASP_NET authentication. I did some digging and came up with:

http://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/
http://www.auditdatabase.com/Downloads.html

I took the code from AuditDatabase.com and made some changes.

You can find it all in the downloads area: http://www.nuronconsulting.com/File-Download.aspx in the SQL folder Auditing.
There is also a script there that will generate the triggers for this.

I was having a hard time finding a way to calculate holidays. I put together some things I found on the web and came up with Holidays.cs It provides a way to easily get US & Jewish holidays if you are working in C# or VB.NET.

Enjoy! & here is the file.

Just getting this site up and running. I plan to use the blog as a place to put code that I hunt for which can be widely used.