public BindableCollection<AccModulo> ListarAccModulo()
{
BindableCollection<AccModulo> lstModulo = new BindableCollection<AccModulo>();
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "SELECT * FROM AccModulo ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
AccModulo m = new AccModulo();
m.IdAccModulo = Int32.Parse("" + reader["idAccModulo"]);
m.Nombre = reader["nombre"].ToString();
m.Estado = Int32.Parse("" + reader["estado"]);
Trace.Write("MODULO");
Trace.Write("<<" + m.IdAccModulo + ">>");
Trace.Write("<<" + m.Nombre + ">>");
Trace.Write("<<" + m.Estado + ">>");
lstModulo.Add(m);
}
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return lstModulo;
}
public AccModulo BuscarModuloPorId(int idAccModulo)
{
AccModulo am = null;
SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "SELECT * FROM AccModulo WHERE idAccModulo=@idAccModulo";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@idAccModulo", idAccModulo);
Trace.WriteLine("<Flag: ");
try
{
conn.Open();
reader = cmd.ExecuteReader();
if (reader.Read())
{
am = new AccModulo();
am.IdAccModulo = Int32.Parse(reader["idAccModulo"].ToString());
am.Nombre = reader["nombre"].ToString();
am.Estado = Int32.Parse(reader["estado"].ToString());
}
else
{
conn.Close();
}
}
catch (Exception e)
{
MessageBox.Show(e.StackTrace.ToString());
}
return am;
}