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