public int delete(klinikModel klinik) { str = "delete from klinik where id_klinik = @1"; using (MySqlCommand cmd = new MySqlCommand(str, conn)) { cmd.Parameters.AddWithValue("@1", klinik.IdKlinik); return(cmd.ExecuteNonQuery()); } }
public int save(klinikModel klinik) { str = "insert into klinik(klinik_nama, klinik_alamat) values (@1, @2)"; using (MySqlCommand cmd = new MySqlCommand(str, conn)) { cmd.Parameters.AddWithValue("@1", klinik.KlinikNama); cmd.Parameters.AddWithValue("@2", klinik.KlinikAlamat); return(cmd.ExecuteNonQuery()); } }
public int update(klinikModel klinik) { str = "update klinik set klinik_nama = @1, klinik_alamat = @2 where id_klinik = @3"; using (MySqlCommand cmd = new MySqlCommand(str, conn)) { cmd.Parameters.AddWithValue("@1", klinik.KlinikNama); cmd.Parameters.AddWithValue("@2", klinik.KlinikAlamat); cmd.Parameters.AddWithValue("@3", klinik.IdKlinik); return(cmd.ExecuteNonQuery()); } }