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