//ACTUALIZAR:
public static int actualizarRol(Rol r)
{
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
int k = 0;
cmd.CommandText = "UPDATE Rol " +
"SET nombre= @nombre, descripcion= @descripcion" +
" WHERE idRol= @idRol ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@nombre", r.Nombre);
cmd.Parameters.AddWithValue("@descripcion", r.Descripcion);
cmd.Parameters.AddWithValue("@idRol", r.IdRol);
try
{
conn.Open();
k = cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return k;
}
public static Rol buscarRolPorId(int idRol)
{
Rol r = null;
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "SELECT * FROM Rol WHERE idRol=@idRol ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@idRol", idRol);
try
{
conn.Open();
reader = cmd.ExecuteReader();
if (reader.Read())
{
r = new Rol();
r.IdRol = Int32.Parse(reader["idRol"].ToString());
r.Nombre = reader["nombre"].ToString();
r.Estado = Int32.Parse(reader["estado"].ToString());
r.Descripcion = reader["descripcion"].ToString();
}
else
{
conn.Close();
}
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return r;
}
public BindableCollection<Rol> ListarRol()
{
BindableCollection<Rol> lstRol = new BindableCollection<Rol>();
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "SELECT * FROM Rol ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
Rol r = new Rol();
r.IdRol = Int32.Parse("" + reader["idRol"]);
r.Nombre = reader["nombre"].ToString();
r.Descripcion = reader["descripcion"].ToString();
r.Estado = Int32.Parse("" + reader["estado"]);
if (r.Estado == 1)
lstRol.Add(r);
}
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return lstRol;
}
//INSERTAR:
public static int insertarRol(Rol r)
{
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
int k = 0;
cmd.CommandText = "INSERT INTO Rol(nombre,descripcion,estado) " +
"VALUES (@nombre,@descripcion,@estado)";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@nombre", r.Nombre);
cmd.Parameters.AddWithValue("@descripcion", r.Descripcion);
cmd.Parameters.AddWithValue("@estado", r.Estado);
try
{
conn.Open();
k = cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return k;
}
//ELIMINAR:
public static int eliminarRol(Rol r)
{
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
int k = 0;
cmd.CommandText = "UPDATE Rol " +
"SET estado= @estado" +
" WHERE idRol= @idRol ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@estado", 0); //0: Eliminado Lógico
cmd.Parameters.AddWithValue("@idRol", r.IdRol);
try
{
conn.Open();
k = cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return k;
}