All things .NET and beyond

Get selected menu item name in Joomla

Fluxtah — Sun, 07 Mar 2010 19:18:27 GMT

$itemid = JRequest::getVar(
'Itemid' ); $application = JFactory::getApplication();
$menu = $application->getMenu();
$item = $menu->getItem(
$itemid ); return $item->name;

Fibonacci in C#

Fluxtah — Mon, 01 Mar 2010 12:26:57 GMT

First 16 numbers of the fibonacci series

void Main(){ for(long i=0,
n=0, a = 1,
b = 0;
i < 16; i++, Console.WriteLine(n), b = a,
a = n,
n = a + b);
}

SharePoint User Controls and Web Parts

Fluxtah — Thu, 17 Dec 2009 11:34:00 GMT

Its common practice to use a user control in a web part via LoadControl(...). By doing this you get the ASP.NET designer experience when working with .ascx files.

After seeing some implementations of encapsulating a user control in a web part, I created a version that uses a generic base class that has the benefits of giving strongly typed access to the user control, the class is as follows.

public abstract class UserControlWebPart<T>
: WebPart where T : UserControl { ///
<summary> ///
The control in the ASCX file ///
</summary> protected T
UserControl { get; set; } ///
<summary> ///
Path to the ASCX file ///
</summary> protected abstract string UserControlPath
{ get; } protected override void CreateChildControls()
{ base.CreateChildControls(); if (!string.IsNullOrEmpty(this.UserControlPath))
{ this.UserControl = (T)this.Page.LoadControl(this.UserControlPath); this.UserControl.ID = "uc"; this.Controls.Add(this.UserControl);
} } protected override void OnLoad(EventArgs
e) { base.OnLoad(e);
EnsureChildControls(); } protected override void Render(HtmlTextWriter
writer) { if (this.UserControl
!= null)
{ this.UserControl.RenderControl(writer);
} else {
writer.Write("UserControlPath
is an invalid path, it must point to a valid .ascx file"); } }

To use this class you can just subclass it and implement the abstract property to define the path to the ascx file as follows.

public class MyWebPartUserControl
: UserControl { } public class MyWebPart
: UserControlWebPart<MyWebPartUserControl> {     protected override string UserControlPath
    {         get { return "~/_controltemplates/my.user.controls/mywebpartusercontrol.ascx";
}     } }

The MyWebPartUserControl is the code-behind for the ascx file specified for the abstract UserControlPath property, this file requires a fully qualified assembly path to work correctly within sharepoint as follows.

<%@
Assembly Name="My.Assembly,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=1234abcd1234abcd" %> <%@
Control Language="C#" Inherits="My.Assembly.MyWebPartUserControl" %>

Sharepoint missing fields in NewForm for custom list definition and content type

Fluxtah — Wed, 16 Dec 2009 08:38:54 GMT

I created a custom content type and list definition, after upgrading my sharepoint solution I could see the list and content types under the new menu but when creating a new item, the fields were missing from NewForm.aspx

I discovered that it was due to the ContentType definition not having the FieldRefs tag, my content type was defined like this:-

When it should have been like this:-

Testing for a whole number in C#

Fluxtah — Wed, 25 Nov 2009 10:39:40 GMT

I was thinking about this, for some reason, and thought it would be good to remind myself of those little useful bits of code that you never really use much then sometimes wonder how to do them.

So my first tidbit, is to test if a number is a whole number, here is my solution, any better solution than this, answers on a postcard please.

void Main()
{ decimal decimalNumber = 4.9M; decimal wholeNumber = 5;
Console.WriteLine(Math.Floor(decimalNumber) == decimalNumber); //
Returns false; Console.WriteLine(Math.Floor(wholeNumber) == wholeNumber); //
Returns true; }

C# XML serialization and inheritance

Fluxtah — Fri, 13 Nov 2009 07:56:37 GMT

I wrote a small console application to test if this was possible and it turns out all you need is an XmlInclude attribute on the base type of the sub-types you are serializing.

In the following example Ninja and Customer inherit from Person, Person is decorated with the XmlInclude attribute for both Ninja and Customer.

class Program
{ static void Main(string[]
args) { XmlSerializer serializer = new XmlSerializer(typeof(Stuff));
Stuff stuff = new Stuff()
{ People = new List<Person>()
{ new Person()
{ Name = "<b>Bob</b>",
Type="Person" }, new Ninja()
{ Name = "Hiro",
Type="Ninja",
Weapon = "Shuriken" }, new Customer()
{ Name = "Fred",
Type = "Customer",
CustomerId = "1234"}
} }; serializer.Serialize(Console.Out, stuff); } } public class Stuff
{ public List<Person>
People { get; set; } }  [XmlInclude(typeof(Ninja)),
XmlInclude(typeof(Customer))] public class Person
{ public string Type
{ get; set; } public string Name
{ get; set; } } public class Ninja
: Person { public string Weapon
{ get; set; } } public class Customer
: Person { public string CustomerId
{ get; set; } }

Country table data sql script

Fluxtah — Wed, 11 Nov 2009 13:07:31 GMT

It comes to that point in time when you need a country table in your database and you do not have a list to import at hand, after scouring the web a bit, everything seemed to be out of date, so I wrote a little script to scrape the details from a wikipedia page for the ISO 3166-1 standard for country codes.

I wrote and ran the following quick & dirty JQuery script on that page.

if($('#output_textarea').length ==
0){ $(document.body).append($('<textarea rows="128" id="output_textarea"></textarea>'));
} document.output_textarea_val = "";
$('#sortable_table_id_0 tr').each(function(idx){ if(idx
> 0){ document.output_textarea_val += "INSERT
INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("; var cells = $('td', this),
cellLen = cells.length;
cells.each(function(cellIdx){ if(cellIdx
< 4){ document.output_textarea_val += "\"" + $(this).text().trim() + "\""; if(cellIdx
< cellLen - 2){
document.output_textarea_val += ",
"; } } }); document.output_textarea_val += ');\n'; } }); $('#output_textarea').val(document.output_textarea_val);

This script creates insert statements for mySQL and inserts the results into a text box at the foot of the page, in order for it to work you need to inject jQuery into the document, you can do this with the jQueryify Bookmarklet.>>

I have tested this script and it qualifies for the "works on my machine" certification programme.

The script produces the following output.

INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Afghanistan", "AF", "AFG", "004"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Aland Islands Åland Islands", "AX", "ALA", "248"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Albania", "AL", "ALB", "008"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Algeria", "DZ", "DZA", "012"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("American Samoa", "AS", "ASM", "016"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Andorra", "AD", "AND", "020"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Angola", "AO", "AGO", "024"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Anguilla", "AI", "AIA", "660"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Antarctica", "AQ", "ATA", "010"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Antigua and Barbuda", "AG", "ATG", "028"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Argentina", "AR", "ARG", "032"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Armenia", "AM", "ARM", "051"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Aruba", "AW", "ABW", "533"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Australia", "AU", "AUS", "036"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Austria", "AT", "AUT", "040"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Azerbaijan", "AZ", "AZE", "031"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bahamas", "BS", "BHS", "044"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bahrain", "BH", "BHR", "048"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bangladesh", "BD", "BGD", "050"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Barbados", "BB", "BRB", "052"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belarus", "BY", "BLR", "112"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belgium", "BE", "BEL", "056"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belize", "BZ", "BLZ", "084"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Benin", "BJ", "BEN", "204"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bermuda", "BM", "BMU", "060"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bhutan", "BT", "BTN", "064"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bolivia, Plurinational State of", "BO", "BOL", "068"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bosnia and Herzegovina", "BA", "BIH", "070"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Botswana", "BW", "BWA", "072"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bouvet Island", "BV", "BVT", "074"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Brazil", "BR", "BRA", "076"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("British Indian Ocean Territory", "IO", "IOT", "086"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Brunei Darussalam", "BN", "BRN", "096"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bulgaria", "BG", "BGR", "100"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Burkina Faso", "BF", "BFA", "854"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Burundi", "BI", "BDI", "108"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cambodia", "KH", "KHM", "116"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cameroon", "CM", "CMR", "120"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Canada", "CA", "CAN", "124"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cape Verde", "CV", "CPV", "132"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cayman Islands", "KY", "CYM", "136"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Central African Republic", "CF", "CAF", "140"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Chad", "TD", "TCD", "148"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Chile", "CL", "CHL", "152"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("China", "CN", "CHN", "156"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Christmas Island", "CX", "CXR", "162"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cocos (Keeling) Islands", "CC", "CCK", "166"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Colombia", "CO", "COL", "170"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Comoros", "KM", "COM", "174"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Congo", "CG", "COG", "178"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Congo, the Democratic Republic of the", "CD", "COD", "180"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cook Islands", "CK", "COK", "184"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Costa Rica", "CR", "CRI", "188"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cote d'Ivoire Côte d'Ivoire", "CI", "CIV", "384"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Croatia", "HR", "HRV", "191"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cuba", "CU", "CUB", "192"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cyprus", "CY", "CYP", "196"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Czech Republic", "CZ", "CZE", "203"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Denmark", "DK", "DNK", "208"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Djibouti", "DJ", "DJI", "262"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Dominica", "DM", "DMA", "212"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Dominican Republic", "DO", "DOM", "214"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ecuador", "EC", "ECU", "218"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Egypt", "EG", "EGY", "818"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("El Salvador", "SV", "SLV", "222"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Equatorial Guinea", "GQ", "GNQ", "226"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Eritrea", "ER", "ERI", "232"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Estonia", "EE", "EST", "233"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ethiopia", "ET", "ETH", "231"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Falkland Islands (Malvinas)", "FK", "FLK", "238"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Faroe Islands", "FO", "FRO", "234"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Fiji", "FJ", "FJI", "242"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Finland", "FI", "FIN", "246"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("France", "FR", "FRA", "250"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Guiana", "GF", "GUF", "254"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Polynesia", "PF", "PYF", "258"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Southern Territories", "TF", "ATF", "260"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gabon", "GA", "GAB", "266"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gambia", "GM", "GMB", "270"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Georgia", "GE", "GEO", "268"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Germany", "DE", "DEU", "276"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ghana", "GH", "GHA", "288"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gibraltar", "GI", "GIB", "292"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Greece", "GR", "GRC", "300"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Greenland", "GL", "GRL", "304"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Grenada", "GD", "GRD", "308"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guadeloupe", "GP", "GLP", "312"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guam", "GU", "GUM", "316"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guatemala", "GT", "GTM", "320"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guernsey", "GG", "GGY", "831"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guinea", "GN", "GIN", "324"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guinea-Bissau", "GW", "GNB", "624"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guyana", "GY", "GUY", "328"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Haiti", "HT", "HTI", "332"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Heard Island and McDonald Islands", "HM", "HMD", "334"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Holy See (Vatican City State)", "VA", "VAT", "336"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Honduras", "HN", "HND", "340"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Hong Kong", "HK", "HKG", "344"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Hungary", "HU", "HUN", "348"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iceland", "IS", "ISL", "352"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("India", "IN", "IND", "356"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Indonesia", "ID", "IDN", "360"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iran, Islamic Republic of", "IR", "IRN", "364"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iraq", "IQ", "IRQ", "368"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ireland", "IE", "IRL", "372"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Isle of Man", "IM", "IMN", "833"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Israel", "IL", "ISR", "376"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Italy", "IT", "ITA", "380"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jamaica", "JM", "JAM", "388"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Japan", "JP", "JPN", "392"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jersey", "JE", "JEY", "832"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jordan", "JO", "JOR", "400"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kazakhstan", "KZ", "KAZ", "398"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kenya", "KE", "KEN", "404"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kiribati", "KI", "KIR", "296"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Korea, Democratic People's Republic of", "KP", "PRK", "408"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Korea, Republic of", "KR", "KOR", "410"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kuwait", "KW", "KWT", "414"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kyrgyzstan", "KG", "KGZ", "417"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lao People's Democratic Republic", "LA", "LAO", "418"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Latvia", "LV", "LVA", "428"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lebanon", "LB", "LBN", "422"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lesotho", "LS", "LSO", "426"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Liberia", "LR", "LBR", "430"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Libyan Arab Jamahiriya", "LY", "LBY", "434"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Liechtenstein", "LI", "LIE", "438"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lithuania", "LT", "LTU", "440"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Luxembourg", "LU", "LUX", "442"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Macao", "MO", "MAC", "446"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Macedonia, the former Yugoslav Republic of", "MK", "MKD", "807"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Madagascar", "MG", "MDG", "450"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malawi", "MW", "MWI", "454"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malaysia", "MY", "MYS", "458"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Maldives", "MV", "MDV", "462"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mali", "ML", "MLI", "466"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malta", "MT", "MLT", "470"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Marshall Islands", "MH", "MHL", "584"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Martinique", "MQ", "MTQ", "474"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mauritania", "MR", "MRT", "478"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mauritius", "MU", "MUS", "480"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mayotte", "YT", "MYT", "175"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mexico", "MX", "MEX", "484"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Micronesia, Federated States of", "FM", "FSM", "583"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Moldova, Republic of", "MD", "MDA", "498"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Monaco", "MC", "MCO", "492"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mongolia", "MN", "MNG", "496"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Montenegro", "ME", "MNE", "499"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Montserrat", "MS", "MSR", "500"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Morocco", "MA", "MAR", "504"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mozambique", "MZ", "MOZ", "508"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Myanmar", "MM", "MMR", "104"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Namibia", "NA", "NAM", "516"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nauru", "NR", "NRU", "520"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nepal", "NP", "NPL", "524"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Netherlands", "NL", "NLD", "528"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Netherlands Antilles", "AN", "ANT", "530"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("New Caledonia", "NC", "NCL", "540"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("New Zealand", "NZ", "NZL", "554"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nicaragua", "NI", "NIC", "558"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Niger", "NE", "NER", "562"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nigeria", "NG", "NGA", "566"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Niue", "NU", "NIU", "570"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Norfolk Island", "NF", "NFK", "574"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Northern Mariana Islands", "MP", "MNP", "580"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Norway", "NO", "NOR", "578"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Oman", "OM", "OMN", "512"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Pakistan", "PK", "PAK", "586"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Palau", "PW", "PLW", "585"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Palestinian Territory, Occupied", "PS", "PSE", "275"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Panama", "PA", "PAN", "591"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Papua New Guinea", "PG", "PNG", "598"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Paraguay", "PY", "PRY", "600"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Peru", "PE", "PER", "604"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Philippines", "PH", "PHL", "608"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Pitcairn", "PN", "PCN", "612"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Poland", "PL", "POL", "616"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Portugal", "PT", "PRT", "620"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Puerto Rico", "PR", "PRI", "630"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Qatar", "QA", "QAT", "634"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Reunion Réunion", "RE", "REU", "638"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Romania", "RO", "ROU", "642"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Russian Federation", "RU", "RUS", "643"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Rwanda", "RW", "RWA", "646"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Barthélemy", "BL", "BLM", "652"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Helena", "SH", "SHN", "654"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Kitts and Nevis", "KN", "KNA", "659"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Lucia", "LC", "LCA", "662"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Martin (French part)", "MF", "MAF", "663"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Pierre and Miquelon", "PM", "SPM", "666"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Vincent and the Grenadines", "VC", "VCT", "670"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Samoa", "WS", "WSM", "882"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("San Marino", "SM", "SMR", "674"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sao Tome and Principe", "ST", "STP", "678"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saudi Arabia", "SA", "SAU", "682"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Senegal", "SN", "SEN", "686"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Serbia", "RS", "SRB", "688"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Seychelles", "SC", "SYC", "690"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sierra Leone", "SL", "SLE", "694"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Singapore", "SG", "SGP", "702"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Slovakia", "SK", "SVK", "703"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Slovenia", "SI", "SVN", "705"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Solomon Islands", "SB", "SLB", "090"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Somalia", "SO", "SOM", "706"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("South Africa", "ZA", "ZAF", "710"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("South Georgia and the South Sandwich Islands", "GS", "SGS", "239"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Spain", "ES", "ESP", "724"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sri Lanka", "LK", "LKA", "144"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sudan", "SD", "SDN", "736"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Suriname", "SR", "SUR", "740"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Svalbard and Jan Mayen", "SJ", "SJM", "744"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Swaziland", "SZ", "SWZ", "748"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sweden", "SE", "SWE", "752"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Switzerland", "CH", "CHE", "756"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Syrian Arab Republic", "SY", "SYR", "760"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Taiwan, Province of China", "TW", "TWN", "158"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tajikistan", "TJ", "TJK", "762"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tanzania, United Republic of", "TZ", "TZA", "834"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Thailand", "TH", "THA", "764"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Timor-Leste", "TL", "TLS", "626"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Togo", "TG", "TGO", "768"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tokelau", "TK", "TKL", "772"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tonga", "TO", "TON", "776"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Trinidad and Tobago", "TT", "TTO", "780"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tunisia", "TN", "TUN", "788"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turkey", "TR", "TUR", "792"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turkmenistan", "TM", "TKM", "795"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turks and Caicos Islands", "TC", "TCA", "796"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tuvalu", "TV", "TUV", "798"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uganda", "UG", "UGA", "800"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ukraine", "UA", "UKR", "804"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United Arab Emirates", "AE", "ARE", "784"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United Kingdom", "GB", "GBR", "826"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United States", "US", "USA", "840"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United States Minor Outlying Islands", "UM", "UMI", "581"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uruguay", "UY", "URY", "858"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uzbekistan", "UZ", "UZB", "860"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Vanuatu", "VU", "VUT", "548"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Venezuela, Bolivarian Republic of", "VE", "VEN", "862"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Viet Nam", "VN", "VNM", "704"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Virgin Islands, British", "VG", "VGB", "092"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Virgin Islands, U.S.", "VI", "VIR", "850"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Wallis and Futuna", "WF", "WLF", "876"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Western Sahara", "EH", "ESH", "732"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Yemen", "YE", "YEM", "887"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Zambia", "ZM", "ZMB", "894"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Zimbabwe", "ZW", "ZWE", "716");

Interface or Delegate?

Fluxtah — Tue, 15 Sep 2009 02:50:00 GMT

Whilst working on my network engine I came across a problem that I initially solved with an interface, but it turned out that the class that implemented this interface exposed public methods that I really wanted to be private, an example will explain the problem.

public interface IMessageReceiver
{ void Receive(string message);
} public interface IMessageProvider
{ IMessageReceiver MessageReceiver; void Update();
} public class ConcreteReceiver:
IMessageReceiver { private IMessageProvider
_MessageProvider; public ConcreteReciever(IMessageProvider
messageProvider) { _MessageProvider = messageProvider;
_MessageProvider.MessageReceiver = this;
} public void Receive(string message)
{ Console.WriteLine(message); } public void Update()
{ MessageProvider.Update(); } }

When calling ConcreteReceiver.Update(), this will call MessageProvider.Update(), then, the concrete implementation of IMessageProvider should call IMessageReceiver.Receive, effectively like a callback.

Now the issue in my case was that I did not want the Receive method of ConcreteReceiver to be public, but of course any concrete type that implements an interface must implement those methods as public, after pondering a while I realised the design was actually flawed anyway, what I really wanted was a callback, so I changed my design as follows.

public interface IMessageProvider
{ Action<string>
ReceiveAction; void Update();
} public class ConcreteReceiver
{ private IMessageProvider
_MessageProvider; public ConcreteReciever(IMessageProvider
messageProvider) { _MessageProvider = messageProvider;
_MessageProvider.ReceiveAction = Receive;
} private void Receive(string message)
{ Console.WriteLine(message); } public void Update()
{ MessageProvider.Update(); } }

So now my Receive method on my ConcreteReceiver can be private, since I am now using a generic Action<T> delegate, this prevents my public API exposing methods that are really meant to be only used internally.

Socket.Available and UDP

Fluxtah — Wed, 09 Sep 2009 16:26:00 GMT

The Available property of the System.Net.Sockets class will tell you how much data is available to read.

With UDP sockets, one thing to remember is that Socket.Available will give the total size of all the datagrams ready to read, so to the only way to know how many datagrams are waiting to be read is to call ReceiveFrom repeatedly until all data is read, for instance:-

while(Socket.Available
> 0) { int datagramSize = Socket.ReceiveFrom(buffer, ref endPoint);
}

The datagramSize variable will give the size of the datagram that was read, this can be troublesome to manage since you do not know what you are going to get, until you get it, so you would need to initialize a large enough buffer to hold the datagram.

In the networking framework I am currently writing, the application has a configurable MaxPacketSize option so I can initialize my buffer to this size, but this wont help in the event that a bum packet is sent that breaches this constraint so some error handling would also need to be in place to compensate for this issue.