public bool hasBeenDeletedServer(Dictionary <string, object> datos, string condition) { 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); try { List <Dictionary <string, object> > select = db.SelectListDictionary(datos["column_type"].ToString(), "data_id = " + datos["ID_data"] + " AND data " + condition + ";"); bool exist = false; if (select.Count > 0) { exist = true; } /*if (exist) * { * db.NonQuery("DELETE FROM " + datos["column_type"].ToString() + " WHERE data_id = '" + datos["ID_data"].ToString() + "';"); * }*/ return(exist); } catch { return(false); } }
public List <Dictionary <string, object> > executeQueryServer(Dictionary <string, object> datos, string condition) { 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); return(db.SelectListDictionary(datos["column_type"].ToString(), "data_id = " + datos["ID_data"] + condition + ";")); }
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); } }