public static void removeUser(string password)
{
using (NpgsqlConnection con = new NpgsqlConnection(DBConnection.connString))
{
using (NpgsqlCommand command = new NpgsqlCommand())
{
try
{
verifyUser(nickName, password);
con.Open();
var transaction = con.BeginTransaction();
command.Connection = con;
command.Transaction = transaction;
command.CommandText = string.Concat("DELETE FROM users WHERE (id = '", id, "');");
command.ExecuteNonQuery();
command.CommandText = string.Concat("DELETE FROM passwords WHERE (user_id = '", id, "');");
command.ExecuteNonQuery();
nickName = null;
id = null;
instance = null;
transaction.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
}
}
public static void removeIngredient(string name)
{
using (NpgsqlConnection con = new NpgsqlConnection(DBConnection.connString))
{
using (NpgsqlCommand command = new NpgsqlCommand())
{
try
{
con.Open();
var transaction = con.BeginTransaction();
command.Connection = con;
command.Transaction = transaction;
command.CommandText = string.Concat("DELETE FROM ingredients WHERE (name = '", name, "' AND user_id = '", id, "');");
command.ExecuteNonQuery();
nickName = null;
id = null;
instance = null;
transaction.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
}
}
public dbRequestsHandler createInstance(string name, string password)
{
verifyUser(name, password);
if (instance == null)
{
instance = new dbRequestsHandler(name);
return(instance);
}
else
{
return(instance);
}
}