using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Action_Tire_Payment_Processor
{
    public static class Database
    {
        public static SqlConnection sql = null;
        public static string ConnectionString = "";

        public static void Init()
        {
            MaintainTables();
            SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
            csb.DataSource = Settings.GetOption("DBSERVER");
            csb.InitialCatalog = Settings.GetOption("DBNAME");
            try
            {
                csb.IntegratedSecurity = bool.Parse(Settings.GetOption("DBWINDOWS"));
            }
            catch
            {
                csb.IntegratedSecurity = false;
            }
            if (!csb.IntegratedSecurity)
            {
                csb.UserID = Settings.GetOption("DBUSER");
                csb.Password = Settings.GetOption("DBPASSWORD");
            }

            ConnectionString = csb.ConnectionString;
            sql = new SqlConnection(csb.ConnectionString);
        }

        public static void Open()
        {
            Close();

            try
            {
                sql.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Unable to open database connection: " + ex.Message);
            }
        }

        public static void Close()
        {
            try
            {
                sql.Close();
            }
            catch
            {

            }
        }

        public static DataTable Query(SqlCommand cmd)
        {
            Open();
            SqlDataReader reader = cmd.ExecuteReader();
            DataTable results = new DataTable();
            results.Load(reader);
            cmd.Dispose();
            Close();

            return results;
        }

        public static void NonQuery(SqlCommand cmd)
        {
            Open();
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            Close();
        }

        public static void MaintainTables()
        {
            
        }
    }
}