public Oblici ReadOblici(int _id) { Oblici oblik = new Oblici(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT id_oblici, naziv " + "FROM oblici " + "WHERE id_oblici = @id"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id", _id); connection.Open(); using (MySqlDataReader sdr = command.ExecuteReader()) { if (sdr.HasRows) { while (sdr.Read()) { oblik = new Oblici() { Id_oblici = Convert.ToInt32(sdr["id_oblici"]), Naziv = sdr["naziv"].ToString() }; } } } connection.Close(); } return(oblik); }
public bool UpdateOblici(Oblici oblik) { try { this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "UPDATE oblici " + "SET " + "naziv = @naziv " + "WHERE id_oblici = @id_oblici"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_oblici", oblik.Id_oblici); command.Parameters.AddWithValue("@naziv", oblik.Naziv); connection.Open(); command.ExecuteNonQuery(); } } catch { connection.Close(); return(false); } finally { connection.Close(); } return(true); }
public List <Oblici> ReadOblici(string search_string) { List <Oblici> oblici = new List <Oblici>(); this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "SELECT id_oblici, naziv " + "FROM oblici " + "WHERE naziv like '%" + search_string + "%' " + "ORDER BY id_oblici ASC"; connection.Open(); using (MySqlDataReader sdr = command.ExecuteReader()) { if (sdr.HasRows) { while (sdr.Read()) { Oblici oblik = new Oblici() { Id_oblici = Convert.ToInt32(sdr["id_oblici"]), Naziv = sdr["naziv"].ToString() }; oblici.Add(oblik); } } } connection.Close(); } return(oblici); }
public bool CreateOblici(Oblici oblik) { try { this.Connect(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = "INSERT INTO oblici " + "(naziv) " + " VALUES (@naziv)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@naziv", oblik.Naziv); connection.Open(); command.ExecuteNonQuery(); } } catch { connection.Close(); return(false); } finally { connection.Close(); } return(true); }