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);
}
public static void IspisiPpPoId()
{
Console.WriteLine("Upisite id pohadjanja-predavanja:");
int id = Convert.ToInt32(Console.ReadLine());
PohadjaPredaje pp = PohadjaPredajeDAO.GetPPByID(Program.conn, id);
Console.WriteLine(pp.ToString());
}
