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