frequency.class.cpp

Go to the documentation of this file.

class cls_frequency
{
  public:

    string frequency_id;
    float multiplier;

    bool set_freq(string the_freq);
    string get_freq_label();
};


bool cls_frequency::set_freq(string the_freq)
{
  string s;
  s = "SELECT COUNT(*) AS EXIST_NBR from " + oConfig.tbl_prefix + "_frequencies WHERE frequency_id = '" + the_freq + "';";
   db.res = db.stmt->executeQuery(s);
  while (db.res->next())
  {
    if (db.res->getString("EXIST_NBR") == "1")
    {
      this->frequency_id = the_freq;
      return true;
    }
    else
    {
      return false;
    }
  }
  return false; // table not found ;-)
}


string cls_frequency::get_freq_label()
{
  string s;
  s = "SELECT * FROM " + oConfig.tbl_prefix + "_frequencies WHERE frequency_id = '" + this->frequency_id + "';";
   db.res = db.stmt->executeQuery(s);
  while (db.res->next())
  {
    return db.res->getString("frequency_name");
  }
  return "";
}