protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e) // DataGrid Güncelleme İşlemi { L_Id.Text = e.Item.Cells[0].Text; L_islem.Text = "GÜNCELLEME"; NewsSql.GetRecordXML_SUB_Category("SUBCATEGORY_PROC_ID_UPDATES", Txt_Ttl, _Check, L_Id, Category_Atributes_Txt, Category_Atributes_Sub_Txt); Clear(); }
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()); } }
protected void Page_Load(object sender, EventArgs e) { SessionAccess.Control_Session_Values(SessionAccess.CRM_User_Email); Category_Title(Txt_Ttl); if (!IsPostBack) { NewsSql.GetRecords(DataGrid1, "SUBCATEGORY_PROC_ID", int.Parse(Request["Category_ID"])); } }
protected void Page_Load(object sender, EventArgs e) { SessionAccess.Control_Session_Values(SessionAccess.CRM_User_Email); if (!IsPostBack) { NewsSql.GetRecords(DataGrid1, "SUBPRODUCT_PROC_ID", int.Parse(Request["Product_ID"])); Clear(); } }
protected void Page_Load(object sender, EventArgs e) { SessionAccess.Control_Session_Values(SessionAccess.CRM_User_Email); if (!IsPostBack) { NewsSql.GetRecords(DataGrid1, "PRODUCT_PROC_AREA", "BP"); Clear(); } }
protected void INSERT_Click(object sender, EventArgs e) { DateTime Date = DateTime.Now; if (L_Id.Text == "" || string.IsNullOrEmpty(L_Id.Text)) { L_Id.Text = "00"; } File_Upload(ResimUpload, Lbl_Txt_Pic, "images"); db.SP("exec Category_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7", int.Parse(L_Id.Text), Txt_Ttl.Text, Txt_Shrt.Text, Lbl_Txt_Pic.Text, Editor_Text_Box.Text, Live_Check.Checked, Category_Text.Text, "Category"); NewsSql.GetRecords(DataGrid1, "Category_PROC_AREA", "Category"); }
protected void INSERT_Click(object sender, EventArgs e) { DateTime Date = DateTime.Now; if (L_Id.Text == "" || string.IsNullOrEmpty(L_Id.Text)) { L_Id.Text = "00"; } File_Upload(ResimUpload, Lbl_Txt_Pic, "images"); db.SP("exec PRODUCT_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19", int.Parse(L_Id.Text), Txt_Ttl.Text, Txt_Shrt.Text, Lbl_Txt_Pic.Text, Editor_Text_Box.Text, "Product", Date, Live_Check.Checked, DropDownList1.SelectedValue, Price_Txt.Text, Product_Counter.Text, Product_Status.SelectedItem.Value, Brand_Drp.SelectedItem.Text, Reduce_Price_Txt.Text, Ratio_Reduce_TXT.Text, Product_Type_DRP.SelectedItem.Text, "", "", "", ""); NewsSql.GetRecords(DataGrid1, "PRODUCT_PROC_AREA", "Product"); }
protected void INSERT_Click(object sender, EventArgs e) { if (L_Id.Text == "" || string.IsNullOrEmpty(L_Id.Text)) { L_Id.Text = "00"; } db.SP("exec SUBCATEGORY_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5", int.Parse(Request["Category_ID"]), int.Parse(L_Id.Text), Txt_Ttl.Text, Category_Atributes_Txt.Text, Category_Atributes_Sub_Txt.Text, _Check.Checked); NewsSql.GetRecords(DataGrid1, "SUBCATEGORY_PROC_ID", int.Parse(Request["Category_ID"])); Clear(); }
protected void INSERT_Click(object sender, EventArgs e) { DateTime Date = DateTime.Now; if (L_Id.Text == "" || string.IsNullOrEmpty(L_Id.Text)) { L_Id.Text = "00"; } File_Upload(ResimUpload, Lbl_Txt_Pic, "images"); db.SP("exec SUBPRODUCT_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8", int.Parse(Request["Product_ID"]), Txt_Ttl.Text, Lbl_Txt_Pic.Text, Slider_Check.Checked, Date, int.Parse(L_Id.Text), Keywords_TXT.Text, UrunDrop.SelectedItem.Value, Stok_Txt.Text); NewsSql.GetRecords(DataGrid1, "SUBPRODUCT_PROC_ID", int.Parse(Request["Product_ID"])); Clear(); }
protected void INSERT_Click(object sender, EventArgs e) { DateTime Date = DateTime.Now; if (L_Id.Text == "" || string.IsNullOrEmpty(L_Id.Text)) { L_Id.Text = "00"; } // string TXT_TIMES = result.ToString("hh:mm:ss tt", CultureInfo.CurrentCulture); File_Upload(ResimUpload, Lbl_Txt_Pic, "images"); // db.SP("exec PRODUCT_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19", int.Parse(L_Id.Text), Txt_Ttl.Text, Txt_Shrt.Text, Lbl_Txt_Pic.Text, Editor_Text_Box.Text, "TD", Date, Live_Check.Checked, DropDownList1.SelectedValue, Price_Txt.Text, Product_Counter.Text, Product_Status.SelectedItem.Value, Brand_Drp.SelectedItem.Text, Reduce_Price_Txt.Text, Ratio_Reduce_TXT.Text, Product_Type_DRP.SelectedItem.Text, Convert.ToDateTime(TXT_DAY.Text), Convert.ToDateTime(TXT_MONTH.Text), Convert.ToDateTime(TXT_YEAR.Text), Convert.ToDateTime(TXT_TIME.Text)); db.SP("exec PRODUCT_PROC_INSERT_UPDATE @P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19", int.Parse(L_Id.Text), Txt_Ttl.Text, Txt_Shrt.Text, Lbl_Txt_Pic.Text, Editor_Text_Box.Text, "LD", Date, Live_Check.Checked, DropDownList1.SelectedValue, Price_Txt.Text, Product_Counter.Text, Product_Status.SelectedItem.Value, Brand_Drp.SelectedItem.Text, Reduce_Price_Txt.Text, Ratio_Reduce_TXT.Text, Product_Type_DRP.SelectedItem.Text, "", "", "", ""); NewsSql.GetRecords(DataGrid1, "PRODUCT_PROC_AREA", "LD"); Clear(); }
protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e) // DataGrid Güncelleme İşlemi { L_Id.Text = e.Item.Cells[0].Text; L_islem.Text = "GÜNCELLEME"; NewsSql.GetRecordXML("PRODUCT_PROC_ID_AREA", Txt_Ttl, Txt_Shrt, Lbl_Txt_Pic, Editor_Text_Box, "BP", L_Id, Live_Check, Product_Image, DropDownList1, Price_Txt, Product_Counter, Product_Status, Brand_Drp, Reduce_Price_Txt, Ratio_Reduce_TXT, Product_Type_DRP); }
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 { } } }
protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e) // Datagrid Delete İşlemi { db.SP("exec SUBPRODUCT_DELETE_PROC @P0", int.Parse((e.Item.Cells[0].Text))); //ID'e göre delete işlemi NewsSql.GetRecords(DataGrid1, "SUBPRODUCT_PROC_ID", int.Parse(Request["Product_ID"])); }
protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e) // DataGrid Güncelleme İşlemi { L_Id.Text = e.Item.Cells[0].Text; L_islem.Text = "GÜNCELLEME"; NewsSql.GetRecordXML_SUB("SUBPRODUCT_PROC_ID_UPDATES", Txt_Ttl, Slider_Check, Lbl_Txt_Pic, L_Id, Product_image, Keywords_TXT, UrunDrop, Stok_Txt); }
protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e) // DataGrid Güncelleme İşlemi { L_Id.Text = e.Item.Cells[0].Text; L_islem.Text = "GÜNCELLEME"; NewsSql.GetRecordXML("CATEGORY_PROC_ID_AREA", Txt_Ttl, Txt_Shrt, Lbl_Txt_Pic, Editor_Text_Box, L_Id, Live_Check, Product_Image, Category_Text); }
protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex = e.NewPageIndex; NewsSql.FillDataGrid("SUBCATEGORY_PROC_ID", DataGrid1, int.Parse(Request["Category_ID"])); }
protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex = e.NewPageIndex; NewsSql.FillDataGrid("PRODUCT_PROC_AREA", DataGrid1, "BP"); }
protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex = e.NewPageIndex; NewsSql.FillDataGrid("SUBPRODUCT_PROC_ID", DataGrid1, int.Parse(Request["Product_ID"])); }
protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e) // Datagrid Delete İşlemi { db.SP("exec PRODUCT_DELETE_PROC @P0", int.Parse((e.Item.Cells[0].Text))); //ID'e göre delete işlemi NewsSql.GetRecords(DataGrid1, "PRODUCT_PROC_AREA", "BP"); }
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 { } } }