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