public bool deleteCarrito(ENCarrito en)
{
SqlConnection conn = null;
String comando = "Delete from Carrito where Id = '" + en.Id + "'";
try
{
conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = new SqlCommand(comando, conn);
cmd.ExecuteNonQuery();
}
catch (SqlException sqlex)
{
throw sqlex;
}
finally
{
if (conn != null)
{
conn.Close(); // Se asegura de cerrar la conexión.
}
}
return(true);
}
public bool createCarrito(ENCarrito en)
{
SqlConnection conn = null;
String comando = "Insert into Carrito(Id) VALUES ('" + en.Id + "')";
try
{
conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = new SqlCommand(comando, conn);
cmd.ExecuteNonQuery();
}
catch (SqlException sqlex)
{
throw sqlex;
}
finally
{
if (conn != null)
{
conn.Close(); // Se asegura de cerrar la conexión.
}
}
return(true);
}
public bool updateCarrito2(ENCarrito en)
{
SqlConnection conn = null;
String comando = "Select * from Menu where pedido = '" + 1 + "'";
try
{
conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = new SqlCommand(comando, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
en.Nombre = en.Nombre + " " + dr.GetString(1) + " " + dr.GetDouble(2) + "€ ";
en.CosteTotal = en.CosteTotal + dr.GetDouble(2);
}
}
else
{
Console.WriteLine("No rows found.");
}
dr.Close();
}
catch (SqlException sqlex)
{
throw sqlex;
}
finally
{
if (conn != null)
{
conn.Close(); // Se asegura de cerrar la conexión.
}
}
return(true);
}
public bool readCarrito(ENCarrito en)
{
SqlConnection conn = null;
String comando = "Select * from Carrito where Id = '" + en.Id + "'";
try
{
conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = new SqlCommand(comando, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//mostrar los productos del carrito?
}
else
{
Console.WriteLine("No rows found.");
}
dr.Close();
}
catch (SqlException sqlex)
{
throw sqlex;
}
finally
{
if (conn != null)
{
conn.Close(); // Se asegura de cerrar la conexión.
}
}
return(true);
}