public bool updateQueryServer(Dictionary <string, object> datos, string condition, string value) { string server = datos["server"].ToString(); string database = "multidb_datos"; string uid = datos["user"].ToString(); string pass = datos["pass"].ToString(); string port = datos["port"].ToString(); ServerConnect db = new ServerConnect(server, database, uid, pass, port); //update string set data = 'holi' WHERE data_id = 1 AND data = 'pi'; db.NonQuery("UPDATE " + datos["column_type"].ToString() + " SET data = '" + value + "' WHERE data_id = " + datos["ID_data"] + " AND data " + condition + ";"); return(true); }
public bool insertServer(Dictionary <string, object> conexion, object dato, int data_id) { string server = conexion["server"].ToString(); string database = "multidb_datos"; string uid = conexion["user"].ToString(); string pass = conexion["pass"].ToString(); string port = conexion["port"].ToString(); ServerConnect db = new ServerConnect(server, database, uid, pass, port); try { db.NonQuery("INSERT INTO " + conexion["columna"] + "(data_id, data) VALUES ('" + data_id + "', '" + dato.ToString() + "');"); return(true); } catch { return(false); } }
public bool deleteDataServer(Dictionary <string, object> datos) { string server = datos["server"].ToString(); string database = "multidb_datos"; string uid = datos["user"].ToString(); string pass = datos["pass"].ToString(); string port = datos["port"].ToString(); ServerConnect db = new ServerConnect(server, database, uid, pass, port); Debug.WriteLine("DELETE FROM " + datos["column_type"].ToString() + " WHERE data_id = '" + datos["ID_data"].ToString() + "';"); try { db.NonQuery("DELETE FROM " + datos["column_type"].ToString() + " WHERE data_id = '" + datos["ID_data"].ToString() + "';"); return(true); } catch { return(false); } }