public static bool runDelete(string tabla, string llave, long valorLlave)
{
string query = string.Format("UPDATE `{0}` SET estado=0 WHERE {1}='{2}'", tabla, llave, valorLlave);
var comm = new SqlCommand(query, DatabaseChecado._conn);
try
{
DatabaseChecado._conn.Open();
Console.WriteLine(query);
comm.ExecuteNonQuery();
DatabaseChecado._conn.Close();
return(true);
}
catch (Exception e)
{
DatabaseChecado.ManageException(e);
return(false);
}
}
public static bool runQuery(string query)
{
query = query.Replace("\n", "");
query = query.Replace("'", "\'");
var comm = new SqlCommand(query, DatabaseChecado._conn);
try
{
DatabaseChecado._conn.Open();
Console.WriteLine(query);
comm.ExecuteNonQuery();
DatabaseChecado._conn.Close();
return(true);
}
catch (Exception e)
{
DatabaseChecado.ManageException(e);
return(false);
}
}
public static string runSelectQueryEspecial(string query)
{
try
{
query = query.Replace("\n", "");
Console.WriteLine(query);
DataTable tablaSelect = new DataTable();
string sql = query;
var comm = new SqlCommand(sql, DatabaseChecado._conn);
DatabaseChecado._conn.Open();
DatabaseChecado.adapt = new SqlDataAdapter(comm);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(DatabaseChecado.adapt);
DatabaseChecado.tablaBusqueda = new DataTable();
DatabaseChecado.adapt.Fill(tablaSelect);
DatabaseChecado._conn.Close();
if (tablaSelect == null)
{
return(null);
}
else if (tablaSelect.Rows.Count < 1)
{
return(null);
}
return("Correcto");
}
catch (Exception e)
{
DatabaseChecado.ManageException(e);
return(e.ToString());
}
}
