public Godisnji_plan ReadGodisnjiPlan(int _id) { Godisnji_plan plan = new Godisnji_plan(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT * FROM godisnji_plan " + "WHERE id_pedagog = @id_pedagog " + "AND id_god = @id_god " + "ORDER BY id_god ASC"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_god", _id); command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId); connection.Open(); using (MySqlDataReader sdr = command.ExecuteReader()) { if (sdr.HasRows) { while (sdr.Read()) { Godisnji_plan g_plan = new Godisnji_plan() { Id_god = Convert.ToInt32(sdr["id_god"]), Id_pedagog = Convert.ToInt32(sdr["id_pedagog"]), Ak_godina = sdr["ak_godina"].ToString(), Br_radnih_dana = Convert.ToInt32(sdr["br_radnih_dana"]), Br_dana_godina_odmor = Convert.ToInt32(sdr["br_dana_godina_odmor"]), Ukupni_rad_dana = Convert.ToInt32(sdr["ukupni_rad_dana"]), God_fond_sati = Convert.ToInt32(sdr["god_fond_sati"]), }; plan = g_plan; } } } connection.Close(); } return(plan); }
public List <Godisnji_plan> ReadGodisnjePlanove() { int id = 0; List <Godisnji_plan> godisnji_planovi = new List <Godisnji_plan>(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT id_god, id_pedagog, ak_godina, br_radnih_dana, br_dana_godina_odmor, ukupni_rad_dana, god_fond_sati" + " FROM godisnji_plan " + "WHERE id_pedagog = @id_pedagog " + "ORDER BY ak_godina ASC"; command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId); connection.Open(); using (MySqlDataReader sdr = command.ExecuteReader()) { if (sdr.HasRows) { while (sdr.Read()) { Godisnji_plan plan = new Godisnji_plan() { Redni_broj = ++id, Id_god = Convert.ToInt32(sdr["id_god"]), Ak_godina = sdr["ak_godina"].ToString(), Br_radnih_dana = Convert.ToInt32(sdr["br_radnih_dana"]), Br_dana_godina_odmor = Convert.ToInt32(sdr["br_dana_godina_odmor"]), Ukupni_rad_dana = Convert.ToInt32(sdr["ukupni_rad_dana"]), God_fond_sati = Convert.ToInt32(sdr["god_fond_sati"]), }; godisnji_planovi.Add(plan); } } } connection.Close(); } return(godisnji_planovi); }