public z_guardia getObjectz_guardia(string myID)
{
z_guardia myz_guardia = new z_guardia();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_guardia,tipo_oficial,oficial,responsabilidades,mostrar FROM z_guardia WHERE (tipo_oficial='" + myID + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_guardia.id_guardia = Convert.ToInt32(myReader[0]);
myz_guardia.tipo_oficial = myReader[1].ToString();
myz_guardia.oficial = myReader[2].ToString();
myz_guardia.responsabilidades = myReader[3].ToString();
myz_guardia.mostrar = Convert.ToBoolean(myReader[4]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_guardia);
}
/// <summary>
/// modify a record
/// </summary>
public void modifyz_guardia(z_guardia myz_guardia)
{
CnxBase myBase = new CnxBase();
string reqSQL = "UPDATE z_guardia SET id_guardia=" + myz_guardia.id_guardia + ",tipo_oficial='" + myz_guardia.tipo_oficial + "',oficial='" + myz_guardia.oficial + "',responsabilidades='" + myz_guardia.responsabilidades + "',mostrar=" + myz_guardia.mostrar + " WHERE (id_guardia=" + myz_guardia.id_guardia + ")";
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 addz_guardia(z_guardia myz_guardia)
{
CnxBase myBase = new CnxBase();
string reqSQL = "INSERT INTO z_guardia (tipo_oficial,oficial,responsabilidades,mostrar) VALUES ('" + myz_guardia.tipo_oficial + "','" + myz_guardia.oficial + "','" + myz_guardia.responsabilidades + "','" + myz_guardia.mostrar + "')";
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));
}
}
