using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Data;
using System.Windows.Forms;

namespace AplikacijaZaVodjenjeTeretane
{
    public class db
    {
        MySqlConnection connection = new MySqlConnection("datasource=sql8.freemysqlhosting.net;port=3306;Database=sql8123501;username=sql8123501;password=Rc4bDHr1Ej");
        MySqlCommand command;
        MySqlDataReader dataReader;

        //metoda za otvaranje konekcije prema bazi
        public void openConnection()
        {
            if (connection.State == ConnectionState.Closed)
            {
                connection.Open();
            }
        }

        //metoda za zatvaranje konekcije
        public void closeConnection()
        {
            if (connection.State == ConnectionState.Open)
            {
                connection.Close();
            }
        }

        //izvršavanje INSERT, UPDATE i DELETE naredbi
        public void ExecuteQuery(string upit)
        {
            try
            {
                openConnection();
                command = new MySqlCommand(upit, connection);
                if (command.ExecuteNonQuery() == 1)
                {
                    //MessageBox.Show("Upit je izvršen.");
                }
                else
                {
                    //MessageBox.Show("Upit nije izvršen.");
                }

            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.Message);
            }
        }

        //vraćanje podataka SELECT upita
        public MySqlDataReader SelectQuery(string upit)
        {


            openConnection();
            command = new MySqlCommand(upit, connection);
            dataReader = command.ExecuteReader();
            return dataReader;

            //return command.ExecuteReader();
        }
    }
}