public void Banner_Category()
{
DataTable dt = null;
dt = db.QP("exec Deal_Stored_Select_Without_Category @P0,@P1", "BA", 2).Tables[0];
if (dt.Rows.Count > 0)
{
try
{
A1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A1.Title = (string)dt.Rows[0]["Title"];
img1.Src = (string)dt.Rows[0]["İmage"];
img1.Alt = (string)dt.Rows[0]["Title"];
}
catch { }
try
{
A2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A2.Title = (string)dt.Rows[1]["Title"];
img2.Src = (string)dt.Rows[1]["İmage"];
img2.Alt = (string)dt.Rows[1]["Title"];
}
catch { }
}
}
public void Slider_Home_Data_Preview()
{
DataTable dt = db.QP("exec Common_Procedures_Of_Products_Area @P0,@P1", "Slider", 3).Tables[0];
if (dt.Rows.Count > 0)
{
contenhomesliderLink0.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code(dt.Rows[0]["Category"].ToString()), Title = NewsSql.Replacement_Code(dt.Rows[0]["title"].ToString()), PRODUCT_ID = NewsSql.Replacement_Code(dt.Rows[0]["Product_ID"].ToString()) });
contenhomesliderLink0.Title = NewsSql.Replacement_Code(dt.Rows[0]["title"].ToString());
contenhomesliderLink0.Target = "_parent";
contenhomesliderimg0.Src = (string)dt.Rows[0]["İmage"];
contenhomesliderimg0.Alt = NewsSql.Replacement_Code(dt.Rows[0]["title"].ToString());
contenhomesliderLink1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code(dt.Rows[1]["Category"].ToString()), Title = NewsSql.Replacement_Code(dt.Rows[1]["title"].ToString()), PRODUCT_ID = NewsSql.Replacement_Code(dt.Rows[1]["Product_ID"].ToString()) });
contenhomesliderLink1.Title = NewsSql.Replacement_Code(dt.Rows[1]["title"].ToString());
contenhomesliderLink1.Target = "_parent";
contenhomesliderimg1.Src = (string)dt.Rows[1]["İmage"];
contenhomesliderimg1.Alt = NewsSql.Replacement_Code(dt.Rows[1]["title"].ToString());
contenhomesliderLink2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code(dt.Rows[2]["Category"].ToString()), Title = NewsSql.Replacement_Code(dt.Rows[2]["title"].ToString()), PRODUCT_ID = NewsSql.Replacement_Code(dt.Rows[2]["Product_ID"].ToString()) });
contenhomesliderLink2.Title = NewsSql.Replacement_Code(dt.Rows[2]["title"].ToString());
contenhomesliderLink2.Target = "_parent";
contenhomesliderimg2.Src = (string)dt.Rows[2]["İmage"];
contenhomesliderimg2.Alt = NewsSql.Replacement_Code(dt.Rows[2]["title"].ToString());
}
}
private void Spor_Category()
{
DataTable dt = null;
dt = db.QP("exec Deal_Stored_Select @P0,@P1,@P2", "TD", "Spor ve Outdoor", 3).Tables[0];
if (dt.Rows.Count > 0)
{
try
{ // Deal 1
Deal_Link_1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Deal_Link_1.Title = (string)dt.Rows[0]["Title"];
Deal_Img_1.Src = (string)dt.Rows[0]["İmage"];
Deal_Img_1.Alt = (string)dt.Rows[0]["Title"];
Deal_Link_2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Deal_Link_2.Title = (string)dt.Rows[0]["Title"];
Link_Label_1.InnerHtml = (string)dt.Rows[0]["Title"];
Link_Label_Price_1.InnerHtml = (string)dt.Rows[0]["Price_Reduce"];
Link_Label_Old_Price_1.InnerHtml = (string)dt.Rows[0]["Price"];
Link_Label_Sale_Price_1.InnerHtml = "%" + (string)dt.Rows[0]["Price_Ratio_Reduce"];
Link_Label_Description_1.InnerHtml = (string)dt.Rows[0]["Description"].ToString().Substring(0, 86) + " ...";
// Deal 4
Deal_Link_11.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Deal_Link_11.Title = (string)dt.Rows[0]["Title"];
Deal_Img_11.Src = (string)dt.Rows[0]["İmage"];
Deal_Img_11.Alt = (string)dt.Rows[0]["Title"];
Deal_Link_22.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Deal_Link_22.Title = (string)dt.Rows[0]["Title"];
Link_Label_11.InnerHtml = (string)dt.Rows[0]["Title"];
Link_Label_Price_11.InnerHtml = (string)dt.Rows[0]["Price_Reduce"];
Link_Label_Old_Price_11.InnerHtml = (string)dt.Rows[0]["Price"];
Link_Label_Sale_Price_11.InnerHtml = "%" + (string)dt.Rows[0]["Price_Ratio_Reduce"];
Link_Label_Description_11.InnerHtml = (string)dt.Rows[0]["Description"].ToString().Substring(0, 86) + " ...";
}
catch { }
try
{ // Deal 2
Deal_Link_3.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Deal_Link_3.Title = (string)dt.Rows[1]["Title"];
Deal_Img_2.Src = (string)dt.Rows[1]["İmage"];
Deal_Img_2.Alt = (string)dt.Rows[1]["Title"];
Deal_Link_4.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Deal_Link_4.Title = (string)dt.Rows[1]["Title"];
Link_Label_2.InnerHtml = (string)dt.Rows[1]["Title"];
Link_Label_Price_2.InnerHtml = (string)dt.Rows[1]["Price_Reduce"];
Link_Label_Old_Price_2.InnerHtml = (string)dt.Rows[1]["Price"];
Link_Label_Sale_Price_2.InnerHtml = "%" + (string)dt.Rows[1]["Price_Ratio_Reduce"];
Link_Label_Description_2.InnerHtml = (string)dt.Rows[1]["Description"].ToString().Substring(0, 86) + " ...";
// Deal 5
Deal_Link_33.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Deal_Link_33.Title = (string)dt.Rows[1]["Title"];
Deal_Img_22.Src = (string)dt.Rows[1]["İmage"];
Deal_Img_22.Alt = (string)dt.Rows[1]["Title"];
Deal_Link_44.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Deal_Link_44.Title = (string)dt.Rows[1]["Title"];
Link_Label_22.InnerHtml = (string)dt.Rows[1]["Title"];
Link_Label_Price_22.InnerHtml = (string)dt.Rows[1]["Price_Reduce"];
Link_Label_Old_Price_22.InnerHtml = (string)dt.Rows[1]["Price"];
Link_Label_Sale_Price_22.InnerHtml = "%" + (string)dt.Rows[1]["Price_Ratio_Reduce"];
Link_Label_Description_22.InnerHtml = (string)dt.Rows[1]["Description"].ToString().Substring(0, 86) + " ...";
}
catch { }
try
{ // Deal 3
Deal_Link_5.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Deal_Link_5.Title = (string)dt.Rows[2]["Title"];
Deal_Img_3.Src = (string)dt.Rows[2]["İmage"];
Deal_Img_3.Alt = (string)dt.Rows[2]["Title"];
Deal_Link_6.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Deal_Link_6.Title = (string)dt.Rows[2]["Title"];
Link_Label_3.InnerHtml = (string)dt.Rows[2]["Title"];
Link_Label_Price_3.InnerHtml = (string)dt.Rows[2]["Price_Reduce"];
Link_Label_Old_Price_3.InnerHtml = (string)dt.Rows[2]["Price"];
Link_Label_Sale_Price_3.InnerHtml = "%" + (string)dt.Rows[2]["Price_Ratio_Reduce"];
Link_Label_Description_3.InnerHtml = (string)dt.Rows[2]["Description"].ToString().Substring(0, 86) + " ...";
// Deal 6
Deal_Link_55.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Deal_Link_55.Title = (string)dt.Rows[2]["Title"];
Deal_Img_33.Src = (string)dt.Rows[2]["İmage"];
Deal_Img_33.Alt = (string)dt.Rows[2]["Title"];
Deal_Link_66.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Deal_Link_66.Title = (string)dt.Rows[2]["Title"];
Link_Label_33.InnerHtml = (string)dt.Rows[2]["Title"];
Link_Label_Price_33.InnerHtml = (string)dt.Rows[2]["Price_Reduce"];
Link_Label_Old_Price_33.InnerHtml = (string)dt.Rows[2]["Price"];
Link_Label_Sale_Price_33.InnerHtml = "%" + (string)dt.Rows[2]["Price_Ratio_Reduce"];
Link_Label_Description_33.InnerHtml = (string)dt.Rows[2]["Description"].ToString().Substring(0, 86) + " ...";
}
catch { }
}
dt = null;
dt = db.QP("exec Deal_Stored_Select @P0,@P1,@P2", "SCT", "Spor ve Outdoor", 3).Tables[0];
if (dt.Rows.Count > 0)
{
try
{ // Slider 1
Slider_Spor1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Slider_Spor1.Title = (string)dt.Rows[0]["Title"];
Spor_Img1.Src = (string)dt.Rows[0]["İmage"];
Spor_Img1.Alt = (string)dt.Rows[0]["Title"];
Slider_Spor11.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
Slider_Spor11.Title = (string)dt.Rows[0]["Title"];
Spor_Img11.Src = (string)dt.Rows[0]["İmage"];
Spor_Img11.Alt = (string)dt.Rows[0]["Title"];
}
catch { }
try
{ // Slider 2
Slider_Spor2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Slider_Spor2.Title = (string)dt.Rows[1]["Title"];
Spor_Img2.Src = (string)dt.Rows[1]["İmage"];
Spor_Img2.Alt = (string)dt.Rows[1]["Title"];
Slider_Spor22.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
Slider_Spor22.Title = (string)dt.Rows[1]["Title"];
Spor_Img22.Src = (string)dt.Rows[1]["İmage"];
Spor_Img22.Alt = (string)dt.Rows[1]["Title"];
}
catch { }
try
{ // Slider 3
Slider_Spor3.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Slider_Spor3.Title = (string)dt.Rows[2]["Title"];
Spor_Img3.Src = (string)dt.Rows[2]["İmage"];
Spor_Img3.Alt = (string)dt.Rows[2]["Title"];
Slider_Spor33.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
Slider_Spor33.Title = (string)dt.Rows[2]["Title"];
Spor_Img33.Src = (string)dt.Rows[2]["İmage"];
Spor_Img33.Alt = (string)dt.Rows[2]["Title"];
}
catch { }
}
}
public void Blog_Category()
{
DataTable dt = null;
dt = db.QP("exec Deal_Stored_Select_Without_Category @P0,@P1", "BP", 10).Tables[0];
if (dt.Rows.Count > 0)
{
try
{
A1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A1.Title = (string)dt.Rows[0]["Title"];
img1.Src = (string)dt.Rows[0]["İmage"];
img1.Alt = (string)dt.Rows[0]["Title"];
A2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A2.Title = (string)dt.Rows[0]["Title"];
A3.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A3.Title = (string)dt.Rows[0]["Title"];
Label1.InnerHtml = (string)dt.Rows[0]["Title"];
}
catch { }
try
{
A4.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A4.Title = (string)dt.Rows[1]["Title"];
img2.Src = (string)dt.Rows[1]["İmage"];
img2.Alt = (string)dt.Rows[1]["Title"];
A5.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A5.Title = (string)dt.Rows[1]["Title"];
A6.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A6.Title = (string)dt.Rows[1]["Title"];
Label2.InnerHtml = (string)dt.Rows[1]["Title"];
}
catch { }
try
{
A7.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
A7.Title = (string)dt.Rows[2]["Title"];
img3.Src = (string)dt.Rows[2]["İmage"];
img3.Alt = (string)dt.Rows[2]["Title"];
A8.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
A8.Title = (string)dt.Rows[2]["Title"];
A9.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
A9.Title = (string)dt.Rows[2]["Title"];
Label3.InnerHtml = (string)dt.Rows[2]["Title"];
}
catch { }
try
{
A10.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[3]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[3]["Title"]), PRODUCT_ID = (int)dt.Rows[3]["PRODUCT_ID"] });
A10.Title = (string)dt.Rows[3]["Title"];
img4.Src = (string)dt.Rows[3]["İmage"];
img4.Alt = (string)dt.Rows[3]["Title"];
A11.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[3]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[3]["Title"]), PRODUCT_ID = (int)dt.Rows[3]["PRODUCT_ID"] });
A11.Title = (string)dt.Rows[3]["Title"];
A12.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[3]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[3]["Title"]), PRODUCT_ID = (int)dt.Rows[3]["PRODUCT_ID"] });
A12.Title = (string)dt.Rows[3]["Title"];
Label4.InnerHtml = (string)dt.Rows[3]["Title"];
}
catch { }
}
}
public void Deal_Category()
{
DataTable dt = null;
dt = db.QP("exec Deal_Stored_Select_Without_Category @P0,@P1", "LD", 10).Tables[0];
if (dt.Rows.Count > 0)
{
try
{
A1.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A1.Title = (string)dt.Rows[0]["Title"];
img1.Src = (string)dt.Rows[0]["İmage"];
img1.Alt = (string)dt.Rows[0]["Title"];
A2.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[0]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[0]["Title"]), PRODUCT_ID = (int)dt.Rows[0]["PRODUCT_ID"] });
A2.Title = (string)dt.Rows[0]["Title"];
Label1.InnerHtml = (string)dt.Rows[0]["Title"];
Span1.InnerHtml = (string)dt.Rows[0]["Price"];
}
catch { }
try
{
A3.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A3.Title = (string)dt.Rows[1]["Title"];
img2.Src = (string)dt.Rows[1]["İmage"];
img2.Alt = (string)dt.Rows[1]["Title"];
A4.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[1]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[1]["Title"]), PRODUCT_ID = (int)dt.Rows[1]["PRODUCT_ID"] });
A4.Title = (string)dt.Rows[1]["Title"];
Label2.InnerHtml = (string)dt.Rows[1]["Title"];
Span2.InnerHtml = (string)dt.Rows[1]["Price"];
}
catch { }
try
{
A5.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
A5.Title = (string)dt.Rows[2]["Title"];
img3.Src = (string)dt.Rows[2]["İmage"];
img3.Alt = (string)dt.Rows[2]["Title"];
A6.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[2]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[2]["Title"]), PRODUCT_ID = (int)dt.Rows[2]["PRODUCT_ID"] });
A6.Title = (string)dt.Rows[2]["Title"];
Label3.InnerHtml = (string)dt.Rows[2]["Title"];
Span3.InnerHtml = (string)dt.Rows[2]["Price"];
}
catch { }
try
{
A7.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[3]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[3]["Title"]), PRODUCT_ID = (int)dt.Rows[3]["PRODUCT_ID"] });
A7.Title = (string)dt.Rows[3]["Title"];
img4.Src = (string)dt.Rows[3]["İmage"];
img4.Alt = (string)dt.Rows[3]["Title"];
A8.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[3]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[3]["Title"]), PRODUCT_ID = (int)dt.Rows[3]["PRODUCT_ID"] });
A8.Title = (string)dt.Rows[3]["Title"];
Label4.InnerHtml = (string)dt.Rows[3]["Title"];
Span4.InnerHtml = (string)dt.Rows[3]["Price"];
}
catch { }
try
{
A9.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[4]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[4]["Title"]), PRODUCT_ID = (int)dt.Rows[4]["PRODUCT_ID"] });
A9.Title = (string)dt.Rows[4]["Title"];
img5.Src = (string)dt.Rows[4]["İmage"];
img5.Alt = (string)dt.Rows[4]["Title"];
A10.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[4]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[4]["Title"]), PRODUCT_ID = (int)dt.Rows[4]["PRODUCT_ID"] });
A10.Title = (string)dt.Rows[4]["Title"];
Label5.InnerHtml = (string)dt.Rows[4]["Title"];
Span5.InnerHtml = (string)dt.Rows[4]["Price"];
}
catch { }
try
{
A11.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[5]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[5]["Title"]), PRODUCT_ID = (int)dt.Rows[5]["PRODUCT_ID"] });
A11.Title = (string)dt.Rows[5]["Title"];
img6.Src = (string)dt.Rows[5]["İmage"];
img6.Alt = (string)dt.Rows[5]["Title"];
A12.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[5]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[5]["Title"]), PRODUCT_ID = (int)dt.Rows[5]["PRODUCT_ID"] });
A12.Title = (string)dt.Rows[5]["Title"];
Label6.InnerHtml = (string)dt.Rows[5]["Title"];
Span6.InnerHtml = (string)dt.Rows[5]["Price"];
}
catch { }
try
{
A13.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[6]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[6]["Title"]), PRODUCT_ID = (int)dt.Rows[6]["PRODUCT_ID"] });
A13.Title = (string)dt.Rows[6]["Title"];
img7.Src = (string)dt.Rows[6]["İmage"];
img7.Alt = (string)dt.Rows[6]["Title"];
A14.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[6]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[6]["Title"]), PRODUCT_ID = (int)dt.Rows[6]["PRODUCT_ID"] });
A14.Title = (string)dt.Rows[6]["Title"];
Label7.InnerHtml = (string)dt.Rows[6]["Title"];
Span7.InnerHtml = (string)dt.Rows[6]["Price"];
}
catch { }
try
{
A15.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[7]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[7]["Title"]), PRODUCT_ID = (int)dt.Rows[7]["PRODUCT_ID"] });
A15.Title = (string)dt.Rows[7]["Title"];
img8.Src = (string)dt.Rows[7]["İmage"];
img8.Alt = (string)dt.Rows[7]["Title"];
A16.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[7]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[7]["Title"]), PRODUCT_ID = (int)dt.Rows[7]["PRODUCT_ID"] });
A16.Title = (string)dt.Rows[7]["Title"];
Label8.InnerHtml = (string)dt.Rows[7]["Title"];
Span8.InnerHtml = (string)dt.Rows[7]["Price"];
}
catch { }
try
{
A17.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[8]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[8]["Title"]), PRODUCT_ID = (int)dt.Rows[8]["PRODUCT_ID"] });
A17.Title = (string)dt.Rows[8]["Title"];
img9.Src = (string)dt.Rows[8]["İmage"];
img9.Alt = (string)dt.Rows[8]["Title"];
A18.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[8]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[8]["Title"]), PRODUCT_ID = (int)dt.Rows[8]["PRODUCT_ID"] });
A18.Title = (string)dt.Rows[8]["Title"];
Label9.InnerHtml = (string)dt.Rows[8]["Title"];
Span9.InnerHtml = (string)dt.Rows[8]["Price"];
}
catch { }
try
{
A19.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[9]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[9]["Title"]), PRODUCT_ID = (int)dt.Rows[9]["PRODUCT_ID"] });
A19.Title = (string)dt.Rows[9]["Title"];
img10.Src = (string)dt.Rows[9]["İmage"];
img10.Alt = (string)dt.Rows[9]["Title"];
A20.HRef = Page.GetRouteUrl("Product", new { Category = NewsSql.Replacement_Code((string)dt.Rows[9]["Category"]), Title = NewsSql.Replacement_Code((string)dt.Rows[9]["Title"]), PRODUCT_ID = (int)dt.Rows[9]["PRODUCT_ID"] });
A20.Title = (string)dt.Rows[9]["Title"];
Label10.InnerHtml = (string)dt.Rows[9]["Title"];
Span10.InnerHtml = (string)dt.Rows[9]["Price"];
}
catch { }
}
}