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