/// <summary> /// get an instance of object /// </summary> /// <param name="myID"></param> public dh_herramientas_carros getObject(int id_herramienta_carro) { dh_herramientas_carros dh_herramcarro = new dh_herramientas_carros(); CnxBase myBase = new CnxBase(); string reqSQL = "SELECT id_herramienta_carro, id_herramienta,id_carro,cantidad FROM dh_herramientas_carros WHERE (id_herramienta_carro=" + id_herramienta_carro + ")"; try { NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString); NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn); NpgsqlDataReader myReader = myCommand.ExecuteReader(); if (myReader.Read()) { dh_herramcarro.id_herramienta_carro = Convert.ToInt32(myReader[0]); dh_herramcarro.id_herramienta = Convert.ToInt32(myReader[1]); dh_herramcarro.id_carro = Convert.ToInt32(myReader[2]); dh_herramcarro.cantidad = Convert.ToInt32(myReader[3]); } myBase.CloseConnection(myConn); } catch (Exception myErr) { throw (new Exception(myErr.ToString() + reqSQL)); } return(dh_herramcarro); }
/// <summary> /// add a record /// </summary> /// <param name="myID"></param> public void Insert(dh_herramientas_carros mydh_herramcarro) { CnxBase myBase = new CnxBase(); string reqSQL = "INSERT INTO dh_herramientas_carros (id_herramienta, id_carro, cantidad) VALUES (" + mydh_herramcarro.id_herramienta + "," + mydh_herramcarro.id_carro + "," + mydh_herramcarro.cantidad + ")"; try { NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString); NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn); myCommand.ExecuteNonQuery(); myBase.CloseConnection(myConn); } catch (Exception myErr) { throw (new Exception(myErr.ToString() + reqSQL)); } }
/// <summary> /// modify a record /// </summary> public void Update(dh_herramientas_carros mydh_herramcarro) { CnxBase myBase = new CnxBase(); string reqSQL = "UPDATE dh_herramientas_carros SET id_carro=" + mydh_herramcarro.id_carro + ",cantidad=" + mydh_herramcarro.cantidad + " WHERE (id_herramienta_carro=" + mydh_herramcarro.id_herramienta_carro + ")"; try { NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString); NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn); myCommand.ExecuteNonQuery(); myBase.CloseConnection(myConn); } catch (Exception myErr) { throw (new Exception(myErr.ToString() + reqSQL)); } }