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)); }