using SF_52_2018.Enumeracije;
using SF_52_2018.Fakultet;
using SF_52_2018.Model;
using SF_52_2018.Zaposleni;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SF_52_2018.Util
{
    public class Data
    {
       public static List<Korisnik> Korisnici { get; set; }
        public static List<Ustanova> Ustanove { get; private set; }
        public static List<Ucionica> Ucionice { get; private set; }
        //
        public static String CONNECTION_STRING = @"DESKTOP-RIBO916\SQLEXPRESS;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
        /*public static void DodajKorisnika()
        {
            Korisnici = new List<Korisnik>();
            Administrator admin = new Administrator("pera", "pera12", "peric", "pera@live.com", "prelud",true);
            Korisnici.Add(admin);
            Profesor profesor = new Profesor("aleksa", "alexkiller", "petrovic", "aleksapetrovic@hotmail.com", "apokalipsa", true);
            Korisnici.Add(profesor);
            Asistent asistent = new Asistent("natka", "malanaca", "pajic", "natasapajic@hotmail.com","prejaka", profesor, true);
            Korisnici.Add(asistent);
        }*/
        /*
        public static void CitajKorisnike()
        {
            Korisnici = new List<Korisnik>();
            using(SqlConnection conn = new SqlConnection(CONNECTION_STRING))
            {
                conn.Open();
                SqlCommand command = conn.CreateCommand();
                command.CommandText = @"select * from korisnik";
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    String ime = reader.GetString(1);
                    String korisnickoIme = reader.GetString(2);
                    String prezime = reader.GetString(3);
                    String tipZaposlenog = reader.GetString(4);
                    String lozinka = reader.GetString(5);
                    String email = reader.GetString(6);
                    bool active = (bool)reader.GetValue(7);

                    if (tipZaposlenog.Equals("ADMIN"))
                    {
                        Administrator admin = new Administrator(ime, korisnickoIme, prezime, email, lozinka, active);
                        Korisnici.Add(admin);
                    }

                }
            }
        }
        */
        public static void ReadUsers()
        {
            Korisnici = new List<Korisnik>();
            using (SqlConnection conn = new SqlConnection(CONNECTION_STRING))
            {
                conn.Open();
                SqlCommand command = conn.CreateCommand();
                command.CommandText = @"select * from korisnici";
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter();

                da.SelectCommand = command;
                da.Fill(ds, "Korisnici");
                foreach(DataRow row in ds.Tables["Korisnici"].Rows)
                {
                    string korisnickoIme = (string)row["korisnickoIme"];
                    string ime = (string)row["Ime"];
                    string active = (string)row["Active"];
                    string email = (string)row["Email"];
                    string prezime = (string)row["Prezime"];
                    string lozinka = (string)row["Lozinka"];
                    if (row["TipZaposlenog"].Equals(TipZaposlenog.Administrator.ToString()))
                    {
                        Administrator admin = new Administrator(ime, korisnickoIme, prezime, email, lozinka, true);
                        Korisnici.Add(admin);


                    }
                }


            }
        }
        public static void PretragaPoKorisnickomImenu(string korisnickoIme)
        {
            Korisnici.Clear();
            using (SqlConnection conn = new SqlConnection(CONNECTION_STRING))
            {
                conn.Open();
                SqlCommand command = conn.CreateCommand();
                command.CommandText = @"select * from korisnici where korisnickoIme like @korisnickoIme";
                //and @active = 1 kao i aktivne da prikaze

                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter();

                da.SelectCommand = command;
                da.Fill(ds, "Korisnici");
                foreach(DataRow row in ds.Tables["Korisnici"].Rows)
                {
                    string korisnickoIme1 = (string)row["korisnickoIme"];
                    string ime = (string)row["Ime"];
                    string active = (string)row["Active"];
                    string email = (string)row["Email"];
                    string prezime = (string)row["Prezime"];
                    string lozinka = (string)row["Lozinka"];
                    if (row["TipZaposlenog"].Equals(TipZaposlenog.Administrator.ToString()))
                    {
                        Administrator admin = new Administrator(ime, korisnickoIme1, prezime, email, lozinka, true);
                        Korisnici.Add(admin);


                    }
                }

            }
        }






        public static void DodajUstanovu()
        {
            Ustanove = new List<Ustanova>();
            Ustanova ustanova = new Ustanova("001", "Osnovna skola", "Danila Kisa");
            Ustanove.Add(ustanova);
            Ustanova ustanova1 = new Ustanova("002", "Osnovna skola", "Danila Kisa");
            Ustanove.Add(ustanova1);
            Ustanova ustanova2 = new Ustanova("003", "Osnovna skola", "Danila Kisa");
            Ustanove.Add(ustanova2);
        }
        public static void DodajUcionicu()
        {
            Ucionice = new List<Ucionica>();
            Ucionica ucionica = new Ucionica(1,30,40,true);
            Ucionice.Add(ucionica);
            Ucionica ucionica1 = new Ucionica(2, 35,42, false);
            Ucionice.Add(ucionica1);
            Ucionica ucionica2 = new Ucionica(3, 20,41, false);
            Ucionice.Add(ucionica2);
        }
        public static Korisnik UzmiKorisnikaPoKorisnickoImenu(string korisnickoIme)
        {
            foreach(Korisnik korisnik in Korisnici)
            {
                if (korisnik.KorisnickoIme.Equals(korisnickoIme))
                {
                    return korisnik;
                }
            }
            return null;
        }

    }
}