Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

File Name : ucLeft.ascx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.ApplicationBlocks.Data;

public partial class Usercontrols_ucLeft : System.Web.UI.UserControl
{
    public string stroffer = "";
    DataSet dsmcatid;
    protected void Page_Load(object sender, EventArgs e)
    {
        bindName();
        bindcategory();
        loadsubcategory();
        loadoffer();

Page.ClientScript.RegisterStartupScript(this.GetType(), "fadinfadout", "fadeMsg();", true);
    }

private void loadsubcategory()
    {
        
    }

private void bindcategory()
    {
        DataSet ds = new DataSet();
        string str = "";
        DataView dv;
        int id1 = Convert.ToInt32(dsmcatid.Tables[0].Rows[0][0]);
        str = "select top 10 category,catid,mcatid from tblcategory where mcatid=" + id1 + " order by category";
        ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);

dv = new DataView(ds.Tables[0]);

//dv.RowFilter = "mcatid=1";

if (dv.Count > 0)
        {
            rptspecialcat.DataSource = dv;
            rptspecialcat.DataBind();
            trsp.Visible = true;
        }
        else
        {
            trsp.Visible = false;
        }
        int id2 = Convert.ToInt32(dsmcatid.Tables[0].Rows[1][0]);
        str = "select top 10 category,catid,mcatid from tblcategory where mcatid=" + id2 + " order by category";
        ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);

dv = new DataView(ds.Tables[0]);

//dv.RowFilter = "mcatid=2";
        if (dv.Count > 0)
        {
            rptbeadscat.DataSource = dv;
            rptbeadscat.DataBind();
            trbeads.Visible = true;
        }
        else
        {
            trbeads.Visible = false;
        }
        int id3 = Convert.ToInt32(dsmcatid.Tables[0].Rows[2][0]);
        str = "select top 10 category,catid,mcatid from tblcategory where mcatid=" + id3 + " order by category";
        ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);

dv = new DataView(ds.Tables[0]);
        //dv.RowFilter = "mcatid=3";

if (dv.Count > 0)
        {
            rptgemstone.DataSource = dv;
            rptgemstone.DataBind();
            trgem.Visible = true;
        }
        else
        {
            trgem.Visible = false;
        }

// str = "select top 10 category,catid,mcatid from tblcategory where mcatid=4 order by category";
        // ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);

// dv = new DataView(ds.Tables[0]);
        ////dv.RowFilter = "mcatid=4";

//if (dv.Count > 0)
        //{
        //    rptgemcab.DataSource = dv;
        //    rptgemcab.DataBind();
        //    trgemcab.Visible = true;
        //}
        //else
        //{
        //    trgemcab.Visible = false;
        //}

int id4 = Convert.ToInt32(dsmcatid.Tables[0].Rows[3][0]);
        str = "select top 10 category,catid,mcatid from tblcategory where mcatid=" + id4 + " order by category";
        ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);

dv = new DataView(ds.Tables[0]);
        //dv.RowFilter = "mcatid=5";

if (dv.Count > 0)
        {
            rptjewelry.DataSource = dv;
            rptjewelry.DataBind();
            trjew.Visible = true;
        }
        else
        {
            trjew.Visible = false;
        }

ds.Dispose();
        dv.Dispose();

}
    protected void rptspecialcat_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HiddenField hdncatid = (HiddenField)e.Item.FindControl("hdncatid");
            HtmlAnchor hrfbeadcat = (HtmlAnchor)e.Item.FindControl("hrfspecial");

string str = "select count(*) from tblsubcategory where catid=" + hdncatid.Value;
            int catcount = Convert.ToInt16(SqlDBHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str));

if (catcount > 0)
            {
                hrfbeadcat.HRef = "../subcategory.aspx?cid=" + hdncatid.Value;
            }
            else
            {
                int id1 = Convert.ToInt32(dsmcatid.Tables[0].Rows[0][0]);
                hrfbeadcat.HRef = "../catlog.aspx?mid=" + id1 + "&cid=" + hdncatid.Value;
            }
        }

}
    protected void rptbeadscat_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HiddenField hdncatid = (HiddenField)e.Item.FindControl("hdncatid");
            HtmlAnchor hrfbeadcat = (HtmlAnchor)e.Item.FindControl("hrfbeadcat");

if (catcount > 0)
            {
                hrfbeadcat.HRef = "../subcategory.aspx?cid=" + hdncatid.Value;
            }
            else
            {
                int id2 = Convert.ToInt32(dsmcatid.Tables[0].Rows[1][0]);
                hrfbeadcat.HRef = "../catlog.aspx?mid=" + id2 + "&cid=" + hdncatid.Value;
            }
        }
    }
    protected void rptgemstone_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HiddenField hdncatid = (HiddenField)e.Item.FindControl("hdncatid");
            HtmlAnchor hrfjewcat = (HtmlAnchor)e.Item.FindControl("hrfjewcat");

if (catcount > 0)
            {
                hrfjewcat.HRef = "../subcategory.aspx?cid=" + hdncatid.Value;
            }
            else
            {
                int id3 = Convert.ToInt32(dsmcatid.Tables[0].Rows[2][0]);
                hrfjewcat.HRef = "../catlog.aspx?mid=" + id3 + "&cid=" + hdncatid.Value;
            }
        }
    }

//protected void rptgemcab_ItemDataBound(object sender, RepeaterItemEventArgs e)
    //{
    //    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    //    {
    //        HiddenField hdncatid = (HiddenField)e.Item.FindControl("hdncatid");
    //        HtmlAnchor hrfjewcat = (HtmlAnchor)e.Item.FindControl("hrfjewcat");

//        string str = "select count(*) from tblsubcategory where catid=" + hdncatid.Value;
    //        int catcount = Convert.ToInt16(SqlDBHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str));

//        if (catcount > 0)
    //        {
    //            hrfjewcat.HRef = "../subcategory.aspx?cid=" + hdncatid.Value;
    //        }
    //        else
    //        {
    //            hrfjewcat.HRef = "../catlog.aspx?mid=4&cid=" + hdncatid.Value;
    //        }
    //    }
    //}

protected void rptjewelry_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HiddenField hdncatid = (HiddenField)e.Item.FindControl("hdncatid");
            HtmlAnchor hrfjewcat = (HtmlAnchor)e.Item.FindControl("hrfjewcat");

if (catcount > 0)
            {
                hrfjewcat.HRef = "../subcategory.aspx?cid=" + hdncatid.Value;
            }
            else
            {
                int id4 = Convert.ToInt32(dsmcatid.Tables[0].Rows[3][0]);
                hrfjewcat.HRef = "../catlog.aspx?mid=" + id4 + "&cid=" + hdncatid.Value;
            }
        }
    }

private void loadoffer()
    {
        DataSet ds = new DataSet();
        string str = "select offertext from tbloffer order by adddate desc";
        ds = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);
        if (ds.Tables[0].Rows.Count > 0)
        {
            stroffer = "";
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                stroffer = stroffer + "'" + ds.Tables[0].Rows[i]["offertext"].ToString() + "',";
            }
            stroffer = stroffer.Trim(',');
        }
        ds.Dispose();
    }

private void bindName()
    {
        string str = "";
        str = "select mcatid,maincategory,pos from  tblmaincategory order by pos";
        dsmcatid = SqlDBHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString, CommandType.Text, str);
        a11.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[0][0].ToString();
        a12.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[0][0].ToString();
        Literal1.Text = dsmcatid.Tables[0].Rows[0][1].ToString();

a21.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[1][0].ToString();
        a22.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[1][0].ToString();
        Literal2.Text = dsmcatid.Tables[0].Rows[1][1].ToString();

a31.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[2][0].ToString();
        a32.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[2][0].ToString();
        Literal3.Text = dsmcatid.Tables[0].Rows[2][1].ToString();

a41.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[3][0].ToString();
        a42.HRef = "../category.aspx?mid=" + dsmcatid.Tables[0].Rows[3][0].ToString();
        Literal4.Text = dsmcatid.Tables[0].Rows[3][1].ToString();

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2018-05-13 06:47:06
..	dir	-	0/0	0777	2018-05-26 09:33:32
LeftControlWithNewStyle.ascx	text/html	3.54 KB	0/0	0666	2018-05-13 06:47:06
LeftControlWithNewStyle.ascx.cs	text/plain	488 B	0/0	0666	2018-05-13 06:47:06
ucLeft.ascx	text/html	7.59 KB	0/0	0666	2018-05-13 06:47:06
ucLeft.ascx.cs	text/plain	10.84 KB	0/0	0666	2018-05-13 06:47:06
ucPaging.ascx	text/plain	1.36 KB	0/0	0666	2018-05-13 06:47:06
ucPaging.ascx.cs	text/plain	7.67 KB	0/0	0666	2018-05-13 06:47:06
ucRight.ascx	text/html	4.02 KB	0/0	0666	2018-05-13 06:47:06
ucRight.ascx.cs	text/plain	8.62 KB	0/0	0666	2018-05-13 06:47:06

Team Anon Force

https://t.me/Professor6T9x