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();
}
}
}
