public string mantenerTelevision(TelevisionCE aut, string accion)
//public string mantenerAuto(Autos aut)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_mantenimientotelevision";
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@modelo", SqlDbType.VarChar, 15).Value = aut.getModelo();
cmd.Parameters.Add("@idprov", SqlDbType.Char, 11).Value = aut.getIdprov();
cmd.Parameters.Add("@codtip", SqlDbType.VarChar, 6).Value = aut.getCodtip();
cmd.Parameters.Add("@codcat", SqlDbType.VarChar, 3).Value = aut.getCodcat();
cmd.Parameters.Add("@resolucion", SqlDbType.VarChar, 10).Value = aut.getResolucion();
cmd.Parameters.Add("@tamaño", SqlDbType.Char, 3).Value = aut.getTamaño();
cmd.Parameters.Add("@caracteristica", SqlDbType.VarChar, 200).Value = aut.getCaracteristica();
cmd.Parameters.Add("@precio", SqlDbType.Decimal).Value = aut.getPrecio();
cmd.Parameters.Add("@stock", SqlDbType.Int).Value = aut.getStock();
cmd.Parameters.Add("@img", SqlDbType.VarChar, 200).Value = aut.getImg();
cmd.Parameters.Add("@accion", SqlDbType.Char, 1).Value = accion;
try
{
cn.Open();
cmd.ExecuteNonQuery();
return("exito");
}
catch (Exception e)
{
return("Error" + e.ToString());
}
finally
{
cmd.Dispose();
cn.Close();
}
//SqlCommand cmd = new SqlCommand();
//cmd.CommandText = "registrarimagen";
//cmd.Connection = cn;
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@stock", SqlDbType.Int).Value = aut.getStock();
//cmd.Parameters.Add("@url", SqlDbType.VarChar, 200).Value = aut.getUrl();
//try
//{
// cn.Open();
// cmd.ExecuteNonQuery();
// return "exito";
//}
//catch (Exception e)
//{
// return "Error" + e.ToString();
//}
//finally
//{
// cmd.Dispose();
// cn.Close();
//}
}
public string mantenerTelevision(TelevisionCE aut, string accion)
{
return(televisioncd.mantenerTelevision(aut, accion));
}
