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) { }
}
