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());
}
}
