protected void Page_Load(object sender, EventArgs e) { if (!IsCallback && !IsPostBack) { DataView dv = (DataView)SqlDataSourceMaster.Select(DataSourceSelectArguments.Empty);; if (dv.Table.Rows.Count > 0) { this.Title = dv.Table.Rows[0]["Title"].ToString(); PageBody = dv.Table.Rows[0]["Body"].ToString(); PageMetaKeywords = dv.Table.Rows[0]["MetaKeywords"].ToString(); // TODO: Create Meta's SEO fields/page Editing in editor PageMetaDescription = StripHTML(dv.Table.Rows[0]["Description"].ToString().Substring(0, Math.Min(dv.Table.Rows[0]["Description"].ToString().Length, 160))); string resfolder = "~/Content/Files/Productos/" + dv.Table.Rows[0]["Category"].ToString().Trim() + "/" + dv.Table.Rows[0]["SubCategory"].ToString().Trim() + "/" + dv.Table.Rows[0]["Title"].ToString().Trim(); if (Directory.Exists(Server.MapPath(resfolder))) { string[] filePaths = Directory.GetFiles(Server.MapPath(resfolder)); string filename, downloadurl; foreach (string filePath in filePaths) { filename = Path.GetFileName(filePath); downloadurl = ResolveUrl(resfolder + "/" + filename); files.Add(new ListItem(filename.Substring(0, filename.Length - 3).Replace('-', ' ').Replace('_', ' '), downloadurl)); } GridView1.DataSource = files; GridView1.DataBind(); } string resfolderImg = "~/Content/Img/Productos/" + dv.Table.Rows[0]["Category"].ToString().Trim() + "/" + dv.Table.Rows[0]["SubCategory"].ToString().Trim() + "/" + dv.Table.Rows[0]["Title"].ToString().Trim(); if (Directory.Exists(Server.MapPath(resfolderImg))) { ASPxImageSlider1.ImageSourceFolder = resfolderImg; } else { ASPxImageSlider1.Enabled = false; // for security ASPxImageSlider1.Visible = false; } // BREADCRUM if (Request.QueryString["typ"] != null) { Breadcrum.InnerHtml += string.Format("<li class=\"breadcrumb-item\"><a href = \"{0}\"> {1} </a></li>", "/products.aspx", Request.QueryString["typ"].ToUpper()); } if (Request.QueryString["cat"] != null) { Breadcrum.InnerHtml += string.Format("<li class=\"breadcrumb-item\"><a href = \"{0}\"> {1} </a></li>", "/products.aspx?query=" + Request.QueryString["cat"], Request.QueryString["cat"].ToUpper()); } if (Request.QueryString["sub"] != null) { Breadcrum.InnerHtml += string.Format("<li class=\"breadcrumb-item\"><a href = \"{0}\"> {1} </a></li>", "/products.aspx?query=" + Request.QueryString["sub"], Request.QueryString["sub"].ToUpper()); } if (Request.QueryString["pag"] != null) { Breadcrum.InnerHtml += string.Format("<li class=\"breadcrumb-item active\">{0}</li>", Request.QueryString["pag"].ToUpper()); } Header.DataBind(); } } }