C#

MySqlConnection sql_connection = null;
MySqlCommand sql_command = null;
MySqlDataAdapter sql_adapter;
DataTable data_table = null;
MySqlDataReader sql_reader = null;
DataSet data_set = null;

public public_class public_var = new public_class();

const int MF_BYPOSITION = 0x400;

[DllImport("User32.dll")]
private static extern int RemoveMenu(IntPtr hMenu, int nPosition, int wFlagS);

[DllImport("User32.dll")]
private static extern IntPtr GetSystemMenu(IntPtr hWnd, bool bRevert);

[DllImport("User32.dll")]
private static extern int GetMenuItemCount(IntPtr hWnd);

public delegate void ControlStringConsumer(Control control, string text);

public int result_rows;

public frmMain()
{
    InitializeComponent();
}

public void SetText(Control control, string text)
{
    control.Invoke(new ControlStringConsumer(SetTextGUI), new object[] { control, text });  // invoking another method
}

public void SetTextGUI(Control control, string text)
{
    control.Text = text;      // the "functional part", acceptable only on the main thread
}

private void perform()
{
    get_statistics_summary();
    send_sms();
}

private void get_statistics_summary()
{
    // progressRunning.Visible = true;

    // try
    // {
        // sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=shefa;integrated security=true");
        sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
        sql_connection.Open();
        sql_command = new MySqlCommand("SELECT COUNT(*) AS total_files FROM persons", sql_connection);
        sql_command.CommandType = CommandType.Text;
        sql_reader = sql_command.ExecuteReader();

        if (sql_reader.Read())
        {
            // lblTotalFiles.Text = sql_reader["total_files"].ToString();
            SetText(lblTotalFiles, sql_reader["total_files"].ToString());
        }

        sql_reader.Close();

        sql_command = new MySqlCommand("SELECT COUNT(*) AS total_appointments FROM appointments", sql_connection);
        sql_command.CommandType = CommandType.Text;
        sql_reader = sql_command.ExecuteReader();

        if (sql_reader.Read())
        {
            // lblTotalAppointments.Text = sql_reader["total_appointments"].ToString();
            SetText(lblTotalAppointments, sql_reader["total_appointments"].ToString());
        }
    /*
    }
    catch (Exception exp)
    {
        MessageBox.Show(exp.Message);
    }
    finally
    {
        if (sql_reader != null) sql_reader.Close();
        if (sql_connection != null)
        {
            if (sql_connection.State == ConnectionState.Open)
                sql_connection.Close();
        }
    }
     * */

    // progressRunning.Visible = false;
}

private void send_sms()
{
    // progressRunning.Visible = true;

    // try
    // {
        sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
        sql_connection.Open();
        sql_command = new MySqlCommand("sp_send_pending_sms", sql_connection);
        sql_command.CommandType = CommandType.StoredProcedure;
        sql_reader = sql_command.ExecuteReader();

        while (sql_reader.Read())
        {
            // lblTimer.Text = sql_reader["sms_queue_id"].ToString();
            SetText(lblTimer, sql_reader["sms_queue_id"].ToString());
        }
    /*
    }
    catch (Exception exp)
    {
        MessageBox.Show(exp.Message);
    }
    finally
    {
        if (sql_reader != null) sql_reader.Close();
        if (sql_connection != null)
        {
            if (sql_connection.State == ConnectionState.Open)
                sql_connection.Close();
        }
    }
     * */

    // progressRunning.Visible = false;
}

private void frmMain_Load(object sender, EventArgs e)
{
    this.Cursor = Cursors.WaitCursor;

    IntPtr hMenu = GetSystemMenu(this.Handle, false);
    int menuItemCount = GetMenuItemCount(hMenu);
    RemoveMenu(hMenu, menuItemCount - 1, MF_BYPOSITION);

    timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);

    // public_var.get_system_properties();
}

private void btnEmailTemplates_Click(object sender, EventArgs e)
{
    frmEmailTemplates EmailTemplatesForm = new frmEmailTemplates(public_var);
    EmailTemplatesForm.ShowDialog();
}

private void frmMain_Shown(object sender, EventArgs e)
{
    this.Cursor = Cursors.WaitCursor;

    timerMain.Start();

    this.Cursor = Cursors.Default;
}


private void timerMain_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
    // lblTimer.Text = DateTime.Now.ToString();
    backgroundWorkerSMS.RunWorkerAsync();

    // send_sms();
}

private void btnOptions_Click(object sender, EventArgs e)
{
    frmOptions OptionsForm = new frmOptions();
    DialogResult options_form = OptionsForm.ShowDialog();

    if (options_form == DialogResult.OK)
    {
        timerMain.Stop();

        timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);

        timerMain.Start();
    }
}

private void backgroundWorkerSMS_DoWork(object sender, DoWorkEventArgs e)
{
    perform();
}

private void backgroundWorkerSMS_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
    backgroundWorkerSMS.Dispose();
}
</pre>