public bool runVSM_DB(string data, string id, int tf) { string idTerm; this.con = new koneksi(); con.openConnection(); string cek_KesediaanTerm = "SELECT * FROM public.\"Term\" where \"Term\"='" + data + "';"; DataTable result = this.con.getResult(cek_KesediaanTerm); con.stopAccess(); if (result.Rows.Count == 0) { //simpan Term baru con.openConnection(); this.con = new koneksi(); string queryTerm = "INSERT INTO public.\"Term\"(\"Term\", \"DF\") VALUES ('" + data + "','1');"; con.excequteQuery(queryTerm); con.stopAccess(); con.closeConnection(); //baca idTermnya idTerm = cariID_Term(data); insert_ToBobot(id, idTerm, tf); con.stopAccess(); con.closeConnection(); } else // ketika sama { //baca idTermnya idTerm = cariID_Term(data); //update nilai df kata-n int dfBefore = Convert.ToInt32(getValueDF(data)); int data_update = (dfBefore + 1); updateDF(data, Convert.ToString(data_update)); insert_ToBobot(id, idTerm, tf); con.stopAccess(); } //simpan dokument return(true); }
public bool getKataSambung(string kata) { this.con = new koneksi(); string query = "SELECT kata FROM public.kata_sambung where kata = '" + kata + "'"; DataTable result = this.con.getResult(query); con.closeConnection(); if (result.Rows.Count == 1) { return(true); } else { return(false); } }
public double cekKetersediaan_Term(string kata) { koneksi con = new koneksi(); con.openConnection(); string query = "SELECT \"Term\" FROM public.\"Term\" where \"Term\"='" + kata + "';"; DataTable result = con.getResult(query); con.closeConnection(); if (result.Rows.Count >= 1) { con.openConnection(); double getIDF_Term = 0; string QgetDF_Term = "SELECT \"IDF\" FROM public.\"Term\" where \"Term\"='" + kata + "';"; DataTable result2 = con.getResult(QgetDF_Term); getIDF_Term = Convert.ToDouble(result2.Rows[0]["IDF"]); con.stopAccess(); return(getIDF_Term); } else { return(0); } }