public static List <UplataUcenika> GetAll(SqlConnection conn)
        {
            List <UplataUcenika> sveUplateIUcenici = new List <UplataUcenika>();

            try
            {
                string query = "SELECT id, ucenik_id, uplata_id " +
                               "FROM uplata_ucenika";
                SqlCommand cmd = new SqlCommand(query, conn);

                SqlDataReader r = cmd.ExecuteReader();

                while (r.Read())
                {
                    int id       = (int)r["id"];
                    int uplataId = (int)r["uplata_id"];
                    int ucenikId = (int)r["ucenik_id"];

                    Uplata uplata = UplataDAO.GetUplataById(Program.conn, uplataId);
                    Ucenik ucenik = UcenikDAO.GetUcenikById(Program.conn, ucenikId);

                    sveUplateIUcenici.Add(new UplataUcenika(id, uplata, ucenik));
                }
                r.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            return(sveUplateIUcenici);
        }
        public static List <PohadjaPredaje> GetAll(SqlConnection conn)
        {
            List <PohadjaPredaje> sviPp = new List <PohadjaPredaje>();

            try
            {
                string query = "SELECT id, kurs_id, ucenik_id, nastavnik_id " +
                               "FROM pohadja_predaje";
                SqlCommand    cmd = new SqlCommand(query, conn);
                SqlDataReader r   = cmd.ExecuteReader();

                while (r.Read())
                {
                    int id     = (int)r["id"];
                    int kursId = (int)r["kurs_id"];
                    int nastId = (int)r["nastavnik_id"];
                    int ucId   = (int)r["ucenik_id"];

                    Kurs      kurs = KursDAO.GetKursById(Program.conn, kursId);
                    Nastavnik nast = NastavnikDAO.GetNastavnikById(Program.conn, nastId);
                    Ucenik    uc   = UcenikDAO.GetUcenikById(Program.conn, ucId);

                    sviPp.Add(new PohadjaPredaje(id, nast, uc, kurs));
                }
                r.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            return(sviPp);
        }
        public static UplataUcenika GetUplataByUcenikId(SqlConnection conn, int id)
        {
            UplataUcenika uplUc = null;

            try
            {
                string query = "SELECT uplata_id, ucenik_id " +
                               "FROM uplata_ucenika " +
                               "WHERE id=" + id;
                SqlCommand cmd = new SqlCommand(query, conn);

                SqlDataReader r = cmd.ExecuteReader();
                if (r.Read())
                {
                    int uplataId = (int)r["uplata_id"];
                    int ucenikId = (int)r["ucenik_id"];

                    Uplata uplata = UplataDAO.GetUplataById(Program.conn, uplataId);
                    Ucenik ucenik = UcenikDAO.GetUcenikById(Program.conn, ucenikId);

                    uplUc = new UplataUcenika(id, uplata, ucenik);
                }
                r.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            return(uplUc);
        }
        public static PohadjaPredaje GetPPByID(SqlConnection conn, int id)
        {
            PohadjaPredaje pp = null;

            try
            {
                string query = "SELECT kurs_id, nastavnik_id, ucenik_id " +
                               "FROM pohadja_predaje " +
                               "WHERE id = " + id;
                SqlCommand    cmd = new SqlCommand(query, conn);
                SqlDataReader r   = cmd.ExecuteReader();

                if (r.Read())
                {
                    int kursId = (int)r["kurs_id"];
                    int nastId = (int)r["nastavnik_id"];
                    int ucId   = (int)r["ucenik_id"];

                    Kurs      kurs = KursDAO.GetKursById(Program.conn, kursId);
                    Nastavnik nast = NastavnikDAO.GetNastavnikById(Program.conn, nastId);
                    Ucenik    uc   = UcenikDAO.GetUcenikById(Program.conn, ucId);

                    pp = new PohadjaPredaje(id, nast, uc, kurs);
                }
                r.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            return(pp);
        }