public static void asignarRolUsuario(int CedulaUsuario, Roles roles) { SqlConnection DataConnection = new SqlConnection(AccesoDatos._Connection); try { SqlCommand execproc = new SqlCommand("SP_ASIGNAR_ROLES", DataConnection); SqlParameter param = execproc.Parameters.Add("@pIdCedula", SqlDbType.Int); param.Value = CedulaUsuario; param = execproc.Parameters.Add("@pIdRol", SqlDbType.Int); param.Value = roles.Id; execproc.CommandType = CommandType.StoredProcedure; execproc.Connection.Open(); execproc.ExecuteReader(); execproc.Connection.Close(); } catch (Exception sqle) { } }
public static void asignarAutorizacionRol(Autorizacion Autorizacion, Roles Roles) { SqlConnection DataConnection = new SqlConnection(AccesoDatos._Connection); try { SqlCommand execproc = new SqlCommand("SP_ASIGNAR_AUTORIZACION", DataConnection); SqlParameter param = execproc.Parameters.Add("@pIdAutorizacion", SqlDbType.Int); param.Value = Autorizacion.Id; param = execproc.Parameters.Add("@pIdRol", SqlDbType.Int); param.Value = Roles.Id; execproc.CommandType = CommandType.StoredProcedure; execproc.Connection.Open(); execproc.ExecuteReader(); execproc.Connection.Close(); } catch (Exception sqle) { } }