/// <summary>
/// Convert an XMLNameValueCollection into a sql object
/// </summary>
/*
public static object ToSql(General.XMLNameValueCollection input)
{
if (input == null)
return DBNull.Value;
else
return input.XMLDocument.OuterXml;
}
*/
/// <summary>
/// Convert a SimpleXMLNameValueCollection into a sql object
/// </summary>
/*
public static object ToSql(General.SimpleXMLNameValueCollection input)
{
if (input == null)
return DBNull.Value;
else
return input.XMLDocument.OuterXml;
}
*/
/// <summary>
/// Convert a string into a PhoneNumber object
/// </summary>
public static object ToSql(PhoneNumber input)
{
if (input == null)
return DBNull.Value;
else
return input.ToSql();
}
public void TestPhoneNumber()
{
//The PhoneNumber class uses an embedded XML file called General.PhoneNumber.xml,
//this allows it to parse any number from around the world, and know where that number is from...
//and how to dial it from anywhere else in the world!
PhoneNumber phone1 = new PhoneNumber("867-5309","702"); //Local number (area code defaults per your settings)
bool valid = phone1.Valid; //True
string phoneValue = phone1.Value; //(702) 867-5309
string phoneToString = phone1.ToString(); //(702) 867-5309
object sqlObj = phone1.ToSql(); //17028675309 or DBNull.Value when empty
string country = phone1.CountryName; //UNITED STATES OF AMERICA
string region = phone1.AreaDescription; //NV - Las Vegas
Assert.IsTrue(valid);
Assert.AreEqual(phoneValue, "(702) 867-5309");
Assert.AreEqual(phoneToString, "(702) 867-5309");
Assert.AreEqual(sqlObj, 17028675309);
Assert.AreEqual(country, "UNITED STATES OF AMERICA");
Assert.AreEqual(region, "NV - Las Vegas");
//This phone number looks right, but has an invalid area code... see how it's handled by default.
PhoneNumber phone1BadAreaCode_Default = new PhoneNumber("555-867-5309"); //Local number (area code defaults per your settings)
Assert.IsTrue(phone1BadAreaCode_Default.Valid); //Turns out this is still probably a valid number
Assert.AreEqual(phone1BadAreaCode_Default.CountryCode, 55); //But it's in Brazil!
Assert.AreEqual(phone1BadAreaCode_Default.CountryName, "BRAZIL"); //See!
Assert.AreEqual(phone1BadAreaCode_Default.Value, "+55-58675309");
//Maybe I only care about North American phone numbers, so I want it to assume that the number is NANP whenever there is doubt
// NOTE: If the number isn't 7, 10, or 11 digits starting with a 1... default parsing will be used as this MUST be non NANP number.
PhoneNumber phone1BadAreaCode_NANP = new PhoneNumber("555-867-5309", ParseAs: PhoneNumber.ParseArgument.NANP);
Assert.IsTrue(phone1BadAreaCode_NANP.Valid); //The area code might be junk, but it's still valid
Assert.AreEqual(phone1BadAreaCode_NANP.CountryCode, 1); //And it's a NANP number because we used ParseArgument.NANP
Assert.AreEqual(phone1BadAreaCode_NANP.AreaCode, 555);
Assert.AreEqual(phone1BadAreaCode_NANP.Value, "(555) 867-5309");
//NANP parsing is also forgiving if you only use a seven digit number
PhoneNumber phone1_NANPShort = new PhoneNumber("867-5309", ParseAs: PhoneNumber.ParseArgument.NANP); //Local number (unknown area code)
Assert.IsTrue(phone1_NANPShort.Valid); //It's still at least 7 digits
Assert.AreEqual(phone1_NANPShort.CountryCode, 1); //And it's a NANP number because we used ParseArgument.NANP
Assert.AreEqual(phone1_NANPShort.AreaCode, -1); //No area code!
Assert.AreEqual(phone1_NANPShort.Value, "867-5309");
//If I don't give it any kind of hint, it will try to find this number somewhere in the world.
PhoneNumber phone1_Short = new PhoneNumber("867-5309"); //Local number (unknown area code)
Assert.IsFalse(phone1_Short.Valid); //Not a valid number, not enough digits after country code
Assert.AreEqual(phone1_Short.CountryCode, 86); //China!
Assert.AreEqual(phone1_Short.CountryName, "CHINA"); //The first two digits matched to China, so this becomes an invalid Chinese number.
//All of these objects will be equal to eachother, as each is really a different representation of the same telephone, Jenny's phone.
PhoneNumber phone2 = new PhoneNumber("7028675309", "808"); //Long distance number (default area code not used)
PhoneNumber phone3 = new PhoneNumber("7028675309"); //Default area code is optional
PhoneNumber phone4 = new PhoneNumber("702-867-5309"); //Number can be formatted or unformatted
PhoneNumber phone5 = new PhoneNumber("1-702-867-5309"); //..
PhoneNumber phone6 = new PhoneNumber("17028675309"); //..
PhoneNumber phone7 = new PhoneNumber("+1 (702) 867-5309"); //International format
PhoneNumber phone8 = new PhoneNumber("001-702-867-5309"); //Calling from overseas
PhoneNumber phone9 = new PhoneNumber("00-1-702-867-5309"); //..
PhoneNumber phone10 = new PhoneNumber("702-TOP-5309"); //Vanity letters are no problem
PhoneNumber phone11 = new PhoneNumber("8675309", "702"); //7 digit number with default area code
//Resolved, all these phone numbers are actually calling Jenny
Assert.AreEqual(phone1, phone2);
Assert.AreEqual(phone2, phone3);
Assert.AreEqual(phone3, phone4);
Assert.AreEqual(phone4, phone5);
Assert.AreEqual(phone5, phone6);
Assert.AreEqual(phone6, phone7);
Assert.AreEqual(phone7, phone8);
Assert.AreEqual(phone8, phone9);
Assert.AreEqual(phone9, phone10);
Assert.AreEqual(phone10, phone11);
//And they are all considered valid phone numbers
Assert.IsTrue(phone1.Valid);
Assert.IsTrue(phone2.Valid);
Assert.IsTrue(phone3.Valid);
Assert.IsTrue(phone4.Valid);
Assert.IsTrue(phone5.Valid);
Assert.IsTrue(phone6.Valid);
Assert.IsTrue(phone7.Valid);
Assert.IsTrue(phone8.Valid);
Assert.IsTrue(phone9.Valid);
Assert.IsTrue(phone10.Valid);
Assert.IsTrue(phone11.Valid);
//Now I wanna call Jenny from all over the world
string strDialFromFrance = phone1.ToDialString(33);
string strDialFromFranceAgain = phone1.ToDialString("FR");
string strDialFromMorocco = phone1.ToDialString(212);
string strDialFromJapan = phone1.ToDialString("JP");
string strDialFromCaymanIslands = phone1.ToDialString("KY");
Assert.AreEqual(strDialFromFrance, "00-1-702-867-5309");
Assert.AreEqual(strDialFromFranceAgain, "00-1-702-867-5309");
Assert.AreEqual(strDialFromMorocco, "00-1-702-867-5309");
Assert.AreEqual(strDialFromJapan, "010-1-702-867-5309");
Assert.AreEqual(strDialFromCaymanIslands, "1-702-867-5309");
//Some more international dialing magic
PhoneNumber intl1 = new PhoneNumber("+41-22-334325343x4544"); //Swiss number with extension
string strDialNumberFromSwissPhone = phone1.ToDialString(intl1);
PhoneNumber intl2 = new PhoneNumber("+49 (0)69 2475 130"); //German number
string strDialNumberFromGermanPhone = phone1.ToDialString(intl2);
PhoneNumber intl3 = new PhoneNumber("+993 12 22-10-25"); //Turkmenistan
string strDialNumberFromTurkmenistanPhone = phone1.ToDialString(intl3);
string strDialGermanyFromCaymanIslands = intl2.ToDialString("KY");
Assert.AreEqual(strDialNumberFromSwissPhone, "00-1-702-867-5309");
Assert.AreEqual(strDialNumberFromGermanPhone, "00-1-702-867-5309");
Assert.AreEqual(strDialNumberFromTurkmenistanPhone, "810-1-702-867-5309");
Assert.AreEqual(strDialGermanyFromCaymanIslands, "011-49-69-247-5130");
//What if a phone number is really bogus, with a 0 at the beginning?
PhoneNumber phoneZero1 = new PhoneNumber("(555) 078-9543", PhoneNumber.ParseArgument.NANP); //Not a valid number in North America
Assert.IsFalse(phoneZero1.Valid);
phoneZero1 = new PhoneNumber("(555) 078-9543"); //Possible Brazilian Phone Number (improperly formatted)
Assert.IsTrue(phoneZero1.Valid);
PhoneNumber phoneZero2 = new PhoneNumber("(055) 078-9543", PhoneNumber.ParseArgument.NANP); //Not a valid number in North America
Assert.IsFalse(phoneZero2.Valid);
phoneZero2 = new PhoneNumber("(055) 078-9543"); //Possible Brazilian Phone Number (improperly formatted)
Assert.IsTrue(phoneZero2.Valid);
PhoneNumber phoneZero3 = new PhoneNumber("(055) 8784-9543", PhoneNumber.ParseArgument.NANP); //Not a valid number in North America
Assert.IsFalse(phoneZero3.Valid);
phoneZero3 = new PhoneNumber("(055) 8784-9543"); //Valid Brazilian Phone Number (improperly formatted)
Assert.IsTrue(phoneZero3.Valid);
PhoneNumber phoneZero4 = new PhoneNumber("(000) 000-0000", PhoneNumber.ParseArgument.NANP); //Not a valid number
Assert.IsFalse(phoneZero4.Valid);
phoneZero4 = new PhoneNumber("0000000000"); //Not a valid number
Assert.IsFalse(phoneZero4.Valid);
//Got it? cool.
}