public static void EliminarDir(int idDir)
{
string sql = String.Format("DELETE FROM ADDRESS WHERE idAddress = {0};", idDir);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void EliminarProd(int idProd)
{
string sql = String.Format("DELETE FROM PRODUCT WHERE idProduct = {0};", idProd);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void EliminarOrder(int idOrder)
{
string sql = String.Format("DELETE FROM apporder WHERE idorder = '{0}';", idOrder);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void EliminarUser(string username)
{
string sql = String.Format("DELETE FROM appuser WHERE username = '******';", username);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void UpdatePass(string newPass, AppUser user)
{
string sql = String.Format("UPDATE appuser SET password = '******' WHERE idUser = {1};", newPass, user.idUser);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void EliminarBus(int id)
{
string sql = String.Format("DELETE FROM business WHERE idBusiness = '{0}';", id);
ConnectionDB.ExecuteNonQuery(sql);
}