using System;
using MySql.Data.MySqlClient;
//Summary
//Check if a payment has been made successful. This give a bool to the Frontend to avoid double payment
//Summary

public static class PaymentChecker
{

    public static bool CheckLocalPaymentStatus(string infringement, MySqlConnection con)
    {
        MySqlDataReader reader = null;
        string result = "NO";
        string statement = $"Select intPaid FROM infringement WHERE strInfringementNumber = '{infringement}'";

        try
        {
            using var cmd = new MySqlCommand();
            cmd.Connection = con;
            cmd.CommandText = statement;
            cmd.ExecuteNonQuery();

            reader = cmd.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    result = reader["intPaid"].ToString();
                    if (string.Equals("YES", result))
                    {
                        reader.Close();
                        return false;
                    }
                }
                reader.Close();
                return true;
            }
            else
            {
                reader.Close();
                return true;
            }
        }
        catch (Exception)
        {
            return false;
        }
        finally
        {
            if (reader != null) reader.Close();
        }
    }
}