protected void Page_Load(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand("Select_About", cnn);
cmd.Parameters.AddWithValue("@ttype", 5);
cmd.CommandType = CommandType.Text;
SqlDataReader sd;
string sr = "";
try
{
cnn.Open();
sd = cmd.ExecuteReader();
if (sd.HasRows)
{
while (sd.Read())
{
ltrabout1.Text = @"<span style='font-size:13px'>" + sd["About"].ToString() + "</span>";
}
}
}
catch
{
}
finally
{
cnn.Close();
cmd.Dispose();
}
}
protected void chkfilterpro_SelectedIndexChanged(object sender, EventArgs e)
{
string temp_query = "SELECT distinct (Tbl_Product.Id), [Price], [OffPrice], [ProductName], [ImageUrl] FROM [Tbl_Product] inner join Tbl_CarpetInFilter on Tbl_Product.Id=Tbl_CarpetInFilter.ProductId where Tbl_Product.[Counter]>0 ";
bool counter = false;
bool check_null = true;
for (int i = 0; i < chkfilterpro.Items.Count; i++)
{
if (chkfilterpro.Items[i].Selected)
{
check_null = false;
int idfilter = Convert.ToInt32(chkfilterpro.Items[i].Value);
if (!counter)
{
temp_query += " AND Tbl_CarpetInFilter.FilterId = " + idfilter.ToString() + " ";
counter = true;
}
else
{
temp_query += " OR Tbl_CarpetInFilter.FilterId = " + idfilter.ToString() + " ";
}
try
{
}
catch
{
}
finally
{
}
}
}
if (check_null)
{
temp_query = "SELECT [Price], [OffPrice], [ProductName], [ImageUrl], [Id] FROM [Tbl_Product] where [Counter] > 0";
}
try
{
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand(temp_query, cnn);
cnn.Open();
SqlDataAdapter drp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
drp.Fill(ds);
ImagesListView.DataSource = ds;
ImagesListView.DataBind();
cnn.Close();
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand("SELECT [Price], [OffPrice], [ProductName], [ImageUrl], [Id] FROM [Tbl_Product] where [Counter] > 0", cnn);
cnn.Open();
SqlDataAdapter drp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
drp.Fill(ds);
ImagesListView.DataSource = ds;
ImagesListView.DataBind();
cnn.Close();
}
catch (Exception ex)
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand("SELECT [Price], [OffPrice], [ProductName], [ImageUrl], [Id] FROM [Tbl_Product] where [Counter] > 0 AND ProductName like N'%" + Request.QueryString["content"].ToString() + "%'", cnn);
cnn.Open();
SqlDataAdapter drp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
drp.Fill(ds);
ImagesListView.DataSource = ds;
ImagesListView.DataBind();
cnn.Close();
}
catch (Exception ex)
{
Label1.Text = "جستجوی شما نتیجه ای در بر نداشت";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
temp = Convert.ToInt32(Request.QueryString["product"]);
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand("Select_Pro", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", temp);
try
{
SqlDataReader dr;
cnn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ltrname.Text = @"<span style='color:green;font-size: 13px;'>" + dr["نام"].ToString() + "</span>";
ltrimg.Text = @"<img id='zoom_01' width='400px' src='../ProductImages/vlb_images1/" + dr["تصویر"].ToString() + "' data-zoom-image='../ProductImages/vlb_images1/" + dr["تصویر"].ToString() + "'/>";
ltrcolor.Text = @"<span style='color:green;font-size: 13px;'>" + dr["رنگ"].ToString() + "</span>";
lblcolor.Text = dr["کدرنگ"].ToString();
ltrcount.Text = @"<span style='color:green;font-size: 13px;'>" + dr["تعداد"].ToString() + "</span>";
ltrdesc.Text = @"<span style='color:green;font-size: 13px;'>" + dr["توضیحات"].ToString() + "</span>";
ltrdimen.Text = @"<span style='color:green;font-size: 13px;'>" + dr["ابعاد"].ToString() + "</span>";
string pic1 = dr["عکس1"].ToString();
string pic2 = dr["عکس2"].ToString();
string pic3 = dr["عکس3"].ToString();
string pic4 = dr["عکس4"].ToString();
if (pic1 == "")
{
ltrpic1.Text = "";
}
else
{
ltrpic1.Text = @"<img class=thumnail' width='100px' src='../ProductImages/vlb_images1/" + dr["عکس1"].ToString() + "'/>";
}
if (pic2 == "")
{
ltrpic2.Text = "";
}
else
{
ltrpic2.Text = @"<img class=thumnail' width='100px' src='../ProductImages/vlb_images1/" + dr["عکس2"].ToString() + "'/>";
}
if (pic3 == "")
{
ltrpic3.Text = "";
}
else
{
ltrpic3.Text = @"<img class=thumnail' width='100px' src='../ProductImages/vlb_images1/" + dr["عکس3"].ToString() + "'/>";
}
if (pic4 == "")
{
ltrpic4.Text = "";
}
else
{
ltrpic4.Text = @"<img class=thumnail' width='100px' src='../ProductImages/vlb_images1/" + dr["عکس4"].ToString() + "'/>";
}
ltrproducer.Text = @"<span style='color:green'>" + dr["تولیدکننده"].ToString() + "</span>";
ltrshane.Text = @"<span style='color:green;font-size: 13px;'>" + dr["شانه"].ToString() + "</span>";
ltrtarakom.Text = @"<span style='color:green;font-size: 13px;'>" + dr["تراکم"].ToString() + "</span>";
ltrcode.Text = @"<span style='color:green;font-size: 13px;'>" + dr["کد"].ToString() + "</span>";
lblcode.Text = dr["کد"].ToString();
lblprice.Text = dr["تخفیف"].ToString();
ltrprice.Text = @"<span style='color:green;font-size: 18px;'>" + dr["قیمت"].ToString() + "</span>ريال";
ltrpriceoff.Text = @"<span style='color:red;font-size: 18px;'>" + dr["تخفیف"].ToString() + "</span>ريال";
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.ToString();
}
finally
{
cnn.Close();
cmd.Dispose();
}
}
catch (Exception ex)
{
lblmsg.Text = ex.ToString();
}
finally
{
}
SqlConnection cn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cm = new SqlCommand("Select_CarpetColor", cn);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("productid", temp);
SqlDataReader dd;
try
{
cn.Open();
dd = cm.ExecuteReader();
if (dd.HasRows)
{
while (dd.Read())
{
ltrcolocarpet.Text += @"<img src='../ProductImages/vlb_images1/" + dd["تصویر"].ToString() + "' style='width:200px'/><br/>";
}
}
}
catch
{
}
finally
{
cn.Close();
cm.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
/***************************************Top menu****************************/
SqlConnection cntop = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmdtop = new SqlCommand("SELECT Tbl_TopMenu.Id AS TopMenu, Tbl_Filter.Name AS نام, Tbl_TopMenu.filterId AS sfilterid FROM Tbl_TopMenu INNER JOIN Tbl_Filter ON Tbl_TopMenu.filterId = Tbl_Filter.Id ", cntop);
cmdtop.CommandType = CommandType.Text;
SqlDataReader drtop;
try
{
cntop.Open();
drtop = cmdtop.ExecuteReader();
if (drtop.HasRows)
{
while (drtop.Read())
{
ltrtopmenu.Text += @"<li class='nv'><a href='#'>" + drtop["نام"].ToString() + "</a></li>";
}
}
}
catch (Exception ex)
{
}
finally
{
cntop.Close();
cmdtop.Dispose();
}
/**************************************Left menu***************************************/
SqlConnection cnleft = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmdleft = new SqlCommand("select Tbl_Filter.Id , Tbl_Filter.Name As نام from Tbl_Filter where Tbl_Filter.Id not in (select Tbl_TopMenu.FilterId from Tbl_TopMenu)", cnleft);
cmdleft.CommandType = CommandType.Text;
SqlDataReader drleft;
try
{
cnleft.Open();
drleft = cmdleft.ExecuteReader();
if (drleft.HasRows)
{
while (drleft.Read())
{
ltrletfmenu.Text += @"<li><a href='#'>" + drleft["نام"].ToString() + "</a></li>";
}
}
}
catch (Exception ex)
{
}
finally
{
cnleft.Close();
cmdleft.Dispose();
}
/*******************************************productslider**************************************/
List <int> listfilterid = new List <int>();
SqlConnection cnn = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd = new SqlCommand("SELECT Tbl_Slider.Id AS SliderId, Tbl_Filter.Name AS نام, Tbl_Slider.filterId AS sfilterid FROM Tbl_Slider INNER JOIN Tbl_Filter ON Tbl_Slider.filterId = Tbl_Filter.Id ", cnn);
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
try
{
cnn.Open();
dr = cmd.ExecuteReader();
int counter = 1;
if (dr.HasRows)
{
while (dr.Read())
{
listfilterid.Add(Convert.ToInt32(dr["sfilterid"]));
switch (counter)
{
case 1:
{
lbl1.Text = dr["نام"].ToString();
counter++;
break;
}
case 2:
{
lbl2.Text = dr["نام"].ToString();
counter++;
break;
}
case 3:
{
lbl3.Text = dr["نام"].ToString();
counter++;
break;
}
default: break;
}
}
}
}
catch
{
}
finally
{
cnn.Close();
cmd.Dispose();
}
SqlConnection con = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cm = new SqlCommand("select ProductName,Price,OffPrice,ImageUrl,Tbl_Product.Id as Id from Tbl_Product inner join Tbl_CarpetInFilter on Tbl_Product.Id=Tbl_CarpetInFilter.ProductId where FilterId='" + listfilterid[0] + "'", con);
cm.CommandType = CommandType.Text;
SqlDataReader sdr;
try
{
con.Open();
sdr = cm.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
string s = sdr["ImageUrl"].ToString();
string m = sdr["ProductName"].ToString();
string n = sdr["Price"].ToString();
string a = sdr["OffPrice"].ToString();
ltrslider1.Text += @"<a href='../Pages/ProductDetails.aspx?product=" + sdr["Id"].ToString() + "'><div class='slide'><img src='../ProductImages/vlb_images1/" + sdr["ImageUrl"].ToString() + "' class='x'/><br /><span style=\"font-family:'B Yekan'; font-size:15px;\">" + sdr["ProductName"].ToString() + "</span><br /><span style=\"font-family:'B Yekan'; color:red;\"><del>" + sdr["Price"].ToString() + " ریال</del></span><br /><span style=\"font-family: 'B Yekan'; color: #2b9000;\">" + sdr["OffPrice"].ToString() + " ريال</span></div></a>";
}
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
cm.Dispose();
}
SqlConnection con1 = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd1 = new SqlCommand("select ProductName,Price,OffPrice,ImageUrl,Tbl_Product.Id as Id from Tbl_Product inner join Tbl_CarpetInFilter on Tbl_Product.Id=Tbl_CarpetInFilter.ProductId where FilterId='" + listfilterid[1] + "'", con1);
cmd1.CommandType = CommandType.Text;
SqlDataReader sdr1;
try
{
con1.Open();
sdr1 = cmd1.ExecuteReader();
if (sdr1.HasRows)
{
while (sdr1.Read())
{
ltrslider2.Text += @"<a href='../Pages/ProductDetails.aspx?product=" + sdr1["Id"].ToString() + "'><div class='slide'><img src='../ProductImages/vlb_images1/" + sdr1["ImageUrl"].ToString() + "' class='x'/><br /><span style=\"font-family:'B Yekan'; font-size:15px;\">" + sdr1["ProductName"].ToString() + "</span><br /><span style=\"font-family:'B Yekan'; color:red;\"><del>" + sdr1["Price"].ToString() + " ریال</del></span><br /><span style=\"font-family: 'B Yekan'; color: #2b9000;\">" + sdr1["OffPrice"].ToString() + " ريال</span></div></a>";
}
}
}
catch (Exception ex)
{
}
finally
{
con1.Close();
cmd1.Dispose();
}
SqlConnection con2 = new SqlConnection(Vozaracoonnection.GetConnectionStringByName());
SqlCommand cmd2 = new SqlCommand("select ProductName,Price,OffPrice,ImageUrl,Tbl_Product.Id as Id from Tbl_Product inner join Tbl_CarpetInFilter on Tbl_Product.Id=Tbl_CarpetInFilter.ProductId where FilterId=" + listfilterid[2] + "", con2);
cmd2.CommandType = CommandType.Text;
SqlDataReader sdr2;
try
{
con2.Open();
sdr2 = cmd2.ExecuteReader();
if (sdr2.HasRows)
{
while (sdr2.Read())
{
ltrslider3.Text += @"<a href='../Pages/ProductDetails.aspx?product=" + sdr2["Id"].ToString() + "'><div class='slide'><img src='../ProductImages/vlb_images1/" + sdr2["ImageUrl"].ToString() + "' class='x'/><br /><span style=\"font-family:'B Yekan'; font-size:15px;\">" + sdr2["ProductName"].ToString() + "</span><br /><span style=\"font-family:'B Yekan'; color:red;\"><del>" + sdr2["Price"].ToString() + " ریال</del></span><br /><span style=\"font-family: 'B Yekan'; color: #2b9000;\">" + sdr2["OffPrice"].ToString() + " ريال</span></div></a>";
}
}
}
catch (Exception ex)
{
}
finally
{
con2.Close();
cmd2.Dispose();
}
}
