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 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);
}