NDepend and complex methods.

First I want to say I am no expert on NDepend. I have just begun my journey. If you are unfamiliar with NDepend here is a description straight from there website.

"NDepend is a tool that simplifies managing a complex .NET code base. Architects and developers can analyze code structure, specify design rules, plan massive refactoring, do effective code reviews and master evolution by comparing different versions of the code. "

This is no lie! For those of you who are starting to analyze your code and are attempting to improve the overall architecture this product is a must have.

Getting Started

To get started its pretty straight forward. You take your compiled assembly's and point NDepend at them. Here are instructions straight from the quick start tutorial.

After unzipping the software into a directory of your choosing, there is no installation program, you follow these steps.

Run VisualNDepend.exe. There is no shortcut you will need to load it from where you unzipped it.
Select the option: Select assemblies to analyze.
Populate the data grid with your assemblies by using the browse button or by using drag&drop.
Click OK. (This will take a few minutes)

The result will look something like this.

Here are a list of some short beginning video tutorials to get you started. I have to admit a prefer short videos and NDepend does not disappoint. Everyone's time is extremely valuable and getting to the heart of the matter, matters!

NDepend Basics

Analyzing Assemblies

Building a NDepend Project

Complex Methods

It would take 1000 blog posts to go through how you can use this product. Today I just wanted to show you how I used it to identify a function that was more complex than it needed to be.

Below is a code snippet of a method of a class that manages Excel files. It is designed to take a regular expression and search all sheets and all cells for a match. Once the match is found the method return the associated cell.

   1: public Cell GetCellByRegEx(string regularExpression)

   2:       {

   3:           Check.Require(this._xlsFile != null);

   4:           Check.Require(!string.IsNullOrEmpty(regularExpression));

5:

   6:           var colCount = this._xlsFile.ColCount;

   7:           var rowCount = this._xlsFile.RowCount;

   8:           var sheetcount = this._xlsFile.SheetCount;

9:

  10:           for (var s = 1; s < sheetcount; s++)

  11:           {

  12:               this._xlsFile.ActiveSheet = s;

13:

  14:               for (var r = 1; r <= rowCount; r++)

  15:               {

  16:                   for (var c = 1; c <= colCount; c++)

  17:                   {

  18:                       var v = this._xlsFile.GetCellValue(r, c);

  19:                       if (v != null)

  20:                       {

  21:                           var regex = new Regex(

  22:                               regularExpression,

  23:                               RegexOptions.IgnoreCase);

  24:                           var matches = regex.Matches(v.ToString());

25:

  26:                           if (matches.Count > 0)

  27:                           {

  28:                               var cell = new Cell { Row = r, Column = c, Value = v.ToString() };

29:

  30:                               return cell;

  31:                           }

  32:                       }

  33:                   }

  34:               }

  35:           }

36:

  37:           return null;

  38:       }

There is a section for code quality query's within NDepend. It is designed to run through your code and analyze how it is constructed based on query's made by the developers of the product. These rules of course are based on what they believe is a best practice. Users of the product will end using there own skill to determine what is right or wrong. The goods news is that you can change these CQL queries at any time. Below is a screen capture of what a CQL looks like.

I have highlighted below a CQL result that describes "Methods too complex". There are 4 methods in my project that have been deemed too complex.

The above method "GetCellByRegEx" has a IL Nesting depth of 5. When you select a query result below you will see a listing of the methods that make up that result.

On the bottom right hand side of the NDepend screen shows the results of the CQL Code Quality queries run against your code assembly.

Shows when you select edit on the "Methods too complex" CQL item.

Solving the Problem

Now that you have identified that you have a method that is too complex what do you do. Just fix it right! Easier said than done is most cases. There is some good news though. Most of the CQL items I have seen provide you with some assistance right in the query edit screen. Looking closely CQL Query Edit screen you will see a link to help on this subject.

Here is a snippet from NDepend that covers what this query is suppose to track and what they recommend.

IL Nesting Depth: The metric Nesting Depth for a method is the maximum number of encapsulated scopes inside the body of the method. The metric IL Nesting Depth is computed from the IL code. Values computed are very similar to what we would expect by computing them from the C# or VB.NET source code.
When you have a testing condition with N conditions, such as if( i > 9 && i < 12) then it is considered as N scopes because it is possible to decompose such conditions into N atomic conditions.
When a method has a large number of case statements corresponding to a switch, the C# and VB.NET compiler generally produce optimizations while generating the IL. In such case, the IL Nesting Depth corresponding value might be slightly higher to what you would expect.

Recommendations: Methods where ILNestingDepth is higher than 4 are hard to understand and maintain. Methods where ILNestingDepth is higher than 8 are extremely complex and should be split in smaller methods (except if they are automatically generated by a tool).

Related Link::
A simple trick to code better and to increase testability

After following the link and using there simple trick to adjust my code as follows the method was no longer deemed complex.

   1: public Cell GetCellByRegEx(string regularExpression)

   2:       {

   3:           Check.Require(this._xlsFile != null);

   4:           Check.Require(!string.IsNullOrEmpty(regularExpression));

5:

   6:           var colCount = this._xlsFile.ColCount;

   7:           var rowCount = this._xlsFile.RowCount;

   8:           var sheetcount = this._xlsFile.SheetCount;

9:

  10:           for (var s = 1; s < sheetcount; s++)

  11:           {

  12:               this._xlsFile.ActiveSheet = s;

13:

  14:               for (var r = 1; r <= rowCount; r++)

  15:               {

  16:                   for (var c = 1; c <= colCount; c++)

  17:                   {

  18:                       var v = this._xlsFile.GetCellValue(r, c);

  19:                       if (v == null)

  20:                       {

  21:                           continue;

  22:                       }

  23:                       var regex = new Regex(

  24:                           regularExpression,

  25:                           RegexOptions.IgnoreCase);

  26:                       var matches = regex.Matches(v.ToString());

27:

  28:                       if (matches.Count <= 0)

  29:                       {

  30:                           continue;

  31:                       }

  32:                       var cell = new Cell { Row = r, Column = c, Value = v.ToString() };

33:

  34:                       return cell;

  35:                   }

  36:               }

  37:           }

38:

  39:           return null;

  40:       }

Conclusion

I have been developing software for 20+ years and the tools just keep getting better and better. If you have the time and the inclination to improve your existing architecture you owe it to yourself to take a look at this product.

Currently rated 1.0 by 1 people

Currently 1/5 Stars.
1
2
3
4
5

Categories: Agile | C#

Posted by Bryan on Saturday, August 09, 2008 4:29 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Latitude, Longitude, Bearing, Cardinal Direction, Distance, and C#

If you are looking for some examples of using latitude and longitude to get bearing and distance information with C# you have come to the right place. If you want to get straight to the code and the download click here.

I usually try to blog about things that I am working on that also could be interesting to other developers. Recently I have been working on an application that stores information about commercial buildings and there competition. Each location has a latitude and longitude which is used to display there data on a map.

To visualize the end result I have added a picture below of an application that is using using ASP.Net, Virtual Earth, while calculating bearing and distance. This was inspire by Alessandro Gallo article. If you are interesting in building a Virtual Earth mash-up using ASP.NET this is a must read article. When the user puts there mouse over a location a pop-up with the distance and bearing are shown. The distance is in miles while the bearing is represented by its cardinal value or compass direction.

Calculating Distance between two points of Latitude and Longitude

The function below uses the Haversine formula to calculate the distance between the to coordinates and a enumeration to request the type of unit of length.

   1: /// <summary>

   2: /// Calculates the distance between two points of latitude and longitude.

   3: /// Great Link - http://www.movable-type.co.uk/scripts/latlong.html

   4: /// </summary>

   5: /// <param name="coordinate1">First coordinate.</param>

   6: /// <param name="coordinate2">Second coordinate.</param>

   7: /// <param name="unitsOfLength">Sets the return value unit of length.</param>

   8: public static Double Distance(Coordinate coordinate1, Coordinate coordinate2, UnitsOfLength unitsOfLength)

   9: {

10:

  11:     var theta = coordinate1.Longitude - coordinate2.Longitude;

  12:     var distance = Math.Sin(coordinate1.Latitude.ToRadian()) * Math.Sin(coordinate2.Latitude.ToRadian()) +

  13:                    Math.Cos(coordinate1.Latitude.ToRadian()) * Math.Cos(coordinate2.Latitude.ToRadian()) *

  14:                    Math.Cos(theta.ToRadian());

15:

  16:     distance = Math.Acos(distance);

  17:     distance = distance.ToDegree();

  18:     distance = distance * 60 * 1.1515;

19:

  20:     if (unitsOfLength == UnitsOfLength.Kilometer)

  21:         distance = distance * _MilesToKilometers;

  22:     else if (unitsOfLength == UnitsOfLength.NauticalMiles)

  23:         distance = distance * _MilesToNautical;

24:

  25:     return (distance);

26:

  27: }

Originally the function was made with 4 double values representing the latitude and longitudes for each coordinate. While unit testing I tested incorrect coordinates. I found myself adding ArgumentOutOfRangeExceptions directly into the distance function above. I did not like the feeling of this so I encapsulated the throwing of the exceptions in a coordinate class. This reduced the code for the distance function and made the code clearer.

   1: public class Coordinate

   2:    {

   3:        private double latitude, longitude;

4:

   5:        /// <summary>

   6:        /// Latitude in degrees. -90 to 90

   7:        /// </summary>

   8:        public Double Latitude

   9:        {

  10:            get { return latitude; }

  11:            set

  12:            {

  13:                if (value > 90) throw new ArgumentOutOfRangeException("value", "Latitude value cannot be greater than 90.");

  14:                if (value < -90) throw new ArgumentOutOfRangeException("value", "Latitude value cannot be less than -90.");

  15:                latitude = value;

  16:            }

  17:        }

18:

  19:        /// <summary>

  20:        /// Longitude in degree. -180 to 180

  21:        /// </summary>

  22:        public Double Longitude

  23:        {

  24:            get { return longitude; }

  25:            set

  26:            {

  27:                if (value > 180) throw new ArgumentOutOfRangeException("value", "Longitude value cannot be greater than 180.");

  28:                if (value < -180) throw new ArgumentOutOfRangeException("value", "Longitude value cannot be less than -180.");

  29:                longitude = value;

  30:            }

  31:        }

  32:    }

Here are some of the unit tests that for the coordinate class.

   1: [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

   2:      public void CoordinateLatitudeGreater90() { var coordinate = new Coordinate() { Latitude = 100, Longitude = -90 }; }

3:

   4:      [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

   5:      public void CoordinateLatitudeLessN90() { var coordinate = new Coordinate() { Latitude = -91, Longitude = -90 }; }

6:

   7:      [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

   8:      public void CoordinateLongitudeGreater180() { var coordinate = new Coordinate() { Latitude = 90, Longitude = 190 }; }

9:

  10:      [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  11:      public void CoordinateLongitudeLessN180() { var coordinate = new Coordinate() { Latitude = 90, Longitude = -190 }; }

Here is an example usage of the distance function.

   1: var distance = Helper.Distance(new Coordinate() { Latitude = 45, Longitude = 0 },

   2:                                new Coordinate() { Latitude = 0, Longitude = 45 }, UnitsOfLength.NauticalMiles);

3:

   4: Assert.AreEqual(3599.8653599999993d, distance, "");

Calculating Bearing and Cardinal Direction

First, I have to give thanks to wikipedia for explaining what a cardinal point was. I never really thought about it until I thought about writing this article. So for all of you who don't already know the location on your compass that say, "N,S,E,W" are called cardinal points. I am not generally one for being a stickler for using the correct nomenclature, but since I went and looked it up, you can benefit from it.

First things first, we need to create a function that takes two coordinates that returns a direction in degrees. Here is where my decision to encapsulate the latitude and longitude values paid some dividends. Now the code will check the latitude and longitude values before it evaluates this function.

   1: /// <summary>

   2:       /// Accepts two coordinates in degrees.

   3:       /// </summary>

   4:       /// <returns>A double value in degrees.  From 0 to 360.</returns>

   5:       public static Double Bearing(Coordinate coordinate1, Coordinate coordinate2)

   6:       {

   7:           var latitude1 = coordinate1.Latitude.ToRadian();

   8:           var latitude2 = coordinate2.Latitude.ToRadian();

9:

  10:           var longitudeDifference = (coordinate2.Longitude - coordinate1.Longitude).ToRadian();

11:

  12:           var y = Math.Sin(longitudeDifference) * Math.Cos(latitude2);

  13:           var x = Math.Cos(latitude1) * Math.Sin(latitude2) -

  14:                   Math.Sin(latitude1) * Math.Cos(latitude2) * Math.Cos(longitudeDifference);

15:

  16:           return (Math.Atan2(y, x).ToDegree() + 360) % 360;

  17:       }

Now that we have a function that will return the bearing in degrees we need to convert those degrees to there cardinal value.

An enumeration to store the cardinal points.

   1: public enum CardinalPoints { N, E, W, S, NE, NW, SE, SW }

A class to store the ranges used to evaluated the cardinal points.

   1: /// <summary>

   2: /// Class is used in a calculation to determin cardinal point enumeration values from degrees.

   3: /// </summary>

   4: private struct CardinalRanges

   5: {

   6:     public CardinalPoints CardinalPoint;

   7:     /// <summary>

   8:     /// Low range value associated with the cardinal point.

   9:     /// </summary>

  10:     public Double LowRange;

  11:     /// <summary>

  12:     /// High range value associated with the cardinal point.

  13:     /// </summary>

  14:     public Double HighRange;

  15: }

The function to evaluate and return the cardinal direction.

   1: /// <summary>

   2:        /// Method extension for Doubles. Converts a degree to a cardinal point enumeration.

   3:        /// </summary>

   4:        /// <returns>Returns a cardinal point enumeration representing a compass direction.</returns>

   5:        public static CardinalPoints ToCardinalMark(this Double degree)

   6:        {

7:

   8:            var CardinalRanges = new List<CardinalRanges>

   9:                       {

  10:                         new CardinalRanges {CardinalPoint = CardinalPoints.N, LowRange = 0, HighRange = 22.5},

  11:                         new CardinalRanges {CardinalPoint = CardinalPoints.NE, LowRange = 22.5, HighRange = 67.5},

  12:                         new CardinalRanges {CardinalPoint = CardinalPoints.E, LowRange = 67.5, HighRange = 112.5},

  13:                         new CardinalRanges {CardinalPoint = CardinalPoints.SE, LowRange = 112.5, HighRange = 157.5},

  14:                         new CardinalRanges {CardinalPoint = CardinalPoints.S, LowRange = 157.5, HighRange = 202.5},

  15:                         new CardinalRanges {CardinalPoint = CardinalPoints.SW, LowRange = 202.5, HighRange = 247.5},

  16:                         new CardinalRanges {CardinalPoint = CardinalPoints.W, LowRange = 247.5, HighRange = 292.5},

  17:                         new CardinalRanges {CardinalPoint = CardinalPoints.NW, LowRange = 292.5, HighRange = 337.5},

  18:                         new CardinalRanges {CardinalPoint = CardinalPoints.N, LowRange = 337.5, HighRange = 360.1}

  19:                       };

20:

21:

  22:            if (!(degree >= 0 && degree <= 360))

  23:                throw new ArgumentOutOfRangeException("degree",

  24:                                                      "Degree value must be greater than or equal to 0 and less than or equal to 360.");

25:

26:

  27:            return CardinalRanges.Find(p => (degree >= p.LowRange && degree < p.HighRange)).CardinalPoint;

28:

29:

  30:        }

It seems like there could be a better way to check the value ranges but I could not think of one. One thought was to use a simple array of values, but I concluded clearer larger code was better for long term readability.

Unit tests

Some basic unit tests to cover the code.

   1: /// <summary>

   2:    /// Summary description for UnitTest1

   3:    /// </summary>

   4:    [TestFixture]

   5:    public class Maps

   6:    {

7:

   8:        [Test]

   9:        public void DistanceSamePoint0()

  10:        {

  11:            var distance = Helper.Distance(new Coordinate() { Latitude = 90, Longitude = -90 },

  12:                                           new Coordinate() { Latitude = 90, Longitude = -90 }, UnitsOfLength.Mile);

13:

  14:            Assert.AreEqual(0, distance, "");

15:

  16:        }

17:

  18:        [Test]

  19:        public void DistanceSampleDataNauticalMiles()

  20:        {

  21:            var distance = Helper.Distance(new Coordinate() { Latitude = 45, Longitude = 0 },

  22:                                           new Coordinate() { Latitude = 0, Longitude = 45 }, UnitsOfLength.NauticalMiles);

23:

  24:            Assert.AreEqual(3599.8653599999993d, distance, "");

  25:        }

26:

27:

  28:        [Test]

  29:        public void DistanceSampleDataMiles()

  30:        {

  31:            var distance = Helper.Distance(new Coordinate() { Latitude = 45, Longitude = 0 },

  32:                                           new Coordinate() { Latitude = 0, Longitude = 45 }, UnitsOfLength.Mile);

33:

  34:            Assert.AreEqual(4145.3999999999996d, distance, "");

  35:        }

36:

  37:        [Test]

  38:        public void DistanceSampleDataKilometer()

  39:        {

  40:            var distance = Helper.Distance(new Coordinate() { Latitude = 45, Longitude = 0 },

  41:                                           new Coordinate() { Latitude = 0, Longitude = 45 }, UnitsOfLength.Kilometer);

42:

  43:            Assert.AreEqual(6671.3746175999995d, distance, "");

  44:        }

45:

  46:        [Test]

  47:        public void BearingsTests()

  48:        {

  49:            var bearing = Helper.Bearing(new Coordinate() { Latitude = 45, Longitude = 1 },

  50:                                         new Coordinate() { Latitude = 45, Longitude = 0 });

51:

  52:            Assert.AreEqual(270.35355787806577d, bearing, "");

  53:            Assert.AreEqual(CardinalPoints.W, bearing.ToCardinalMark());

54:

  55:        }

56:

  57:        [Test]

  58:        public void CardinalMarkValues()

  59:        {

  60:            Assert.AreEqual(CardinalPoints.N, 2D.ToCardinalMark());

  61:            Assert.AreEqual(CardinalPoints.NE, 46D.ToCardinalMark());

  62:            Assert.AreEqual(CardinalPoints.SE, 120D.ToCardinalMark());

  63:            Assert.AreEqual(CardinalPoints.S, 170D.ToCardinalMark());

  64:            Assert.AreEqual(CardinalPoints.SW, 220D.ToCardinalMark());

  65:            Assert.AreEqual(CardinalPoints.W, 273D.ToCardinalMark());

  66:            Assert.AreEqual(CardinalPoints.NW, 320D.ToCardinalMark());

67:

  68:        }

69:

70:

71:

  72:        [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  73:        public void ToCardinalMarkOutOfRange() { 390D.ToCardinalMark(); }

74:

  75:        [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  76:        public void CoordinateLatitudeGreater90() { var coordinate = new Coordinate() { Latitude = 100, Longitude = -90 }; }

77:

  78:        [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  79:        public void CoordinateLatitudeLessN90() { var coordinate = new Coordinate() { Latitude = -91, Longitude = -90 }; }

80:

  81:        [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  82:        public void CoordinateLongitudeGreater180() { var coordinate = new Coordinate() { Latitude = 90, Longitude = 190 }; }

83:

  84:        [Test, ExpectedException(typeof(ArgumentOutOfRangeException))]

  85:        public void CoordinateLongitudeLessN180() { var coordinate = new Coordinate() { Latitude = 90, Longitude = -190 }; }

86:

87:

  88:    }

Summary

Hope this helps someone out there. Let me know if there is anything I left out.

Bryan Reynolds

C# Developer

Currently rated 5.0 by 4 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: bearing, distance, c#, asp.net, virtual earth

Categories: ASP.NET | Bearing | C# | Distance

Posted by Bryan on Monday, June 02, 2008 12:01 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (3) | Post RSS RSS comment feed

C# Wrapping text using split and List<>

Below is a useful snippet of code to wrap text into a list of strings. Download Click here.

Example

"The quick brown fox jumps over the lazy dog"

Lets say you need to fit this into a multi-line text box with a width or around 12 characters and an unlimited height.

The function will return a list of strings without splitting the individual words.

   1: var result = Wrap("The quick brown fox jumps over the lazy dog", 12);

result [0] = "The quick"

result [1] = "brown fox "

result [2] = "jumps over"

result [3] = "the lazy dog"

This function was used for reporting writing and formatting logs.

The function takes a string of any size and returns a list of string no larger than the max length input variable.

Let me know if this was useful.

   1: using System;

   2: using System.Collections.Generic;

3:

   4: /// <summary>

   5: /// Summary description for StringExtention

   6: /// </summary>

   7: public class StringExtention

   8: {

   9:     /// <summary>

  10:     /// Returns a list of strings no larger than the max length sent in.

  11:     /// </summary>

  12:     /// <remarks>useful function used to wrap string text for reporting.</remarks>

  13:     /// <param name="text">Text to be wrapped into of List of Strings</param>

  14:     /// <param name="maxLength">Max length you want each line to be.</param>

  15:     /// <returns>List of Strings</returns>

  16:     public static List<String> Wrap(string text, int maxLength)

  17:     {

18:

  19:         // Return empty list of strings if the text was empty

  20:         if (text.Length == 0) return new List<string>();

21:

  22:         var words = text.Split(' ');

  23:         var lines = new List<string>();

  24:         var currentLine = "";

25:

  26:         foreach (var currentWord in words)

  27:         {

28:

  29:             if ((currentLine.Length > maxLength) ||

  30:                 ((currentLine.Length + currentWord.Length) > maxLength))

  31:             {

  32:                 lines.Add(currentLine);

  33:                 currentLine = "";

  34:             }

35:

  36:             if (currentLine.Length > 0)

  37:                 currentLine += " " + currentWord;

  38:             else

  39:                 currentLine += currentWord;

40:

  41:         }

42:

  43:         if (currentLine.Length > 0)

  44:             lines.Add(currentLine);

45:

46:

  47:         return lines;

  48:     }

49:

50:

  51: }

Currently rated 5.0 by 2 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: wrap text

Categories: C#

Posted by Bryan on Wednesday, May 07, 2008 11:04 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (4) | Post RSS RSS comment feed

Using LINQ to SQL instead of a sub report.

The post described how to use "Linq to SQL" with XtraReports and DevExpress for displaying relational data within a column of a report.

As a developer's we have all made many reports and used many tools to generate reports. Currently I am working with DevExpress's XtraReports Suite and "LINQ to SQL". For web based relational database system reporting there tools are pretty easy to work with.

Below is a sample output from a report that I am working on. The interesting challenge was the 1 to many relationship within the Competitor column.

The competitor column needs to report all competitors from a 1 to many relationship table. There are many possible solutions to this common problem. Using XtraReports you can make a subreport, you could set the text of the control by pulling the data from the database, or you could have a stored procedure format that data in the SQL engine you use prior to printing the report.

I chose to use "LINQ to SQL" for its quick implementation and ease of use. If you have not had a chance to look at this technology take a look at Scott Gu's post.

In shorts order I was able to have a strongly type set of code that loaded a string with the exact format I needed to solve the problem.

private void Detail_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
   {
       var projectID = Convert.ToInt32(GetCurrentColumnValue("ProjectID"));
       var db = new dbDataContext();
     6:        var queryCompitetion = from recs in db.ProjectCompetitions
                              join comprecs in db.Competitions on recs.CompetitionID equals comprecs.CompetitionID
                              where recs.ProjectID == projectID
                              select new
                                         {
                                             recs.Distance,
                                             recs.Direction,
                                             comprecs.Name,
    15:                                          };
    17:        var stringBuiler = new StringBuilder();
    19:        for (int i = 0; i < queryCompitetion.ToList().Count-1; i++)
       {
           var recs = queryCompitetion.ToList()[i];
           stringBuiler.AppendFormat("{0}/ {1}{2}    ", recs.Name, recs.Distance, recs.Direction);
    24:            if ((i + 1) % 2 == 0) stringBuiler.Append("\r\n");
       }
    27:        
       xrCompetitorCell.Text = stringBuiler.ToString();
   }

The "Detail_BeforePrint" function fires off before each report detail line is displayed. Using the GetCurrentColumnValue function I retrieved the ProjectID for the current line. Used "Linq to SQL" to grab the appropriate data using strong typing. Iterated through the result and add the formatted string to the "xrCompetitorCell". The "xrCompetitorCell" is a property of the report and generated via DevExpress's designer.

Hope this was useful from you.

Bryan

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: linq to sql, asp.net, xtrareports, devexpress

Categories: ASP.NET | C# | LINQ to SQL

Posted by Bryan on Wednesday, April 30, 2008 7:21 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (1) | Post RSS RSS comment feed

LLBLGen Pro and Microsoft’s Dynamic Data will play nice!

I am a big fan of LLBLGen Pro, an n-tier generator and O/R mapper, written mostly by Frans Bouma. For those of you who are not familiar with this product the true value is its creator and evangelist Frans Bouma. The quality product, support and enthusiasm brought by him and his organization is refreshing.

Also recently Microsoft has been working on a ASP.NET extension called Dynamic Data. Dynamic Data currently was scheduled to work with Microsoft O/R mapping initiatives LINQ to SQL and the Entity Framework. Dynamic Data is designed to allow developers to quickly create CRUD pages surrounded by a base scaffolding with a central place to update UI and Validation logic. I know that was a mouthful, and if you are looking for more information there are numerous blogs and sites that you can look at to get familiar with this technology. Some of the more prominent links are below.

MSDN code gallery
Microsoft Evangelists

Good news!

Both Dynamic Data and LLBLgen will be playing nice. It started about a month ago when I was talking David Ebbo whether or not the extension was going to work with other O/R tools and with Frans Bouma about Dynamic Data. After I took Frans through a demo he immediately contacted Microsoft to make it happen. Today I got the email from him telling me they were going to release the product with the appropriate API to allow his product to integrate with Dynamic Data.

I will hopefully have time to go through the bits Frans sent me today. I am excited this produced a situation where I get what I believe to be the best of both worlds, for small projects.

Microsoft was not planning on releasing this API until this happened and I applaud both Microsoft and Frans for bringing the tools together for the community to enjoy.

Thanks!

Bryan Reynolds

C# Developer

Currently rated 5.0 by 2 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: dynamic data, llblgen

Categories: ASP.NET | Dynamic Data | LLBLGen

Posted by Bryan on Friday, April 25, 2008 3:29 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Interesting article about the new C# "var"

Ilya Ryzhenkov, a .NET Tools Product Manager at JetBrains, relays some of his thoughts on the var keyword here.

If you had a chance to use some of the latest c# language features you have no doubt heard of var. Coming from the idea of KISS, keep it simple stupid, I not only agree with Ilya, but would say that this is the way it should have always been. Especially now that we are in the day of IDE's and IDE addon's like JetBrain's resharper we should be reducing the amount of code we need to maintain and making the syntax easier to read.

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Categories: C#

Posted by Bryan on Wednesday, April 23, 2008 11:58 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Dynamic Data - New Code Drop

If you have not had a chance to check out Microsoft's DynamicData you should. I have been working on the latest bits via Microsoft Connect and I have been pleased. It does not fit every need of course. Its not "Enterprise Level" and we can debate what that means for ever. Suffice it to say, if you have a large complex architecture with many developers, this is not the tool. Good news is not all projects are like that. For the many small applications that offices and companies of all size need on a regular basis. This will fill the bill.

Below with virtually no code I was able to modify the default templates to make a customer detail screen that shows the customers jobs. The field captions all the way to the validation are described in a single location to reduce the amount of work you have to do. Its all about being lazy! Or better yet code reduction without functionality reduction.

You can see links on the left below that shows a list of links to function of this tiny program. After talking with the client for about 3 hours. I generated in 30 minutes a complete site for data entry. As the customer requested changes I was able to quickly respond to there requests.

If a field is required via a not null property on your data field via SQL Server. Then the data validation on the screen is linked as well.

Conclusion

Looks like Microsoft is listening to there customers. As a software developer you must take a look at this tool.

Bryan MCPD

C# Developer

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: asp.net, dynamicdata

Categories: ASP.NET | Dynamic Data

Posted by Bryan on Thursday, April 10, 2008 8:34 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (1) | Post RSS RSS comment feed

Fraudulent Companies

Yesterday I got a frantic call from one of our clients. They were concerned that one of the marketing campaigns we manage through our lead system was not performing. They mentioned after looking at some reports they were concerned that this campaign had shut down. Leads were being submitted perfectly fine one day then not at all the next. They thought the system was broken. It was a valid question. I investigated.

During the conversation I looked at the reports myself and quickly realized that someone was messing with us. They were submitting leads at an almost 1 for 1 basis to visits. This was not the pattern we saw for any other lead campaign. 50 visits to a lead was more realistic. This campaign was not only performing at an almost 1 to 1 basis, but all leads were valid on entry. This is of course not realistic either. Normally we see a 5 to 1 ratio on a user submitting a lead and it passing all the validation checks to make sure it’s a real lead. This is not standard for everyone, I am sure. Depending on the validation logic your system has the numbers can be very different. Either way, this was a problem.

We are dealing with this now by adding preventative logic to the system.

Why do they do it? What can be done with people like this?

Currently rated 1.0 by 1 people

Currently 1/5 Stars.
1
2
3
4
5

Tags: internet security

Categories: ASP.NET | General | Lead Management | Marketing

Posted by Bryan on Tuesday, March 18, 2008 7:25 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (2) | Post RSS RSS comment feed

Mocking using TypeMock

Unit testing and using the mocking pattern are new to my team and I. After talking with Ron Shoshani at TypeMock they decided put a video up for beginners.

This video shows you how to break constructor dependency when writing unit tests. Constructor dependency is when you one object depends on another during the creation or construction. When another object is used in the constructor it binds the classes together in a way that makes testing discrete concerns more difficult.

To solve this problem without TypeMock developers would use the Mock Object Pattern. Usually through the use of interfaces a class is created for the use in the test that mocks or mimics what the real functionality would be. Usually this is a simple implementation that does not actually perform the true work that would be needed to implement the interface. The implementation would be just enough to complete the unit tests that use it. This new implementation would then be used in the unit test of the class you wanted to test.

With TypeMock you will be able to mock objects that do not have interfaces, and even more powerful you don't even have to create the mock object implementation. This makes testing objects that have dependant objects much easier to test.

If you have not checked out TypeMock you should do so.

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: mock object, typemock

Categories: Agile

Posted by Bryan on Wednesday, January 30, 2008 5:04 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Datatable Pivot/Crosstab

This article was written to show an example of how to pivot or transform a ADO.Net datatable. This can also be referred to as a crosstab query. This example code below was written for a VB.NET application but you can easily convert this to C#.

These unit tests where written for the MS Unit testing framework within Visual Studio Team System 2008.

I am sure you have seen example of this type before, so I will be brief.

I rewrote this with agile development and unit testing in mind. Basically this code takes a datatable that you want to transform. A key column that defines each unique row. A variable column that will display across the top and a value column representing the data for it.

For this example to work you need to sort the table by that key column. Alternatively, I could add some code to make sure that happens in the view. Will probably update that later.

For those of you that are new to unit testing this was a perfect example of a time when testing came in handy. When I tested the code without variable columns that where of type date the class worked great. As soon as I change the data to a date field the unit test crashed. Below is the result of the modified code by adding ".tostring"

Code for the PivotTable Class

   1: Namespace GEN.DL.Transformation

2:

   3:     Public Class PivotTable

4:

   5:         Private lSourceTable As DataTable

   6:         Private lVariableColumn As DataColumn

   7:         Private lAggregateColumn As DataColumn

   8:         Private lKeyColumn As DataColumn

   9:         Private lDestinationTable As New DataTable

10:

11:

  12: #Region "Public Properties"

13:

  14:         ''' <summary>

  15:         ''' Pivot datatable

  16:         ''' </summary>

  17:         Public Sub New(ByVal mSourceTable As DataTable, ByVal mKeyColumn As DataColumn, _

  18:                        ByVal mVariableColumn As DataColumn, ByVal mValueColumn As DataColumn)

19:

  20:             lSourceTable = mSourceTable

  21:             lKeyColumn = mKeyColumn

  22:             lVariableColumn = mVariableColumn

  23:             lAggregateColumn = mValueColumn

24:

  25:         End Sub

26:

  27: #End Region

28:

  29:         ''' <summary>

  30:         ''' Pivots a datatable

  31:         ''' </summary>

  32:         ''' <returns>Returns pivot datatable</returns>

  33:         Public Function Transform() As DataTable

34:

  35:             Dim mColumn As DataColumn ' Column used in for each to add non essential columns

  36:             Dim mSourceDataRow As DataRow ' Source Row

  37:             Dim mDestinationDataRow As DataRow = Nothing ' Row to be Added

  38:             Dim mCurrentKeyValue As String = "" ' Current Key Name

  39:             Dim mCurrentColumn As String = "" ' Current Column Name

40:

41:

  42:             ' Add All the columns excluding the aggregate and the Variable Column

  43:             For Each mColumn In lSourceTable.Columns

44:

  45:                 If mColumn.Ordinal <> lVariableColumn.Ordinal AndAlso _

  46:                    mColumn.Ordinal <> lAggregateColumn.Ordinal Then

47:

  48:                     lDestinationTable.Columns.Add(mColumn.ColumnName, mColumn.DataType)

49:

  50:                 End If

  51:             Next

52:

  53:             For Each mSourceDataRow In lSourceTable.Rows ' Main Process to add values to pivot table

54:

  55:                 ' Set the current Column Value

  56:                 mCurrentColumn = mSourceDataRow(lVariableColumn.Ordinal).ToString

57:

  58:                 If Not lDestinationTable.Columns.Contains(mCurrentColumn) Then ' Column is new

59:

  60:                     Dim lDataColumn As DataColumn = lDestinationTable.Columns.Add(mCurrentColumn, lAggregateColumn.DataType)

61:

  62:                     ' set the index so that it is sorted properly:

  63:                     Dim newOrdinal As Integer = lDataColumn.Ordinal

  64:                     Dim i As Integer

65:

  66:                     For i = newOrdinal - 1 To lSourceTable.Columns.Count - 2 Step -1

  67:                         If lDataColumn.ColumnName.CompareTo(lDestinationTable.Columns(i).ColumnName) < 0 Then

  68:                             newOrdinal = i

  69:                         End If

  70:                     Next

  71:                     lDataColumn.SetOrdinal(newOrdinal)

72:

  73:                 End If

74:

  75:                 If mCurrentKeyValue <> mSourceDataRow(lKeyColumn.Ordinal).ToString Then ' New Row

76:

  77:                     If Not mCurrentKeyValue = "" Then ' First row

  78:                         lDestinationTable.Rows.Add(mDestinationDataRow)

  79:                     End If

80:

  81:                     mCurrentKeyValue = mSourceDataRow(lKeyColumn.Ordinal).ToString

  82:                     mDestinationDataRow = lDestinationTable.NewRow()

83:

  84:                     For Each mColumn In lSourceTable.Columns

85:

  86:                         If mColumn.Ordinal <> lVariableColumn.Ordinal AndAlso _

  87:                            mColumn.Ordinal <> lAggregateColumn.Ordinal Then

88:

  89:                             mDestinationDataRow(mColumn.ColumnName) = mSourceDataRow(mColumn.ColumnName)

90:

  91:                         End If

  92:                     Next

93:

  94:                 End If

95:

  96:                 mDestinationDataRow(mCurrentColumn) = mSourceDataRow(lAggregateColumn.Ordinal)

97:

  98:             Next

99:

 100:             ' If rows where added, add the last row

 101:             If mCurrentKeyValue.Length > 0 Then lDestinationTable.Rows.Add(mDestinationDataRow)

 102:

 103:             Return lDestinationTable

 104:

 105:         End Function

 106:

 107:     End Class

 108:

 109: End Namespace

Unit Tests

   1: Imports System.Data

   2: Imports Microsoft.VisualStudio.TestTools.UnitTesting

   3: Imports GEN.DL.Transformation

4:

   5: '''<summary>

   6: '''This is a test class for PivotTableTest and is intended

   7: '''to contain all PivotTableTest Unit Tests

   8: '''</summary>

   9: <TestClass()> _

  10: Public Class PivotTableTest

11:

12:

  13:     Private testContextInstance As TestContext

14:

  15:     '''<summary>

  16:     '''Gets or sets the test context which provides

  17:     '''information about and functionality for the current test run.

  18:     '''</summary>

  19:     Public Property TestContext() As TestContext

  20:         Get

  21:             Return testContextInstance

  22:         End Get

  23:         Set(ByVal value As TestContext)

  24:             testContextInstance = value

  25:         End Set

  26:     End Property

27:

  28: #Region "Additional test attributes"

  29:     '

  30:     'You can use the following additional attributes as you write your tests:

  31:     '

  32:     'Use ClassInitialize to run code before running the first test in the class

  33:     '<ClassInitialize()>  _

  34:     'Public Shared Sub MyClassInitialize(ByVal testContext As TestContext)

  35:     'End Sub

  36:     '

  37:     'Use ClassCleanup to run code after all tests in a class have run

  38:     '<ClassCleanup()>  _

  39:     'Public Shared Sub MyClassCleanup()

  40:     'End Sub

  41:     '

  42:     'Use TestInitialize to run code before running each test

  43:     '<TestInitialize()>  _

  44:     'Public Sub MyTestInitialize()

  45:     'End Sub

  46:     '

  47:     'Use TestCleanup to run code after each test has run

  48:     '<TestCleanup()>  _

  49:     'Public Sub MyTestCleanup()

  50:     'End Sub

  51:     '

  52: #End Region

53:

54:

  55:     '''<summary>

  56:     '''A test for Transform

  57:     '''</summary>

  58:     <TestMethod()> _

  59:     Public Sub TransformTestGeneral()

60:

  61:         Dim mSourceTable As New DataTable("TestPivotTable")

  62:         Dim mKeyColumn As New DataColumn("Key", System.Type.GetType("System.DateTime"))

  63:         Dim mVariableColumn As New DataColumn("Variable", System.Type.GetType("System.DateTime"))

  64:         Dim mAggregateColumn As New DataColumn("Aggregate", System.Type.GetType("System.Int32"))

  65:         Dim mDataRow As DataRow

66:

  67:         mSourceTable.Columns.Add(mKeyColumn)

  68:         mSourceTable.Columns.Add(mVariableColumn)

  69:         mSourceTable.Columns.Add(mAggregateColumn)

70:

  71:         ' Row #1

  72:         mDataRow = mSourceTable.NewRow

  73:         mDataRow("Key") = "1/1/2008"

  74:         mDataRow("Variable") = "1/1/2008"

  75:         mDataRow("Aggregate") = 1

  76:         mSourceTable.Rows.Add(mDataRow)

77:

  78:         mDataRow = mSourceTable.NewRow

  79:         mDataRow("Key") = "1/1/2008"

  80:         mDataRow("Variable") = "1/2/2008"

  81:         mDataRow("Aggregate") = 2

  82:         mSourceTable.Rows.Add(mDataRow)

83:

  84:         mDataRow = mSourceTable.NewRow

  85:         mDataRow("Key") = "1/1/2008"

  86:         mDataRow("Variable") = "1/3/2008"

  87:         mDataRow("Aggregate") = 3

  88:         mSourceTable.Rows.Add(mDataRow)

89:

  90:         ' Row #2

  91:         mDataRow = mSourceTable.NewRow

  92:         mDataRow("Key") = "1/2/2008"

  93:         mDataRow("Variable") = "1/1/2008"

  94:         mDataRow("Aggregate") = 1

  95:         mSourceTable.Rows.Add(mDataRow)

96:

  97:         mDataRow = mSourceTable.NewRow

  98:         mDataRow("Key") = "1/2/2008"

  99:         mDataRow("Variable") = "1/2/2008"

 100:         mDataRow("Aggregate") = 2

 101:         mSourceTable.Rows.Add(mDataRow)

 102:

 103:         mDataRow = mSourceTable.NewRow

 104:         mDataRow("Key") = "1/2/2008"

 105:         mDataRow("Variable") = "1/3/2008"

 106:         mDataRow("Aggregate") = 3

 107:         mSourceTable.Rows.Add(mDataRow)

 108:

 109:         ' Row #3

 110:         mDataRow = mSourceTable.NewRow

 111:         mDataRow("Key") = "1/3/2008"

 112:         mDataRow("Variable") = "1/1/2008"

 113:         mDataRow("Aggregate") = 1

 114:         mSourceTable.Rows.Add(mDataRow)

 115:

 116:         mDataRow = mSourceTable.NewRow

 117:         mDataRow("Key") = "1/3/2008"

 118:         mDataRow("Variable") = "1/2/2008"

 119:         mDataRow("Aggregate") = 2

 120:         mSourceTable.Rows.Add(mDataRow)

 121:

 122:         mDataRow = mSourceTable.NewRow

 123:         mDataRow("Key") = "1/3/2008"

 124:         mDataRow("Variable") = "1/3/2008"

 125:         mDataRow("Aggregate") = 3

 126:         mSourceTable.Rows.Add(mDataRow)

 127:

 128:

 129:         Dim target As PivotTable = New PivotTable(mSourceTable, mKeyColumn, mVariableColumn, mAggregateColumn)

 130:

 131:         Dim actual As DataTable

 132:         actual = target.Transform

 133:

 134:         Assert.AreEqual(3, actual.Rows.Count, "Should have 3 rows")

 135:         Assert.AreEqual(4, actual.Columns.Count, "Should have 4 columns")

 136:         Assert.AreEqual(2, actual.Rows(1)(2), "Value in Column 1 2 should be ""2""")

 137:

 138:         'Assert.Inconclusive("Verify the correctness of this test method.")

 139:

 140:     End Sub

 141:

 142:

 143:     '''<summary>

 144:     ''' Test to see when a column is added that the correct ordinal is set.

 145:     ''' If Column 2 is added before 3 does it show as 2 or 3.

 146:     ''' Correct outcome should be 1,2,3

 147:     '''</summary>

 148:     <TestMethod()> _

 149:     Public Sub TransformTestColumnAddingOrder()

 150:         Dim mSourceTable As New DataTable("TestPivotTable")

 151:         Dim mKeyColumn As New DataColumn("Key", System.Type.GetType("System.DateTime"))

 152:         Dim mVariableColumn As New DataColumn("Variable", System.Type.GetType("System.String"))

 153:         Dim mAggregateColumn As New DataColumn("Aggregate", System.Type.GetType("System.Int32"))

 154:         Dim mDataRow As DataRow

 155:

 156:         mSourceTable.Columns.Add(mKeyColumn)

 157:         mSourceTable.Columns.Add(mVariableColumn)

 158:         mSourceTable.Columns.Add(mAggregateColumn)

 159:

 160:         ' Row #1

 161:         mDataRow = mSourceTable.NewRow

 162:         mDataRow("Key") = "1/1/2008"

 163:         mDataRow("Variable") = "Column1"

 164:         mDataRow("Aggregate") = 1

 165:         mSourceTable.Rows.Add(mDataRow)

 166:

 167:         ' Row #2

 168:         mDataRow = mSourceTable.NewRow

 169:         mDataRow("Key") = "1/2/2008"

 170:         mDataRow("Variable") = "Column1"

 171:         mDataRow("Aggregate") = 1

 172:         mSourceTable.Rows.Add(mDataRow)

 173:

 174:         mDataRow = mSourceTable.NewRow

 175:         mDataRow("Key") = "1/2/2008"

 176:         mDataRow("Variable") = "Column3"

 177:         mDataRow("Aggregate") = 2

 178:         mSourceTable.Rows.Add(mDataRow)

 179:

 180:

 181:         ' Row #3

 182:         mDataRow = mSourceTable.NewRow

 183:         mDataRow("Key") = "1/3/2008"

 184:         mDataRow("Variable") = "Column1"

 185:         mDataRow("Aggregate") = 1

 186:         mSourceTable.Rows.Add(mDataRow)

 187:

 188:         mDataRow = mSourceTable.NewRow

 189:         mDataRow("Key") = "1/3/2008"

 190:         mDataRow("Variable") = "Column2"

 191:         mDataRow("Aggregate") = 2

 192:         mSourceTable.Rows.Add(mDataRow)

 193:

 194:         mDataRow = mSourceTable.NewRow

 195:         mDataRow("Key") = "1/3/2008"

 196:         mDataRow("Variable") = "Column3"

 197:         mDataRow("Aggregate") = 3

 198:         mSourceTable.Rows.Add(mDataRow)

 199:

 200:

 201:         Dim target As PivotTable = New PivotTable(mSourceTable, mKeyColumn, mVariableColumn, mAggregateColumn)

 202:

 203:         Dim actual As DataTable

 204:         actual = target.Transform

 205:

 206:         Assert.AreEqual(3, actual.Rows.Count, "Should have 3 rows")

 207:         Assert.AreEqual(4, actual.Columns.Count, "Should have 4 columns")

 208:         Assert.AreEqual(2, actual.Rows(1)(3), "Value in Column 1 2 should be ""2""")

 209:         Assert.AreEqual("Column1", actual.Columns(1).ColumnName, "Column 1 should be named Column 1")

 210:         Assert.AreEqual("Column2", actual.Columns(2).ColumnName, "Column 2 should be named Column 2")

 211:         Assert.AreEqual("Column3", actual.Columns(3).ColumnName, "Column 3 should be named Column 3")

 212:     End Sub

 213: End Class

Currently rated 2.8 by 4 people

Currently 2.75/5 Stars.
1
2
3
4
5

Posted by Bryan on Wednesday, January 09, 2008 8:43 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (7) | Post RSS RSS comment feed

<< Previous posts

Bryan Reynolds

Software, Business, Life . . .

Contact

Recent comments

Archive

Authors

Tags

Categories

Blogroll

Recent posts

Disclaimer

NDepend and complex methods.

Getting Started

Complex Methods

Solving the Problem

Conclusion

Latitude, Longitude, Bearing, Cardinal Direction, Distance, and C#

Calculating Distance between two points of Latitude and Longitude

Calculating Bearing and Cardinal Direction

Unit tests

Summary

C# Wrapping text using split and List<>

Using LINQ to SQL instead of a sub report.

LLBLGen Pro and Microsoft’s Dynamic Data will play nice!

Interesting article about the new C# "var"

Dynamic Data - New Code Drop

Fraudulent Companies

Mocking using TypeMock

Datatable Pivot/Crosstab

Code for the PivotTable Class

Unit Tests