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 PermitEditUser : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString()); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } } private void LadData() { if (DrpUser.SelectedValue.ToString() == "1") { lblerror.Text = "لا يمكن تعديل هذا المستخدم"; lblerror.Focus(); return; } int mycode = Convert.ToInt16(DrpUser.SelectedValue); SqlCommand cmd2 = new SqlCommand("Select NameD,Tele,Email,Dep from Users where Code=" + mycode + "", con); if (con.State == ConnectionState.Closed) con.Open(); SqlDataReader dr = cmd2.ExecuteReader(); dr.Read(); if (dr.HasRows) { txtName.Text = dr[0].ToString(); if (!dr.IsDBNull(2)) txtEmail.Text = dr[2].ToString(); if (!dr.IsDBNull(1)) txtTele.Text = dr[1].ToString(); if (!dr.IsDBNull(3)) DrpDepartment.SelectedValue = dr[3].ToString(); } dr.Close(); con.Close(); //Permistion SqlCommand cmdCD = new SqlCommand("Select Admin,Report,dawa,Edit,AddNew,P_Delete,P_Order from Permit where Code=" + mycode + "", con); if (con.State == ConnectionState.Closed) con.Open(); SqlDataReader drCD = cmdCD.ExecuteReader(); drCD.Read(); string Admin = "False", Report = "False", dawaa = "False", Pedit = "False", padd = "False", pdelete = "False", porder = "False"; if (drCD.HasRows) { if (!drCD.IsDBNull(0)) Admin = drCD[0].ToString(); if (Admin == "True") ChkAdmin.Checked = true; else ChkAdmin.Checked = false; if (!drCD.IsDBNull(1)) Report = drCD[1].ToString(); if (Report == "True") Show.Checked = true; else Show.Checked = false; if (!drCD.IsDBNull(2)) dawaa = drCD[2].ToString(); if (dawaa == "True") Dawa.Checked = true; else Dawa.Checked = false; if (!drCD.IsDBNull(3)) Pedit = drCD[3].ToString(); if (Pedit == "True") chkEdit.Checked = true; else chkEdit.Checked = false; if (!drCD.IsDBNull(4)) padd = drCD[4].ToString(); if (padd == "True") chkAddNew.Checked = true; else chkAddNew.Checked = false; if (!drCD.IsDBNull(5)) pdelete = drCD[5].ToString(); if (pdelete == "True") chkP_Delete.Checked = true; else chkP_Delete.Checked = false; if (!drCD.IsDBNull(6)) porder = drCD[6].ToString(); if (porder == "True") chkP_Order.Checked = true; else chkP_Order.Checked = false; } drCD.Close(); con.Close(); } protected void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text == "admin") { lblerror.Text = "لا يمكن تعديل هذا المستخدم"; lblerror.Focus(); return; } if (Page.IsValid) { string xadmin = Session["admin"].ToString(); if (xadmin == "True") { int mycode = Convert.ToInt16(DrpUser.SelectedValue); int sd = 0, yd = 0, dawaa = 0, Pedit = 0, padd = 0, pdelete = 0, porder = 0; if (ChkAdmin.Checked == true) { sd = 1; yd = 1; dawaa = 1; Pedit = 1; padd = 1; pdelete = 1; porder = 1; } else { sd = 0; if (Show.Checked == true) yd = 1; else yd = 0; if (Dawa.Checked == true) dawaa = 1; else dawaa = 0; if (chkAddNew.Checked == true) padd = 1; else padd = 0; if (chkEdit.Checked == true) Pedit = 1; else Pedit = 0; if (chkP_Delete.Checked == true) pdelete = 1; else pdelete = 0; if (chkP_Order.Checked == true) porder = 1; else porder = 0; } //, , SqlCommand cmd2 = new SqlCommand("Update Users set PassWord=N'" + txtPass.Text + "', NameD=N'" + txtName.Text + "',Tele =N'" + txtTele.Text + "'" + ",Email=N'" + txtEmail.Text + "',Dep=" + DrpDepartment.SelectedValue + " where Code=" + mycode + "", con); if (con.State == ConnectionState.Closed) con.Open(); cmd2.ExecuteNonQuery(); con.Close(); SqlCommand cmdInsert2 = new SqlCommand("Update Permit set Admin= " + sd + " , Report=" + yd + ", dawa= " + dawaa + " " + ", Edit=" + Pedit + ",AddNew=" + padd + ",P_Delete=" + pdelete + ",P_Order=" + porder + "" + " where Code=" + mycode + "", con); if (con.State == ConnectionState.Closed) con.Open(); cmdInsert2.ExecuteNonQuery(); lblerror.Text = "تم تعديل المستخدم"; DrpUser.ClearSelection(); txtName.Text = ""; txtEmail.Text = ""; txtTele.Text = ""; ChkAdmin.Checked = false; chkAddNew.Checked = false; chkEdit.Checked = false; chkP_Delete.Checked = false; chkP_Order.Checked = false; DrpDepartment.ClearSelection(); con.Close(); } con.Close(); } } protected void btnShow_Click(object sender, EventArgs e) { lblerror.Text = ""; LadData(); } }