public static BOCulture GetDefault()
{
SqlConnection con = new SqlConnection(GetConnectionString());
con.Open();
try
{
SqlCommand cmd = new SqlCommand("P_Culture_GetDefault", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult);
try
{
if (rdr.Read())
{
BOCulture BusinessObject = new BOCulture(rdr);
return BusinessObject;
}
else
{
//Create Key if it does not exist
BOCulture BusinessObject = new BOCulture();
CultureInfo cultureInfo = CultureInfo.GetCultureInfo("en-US");
BusinessObject.Name = cultureInfo.Name;
BusinessObject.DisplayName = cultureInfo.DisplayName;
BusinessObject.EnglishName = cultureInfo.EnglishName;
BusinessObject.Available = true;
BusinessObject.Default = true;
BusinessObject.Save();
return BusinessObject;
}
}
finally
{
rdr.Close();
}
}
finally
{
con.Close();
}
}
