public void updateDataMember(int id) { if (dg_member.SelectedRows.Count > 0) { String no_identitas = tb_edit_no_identitas_member.Text; String nama = tb_edit_nama_member.Text; String username = tb_edit_username_member.Text; String email = tb_edit_email_member.Text; String password = tb_edit_password_member.Text; String no_telp = tb_edit_no_telpon_member.Text; String alamat = tb_edit_alamat_member.Text; if (no_identitas != "" && nama != "" && username != "" && email != "" && password != "" && no_telp != "" && alamat != "") { try { using (db_rental_mobilEntities contextMember = new db_rental_mobilEntities()) { var member = (from a in contextMember.members where a.id_member == id select a).Single(); member.no_identitas = no_identitas; member.nama = nama; member.username = username; member.email = email; member.password = password; member.no_telp = no_telp; member.alamat = alamat; contextMember.SaveChanges(); MessageBox.Show("Member berhasil diedit", "", MessageBoxButtons.OK, MessageBoxIcon.Information); panelEditMember.Hide(); panelListMember.Show(); } } catch { MessageBox.Show("Gagal mengedit member!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Borang ada yang kosong!"); } } }
public void tambahDataMobil() { String nama = tb_nama_mobil.Text; String vendor = tb_vendor_mobil.Text; String transmisi = tb_transmisi_mobil.Text; String harga_mobil_string = tb_harga_mobil.Text; String bagasi = tb_bagasi_mobil.Text; String deskripsi = tb_deskripsi_mobil.Text; if (nama != "" && vendor != "" && bagasi != "" && harga_mobil_string != "" && bagasi != "" && deskripsi != "") { Decimal harga = Decimal.Parse(harga_mobil_string); try { using (db_rental_mobilEntities context = new db_rental_mobilEntities()) { var mobil = new cars(); mobil.nama = nama; mobil.vendor = vendor; mobil.transmisi = transmisi; mobil.harga_sewa = harga; mobil.bagasi = bagasi; mobil.deskripsi = deskripsi; mobil.image = ConvertFiletoByte(this.gambar_mobil.ImageLocation); context.cars.Add(mobil); context.SaveChanges(); MessageBox.Show("Mobil berhasil ditambhkan", "", MessageBoxButtons.OK, MessageBoxIcon.Information); clearTxts(); } } catch { MessageBox.Show("Gagal menambahkan mobil!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Ada field kosong!. Mohon isi semua borang", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void tambahDataMember() { String no_identitas = tb_no_identitas_member.Text; String nama = tb_nama_member.Text; String username = tb_username_member.Text; String email = tb_email_member.Text; String password = tb_password_member.Text; String no_telp = tb_no_telpon_member.Text; String alamat = tb_alamat_member.Text; if (nama != "" && no_identitas != "" && username != "" && email != "" && password != "" && no_telp != "" && alamat != "") { try { using (db_rental_mobilEntities context = new db_rental_mobilEntities()) { var member = new members(); member.nama = nama; member.no_identitas = no_identitas; member.email = email; member.username = username; member.password = password; member.no_telp = no_telp; member.alamat = alamat; context.members.Add(member); context.SaveChanges(); MessageBox.Show("Member berhasil ditambhkan", "", MessageBoxButtons.OK, MessageBoxIcon.Information); clearTxts(); } } catch { MessageBox.Show("Gagal menambahkan member!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Ada field kosong!. Mohon isi semua borang", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Boolean deleteDataMember(int id) { try { using (db_rental_mobilEntities context = new db_rental_mobilEntities()) { var member_deleted = (from member in context.members where member.id_member == id select member).Single(); context.members.Remove(member_deleted); context.SaveChanges(); return(true); } } catch { MessageBox.Show("Gagal menghapus member!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public Boolean deleteDataMobil(int id) { try { using (db_rental_mobilEntities context = new db_rental_mobilEntities()) { var car_deleted = (from car in context.cars where car.id_mobil == id select car).Single(); context.cars.Remove(car_deleted); context.SaveChanges(); return(true); } } catch { MessageBox.Show("Gagal menghapus mobil!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public void updateDataMobil(int id) { String nama = tb_edit_nama_mobil.Text; String vendor = tb_edit_vendor_mobil.Text; String transmisi = tb_edit_transmisi_mobil.Text; String harga_in_string = tb_edit_harga_mobil.Text; String bagasi = tb_edit_bagasi_mobil.Text; String deskripsi = tb_edit_deskripsi_mobil.Text; if (nama != "" && vendor != "" && bagasi != "" && harga_in_string != "" && bagasi != "" && deskripsi != "") { Decimal harga = Decimal.Parse(harga_in_string); try { using (db_rental_mobilEntities context = new db_rental_mobilEntities()) { var car = (from a in context.cars where a.id_mobil == id select a).Single(); car.nama = nama; car.vendor = vendor; car.transmisi = transmisi; car.harga_sewa = harga; car.bagasi = bagasi; car.deskripsi = deskripsi; car.image = ConvertFiletoByte(this.pb_edit_foto_mobil.ImageLocation); context.SaveChanges(); MessageBox.Show("Mobil berhasil ditambhkan", "", MessageBoxButtons.OK, MessageBoxIcon.Information); panelEditMobil.Hide(); panelListMobil.Show(); } } catch { MessageBox.Show("Gagal mengedit mobil!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }