private void btn_simpan_payment_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Data sudah benar?", "Konfirmasi", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var updateOrder = ctx.Database.ExecuteSqlCommand("UPDATE orders SET status = 'PAID' WHERE invoice_number = @invoice_number",
new SqlParameter("invoice_number", this.invoice_number)
);
var updatePayment = ctx.Database.ExecuteSqlCommand("UPDATE payments SET waktu_bayar = @waktu_bayar, nama_rekening = @nama_rekening, nominal = @nominal, nama_bank = @nama_bank, nomor_rekening = @nomor_rekening WHERE id_payment = @id_payment",
new SqlParameter("id_payment", this.id_payment),
new SqlParameter("nama_bank", this.cb_bank.Text),
new SqlParameter("nomor_rekening", this.tb_no_rekening.Text),
new SqlParameter("nama_rekening", this.tb_atas_nama.Text),
new SqlParameter("nominal", this.tb_nominal.Text),
new SqlParameter("waktu_bayar", DateTime.Now)
);
}
this.DialogResult = DialogResult.No;
}
}
protected List <CarsReadyForRent> cari_mobil(String nama, String vendor, String transmisi)
{
using (db_rental_mobilEntities context = new db_rental_mobilEntities())
{
if (nama != "" && vendor != "" && transmisi != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where nama LIKE '%'+@nama+ '%' AND vendor LIKE '%'+@vendor+ '%' AND transmisi LIKE '%'+@transmisi+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@vendor", vendor), new SqlParameter("@nama", nama), new SqlParameter("@transmisi", transmisi)).ToList();
return(mobil_ready);
}
if (nama != "" && vendor != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where vendor LIKE '%'+@vendor+ '%' AND nama LIKE '%'+@nama+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@nama", nama), new SqlParameter("@vendor", vendor)).ToList();
return(mobil_ready);
}
if (nama != "" && transmisi != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where nama LIKE '%'+@nama+ '%' AND transmisi LIKE '%'+@transmisi+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@nama", nama), new SqlParameter("@transmisi", transmisi)).ToList();
return(mobil_ready);
}
if (vendor != "" && transmisi != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where vendor LIKE '%'+@vendor+ '%' AND transmisi LIKE '%'+@transmisi+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@vendor", vendor), new SqlParameter("@transmisi", transmisi)).ToList();
return(mobil_ready);
}
if (vendor != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where vendor LIKE '%'+@vendor+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@vendor", vendor)).ToList();
return(mobil_ready);
}
if (nama != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where nama LIKE '%'+@nama+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@nama", nama)).ToList();
return(mobil_ready);
}
if (transmisi != "")
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where transmisi LIKE '%'+@transmisi+ '%' AND id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')", new SqlParameter("@transmisi", transmisi)).ToList();
return(mobil_ready);
}
else
{
var mobil_ready = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status = 'READY')").ToList();
return(mobil_ready);
}
}
}
// FormHomeMembers formMember;
private void FormSearchReadyCars_Load_1(object sender, EventArgs e)
{
this.panelPayment.Visible = false;
this.panel1.Show();
using (db_rental_mobilEntities context = new db_rental_mobilEntities())
{
var result = context.Database.SqlQuery <CarsReadyForRent>("SELECT * FROM cars where id_mobil NOT IN(SELECT oc.id_car from order_car oc left join orders o on oc.id_order = o.id_order where o.status != 'READY')").ToList();
searchMobil(result);
}
}
private void btn_simpan_payment_Click(object sender, EventArgs e)
{
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var updateOrder = ctx.Database.ExecuteSqlCommand("UPDATE orders SET status = 'CONFIRMED' WHERE invoice_number = @invoice_number",
new SqlParameter("invoice_number", this.rowData[0].ToString())
);
}
this.DialogResult = DialogResult.No;
//dg_payment_clear();
}
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);
}
}
private void insertOrdersData(int car_id, int invoice_number)
{
// try
// {
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var member = ctx.members.Where(m => m.username == LoginInfo.UserID).FirstOrDefault <members>();
var car = ctx.cars.Where(c => c.id_mobil == car_id).FirstOrDefault <cars>();
int id_member = member.id_member;
var total_price = car.harga_sewa * this.jumlah_hari;
var order_date = Order.order_date;
var id_admin = 1;
var status = "UNPAID";
var insertOrder = ctx.Database.ExecuteSqlCommand("INSERT INTO orders(id_member, total_price, invoice_number, tgl_order, id_admin, status) VALUES(@id_member, @total_price, @invoice_number, @order_date, @admin_id, @status)",
new SqlParameter("id_member", id_member), new SqlParameter("total_price", total_price),
new SqlParameter("invoice_number", invoice_number), new SqlParameter("order_date", order_date),
new SqlParameter("admin_id", id_admin), new SqlParameter("status", status)
);
if (insertOrder == 1)
{
var cari_oder_record = ctx.orders.Where(o => o.invoice_number == invoice_number.ToString()).FirstOrDefault <orders>();
var jumlah = 1;
var waktu_kembali = Order.waktu_kembali;
var waktu_ambil = Order.waktu_ambil;
var insertCarOrder = ctx.Database.ExecuteSqlCommand("INSERT INTO order_car(id_order, id_car, jumlah, waktu_ambil, waktu_kembali) VALUES(@id_order, @id_car, @jumlah, @waktu_ambil, @waktu_kembali)",
new SqlParameter("id_order", cari_oder_record.id_order), new SqlParameter("id_car", car_id),
new SqlParameter("jumlah", jumlah), new SqlParameter("waktu_kembali", waktu_kembali),
new SqlParameter("waktu_ambil", waktu_ambil)
);
var insertToPayment = ctx.Database.ExecuteSqlCommand("INSERT INTO payments(id_admin, id_member, id_order) VALUES(@id_admin, @id_member, @id_order)",
new SqlParameter("id_admin", id_admin),
new SqlParameter("id_member", id_member),
new SqlParameter("id_order", cari_oder_record.id_order)
);
}
}
// catch {};
}
private void FormProfilMember_Load(object sender, EventArgs e)
{
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var member = ctx.members.Where(a => a.id_member == 1);
foreach (var detail_member in member.ToList())
{
this.no_identitas.Text = detail_member.no_identitas.ToString();
this.nama_member.Text = detail_member.nama.ToString();
this.alamat_member.Text = detail_member.alamat.ToString();
this.no_telp_member.Text = detail_member.no_telp.ToString();
this.id_member.Text = detail_member.id_member.ToString();
this.username_member.Text = detail_member.username.ToString();
this.email_member.Text = detail_member.email.ToString();
}
}
}
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);
}
}
private void bunifuButton1_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Yakin membatalkan order anda?", "Konfirmasi", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var updateOrder = ctx.Database.ExecuteSqlCommand("UPDATE orders SET status = 'READY' WHERE invoice_number = @invoice_number",
new SqlParameter("invoice_number", this.invoice_number)
);
if (updateOrder != 0)
{
MessageBox.Show("Order anda sudah dibatalkan");
this.DialogResult = DialogResult.No;
}
}
}
}
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);
}
}
}
private void btn_simpan_payment_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("apa anda yakin ?", "Konfirmasi pengembalian mobil", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
double besaranDenda = denda();
using (db_rental_mobilEntities ctx = new db_rental_mobilEntities())
{
var updateOrder = 0;
if (besaranDenda > 0)
{
updateOrder = ctx.Database.ExecuteSqlCommand("UPDATE orders SET status = 'READY' WHERE invoice_number = @invoice_number",
new SqlParameter("invoice_number", this.invoice_number)
);
var updatePayment = ctx.Database.ExecuteSqlCommand("UPDATE payment SET denda = @denda WHERE id_payment = @id_payment",
new SqlParameter("id_payment", this.id_payment),
new SqlParameter("denda", besaranDenda)
);
}
else
{
updateOrder = ctx.Database.ExecuteSqlCommand("UPDATE orders SET status = 'READY' WHERE invoice_number = @invoice_number",
new SqlParameter("invoice_number", this.invoice_number)
);
}
if (updateOrder != 0)
{
MessageBox.Show("Pengembalian telah berhasil");
}
}
this.DialogResult = DialogResult.No;
}
}
private void btn_login_Click(object sender, EventArgs e)
{
String username = tb_username.Text;
Boolean is_admin = cb_admin.Checked;
using (db_rental_mobilEntities context = new db_rental_mobilEntities())
{
if (!is_admin)
{
var verif_username = context.members.FirstOrDefault(u => u.username == username);
if (verif_username != null)
{
String password = tb_password.Text;
var verif_password = context.members.FirstOrDefault(u => u.password == password);
if (verif_password != null)
{
//MessageBox.Show("Berhasil masuk");
this.Hide();
LoginInfo.UserID = username;
FormHomeMembers formHomeMember = new FormHomeMembers();
formHomeMember.Show();
formHomeMember.Focus();
}
else
{
MessageBox.Show("Password Anda salah!");
}
}
else
{
MessageBox.Show("Username anda salah");
}
}
else
{
var verif_username = context.admins.FirstOrDefault(u => u.username == username);
if (verif_username != null)
{
String password = tb_password.Text;
var verif_password = context.admins.FirstOrDefault(u => u.password == password);
if (verif_password != null)
{
//MessageBox.Show("Berhasil masuk anda Admin");
this.Hide();
FormHomeAdmin formHomeAdmin = new FormHomeAdmin();
formHomeAdmin.Show();
formHomeAdmin.Focus();
}
else
{
MessageBox.Show("Password Admin Anda salah!");
}
}
else
{
MessageBox.Show("Username Admin anda salah");
}
}
}
}
