public static List <Business.CountryName> Load(string langCode)
{
QuickCacheHandler cacheHandler = new QuickCacheHandler("CountryNames" + langCode);
cacheHandler.AlternateCacheMinutes = 60;
cacheHandler.ItemPriority = System.Web.Caching.CacheItemPriority.BelowNormal;
List <Business.CountryName> list = cacheHandler.Get() as List <Business.CountryName>;
if (list != null)
{
return(list);
}
list = new List <Business.CountryName>();
SqlDataReader sqlReader = null;
try
{
sqlReader = GetReader(langCode);
if (sqlReader != null)
{
while (sqlReader.Read())
{
Business.CountryName item = new Business.CountryName();
FillObject(item, sqlReader);
list.Add(item);
}
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
cacheHandler.Insert(list);
return(list);
}
private static void FillObject(Business.CountryName item, SqlDataReader sqlReader)
{
item.Name = sqlReader["CountryName"].ToString();
item.LangCode = sqlReader["LangCode"].ToString();
item.CountryCode = sqlReader["CountryCode"].ToString();
}