/// <summary> /// get an instance of object /// </summary> /// <param name="myID"></param> public k_areas getObjectk_areas(System.Int32 myID) { k_areas myk_areas = new k_areas(); CnxBase myBase = new CnxBase(); string reqSQL = "SELECT gid,id_area,count,geom FROM k_areas WHERE (id_area=" + myID + ")"; try { NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString); NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn); NpgsqlDataReader myReader = myCommand.ExecuteReader(); if (myReader.Read()) { myk_areas.gid = Convert.ToInt32(myReader[0]); myk_areas.id_area = Convert.ToInt32(myReader[1]); myk_areas.count = Convert.ToInt64(myReader[2]); myk_areas.the_geom = myReader[3].ToString(); } myBase.CloseConnection(myConn); } catch (Exception myErr) { throw(new Exception(myErr.ToString() + reqSQL)); } return(myk_areas); }
/// <summary> /// modify a record /// </summary> public void Update(k_areas myk_areas) { CnxBase myBase = new CnxBase(); string reqSQL = "UPDATE k_areas SET gid=" + myk_areas.gid + ",id_area=" + myk_areas.id_area + ",count=" + myk_areas.count + ",geom='" + myk_areas.the_geom + "' WHERE (id_area=" + myk_areas.id_area + ")"; 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(k_areas myk_areas) { CnxBase myBase = new CnxBase(); string reqSQL = "INSERT INTO k_areas (gid,id_area,count,geom) VALUES (" + myk_areas.gid + "," + myk_areas.id_area + "," + myk_areas.count + ",'" + myk_areas.the_geom + "')"; 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)); } }