public bool UpdateSSPlanPodrucje(SS_Plan_podrucje SS_Plan_Podrucje)
{
try
{
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "UPDATE ss_plan_podrucje " +
"SET " +
"id = @id, " +
"id_plan = @id_plan, " +
"opis_podrucje = @opis_podrucje, " +
"svrha = @svrha, " +
"zadaca = @zadaca, " +
"sadrzaj = @sadrzaj, " +
"oblici = @oblici, " +
"suradnici = @suradnici, " +
"mjesto = @mjesto, " +
"vrijeme = @vrijeme, " +
"ishodi = @ishodi, " +
"sati = @sati " +
"WHERE id = @id AND id_plan = @id_plan";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@id", SS_Plan_Podrucje.Id);
command.Parameters.AddWithValue("@id_plan", SS_Plan_Podrucje.ID_plan);
command.Parameters.AddWithValue("@opis_podrucje", SS_Plan_Podrucje.Opis_podrucje);
command.Parameters.AddWithValue("@svrha", SS_Plan_Podrucje.Svrha);
command.Parameters.AddWithValue("@zadaca", SS_Plan_Podrucje.Zadaca);
command.Parameters.AddWithValue("@sadrzaj", SS_Plan_Podrucje.Sadrzaj);
command.Parameters.AddWithValue("@oblici", SS_Plan_Podrucje.Oblici);
command.Parameters.AddWithValue("@suradnici", SS_Plan_Podrucje.Suradnici);
command.Parameters.AddWithValue("@mjesto", SS_Plan_Podrucje.Mjesto);
command.Parameters.AddWithValue("@vrijeme", SS_Plan_Podrucje.Vrijeme);
command.Parameters.AddWithValue("@ishodi", SS_Plan_Podrucje.Ishodi);
command.Parameters.AddWithValue("@sati", SS_Plan_Podrucje.Sati);
connection.Open();
command.ExecuteNonQuery();
}
}
catch
{
connection.Close();
return(false);
}
finally
{
connection.Close();
}
return(true);
}
public List <SS_Plan_podrucje> ReadSsPodrucja(int id_plan)
{
int counter = 0;
List <SS_Plan_podrucje> ss_podrucja = new List <SS_Plan_podrucje>();
this.Connect();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT * " +
"FROM ss_plan_podrucje " +
"WHERE id_plan = @id_plan " +
"ORDER BY id_plan ASC";
command.Parameters.AddWithValue("@id_plan", id_plan);
connection.Open();
using (MySqlDataReader sdr = command.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
SS_Plan_podrucje plan = new SS_Plan_podrucje()
{
Red_br = ++counter,
Id = Convert.ToInt32(sdr["id"]),
ID_plan = Convert.ToInt32(sdr["id_plan"]),
Opis_podrucje = sdr["opis_podrucje"].ToString(),
Svrha = sdr["svrha"].ToString(),
Zadaca = sdr["zadaca"].ToString(),
Sadrzaj = sdr["sadrzaj"].ToString(),
Oblici = sdr["oblici"].ToString(),
Suradnici = sdr["suradnici"].ToString(),
Mjesto = sdr["mjesto"].ToString(),
Vrijeme = Convert.ToDateTime(sdr["vrijeme"]),
Ishodi = sdr["ishodi"].ToString(),
Sati = Convert.ToInt32(sdr["sati"])
};
ss_podrucja.Add(plan);
}
}
}
connection.Close();
}
return(ss_podrucja);
}
