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