public IEnumerable <Estatus> ObtenerEstatus()
{
List <Estatus> lstEstatus = new List <Estatus>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("ESTATUS_SELECT", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Estatus estatus = new Estatus();
estatus.ID = Convert.ToInt32(rdr["Id"]);
estatus.Estado = Convert.ToString(rdr["Estatus"]);
lstEstatus.Add(estatus);
}
con.Close();
}
return(lstEstatus);
}
public Estatus ObtenerEstatus(int id)
{
Estatus estatus = new Estatus();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("ESTATUS_SELECT", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
estatus.ID = Convert.ToInt32(rdr["Id"]);
estatus.Estado = Convert.ToString(rdr["Estatus"]);
con.Close();
}
return(estatus);
}
