using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace VIS_Desktop.DTO
{
    class HodnostiDataMapper
    {
        private const String CONNECTION_STRING = "";

        public static Hodnosti GetHodnostiByID(int hid)
        {
            using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
            {
                connection.Open();

                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandType = System.Data.CommandType.Text;
                    command.CommandText = "SELECT TOP 1 * FROM [Hodnosti] WHERE [hid] = @ID";
                    command.Parameters.AddWithValue("@ID", hid);

                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        reader.Read();

                        string Nazev = (string)reader["Nazev"];
                        int MinVek = (int)reader["MinVek"];
                        return new Hodnosti(hid, Nazev, MinVek);


                    }
                }
            }
            return null;
        }

        //INSERT OR UPDATE
        public void Save(Hodnosti hodnosti)
        {
            using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
            {
                connection.Open();

                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandType = System.Data.CommandType.Text;
                    command.CommandText = "SELECT TOP 1 * FROM [Hodnosti] WHERE [hid] = @ID";
                    command.Parameters.AddWithValue("@ID", hodnosti.hid);

                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        command.CommandText = "UPDATE [Hodnosti] SET [Nazev] = @Nazev, [MinVek] = @MinVek WHERE [hid] = @hid";
                    }
                    else
                    {
                        command.CommandText = "INSERT INTO [Hodnosti] (hid, Nazev, MinVek) VALUES (@hid, @Nazev, @MinVek)";
                    }
                    command.Parameters.AddWithValue("@hid", hodnosti.hid);
                    command.Parameters.AddWithValue("@Nazev", hodnosti.Nazev);
                    command.Parameters.AddWithValue("@MinVek", hodnosti.MinVek);

                    command.ExecuteNonQuery();
                }
            }
        }

        //REMOVE FROM
        public void Delete(Hodnosti hodnosti)
        {
            using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
            {
                connection.Open();

                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandType = System.Data.CommandType.Text;
                    command.CommandText = "DELETE FROM [Hodnoti] WHERE ID = @ID";
                    command.Parameters.AddWithValue("@ID", hodnosti.hid);

                    command.ExecuteNonQuery();
                }
            }
        }
    }
}