private void ItemdataGridView1_DoubleClick(object sender, EventArgs e)
{
if (ItemdataGridView1.CurrentRow.Index != -1)
{
model.id = Convert.ToInt32(ItemdataGridView1.CurrentRow.Cells["id"].Value);
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
model = db.items.Where(x => x.id == model.id).FirstOrDefault();
merek_comboBox1.SelectedValue = model.merek_id;
jenis_garansi_comboBox4.SelectedValue = model.garansi_id;
lokasi_gudang_comboBox2.SelectedValue = model.gudang_id;
kondisi_comboBox3.SelectedValue = model.kondisi_id;
stok_numericUpDown1.Value = Convert.ToInt32(model.stok);
harga_numericUpDown1.Value = Convert.ToInt32(model.harga);
tipe_textBox1.Text = model.tipe;
deskripsi_richTextBox1.Text = model.deskripsi;
processor_textBox2.Text = model.processor;
ram_textBox3.Text = model.ram;
penyimpanan_textBox4.Text = model.penyimpanan;
ukuran_layar_textBox5.Text = model.ukuran_layar;
}
simpan_button1.Text = "Update";
delete_button1.Enabled = true;
}
}
void PopulateDataGridView()
{
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
ItemdataGridView1.DataSource = db.items.ToList <item>();
}
}
private void merek_comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
{
// MessageBox.Show(Convert.ToString(merek_comboBox1.SelectedValue));
modelMerek.id = Convert.ToInt32(merek_comboBox1.SelectedValue);
// tipe_laptop_comboBox1.Items.Clear();
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
List <item> itemsData = db.items.Where(x => x.merek_id == modelMerek.id).ToList();
// https://stackoverflow.com/questions/600869/how-to-bind-a-list-to-a-combobox
tipe_laptop_comboBox1.DataSource = itemsData;
tipe_laptop_comboBox1.DisplayMember = "tipe";
tipe_laptop_comboBox1.ValueMember = "id";
/*
* ClassComboboxItem cbItem = new ClassComboboxItem();
* cbItem.Text = "tes";
* cbItem.Value = 1;
* tipe_laptop_comboBox1.Items.Add(cbItem);
*
* foreach (item data in itemsData)
* {
* cbItem.Text = data.tipe;
* cbItem.Value = data.id;
* tipe_laptop_comboBox1.Items.Add(cbItem);
* }
*/
}
}
void PopulateDataGridView()
{
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
dataGridView1.DataSource = db.transaksis.ToList <transaksi>();
}
}
void PopulateDataGridView()
{
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
dataGridView1.DataSource = db.items
.Select(x => new { x.id, x.tipe, x.stok })
.ToList();
}
}
private void delete_button1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Anda yakin ingin menghapus data ini?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
var entry = db.Entry(model);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.items.Attach(model);
}
db.items.Remove(model);
db.SaveChanges();
PopulateDataGridView();
Clear();
MessageBox.Show("Berhasil Menghapus.");
}
}
}
private void tipe_laptop_comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
{
modelItem.id = Convert.ToInt64(tipe_laptop_comboBox1.SelectedValue);
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
modelItem = db.items.Where(x => x.id == modelItem.id).FirstOrDefault();
//merek_comboBox1.SelectedValue = modelItem.merek_id;
stok_disable_textBox1.Text = Convert.ToString(modelItem.stok);
harga_peritem_disable_textBox4.Text = Convert.ToString(modelItem.harga);
tipe_textBox1.Text = modelItem.tipe;
deskripsi_richTextBox1.Text = modelItem.deskripsi;
processor_textBox2.Text = modelItem.processor;
ram_textBox3.Text = modelItem.ram;
penyimpanan_textBox4.Text = modelItem.penyimpanan;
ukuran_layar_textBox5.Text = modelItem.ukuran_layar;
}
}
private void button1_Click(object sender, EventArgs e)
{
modelTransaksi.item_id = modelItem.id;
modelTransaksi.tanggal_transaksi = tanggal_transaksi_dateTimePicker1.Value;
modelTransaksi.qty = Convert.ToInt32(qty_numericUpDown1.Value);
modelTransaksi.harga_satuan_temp = Convert.ToInt32(harga_satuan_textBox1.Text);
modelTransaksi.total_harga = Convert.ToInt32(harga_total_textbox.Text);
modelTransaksi.deskripsi = keterangan_richTextBox1.Text;
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
db.transaksis.Add(modelTransaksi);
modelItem.stok = modelItem.stok - modelTransaksi.qty;
db.Entry(modelItem).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Transaksi Berhasil Ditambahkan");
Clear();
}
}
private void simpan_button1_Click(object sender, EventArgs e)
{
model.merek_id = Convert.ToInt64(merek_comboBox1.SelectedValue);
model.tipe = tipe_textBox1.Text;
model.deskripsi = deskripsi_richTextBox1.Text;
model.processor = processor_textBox2.Text;
model.ram = ram_textBox3.Text;
model.penyimpanan = penyimpanan_textBox4.Text;
model.ukuran_layar = ukuran_layar_textBox5.Text;
model.stok = Convert.ToInt32(stok_numericUpDown1.Value);
model.gudang_id = Convert.ToInt64(lokasi_gudang_comboBox2.SelectedValue);
model.kondisi_id = Convert.ToInt64(kondisi_comboBox3.SelectedValue);
model.tanggal_ditambahkan = tanggal_ditambahkan_dateTimePicker1.Value;
model.garansi_id = Convert.ToInt64(jenis_garansi_comboBox4.SelectedValue);
model.garansi_expired = garansi_expired_dateTimePicker2.Value;
model.harga = Convert.ToInt64(harga_numericUpDown1.Value);
using (dibumilaptopEntities db = new dibumilaptopEntities())
{
if (model.id == 0)
{
db.items.Add(model);
MessageBox.Show("Data berhasil ditambahkan");
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
MessageBox.Show("Data berhasil diupdate");
}
db.SaveChanges();
}
Clear();
PopulateDataGridView();
}
