private void LoadCities()
 {
     City c = new City();
     if (c.LoadByCountryID(CountryID))
     {
         do
         {
             HtmlTableRow row = new HtmlTableRow();
             row.Cells.Add(AddCityCellInnerHTML(c.GetColumn("Name" + Utils.LangPrefix).ToString(), c.GetColumn("CountryName").ToString(),
                 c.GetColumn("Name_en").ToString()));
             tblCities.Rows.Add(row);
         } while (c.MoveNext());
     }
 }
 private void LoadCommonPageData()
 {
     Settings s = new Settings();
     if (s.LoadByPrimaryKey(1))
     {
         if (IsCountryPage)
         {
             Country c = new Country();
             if (c.LoadByPrimaryKey(CountryID))
             {
                 m_Title = c.GetColumn("Name" + Utils.LangPrefix).ToString();
                 if (!s.IsColumnNull("TitleSuffix" + Utils.LangPrefix))
                 {
                     m_Title += " - " + s.GetColumn("TitleSuffix" + Utils.LangPrefix).ToString();
                 }
                 if (!c.IsColumnNull("Keywords" + Utils.LangPrefix))
                 {
                     m_Keywords = c.GetColumn("Keywords" + Utils.LangPrefix).ToString();
                 }
                 if (!c.IsColumnNull("Description" + Utils.LangPrefix))
                 {
                     m_Description = c.GetColumn("Description" + Utils.LangPrefix).ToString();
                 }
             }
         }
         else if (IsCityPage)
         {
             City c = new City();
             if (c.LoadByPrimaryKey(CityID))
             {
                 m_Title = c.GetColumn("Name" + Utils.LangPrefix).ToString();
                 if (!s.IsColumnNull("TitleSuffix" + Utils.LangPrefix))
                 {
                     m_Title += " - " + s.GetColumn("TitleSuffix" + Utils.LangPrefix).ToString();
                 }
                 if (!c.IsColumnNull("Keywords" + Utils.LangPrefix))
                 {
                     m_Keywords = c.GetColumn("Keywords" + Utils.LangPrefix).ToString();
                 }
                 if (!c.IsColumnNull("Description" + Utils.LangPrefix))
                 {
                     m_Description = c.GetColumn("Description" + Utils.LangPrefix).ToString();
                 }
             }
         }
         if (m_Title.TrimEnd().Length == 0 && !s.IsColumnNull("Title" + Utils.LangPrefix))
         {
             m_Title = s.GetColumn("Title" + Utils.LangPrefix).ToString();
         }
         if (m_Keywords.TrimEnd().Length == 0 && !s.IsColumnNull("Keywords" + Utils.LangPrefix))
         {
             m_Keywords = s.GetColumn("Keywords" + Utils.LangPrefix).ToString();
         }
         if (m_Description.TrimEnd().Length == 0 && !s.IsColumnNull("Description" + Utils.LangPrefix))
         {
             m_Description = s.GetColumn("Description" + Utils.LangPrefix).ToString();
         }
     }
 }
 private void LoadCommonPageData()
 {
     Settings s = new Settings();
     if (s.LoadByPrimaryKey(1))
     {
         if (IsCountryPage)
         {
             Country c = new Country();
             if (c.LoadByPrimaryKey(CountryID))
             {
                 m_Title = c.GetColumn(Country.ColumnNames.Name).ToString();
                 if (!s.IsColumnNull(Settings.ColumnNames.TitleSuffix))
                 {
                     m_Title += " - " + s.GetColumn(Settings.ColumnNames.TitleSuffix).ToString();
                 }
                 if (!c.IsColumnNull(Country.ColumnNames.Keywords))
                 {
                     m_Keywords = c.GetColumn(Country.ColumnNames.Keywords).ToString();
                 }
                 if (!c.IsColumnNull(Country.ColumnNames.Description))
                 {
                     m_Description = c.GetColumn(Country.ColumnNames.Description).ToString();
                 }
             }
         }
         else if (IsCityPage)
         {
             City c = new City();
             if (c.LoadByPrimaryKey(CityID))
             {
                 m_Title = c.GetColumn(City.ColumnNames.Name).ToString();
                 if (!s.IsColumnNull(Settings.ColumnNames.TitleSuffix))
                 {
                     m_Title += " - " + s.GetColumn(Settings.ColumnNames.TitleSuffix).ToString();
                 }
                 if (!c.IsColumnNull(City.ColumnNames.Keywords))
                 {
                     m_Keywords = c.GetColumn(City.ColumnNames.Keywords).ToString();
                 }
                 if (!c.IsColumnNull(City.ColumnNames.Description))
                 {
                     m_Description = c.GetColumn(City.ColumnNames.Description).ToString();
                 }
             }
         }
         else if (IsBlogPagePage)
         {
             BlogPage bp = new BlogPage();
             if (bp.LoadByPrimaryKey(BlogPageID))
             {
                 m_Title = bp.GetColumn(BlogPage.ColumnNames.Name).ToString();
                 if (!s.IsColumnNull(Settings.ColumnNames.TitleSuffix))
                 {
                     m_Title += " - " + s.GetColumn(Settings.ColumnNames.TitleSuffix).ToString();
                 }
                 if (!bp.IsColumnNull(BlogPage.ColumnNames.Keywords))
                 {
                     m_Keywords = bp.GetColumn(BlogPage.ColumnNames.Keywords).ToString();
                 }
                 if (!bp.IsColumnNull(BlogPage.ColumnNames.Description))
                 {
                     m_Description = bp.GetColumn(BlogPage.ColumnNames.Description).ToString();
                 }
             }
         }
         if (m_Title.TrimEnd().Length == 0 && !s.IsColumnNull(Settings.ColumnNames.Title))
         {
             m_Title = s.GetColumn(Settings.ColumnNames.Title).ToString();
         }
         if (m_Keywords.TrimEnd().Length == 0 && !s.IsColumnNull(Settings.ColumnNames.Keywords))
         {
             m_Keywords = s.GetColumn(Settings.ColumnNames.Keywords).ToString();
         }
         if (m_Description.TrimEnd().Length == 0 && !s.IsColumnNull(Settings.ColumnNames.Description))
         {
             m_Description = s.GetColumn(Settings.ColumnNames.Description).ToString();
         }
     }
 }