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