/// <summary> /// get an instance of object /// </summary> /// <param name="myID"></param> public s_rescate_urbano getObjects_rescate_urbano(System.Int32 myID) { s_rescate_urbano mys_rescate_urbano = new s_rescate_urbano(); CnxBase myBase = new CnxBase(); string reqSQL = "SELECT id_especialidad,id_sector,prioridad,contacto,id_central FROM s_rescate_urbano WHERE (id_especialidad=" + myID + ")"; try { NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString); NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn); NpgsqlDataReader myReader = myCommand.ExecuteReader(); if (myReader.Read()) { mys_rescate_urbano.id_especialidad = Convert.ToInt32(myReader[0]); mys_rescate_urbano.id_sector = Convert.ToInt32(myReader[1]); mys_rescate_urbano.prioridad = Convert.ToInt32(myReader[2]); mys_rescate_urbano.contacto = myReader[3].ToString(); mys_rescate_urbano.id_central = Convert.ToInt32(myReader[4]); } myBase.CloseConnection(myConn); } catch (Exception myErr) { throw(new Exception(myErr.ToString() + reqSQL)); } return(mys_rescate_urbano); }
/// <summary> /// modify a record /// </summary> public void modifys_rescate_urbano(s_rescate_urbano mys_rescate_urbano) { CnxBase myBase = new CnxBase(); string reqSQL = "UPDATE s_rescate_urbano SET id_especialidad=" + mys_rescate_urbano.id_especialidad + ",id_sector=" + mys_rescate_urbano.id_sector + ",prioridad=" + mys_rescate_urbano.prioridad + ",contacto='" + mys_rescate_urbano.contacto + "',id_central=" + mys_rescate_urbano.id_central + " WHERE (id_especialidad=" + mys_rescate_urbano.id_especialidad + ")"; 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 adds_rescate_urbano(s_rescate_urbano mys_rescate_urbano) { CnxBase myBase = new CnxBase(); string reqSQL = "INSERT INTO s_rescate_urbano (id_especialidad,id_sector,prioridad,contacto, id_central) VALUES (" + mys_rescate_urbano.id_especialidad + "," + mys_rescate_urbano.id_sector + "," + mys_rescate_urbano.prioridad + ",'" + mys_rescate_urbano.contacto + "'," + mys_rescate_urbano.id_central + ")"; 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)); } }