public static bool updateOrNewConfig(string key, string value)
{
MysqlDatas data = getValue(key);
if (!data.hasRows)
{
InsertQueryBuilder query = new InsertQueryBuilder();
query.Table = _table;
query.addValue("config_key", key);
query.addValue("config_value", value);
query.addValue("created_at", Helper.GetDatabaseDateFormat());
string cmd = query.BuildQuery();
return(Utils.Mysql.execute(cmd));
}
else
{
UpdateQueryBuilder query = new UpdateQueryBuilder();
query.Table = _table;
query.addSet("config_value", value);
query.AddWhere("config_key", Comparison.Equals, key);
string cmd = query.BuildQuery();
return(Utils.Mysql.execute(cmd));
}
return(false);
}
public static MysqlDatas getValues()
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
string cmd = query.BuildQuery();
MysqlDatas result = Utils.Mysql.query(cmd);
return(result);
}
public static MysqlDatas searchSicil(string value)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable("liste");
query.AddWhere("sicil", Comparison.Equals, value);
string cmd = query.BuildQuery();
MysqlDatas result = Mysql.query(cmd);
return(result);
}
public static MysqlDatas getValues(string value)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("value", Comparison.Like, "%" + value + "%");
string cmd = query.BuildQuery();
MysqlDatas result = Utils.Mysql.query(cmd);
return(result);
}
public static MysqlDatas getValueById(string id)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("id", Comparison.Equals, id);
string cmd = query.BuildQuery();
MysqlDatas result = Utils.Mysql.query(cmd);
return(result);
}
public static MysqlDatas getValue(string value)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("value", Comparison.Equals, value);
string cmd = query.BuildQuery();
MysqlDatas result = Mysql.query(cmd);
return(result);
}
public static MysqlDatas getUserFromSicil(string sicil)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("sicil_no", Comparison.Equals, sicil);
query.LimitClause = new LimitClause(1);
string cmd = query.BuildQuery();
MysqlDatas result = Mysql.query(cmd);
return(result);
}
public static MysqlDatas getValue(string key)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("config_key", Comparison.Equals, key);
query.LimitClause = new LimitClause(1);
string cmd = query.BuildQuery();
MysqlDatas result = Utils.Mysql.query(cmd);
return(result);
}
public static MysqlDatas getUserFromRfidWithId(string rfid, int id)
{
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.AddWhere("rfid_no", Comparison.Equals, rfid);
query.AddWhere("id", Comparison.NotEquals, id);
query.LimitClause = new LimitClause(1);
string cmd = query.BuildQuery();
MysqlDatas result = Mysql.query(cmd);
return(result);
}
public static MysqlDatas getUsers(int page)
{
int offset = page * limit;
SelectQueryBuilder query = new SelectQueryBuilder();
query.SelectFromTable(_table);
query.SelectColumns(_table + ".*", "faculties.value as facultyValue", "titles.value as titleValue");
query.AddJoin(JoinType.LeftJoin, "faculties", "id", Comparison.Equals, _table, "faculty");
query.AddJoin(JoinType.LeftJoin, "titles", "id", Comparison.Equals, _table, "title");
query.LimitClause = new LimitClause(limit, offset);
string cmd = query.BuildQuery();
MysqlDatas result = Mysql.query(cmd);
return(result);
}
