/// <summary>
/// add a record
/// </summary>
/// <param name="myID"></param>
public void Insert(d_departamento myd_departamento)
{
CnxBase myBase = new CnxBase();
string reqSQL = "INSERT INTO d_departamento (nombre) VALUES ('" + myd_departamento.nombre + "')";
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(d_departamento myd_departamento)
{
CnxBase myBase = new CnxBase();
string reqSQL = "UPDATE d_departamento SET id_departamento=" + myd_departamento.id_departamento + ",nombre='" + myd_departamento.nombre + "' WHERE (id_departamento=" + myd_departamento.id_departamento + ")";
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>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public d_departamento getObjectd_departamento(System.Int32 myID)
{
d_departamento myd_departamento = new d_departamento();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_departamento,nombre FROM d_departamento WHERE (id_departamento=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myd_departamento.id_departamento = Convert.ToInt32(myReader[0]);
myd_departamento.nombre = myReader[1].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myd_departamento);
}
