//To View all employees details
public IEnumerable <Zapatos> ListarZapatos()
{
List <Zapatos> ListaZapatos = new List <Zapatos>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Zapatos", con);
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Zapatos oZapatos = new Zapatos()
{
ID = Convert.ToInt32(rdr["ID"]),
genero = rdr["genero"].ToString(),
modelo = rdr["modelo"].ToString(),
img = rdr["img"].ToString(),
talla = Convert.ToInt32(rdr["talla"])
};
ListaZapatos.Add(oZapatos);
}
con.Close();
}
return(ListaZapatos);
}
//To Update the records of a particluar employee
public void ModificarEmpleados(Zapatos oZapatos)
{
}
//To Add new employee record
public void AgregarEmpleados(Zapatos oZapatos)
{
}