public bool CreateSSPlan(SS_Plan Ss_plan)
{
try
{
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "INSERT INTO Ss_plan " +
"(id_pedagog, id_godina, naziv, opis) " +
" VALUES (@id_pedagog, @id_godina, @naziv, @opis)";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId);
command.Parameters.AddWithValue("@id_godina", Ss_plan.Id_godina);
command.Parameters.AddWithValue("@naziv", Ss_plan.Naziv);
command.Parameters.AddWithValue("@opis", Ss_plan.Opis);
connection.Open();
command.ExecuteNonQuery();
}
}
catch
{
connection.Close();
return(false);
}
finally
{
connection.Close();
}
return(true);
}
public List <SS_Plan> ReadSSPlanove(int id_god)
{
int counter = 0;
List <SS_Plan> Ss_planovi = new List <SS_Plan>();
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT id_plan, id_godina, naziv, opis, godisnji_plan.ak_godina as ak_godina " +
"FROM Ss_plan " +
"JOIN godisnji_plan ON Ss_plan.id_godina = godisnji_plan.id_god " +
"WHERE ss_plan.id_pedagog = @id_pedagog " +
"AND id_godina = @id_godina " +
"ORDER BY naziv ASC";
command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId);
command.Parameters.AddWithValue("@id_godina", id_god);
connection.Open();
using (MySqlDataReader sdr = command.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
SS_Plan plan = new SS_Plan()
{
Red_br = ++counter,
Id_plan = Convert.ToInt32(sdr["id_plan"]),
Naziv = sdr["naziv"].ToString(),
Ak_godina = sdr["ak_godina"].ToString(),
Id_godina = Convert.ToInt32(sdr["Id_godina"]),
Opis = sdr["opis"].ToString(),
};
Ss_planovi.Add(plan);
}
}
}
connection.Close();
}
return(Ss_planovi);
}
public List <SS_Plan> ReadSSPlanove(string search_string)
{
List <SS_Plan> Ss_planovi = new List <SS_Plan>();
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT id_plan, ak_godina, naziv, opis " +
"FROM Ss_plan " +
"WHERE id_pedagog = @id_pedagog " +
"AND (ak_godina like '%" + search_string + "%' " +
"OR naziv like '%" + search_string + "%' " +
"OR opis like '%" + search_string + "%') " +
"ORDER BY id_plan ASC";
command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId);
connection.Open();
using (MySqlDataReader sdr = command.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
SS_Plan plan = new SS_Plan()
{
Id_plan = Convert.ToInt32(sdr["id_plan"]),
Naziv = sdr["naziv"].ToString(),
Id_godina = Convert.ToInt32(sdr["ak_godina"]),
Opis = sdr["opis"].ToString(),
};
Ss_planovi.Add(plan);
}
}
}
connection.Close();
}
return(Ss_planovi);
}
public bool UpdateSSPlan(SS_Plan Ss_plan)
{
try
{
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "UPDATE Ss_plan " +
"SET " +
"id_godina = @id_godina, " +
"naziv = @naziv, " +
"opis = @opis " +
"WHERE id_plan = @id_plan " +
"AND id_pedagog = @id_pedagog";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@id_plan", Ss_plan.Id_plan);
command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId);
command.Parameters.AddWithValue("@id_godina", Ss_plan.Id_godina);
command.Parameters.AddWithValue("@naziv", Ss_plan.Naziv);
command.Parameters.AddWithValue("@opis", Ss_plan.Opis);
connection.Open();
command.ExecuteNonQuery();
}
}
catch
{
connection.Close();
return(false);
}
finally
{
connection.Close();
}
return(true);
}
public SS_Plan ReadSSPlan(int _id)
{
SS_Plan Ss_plan = new SS_Plan();
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT id_plan, id_godina, naziv, opis " +
"FROM Ss_plan " +
"WHERE id_plan = @id " +
"AND id_pedagog = @id_pedagog";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@id", _id);
command.Parameters.AddWithValue("@id_pedagog", PlaniranjeSession.Trenutni.PedagogId);
connection.Open();
using (MySqlDataReader sdr = command.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
Ss_plan = new SS_Plan()
{
Id_plan = Convert.ToInt32(sdr["id_plan"]),
Id_godina = Convert.ToInt32(sdr["id_godina"]),
Naziv = sdr["naziv"].ToString(),
Opis = sdr["opis"].ToString()
};
}
}
}
connection.Close();
}
return(Ss_plan);
}
