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, "PRODUCT_PROC_AREA", "BP");
Clear();
}
}
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 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 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)
{
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 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_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");
}
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"]));
}