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