/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public bitacora_gestion getObjectbitacora_gestion(System.Int32 myID)
{
bitacora_gestion mybitacora_gestion = new bitacora_gestion();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_evento,fecha,id_operadora1,id_operadora2,evento FROM bitacora_gestion WHERE (id_evento=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mybitacora_gestion.id_evento = Convert.ToInt32(myReader[0]);
mybitacora_gestion.fecha = Convert.ToDateTime(myReader[1]);
mybitacora_gestion.id_operadora1 = Convert.ToInt32(myReader[2]);
mybitacora_gestion.id_operadora2 = Convert.ToInt32(myReader[3]);
mybitacora_gestion.evento = myReader[4].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mybitacora_gestion);
}
/// <summary>
/// modify a record
/// </summary>
public void Update(bitacora_gestion mybitacora_gestion)
{
CnxBase myBase = new CnxBase();
string reqSQL = "UPDATE bitacora_gestion SET id_evento=" + mybitacora_gestion.id_evento + ",fecha='" + mybitacora_gestion.fecha + "',id_operadora1=" + mybitacora_gestion.id_operadora1 + ",id_operadora2=" + mybitacora_gestion.id_operadora2 + ",evento='" + mybitacora_gestion.evento + "' WHERE (id_evento=" + mybitacora_gestion.id_evento + ")";
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>
/// add a record
/// </summary>
/// <param name="myID"></param>
public void Insert(bitacora_gestion mybitacora_gestion, bool fecha_servidor)
{
CnxBase myBase = new CnxBase();
string reqSQL = "INSERT INTO bitacora_gestion (fecha,id_operadora1,id_operadora2,evento) VALUES ('" + (fecha_servidor ? "now" : mybitacora_gestion.fecha.ToString()) + "'," + mybitacora_gestion.id_operadora1 + "," + mybitacora_gestion.id_operadora2 + ",'" + mybitacora_gestion.evento + "')";
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));
}
}
