protected void GridViewRole_RowDeleting(object sender, GridViewDeleteEventArgs e) { int index = e.RowIndex; Label _lblRole_ID = (Label)GridViewRole.Rows[e.RowIndex].FindControl("lblRole_ID"); List <dbo_UserClass> user = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, _lblRole_ID.Text, string.Empty, null, string.Empty, string.Empty); dbo_RoleClass role = new dbo_RoleClass(); role.Role_ID = _lblRole_ID.Text; dbo_RoleDataClass.Delete(role); dbo_RolePermissionClass role_per = new dbo_RolePermissionClass(); role_per.Role_ID = _lblRole_ID.Text; dbo_RolePermissionDataClass.Delete(role_per); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ลบข้อมูลสำเร็จ"); GridViewRole.ShowFooter = false; SearchSubmit(); }
public void PrintNodesRecursive(TreeNode oParentNode) { if (oParentNode.Checked) { dbo_RolePermissionClass role = new dbo_RolePermissionClass(); role.Function_Name = oParentNode.ToolTip; role.Role_ID = txtRole_ID.Text; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_RolePermissionDataClass.Add(role, User_ID); } foreach (TreeNode oSubNode in oParentNode.ChildNodes) { PrintNodesRecursive(oSubNode); } }
public static bool Delete(dbo_RolePermissionClass clsdbo_RolePermission) { SqlConnection connection = SAMDataClass.GetConnection(); string deleteProcedure = "[dbo].[RolePermissionDelete]"; SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection); deleteCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_RolePermission.Role_ID != null) { deleteCommand.Parameters.AddWithValue("@OldRole_ID", clsdbo_RolePermission.Role_ID); } else { deleteCommand.Parameters.AddWithValue("@OldRole_ID", DBNull.Value); } deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); deleteCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }
private void BindTree(IEnumerable <MenuNode> list, TreeNode parentNode) { var nodes = list.Where(x => parentNode == null ? x.Parent_MenuID == -1 : x.Parent_MenuID == int.Parse(parentNode.Value)); foreach (var node in nodes) { TreeNode newNode = new TreeNode(node.Function_Name, node.MenuID.ToString()); // newNode newNode.ToolTip = node.Function_ID; if (node.Function_ID == "0000") { newNode.ShowCheckBox = false; } else { newNode.ShowCheckBox = true; } dbo_RolePermissionClass item = dbo_RolePermissionDataClass.GetRolePermissionByRole_IDAndFunctionName(txtRole_ID.Text, node.Function_ID); newNode.Checked = (item == null ? false : true); if (parentNode == null) { TreeView2.ShowLines = false; TreeView2.Nodes.Add(newNode); } else { parentNode.ChildNodes.Add(newNode); } BindTree(list, newNode); } }
public static dbo_RolePermissionClass Select_Record(dbo_RolePermissionClass clsdbo_RolePermissionPara) { dbo_RolePermissionClass clsdbo_RolePermission = new dbo_RolePermissionClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[dbo].[RolePermissionSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Role_Permission_ID", clsdbo_RolePermissionPara.Role_Permission_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_RolePermission.Role_Permission_ID = reader["Role_Permission_ID"] is DBNull ? null : reader["Role_Permission_ID"].ToString(); clsdbo_RolePermission.Role_ID = reader["Role_ID"] is DBNull ? null : reader["Role_ID"].ToString(); clsdbo_RolePermission.Function_Name = reader["Function_Name"] is DBNull ? null : reader["Function_Name"].ToString(); } else { clsdbo_RolePermission = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_RolePermission); } finally { connection.Close(); } return(clsdbo_RolePermission); }
protected void btnSave_Click(object sender, EventArgs e) { dbo_RolePermissionClass role = new dbo_RolePermissionClass(); role.Role_ID = txtRole_ID.Text; dbo_RolePermissionDataClass.Delete(role); try { TreeNode oMainNode = (TreeNode)TreeView2.Nodes[0]; PrintNodesRecursive(oMainNode); } catch (Exception ex) { logger.Error(ex.Message); } System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); // Show("บันทึกสำเร็จ"); //pnlGrid.Visible = true; //pnlForm.Visible = false; //Response.Redirect(Request.UrlReferrer.ToString()); //Response.Redirect("../Views/RolePermission.aspx"); //string script = @"swal(""บันทึกสำเร็จ!"", """", ""success"")"; //ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); string script = string.Format("alert('{0}');window.location ='RolePermission.aspx';", "บันทึกสำเร็จ"); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); pnlGrid.Visible = true; pnlForm.Visible = false; }
public static dbo_RolePermissionClass GetRolePermissionByRole_IDAndFunctionName(string Role_ID, string Function_Name) { SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "GetRolePermissionByRole_IDAndFunctionName"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(Role_ID)) { selectCommand.Parameters.AddWithValue("@Role_ID", Role_ID); } else { selectCommand.Parameters.AddWithValue("@Role_ID", DBNull.Value); } if (!string.IsNullOrEmpty(Function_Name)) { selectCommand.Parameters.AddWithValue("@Function_Name", Function_Name); } else { selectCommand.Parameters.AddWithValue("@Function_Name", DBNull.Value); } dbo_RolePermissionClass clsdbo_RolePermission = new dbo_RolePermissionClass(); List <dbo_RolePermissionClass> item = new List <dbo_RolePermissionClass>(); DataTable dt = new DataTable(); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_RolePermission.Role_Permission_ID = reader["Role_Permission_ID"] is DBNull ? null : reader["Role_Permission_ID"].ToString(); clsdbo_RolePermission.Role_ID = reader["Role_ID"] is DBNull ? null : reader["Role_ID"].ToString(); clsdbo_RolePermission.Function_Name = reader["Function_Name"] is DBNull ? null : reader["Function_Name"].ToString(); } else { clsdbo_RolePermission = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_RolePermission); } finally { connection.Close(); } return(clsdbo_RolePermission); }
public static bool Update(dbo_RolePermissionClass olddbo_RolePermissionClass, dbo_RolePermissionClass newdbo_RolePermissionClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[dbo].[RolePermissionUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_RolePermissionClass.Role_Permission_ID != null) { updateCommand.Parameters.AddWithValue("@NewRole_Permission_ID", newdbo_RolePermissionClass.Role_Permission_ID); } else { updateCommand.Parameters.AddWithValue("@NewRole_Permission_ID", DBNull.Value); } if (newdbo_RolePermissionClass.Role_ID != null) { updateCommand.Parameters.AddWithValue("@NewRole_ID", newdbo_RolePermissionClass.Role_ID); } else { updateCommand.Parameters.AddWithValue("@NewRole_ID", DBNull.Value); } if (newdbo_RolePermissionClass.Function_Name != null) { updateCommand.Parameters.AddWithValue("@NewFunction_Name", newdbo_RolePermissionClass.Function_Name); } else { updateCommand.Parameters.AddWithValue("@NewFunction_Name", DBNull.Value); } if (olddbo_RolePermissionClass.Role_Permission_ID != null) { updateCommand.Parameters.AddWithValue("@OldRole_Permission_ID", olddbo_RolePermissionClass.Role_Permission_ID); } else { updateCommand.Parameters.AddWithValue("@OldRole_Permission_ID", DBNull.Value); } if (olddbo_RolePermissionClass.Role_ID != null) { updateCommand.Parameters.AddWithValue("@OldRole_ID", olddbo_RolePermissionClass.Role_ID); } else { updateCommand.Parameters.AddWithValue("@OldRole_ID", DBNull.Value); } if (olddbo_RolePermissionClass.Function_Name != null) { updateCommand.Parameters.AddWithValue("@OldFunction_Name", olddbo_RolePermissionClass.Function_Name); } else { updateCommand.Parameters.AddWithValue("@OldFunction_Name", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }
public static bool Add(dbo_RolePermissionClass clsdbo_RolePermission, String Created_By) { SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[RolePermissionInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_RolePermission.Role_ID != null) { insertCommand.Parameters.AddWithValue("@Role_ID", clsdbo_RolePermission.Role_ID); } else { insertCommand.Parameters.AddWithValue("@Role_ID", DBNull.Value); } if (clsdbo_RolePermission.Function_Name != null) { insertCommand.Parameters.AddWithValue("@Function_Name", clsdbo_RolePermission.Function_Name); } else { insertCommand.Parameters.AddWithValue("@Function_Name", DBNull.Value); } if (Created_By != null) { insertCommand.Parameters.AddWithValue("@Created_By", Created_By); } else { insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }