From C Sharp to C Sharp - dirges and developers

Why you should be Careful on Public Computers

brian — Sun, 08 Nov 2009 09:22:06 -0700

So, to begin, the following has NOT happened to me, but I wanted to make sure people understand why public computers and certain browser features can be bad... very bad for you.

Let's say you sign in to your email account on a public, or unfamiliar computer. The machine asks you to save the password for that site, and silly you, chooses to accept. OK. So, now you've finished your work,you haven't erased your tracks, and the next person comes along... if the next person comes to the same email provider that you have visited, they'll see something like this :

username
password

yikes

So yeah, they can login as you, see all your mail, perhaps other sensitive information in emails...in short, they can find out a lot. If they were really naughty, they would just do this in the address bar and get your password :

javascript:alert(document.getElementById('Pass').value);

without looking at the src code on this page, you can try it here and see what I've set as the password above.

What can you do? Well, here are 5 safety tip for using a public computer.

Simple Year Pivoting Function

brian — Mon, 05 Oct 2009 20:54:03 -0600

Year after year you know you have a product that will be updated at a[round] a certain month. It happens a lot with my business domain. Rather than changing lots of text, this should work nicely for my needs. (I didn't use any timezone or culture considerations)

the pivot month is the int that decides when we flip to next year.

/// <summary>
/// Figures out if should use this year 
///or next based on a defined pivot month.
/// </summary>
/// <returns>4 digit year</returns>
public int YearPivot(DateTime dt, int pivotMonth)
{
     return (dt.Month <= pivotMonth) ? dt.Year : dt.AddYears(1).Year;
}

couple tests showing it in action...

DateTime dt = new DateTime(2009, 10, 1);
//returns 2009
Assert.AreEqual(2009, m.YearPivot(dt, 10));
//returns 2010
Assert.AreEqual(2010, m.YearPivot(dt, 5));

What software/hardware has your Employer Gotten for YOU?

brian — Fri, 21 Aug 2009 06:06:00 -0600

I work for a fabulous company, I've been with them for about 3 years. They are incredible about making sure developers have what they need to get the job done, whether it's software or hardware (or classes, or books). In fact, I'm on my third development machine! Most software requests are usually also granted.

So what does your gear look like? What development software has your company gotten for you to help better your work?

This is what it looks like for me:(as of posting)

Hardware:

Windows XP 64, core 2 quad @ 2.5 GHz, 8 gigs of ram
3 19 inch widescreen monitors
microsoft natural ergo keyboard
trackball mouse
physical server 03 box [for testing]
various XP/03 virtual machines [more testing]

Software:

Resharper 4
dotTrace
NDepend
NCover complete
RegexBuddy
BareTail Pro
All the microsoft dev. stuff (VS 03,05,08, SQL server 05,08)
Snag it
ultramon

What about you?

A Better string.IsNullOrEmpty and more...

brian — Fri, 19 Jun 2009 19:40:09 -0600

Here's a better version of string.IsNullOrEmpty(). Why is it better you say? Well my friend, this one checks the string for spaces... It also returns a positive statement (true if it is NOT null and NOT empty)

    public static class Extensions
    {
        public static bool IsSafe(this string s)
        {
            return (s != null && s.Trim().Length > 0);
        }
    }

And some unit tests...

       [Test]
        public void IsSafeStringTest()
        {
            string cheese = "is good";
            Assert.IsTrue(cheese.IsSafe());
            cheese = "";
            Assert.IsFalse(cheese.IsSafe());
            cheese = "   ";
            Assert.IsFalse(cheese.IsSafe());
            cheese = null;
            Assert.IsFalse(cheese.IsSafe());
 
            //-------------------------------
            cheese = "yum";
            Assert.IsFalse(string.IsNullOrEmpty(cheese));
            cheese = "";
            Assert.IsTrue(string.IsNullOrEmpty(cheese));
            cheese = null;
            Assert.IsTrue(string.IsNullOrEmpty(cheese));
 
            // rut roh... 
            // string.IsNullOrEmpty() and spaces are not nice together.
            cheese = "   ";
            // should be true!
            Assert.IsFalse(string.IsNullOrEmpty(cheese));
 
 
        }

While the following might be nice, we know that we can't do it because of the null reference exception we might get (if cheese were to be null)...

string.IsNullOrEmpty(cheese.Trim());

Anyway, while we're doing some extension methods, here's a similarly named one I also use when working with generic lists.

        public static bool IsSafe<T>(this List<T> t)
        {
            return (t != null && t.Count() > 0);
        }

And some unit tests...

       [Test]
        public void IsSafeListTest()
        {
 
            var objectList = new List<object>();
            Assert.IsFalse(objectList.IsSafe());
 
            List<int> intList = null;
            Assert.IsFalse(intList.IsSafe());
 
            var stringList = new List<string>(){"cheese","beer","nachos"};
            Assert.IsTrue(stringList.IsSafe());
        }

NUnit Talk Goods

brian — Sun, 14 Jun 2009 08:16:12 -0600

As promised, the materials.

Giving a Presentation on NUnit at CTDOTNET '09

brian — Sun, 24 May 2009 09:35:49 -0600

Yo yo howdy-doody. I'm doing a talk on NUnit (and friends) with VS 2008 at CTDOTNET's second CodeCamp -- June 13th, 2009.

It's an intro to unit testing, but I'll talk about reasons why testing is beneficial, how to setup a unit testing environment, and tools (friends) to use along the way.

Get the deets about the day.

Hope to see you there!

Unit Test a DataReader with NUnit, Moq and Stubs

brian — Sat, 02 May 2009 08:36:17 -0600

This post will allow you to unit test objects that have a dependency on a SqlDataReader by mocking/stubbing a data reader.

Here I've made a 'wrapper' of sorts for the good ol' Microsoft SqlHelper class, which is ancient now, ya? Since the SqlHelper.ExecuteReader's method class implements the IDataReader interface we're in luck.

public interface IFetch {
//add members as necessary
IDataReader ExecuteDataReader(string connectionString, 
string storedProcedureName,SqlParameter[] parameters);
}
 
public class Fetch : IFetch {
 
public IDataReader ExecuteDataReader(string connectionString, 
string storedProcedureName, SqlParameter[] parameters){
return SqlHelper.ExecuteReader(connectionString, 
CommandType.StoredProcedure,storedProcedureName, 
parameters);
}
 
}

Next we create our object from the results of our IDataReader. The SqlHelper class removes the worry about mocking SqlCommand and SqlConnection classes. All you need to worry about are the results (SqlDataReader).

(You can make your own RockStar object, fo sho.)

Whether you call it constructor initialization or constructor chaining, we have it here, and will allow us to inject the correct dependency, in this case, an interface that defines an ExecuteReader method. (I've never gotten into DI/IoC frameworks, should I, and which??)

private readonly RockStar rs;
private readonly IFetch fetch;
 
//here's the magic sauce for the unittests
public FetchCms(IFetch fetch, RockStar rs){
this.fetch = fetch;
this.rs = rs;
}
//production code calls this which calls 
//the other constructor. mmm.
public FetchRockStar() : this(new Fetch(), new RockStar()) { }
 
public RockStar GetRockStar(string urlToLookup){
try
{
var parms = new[] { new SqlParameter("@urlName", urlToLookup) };
using (IDataReader reader = 
fetch.ExecuteDataReader("localhell", "rockstar_page_get",parms)){
if (reader != null && reader.Read()){
rs.Name = reader["name"].ToString();
rs.Guitar = reader["guitar"].ToString();
//add some logic... and so on...                       
}
}
}
catch //swine flu
{}
return fs;
}

ok, so now your production code is hawt, but how do you 'fake' a reader, or 'fake' its results? Good question, but never fear, Phil Haack has you covered with his totally rock-tacular StubDataReader class. Get it.

so now, in your UnitTest project...

I'm creating some fake results that I can use to test my expectations, using the StubDataReader class you've downloaded above and added to your UnitTest project.

private static StubDataReader getData_Kerry_King(){
var resultSet = new StubResultSet("name", "guitar");
resultSet.AddRow("Kerry King", "B.C. Rich");
return new StubDataReader(resultSet);
}

I'm using the Moq framework to mock my interfaces. (it's from an older release, hence the Expect calls rather than the Setup calls [anyone: what does the new version get me?])

[Test]
public void Execute_DataReader_Test() {
var m = new Mock<IFetch>();
//here i'm expecting that my ExecuteReader implementation
//return my 'fake' data
m.Expect(
x => x.ExecuteReader(
It.IsAny<string>(), 
It.IsAny<string>(), 
It.IsAny<SqlParameter[]>()
)
).Returns(getData_Kerry_King());
 
var rockStar = new RockStar();
// pass IN the interface using the special constructor.
var fetch = new FetchRockStar(m.Object, rockStar);
rockStar = fetch.GetRockStar("kerry-king");
//assert
Assert.AreEqual("Kerry King",rockStar.Name);
Assert.AreEqual("B.C. Rich",rockStar.Guitar);
}

Even Kerry thinks you should be testing!

My Site's Analytics Graph as a Stock Graph

brian — Fri, 10 Apr 2009 06:42:58 -0600

After looking at google analytics (ga) graphs all these months, I've come to the conclusion that if my site's ga graph were that of a stock/eft/etc I'd be a RICH dude. I'm guessing you'd be too since it's not a terribly new phenomenon; traffic or sales dropping off on the weekend. Akin to the turmoil on wall street, investors are often afraid to hold securities over the weekend. I don't blame them.

But really what do people do on the weekends? Beats me. I guess they don't read my blog! Granted it is somewhat technical-related. I don't read anyone's on the w/e either so whatev.

Ok, so here is the ga graph... (this is a snapshot from a month ago... by week)

I can assure you, this continues on for months...and months.... and months.

"So what does this all mean?" you ask. Well, in the next highly technically list, I will tell you the secret to becoming rich in this psuedo website exchange.

1. Know the future (which I clearly know regarding this site's traffic)
2. Buy / Cover low.
3. Sell / Short high.

Here I've clearly laid out the points for which actions should be taken! Depending on your strategy, buying, shorting or both (just not at the same time :)) you too can be richy!

happy trading.

Tips for Decreasing the Size of Dynamically Created HTML

brian — Sun, 15 Feb 2009 18:26:16 -0700

If you're like me, and make all of your data-related html bits yourself because you want full control of its output or you enjoy micro optimization... read on.

You're doing your loop thing with your StringBuilder thing because your specs say all the data needs to be on the same page (no paging, more-data-as-you-scroll (or other ajax) [bad specs, eh? Or you're just doing it wrong].

You finally got your page finished, loaded and hot DAMN it's 950kb. That's CRAZY! You gotta do something about that! You'll definitely want to optimize the html that is created during the looping operation. You know, it looks something like this...

StringBuilder sb = new StringBuilder();
sb.Append("<table>");
for(int i=0; i<aZillion; i++) {
sb.Append(@"<tr class=""oddTableDataRow""><td align=""center"" valign=""middle"">blah</td>
<td class=""bottomBorderDarkest""><strong>zonk</strong></td></tr>");
}
sb.Append("</table>");

Ok, so that was very simple. Obviously most cases are much more complicated, but still, it can be optimized. Some of these are general, others are very specific... some might not even be 100% html standards compliant. But hey, no one likes a slow loading page?

here we go:

· Make sure all css classes are actually used, and necessary.

· NO, I repeat, NO inline styles or style-like attributes. Everything should be done in your style sheet(s).

sb.Append(@"<tr><td width=""500"" align=""left"" valign=""top"">...);

· Use the smallest possible names for css classes, css ids, and javascript function names

Instead of id="header" use id=hdr
Instead of class="topBorderNew" use class=tbn
Instead of SomeJsFunctionThatIsPairedWithEachRow(); use s();

· If you have to make words 'stand out,' use instead of , it's shorter

a = 8 characters.
a = 18 characters.

We're on an html diet, so sorry semantics!

· use instead of 
(same logic as above)

· Use the innerHTML of a dropdown (<select>, rather than its value) (unless innerHTML and value are wildly different). <select> boxes are notorious for using up lots of Kbs.

· don't use double quotes (or any quotes for that matter).

<img src=image.jpg /> rather than <img src="image.jpg" />
<td class=blah> instead of <td class="blah">

· if you have lots of line breaks, use instead of 

google does it all the time.

· limit the use of tags

Use a parent container/selector to modify a would-be span-wrapped item.

· Don't use an 'odd' and an 'even' class for row highlighting.
Use one of them. You pick. (You could argue that this can easily be done client-side, but with large datasets you will notice the striping applied after the page is loaded.)

With some of these strategies, I turned a 950kb dynamically-generated page into 603kb page. That's a 36% savings! You could argue that, it's still pretty hefty, or most of this now can be done client-side, or hey "use a templating language" dumbo... but it isn't always an option.

$$cha-ching!$$

If you tried any of these and they worked for you, let me know how many kbs you saved! Or please give any of your own.

Google's Font is smaller?

brian — Mon, 19 Jan 2009 16:48:57 -0700

Is it me... or did today, about perhaps 2-3pm EST, google made all their fonts a tad bit smaller?

UPDATE: I'm a dumbsky :)

OMG I could save if I bundle my services!?

brian — Sat, 03 Jan 2009 12:03:20 -0700

Really? Yeah you bet!

I usually just toss that junk snailmail from the cable/phone company, but this time, they made me a special deal with part of my name in the url! We'll call this company pomcast (no disrespect to the real pomcast.com). I couldn't resist.

Something like http://www.mypomcastsavings.com/MYNAMEHERE0321... (like that sort of dynamic url has never been done before. dumbskys).

So in my clicking around the site specifically made for me and all my bundled needs, i noticed a nifty little savings calculator!

Since I don't have cable (minus the ~8 channels that comes with my internet), I entered $59.00 for internet and $0.00 for telephone (mobile phone is all I need)...

And look at my savings...

that's right, $-7.00. I would have the amazing privilege of paying them more per month for a service completely useless to me! HOT.

Not a terribly great marketing tactic.

Dynamically Add UserControls based on the Request URL

brian — Tue, 16 Dec 2008 20:47:05 -0700

You have a data-driven site and you like to keep the number of .aspx files to a minimum, so you opt for UserControls. Ok cool!

Something you can do to be more dynamic-y is to name a UserControl the same as the requesting url, then check its existence on PageLoad. If it exists, load it into an asp:PlaceHolder control (or some other control). This can help keep your site more modular, and perhaps increase the chances that you'll reuse a UserControl in another project...or not.

Here the UserControls are stored in the /UserControls/dynamic folder on my site.

In your aspx page, we make an asp:PlaceHolder...

<asp:PlaceHolder ID="PHUserControls" runat="server"></asp:PlaceHolder>

And in code behind, on PageLoad... we make the path of the UserControl and see if it exists. If it does, we add it to the placeholder.

string path = AppDomain.CurrentDomain.BaseDirectory + "UserControls\\dynamic\\" + PageUrl + ".ascx";
if (File.Exists(path))
{
Control c = LoadControl("~/UserControls/dynamic/" + PageUrl + ".ascx");
PHUserControls.Controls.Add(c);
}

Beginning Extension Methods

brian — Sun, 14 Dec 2008 14:56:00 -0700

Extension methods have been around since C# 3.0 came out, which I guess was some time ago. I really like using them. The syntax is short and neat. Notice how the example below lives in a static class. Nutty eh!?

This example is for all you foos out there that might not be checking input before it's passed down into the database. It checks the input string for null/empty and if there's something, it will replace a single quote with two single quotes (since the single quote is arguably the most devastating character in user inputs / SQL inserts)

   public static class StringUtils
    {
        public static string ToSafeSql(this string s)
        {
            return (s == null || s.Trim().Length == 0) 
            ? "" 
            : s.Replace("'", "''");
        }
    }

Intro to Pre-processing Directives

brian — Mon, 08 Dec 2008 20:31:37 -0700

So, I totally dig pre-processor directives. Use them all the time. Do you? I hope so! It can make a Debug build ready for a Release build with the change of a dropdown in Visual Studio.

Here's an example to change the logPath string if you're building in Debug mode (or anything else). This could be very handy with programmatically creating a log4net config.

        string logPath;
#if DEBUG
        logPath = @"C:\csharptocsharp.com\log.txt";
#else
        logPath = @"Q:\sites\csharptocsharp.com\logs\log.txt";              
#endif

Anyway, if you're not using preprocessor directives in your code, then what are you waiting for?

Other References:
MSDN Preprocessor directives

Log4Net Config to Make Your Log4Net Loggin' Kickin' [Part 2]

brian — Mon, 08 Dec 2008 20:03:52 -0700

So in my first Log4Net Config post a weee time back, I talked about a hot way to configure your log4net settings using a composite, rolling logging model.

Here, I have that same log4net config, but done in code! It doesn't have the same flexibility of the web.config or an xml file if you're frequently changing values--since you'd have to push code for any changes--but it does make any logic easier.

It begs the usage of preprocessor directives for setting File [location], PatternLayout, or Threshold.

log4net.Appender.RollingFileAppender a = 
new log4net.Appender.RollingFileAppender();
a.Name = "RollingFileAppender";
a.File = @"c:\blah.com\log.txt";
a.AppendToFile = true;
a.RollingStyle = log4net.Appender.RollingFileAppender.RollingMode.Composite;
a.MaxSizeRollBackups = 14;
a.CountDirection = 1;
a.MaximumFileSize = "15000KB";
a.StaticLogFileName = true;
a.Layout = new log4net.Layout.PatternLayout(@"{%level}%date{MM/dd HH:mm:ss} - %message%newline");
a.ActivateOptions();
a.Threshold = log4net.Core.Level.Debug;
log4net.Config.BasicConfigurator.Configure(a);

(Thanks to my buddy J.A. for showing me this).

Enjoy!