public int Delete(Penerbit penerbit) { strSql = "DELETE FROM penerbit WHERE id = @1"; using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@1", penerbit.PenerbitID); return cmd.ExecuteNonQuery(); } }
public int Update(Penerbit penerbit) { strSql = "UPDATE penerbit SET nama = @1 " + "WHERE id = @2"; using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@1", penerbit.Nama); cmd.Parameters.AddWithValue("@2", penerbit.PenerbitID); return cmd.ExecuteNonQuery(); } }
private static Penerbit MappingDtrToObject(OleDbDataReader dtr) { Penerbit penerbit = new Penerbit(); penerbit.PenerbitID = dtr[0] is DBNull ? 0 : dtr.GetInt32(0); penerbit.Nama = dtr[1] is DBNull ? string.Empty : dtr.GetString(1); return penerbit; }
public int Save(Penerbit penerbit) { strSql = "INSERT INTO penerbit (nama) " + "VALUES (@1)"; using (OleDbCommand cmd = conn.CreateCommand()) { cmd.CommandText = strSql; cmd.Parameters.AddWithValue("@1", penerbit.Nama); cmd.ExecuteNonQuery(); strSql = "SELECT MAX(id) FROM penerbit"; cmd.CommandText = strSql; // mengembalikan id terakhir penerbit return Convert.ToInt32(cmd.ExecuteScalar()); } }