public Podrucje_rada ReadPodrucjeRada(int _id) { Podrucje_rada podrucje = new Podrucje_rada(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT id_podrucje, naziv " + "FROM podrucje_rada " + "WHERE id_podrucje = @id "; 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()) { podrucje = new Podrucje_rada() { Id_podrucje = Convert.ToInt32(sdr["id_podrucje"]), Naziv = sdr["naziv"].ToString() }; } } } connection.Close(); } return(podrucje); }
public bool UpdatePodrucjeRada(Podrucje_rada podrucje) { try { this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "UPDATE podrucje_rada " + "SET " + "naziv = @naziv " + "WHERE id_podrucje = @id_podrucje"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_podrucje", podrucje.Id_podrucje); command.Parameters.AddWithValue("@naziv", podrucje.Naziv); connection.Open(); command.ExecuteNonQuery(); } } catch { connection.Close(); return(false); } finally { connection.Close(); } return(true); }
public List <Podrucje_rada> ReadPodrucjeRada(string search_string) { List <Podrucje_rada> podrucje_rada = new List <Podrucje_rada>(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT id_podrucje, naziv " + "FROM podrucje_rada " + "WHERE naziv like '%" + search_string + "%' " + "ORDER BY id_podrucje ASC"; connection.Open(); using (MySqlDataReader sdr = command.ExecuteReader()) { if (sdr.HasRows) { while (sdr.Read()) { Podrucje_rada rad = new Podrucje_rada() { Id_podrucje = Convert.ToInt32(sdr["id_podrucje"]), Naziv = sdr["naziv"].ToString() }; podrucje_rada.Add(rad); } } } connection.Close(); } return(podrucje_rada); }
public bool CreatePodrucjeRada(Podrucje_rada podrucje) { try { this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "INSERT INTO podrucje_rada " + "(naziv) " + " VALUES (@naziv)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@naziv", podrucje.Naziv); connection.Open(); command.ExecuteNonQuery(); } } catch { connection.Close(); return(false); } finally { connection.Close(); } return(true); }