Maintenance.aspx.cs

using MySqlConnector;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Linq;

namespace System.pages
{
    public partial class Maintenance : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                panelConfirmDelete.Visible = false;
            }
            else
            {
                string action = Request["hiddenPostbackAction"] + "";
                if (action == "dropAllTables")
                {
                    DropTables();
                }
            }
        }

        void DeleteDatabase(bool delete)
        {
            System.Text.StringBuilder sb = new System.Text.StringBuilder();

            if (delete)
                sb.AppendLine("The following databases were deleted...");
            else
                sb.AppendLine("The following databases are pending for deletion...");

            sb.AppendLine();

            using (MySqlConnection conn = config.GetNewConnection())
            {
                conn.Open();
                using (var cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SHOW DATABASES LIKE 'test%';";
                    using (var reader = cmd.ExecuteReader())
                    {
                        List<string> databases = new List<string>();
                        while (reader.Read())
                        {
                            string dbName = reader.GetString(0);
                            databases.Add(dbName);
                            sb.AppendLine(dbName);
                        }

                        reader.Close();

                        if (delete)
                        {
                            using (var dropCmd = conn.CreateCommand())
                            {
                                foreach (var dbName in databases)
                                {
                                    dropCmd.CommandText = $"DROP DATABASE `{dbName}`;";
                                    dropCmd.ExecuteNonQuery();

                                }
                            }
                        }
                    }
                }
            }

            ph1.Controls.Add(new LiteralControl(sb.ToString()));
        }

        protected void btDeleteTestDatabase_Click(object sender, EventArgs e)
        {
            panelButton.Visible = false;
            panelConfirmDelete.Visible = true;
            DeleteDatabase(false);
        }

        protected void btDeleteTempDumpFiles_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendLine("The following files were deleted:");
            sb.AppendLine();

            string folder = Server.MapPath("~/App_Data/temp");
            System.IO.Directory.CreateDirectory(folder);

            foreach (var file in Directory.EnumerateFiles(folder))
            {
                try
                {
                    File.Delete(file);
                    sb.AppendLine(file);
                }
                catch (Exception ex)
                {
                    sb.AppendLine($"Failed to delete: {file}");
                    sb.AppendLine(ex.Message);
                }
            }

            ph1.Controls.Add(new LiteralControl(sb.ToString()));
        }

        protected void btDeleteTaskReport_Click(object sender, EventArgs e)
        {
            using (SQLiteConnection conn = new SQLiteConnection(BackupFilesManager.sqliteConnectionString))
            {
                using (var cmd = conn.CreateCommand())
                {
                    conn.Open();

                    cmd.CommandText = "delete from progress_report;";
                    cmd.ExecuteNonQuery();
                }
            }

            ((masterPage1)this.Master).ShowMessage("Done", "All task reports deleted", true);
        }

        protected void DropTables()
        {
            try
            {
                StringBuilder sb = new StringBuilder();
                sb.AppendLine("The following tables were dropped:");
                sb.AppendLine();

                using (MySqlConnection conn = config.GetNewConnection())
                {
                    using (var cmd = conn.CreateCommand())
                    {
                        conn.Open();

                        DataTable dtTable = QueryExpress.GetTable(cmd, "show tables");

                        foreach (DataRow dr in dtTable.Rows)
                        {
                            try
                            {
                                string tableName = dr[0] + "";
                                cmd.CommandText = $"DROP TABLE IF EXISTS `{QueryExpress.EscapeIdentifier(tableName)}`";
                                cmd.ExecuteNonQuery();

                                sb.AppendLine(tableName);
                            }
                            catch { }
                        }
                    }
                }

                ph1.Controls.Add(new LiteralControl(sb.ToString()));
                ((masterPage1)this.Master).ShowMessage("Done", "All task reports deleted", true);
            }
            catch (Exception ex)
            {
                ph1.Controls.Add(new LiteralControl($@"Error:<br />{ex.Message}<br />{ex.StackTrace}"));
            }
        }

        protected void btDeleteDatabaseYes_Click(object sender, EventArgs e)
        {
            panelButton.Visible = true;
            panelConfirmDelete.Visible = false;
            DeleteDatabase(true);
        }

        protected void btDeleteDatabaseNo_Click(object sender, EventArgs e)
        {
            panelButton.Visible = true;
            panelConfirmDelete.Visible = false;
        }
    }
}