using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class th_Edit : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString()); int muslim; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { muslim = Convert.ToInt16(Request.QueryString["id"].ToString()); LoadData(muslim); } } private void LoadData(int Code) { LBLSHOW.Text = "تحرير نشاط غير محدد"; Page.Title = "تحرير نشاط غير محدد"; try { SqlCommand cmd = new SqlCommand("Select Tit_Book,Tit_Matwya,Tit_Dblaga,Tit_Macar,Tit_twitter,Tit_Facebook,Tit_Non,Tit_Chinese" + ",Le_Day,Le_Month,Le_Year,Le_User,Le_Desc From tbl_th where Code=" + Code, con); if (con.State == ConnectionState.Closed) con.Open(); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { if (!dr.IsDBNull(0)) { txtTit_Book.Text=dr["Tit_Book"].ToString(); } if (!dr.IsDBNull(1)) { txtTit_Matwya.Text = dr["Tit_Matwya"].ToString(); } if (!dr.IsDBNull(2)) { txtTit_Dblaga.Text = dr["Tit_Dblaga"].ToString(); } if (!dr.IsDBNull(3)) { txtTit_Macar.Text = dr["Tit_Macar"].ToString(); } if (!dr.IsDBNull(4)) { txtTit_twitter.Text = dr["Tit_twitter"].ToString(); } if (!dr.IsDBNull(5)) { txtTit_Facebook.Text = dr["Tit_Facebook"].ToString(); } if (!dr.IsDBNull(6)) { txtTit_Non.Text = dr["Tit_Non"].ToString(); } if (!dr.IsDBNull(7)) { txtTit_Chinese.Text = dr["Tit_Chinese"].ToString(); } if (!dr.IsDBNull(8)) { DrpDay.SelectedValue = dr["Le_Day"].ToString(); } if (!dr.IsDBNull(9)) { DrpMonth.SelectedValue = dr["Le_Month"].ToString(); } if (!dr.IsDBNull(10)) { txtYear.Text = dr["Le_Year"].ToString(); } if (!dr.IsDBNull(11)) { DrpwhoName.SelectedValue = dr["Le_User"].ToString(); } if (!dr.IsDBNull(12)) { txtTit_Desc.Text = dr["Le_Desc"].ToString(); } } dr.Close(); con.Close(); } catch (Exception ex) { lblerror2.Text = "حدث خطأ كالتالي " + ex.ToString(); throw; } } private void UpdateData(int Code) { string xadmin = Session["Edit"].ToString(); if (xadmin == "True") { try { if (txtYear.Text == "") { txtYear.Text = "1435"; } if (txtTit_Desc.Text == "") { ///return; txtTit_Desc.Focus(); txtTit_Desc.Text = "لم يتم الادخال"; } SqlCommand cmdInsert = new SqlCommand("Update tbl_th set Tit_Book=" + txtTit_Book.Text + ","+ "Tit_Matwya=" + txtTit_Matwya.Text + ",Tit_Dblaga=" + txtTit_Dblaga.Text + ",Tit_Macar=" + txtTit_Macar.Text + "" + ",Tit_twitter=" + txtTit_twitter.Text + ",Tit_Facebook=" + txtTit_Facebook.Text + ",Tit_Non=" + txtTit_Non.Text + ",Tit_Chinese=" + txtTit_Chinese.Text + "" + ",Le_Desc=N'" + txtTit_Desc.Text + "',Le_Day=N'" + DrpDay.SelectedValue + "'" + ",Le_Month=N'" + DrpMonth.SelectedValue + "',Le_Year=N'" + txtYear.Text + "' " + " where Code=" + Code, con); if (con.State == ConnectionState.Closed) con.Open(); cmdInsert.ExecuteNonQuery(); con.Close(); lblerror2.Text = "تم تحديث البيانات"; } catch (Exception ex) { lblerror2.Text = "حدث خطأ كالتالي " + ex.ToString(); return; } } else lblerror2.Text = "ليس لك الصلاحية في هذا الاجراء"; } protected void btnAdd2_Click(object sender, EventArgs e) { string xadmin = Session["Edit"].ToString(); if (xadmin == "True") { muslim = Convert.ToInt16(Request.QueryString["id"].ToString()); UpdateData(muslim); LoadData(muslim); } else lblerror2.Text = "ليس لك الصلاحية في هذا الاجراء"; } protected void btnreturn_Click(object sender, EventArgs e) { Response.Redirect("th.aspx"); } protected void btnDelete_Click(object sender, EventArgs e) { string xadmin = Session["P_Delete"].ToString(); if (xadmin == "True") { try { muslim = Convert.ToInt16(Request.QueryString["id"].ToString()); SqlCommand cmdInsert = new SqlCommand("Delete From tbl_th " + " where Code=" + muslim, con); if (con.State == ConnectionState.Closed) con.Open(); cmdInsert.ExecuteNonQuery(); con.Close(); lblerror2.Text = "تم حذف البيانات"; txtYear.Text = ""; DrpMonth.ClearSelection(); DrpDay.ClearSelection(); txtTit_Facebook.Text = "0"; txtTit_Book.Text = "0"; txtTit_twitter.Text = "0"; txtTit_Dblaga.Text = "0"; txtTit_Matwya.Text = "0"; txtTit_Non.Text = "0"; txtTit_Chinese.Text = "0"; txtTit_Macar.Text = "0"; txtTit_Desc.Text = ""; } catch (Exception ex) { lblerror2.Text = "حدث خطأ كالتالي " + ex.ToString(); return; } } else lblerror2.Text = "ليس لك الصلاحية في هذا الاجراء"; } }