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()); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { City c = new City(); if (c.LoadByCountryID(CountryID)) { int i = 0; StringBuilder strCityList = new StringBuilder(); foreach (DataRow row in c.DefaultView.Table.Rows) { if (i % 3 == 0) { strCityList.Append("<div class=\"row\">"); } string pageURL = SiteURL + "/" + Utils.GenerateFriendlyURL("city", new string[] { row["CountryName"].ToString(), row[City.ColumnNames.Name_en].ToString() }, false); strCityList.Append("<div class=\"col-lg-4 col-md-4 small-blog-item\">"); strCityList.Append("<div class=\"fh5co-blog animate-box\">"); if (!row.IsNull(City.ColumnNames.TitleImage)) { strCityList.Append("<div class='smallbloglist' style='background-image: url(" + SiteURL + Utils.GaleryImagePath.Replace("~", "") + "/" + row[City.ColumnNames.TitleImage].ToString() + ");'><div class='fh5co-overlay'></div>"); strCityList.Append("<h3><a href=\"" + pageURL + "\">" + row[City.ColumnNames.Name].ToString() + "</a></h3>"); strCityList.Append("</div>"); } strCityList.Append("</div>"); strCityList.Append("</div>"); i++; if (i % 3 == 0) { strCityList.Append("</div>"); } } while (i % 3 != 0) { strCityList.Append("<div class=\"col-lg-4 col-md-4\"> </div>"); i++; if (i % 3 == 0) { strCityList.Append("</div>"); } } divCityViewList.InnerHtml = strCityList.ToString(); divCities.Visible = (i > 0); } } }