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 { }
}
}
