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 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 void buttonChange_Click(object sender, EventArgs e)
{
try
{
TipeBuku tipeiDipilih = (TipeBuku)comboBoxTipeBuku.SelectedItem;
Penerbit penerbit = (Penerbit)comboBoxPenerbit.SelectedItem;
Buku b = new Buku(textBoxId.Text, textBoxJudul.Text, int.Parse(textBoxHarga.Text), int.Parse(textBoxStok.Text), tipeiDipilih, penerbit);
Buku.UbahData(b);
MessageBox.Show("Data Buku telah tersimpan", "Info");
}
catch (Exception ex)
{
MessageBox.Show("Penyimpanan gagal. Pesan Kesalahan : " + ex.Message, "Kesalahan");
}
}
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()));
}
}
public static bool Update(PenerbitViewModel model)
{
bool result = true;
try
{
using (var db = new PerpusContext())
{
if (model.Id == 0)
{
Penerbit pnb = new Penerbit();
pnb.Id = model.Id;
pnb.KodePenerbit = model.KodePenerbit;
pnb.NamaPenerbit = model.NamaPenerbit;
pnb.AlamatPenerbit = model.AlamatPenerbit;
pnb.Telepon = model.Telepon;
pnb.CreatedBy = "Admin";
pnb.Created = DateTime.Now;
db.Penerbit.Add(pnb);
db.SaveChanges();
}
else
{
Penerbit pnb = db.Penerbit.Where(o => o.Id == model.Id).FirstOrDefault();
if (pnb != null)
{
pnb.KodePenerbit = model.KodePenerbit;
pnb.NamaPenerbit = model.NamaPenerbit;
pnb.AlamatPenerbit = model.AlamatPenerbit;
pnb.Telepon = model.Telepon;
pnb.ModifiedBy = "Admin";
pnb.Modified = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public List <Penerbit> GetAll()
{
List <Penerbit> daftarPenerbit = new List <Penerbit>();
strSql = "SELECT id, nama " +
"FROM penerbit " +
"ORDER BY nama";
using (OleDbCommand cmd = new OleDbCommand(strSql, conn))
{
using (OleDbDataReader dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
Penerbit penerbit = MappingDtrToObject(dtr);
daftarPenerbit.Add(penerbit);
}
}
}
return(daftarPenerbit);
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
TipeBuku tipeBuku = (TipeBuku)comboBoxTipe.SelectedItem;
Penerbit penerbit = (Penerbit)comboBoxPenerbit.SelectedItem;
Buku b = new Buku(textBoxId.Text, textBoxJudul.Text, int.Parse(textBoxHarga.Text), int.Parse(textBoxStok.Text), tipeBuku, penerbit);
Buku.TambahData(b);
MessageBox.Show("Data buku berhasil ditambahkan", "informasi");
textBoxJudul.Text = "";
textBoxId.Text = "";
textBoxHarga.Text = "";
textBoxStok.Text = "";
comboBoxTipe.Text = "";
comboBoxTipe.Focus();
}
catch (Exception ex)
{
MessageBox.Show("Gagal menambah data. Pesan kesalahan : " + ex.Message, "Kesalahan");
}
}
private void FormDeleteOfBook_Load(object sender, EventArgs e)
{
textBoxId.MaxLength = 5;
textBoxJudul.MaxLength = 45;
listOfTipeBuku = TipeBuku.BacaData("", "");
comboBoxTipeBuku.DataSource = listOfTipeBuku;
comboBoxTipeBuku.DisplayMember = "JenisBuku";
comboBoxTipeBuku.DropDownStyle = ComboBoxStyle.DropDownList;
listOfPenerbit = Penerbit.BacaData("", "");
comboBoxPenerbit.DataSource = listOfPenerbit;
comboBoxPenerbit.DisplayMember = "NamaPenerbit";
comboBoxPenerbit.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxPenerbit.Enabled = false;
comboBoxTipeBuku.Enabled = false;
textBoxHarga.Enabled = false;
textBoxHarga.Enabled = false;
textBoxJudul.Enabled = false;
textBoxStok.Enabled = false;
}
public static bool Delete(int id)
{
bool result = true;
try
{
using (var db = new PerpusContext())
{
Penerbit pnb = db.Penerbit.Where(o => o.Id == id).FirstOrDefault();
if (pnb != null)
{
db.Penerbit.Remove(pnb);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
private void FormChangeBook_Load(object sender, EventArgs e)
{
textBoxId.MaxLength = 5;
textBoxJudul.MaxLength = 45;
listOfTipeBuku = TipeBuku.BacaData("", "");
comboBoxTipeBuku.DataSource = listOfTipeBuku;
comboBoxTipeBuku.DisplayMember = "JenisBuku";
comboBoxTipeBuku.DropDownStyle = ComboBoxStyle.DropDownList;
listOfPenerbit = Penerbit.BacaData("", "");
comboBoxPenerbit.DataSource = listOfPenerbit;
comboBoxPenerbit.DisplayMember = "NamaPenerbit";
comboBoxPenerbit.DropDownStyle = ComboBoxStyle.DropDownList;
textBoxJudul.Text = "";
textBoxHarga.Text = "";
textBoxStok.Text = "";
textBoxId.Text = "";
textBoxHarga.TextAlign = HorizontalAlignment.Right;
textBoxStok.TextAlign = HorizontalAlignment.Right;
}
public List <Penerbit> GetByName(string namaPenerbit)
{
List <Penerbit> daftarPenerbit = new List <Penerbit>();
strSql = "SELECT id, nama " +
"FROM penerbit " +
"WHERE nama LIKE @1 " +
"ORDER BY nama";
using (OleDbCommand cmd = new OleDbCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", "%" + namaPenerbit + "%");
using (OleDbDataReader dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
Penerbit penerbit = MappingDtrToObject(dtr);
daftarPenerbit.Add(penerbit);
}
}
}
return(daftarPenerbit);
}
private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
DialogResult konfirmasi = MessageBox.Show("Data Buku akan terhapus, Apakah anda yakin ?", "Konfirmasi", MessageBoxButtons.YesNo);
if (konfirmasi == System.Windows.Forms.DialogResult.Yes)
{
TipeBuku tipeDipilih = (TipeBuku)comboBoxTipeBuku.SelectedItem;
Penerbit penerbit = (Penerbit)comboBoxPenerbit.SelectedItem;
Buku b = new Buku(textBoxId.Text, textBoxJudul.Text, int.Parse(textBoxHarga.Text), int.Parse(textBoxStok.Text), tipeDipilih, penerbit);
Buku.HapusData(b);
MessageBox.Show("Data Buku telah terhapus", "Info");
}
else
{
MessageBox.Show("Data Buku tidak jadi di hapus", "Info");
}
}
catch (Exception ex)
{
MessageBox.Show("Penghapusan gagal. Pesan Kesalahan : " + ex.Message, "Kesalahan");
}
}
