private void btnSimpan_Click(object sender, EventArgs e) { if (WithErrors()) { val.validateTextBox(txtDibayar, errorProvider1, "Dibayar harus diisi."); return; } var query = from a in context.TRX_PENJUALANs where a.ID_PENJUALAN == Convert.ToInt32(txtId.Text) select a; var histori = new TRX_HISTORI_TRANSAKSI(); Random rdm = new Random(); foreach (var a in query) { histori.NO_TRANSAKSI = rdm.Next(100000000,999999999).ToString(); histori.TGL = DateTime.Now; histori.JML_TAGIH = a.SISA; histori.ID_PENJUALAN = a.ID_PENJUALAN; var dibayar = Convert.ToDecimal(txtDibayar.Text); if (dibayar >= a.SISA) { histori.DIBAYAR = a.SISA; histori.SISA = 0; a.DP = a.DP + a.SISA; a.SISA = 0; } else if (dibayar < a.SISA) { histori.DIBAYAR = dibayar; histori.SISA = a.SISA - dibayar; a.SISA = a.SISA - dibayar; a.DP = a.DP + dibayar; } } context.TRX_HISTORI_TRANSAKSIs.InsertOnSubmit(histori); context.SubmitChanges(); Close(); }
private void btnSimpan_Click(object sender, EventArgs e) { if ( MessageBox.Show("Batalkan reservasi ini ?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var query = from a in context.TRX_PENJUALANs where a.ID_PENJUALAN == Convert.ToInt32(txtId.Text) select a; foreach (var a in query) { a.STATUS = "BATAL"; } Random rdm = new Random(); var fee = Convert.ToDecimal(txtTotal.Text) - Convert.ToDecimal(txtRpKembali.Text); var histori = new TRX_HISTORI_TRANSAKSI(); histori.NO_TRANSAKSI = rdm.Next(100000000, 999999999).ToString(); histori.TGL = DateTime.Now; histori.JML_TAGIH = fee; histori.DIBAYAR = fee; histori.SISA = 0; histori.ID_PENJUALAN = Convert.ToInt32(txtId.Text); histori.INFO = "FEE BATAL"; context.TRX_HISTORI_TRANSAKSIs.InsertOnSubmit(histori); context.SubmitChanges(); Close(); } catch (Exception) { MessageBox.Show("Pembatalan reservasi gagal.", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSimpan_Click(object sender, EventArgs e) { if (WithErrors()) { val.validateTextBox(txtNoIdentitas, errorProvider1, "No identitas harus terisi."); val.validateTextBox(txtNama, errorProvider1, "Nama harus terisi."); val.validateTextBox(txtTelp, errorProvider1, "Telp harus terisi."); val.validateTextBox(txtJmlPenumpang, errorProvider1, "Jumlah penumpang harus terisi."); val.validateTextBox(txtOngkos, errorProvider1, "Ongkos harus terisi."); val.validateTextBox(txtDibayar, errorProvider1, "Dibayar harus terisi."); } else { int cnt = 0; int av = 0; int booked = 0; IsFirstTime = false; int trxId; val.validateReset(errorProvider1); var qry = (from a in context.TRX_PENJUALANs where a.ID_JADWAL == Convert.ToInt32(txtIdJadwal.Text) select new {a.QTY_PENUMPANG}).ToList(); booked = Convert.ToInt32(qry.Select(b => b.QTY_PENUMPANG).Sum()); cnt = booked + Convert.ToInt32(txtJmlPenumpang.Text); av = max - booked; if (cnt <= max) { var jual = new TRX_PENJUALAN(); jual.TGL_PENJUALAN = DateTime.Now; jual.ID_KONSUMEN = Convert.ToInt32(txtIdKonsumen.Text); jual.ID_JADWAL = Convert.ToInt32(cbJadwal.SelectedValue); jual.QTY_PENUMPANG = Convert.ToInt32(txtJmlPenumpang.Text); jual.ONGKOS = Convert.ToDecimal(txtOngkos.Text); jual.JUMLAH = Convert.ToDecimal(txtJumlah.Text); jual.DP = Convert.ToDecimal(txtDibayar.Text); jual.SISA = Convert.ToDecimal(txtSisa.Text); if (rbUloYa.Checked) jual.ID_KOMISI = 2; else jual.ID_KOMISI = 1; context.TRX_PENJUALANs.InsertOnSubmit(jual); context.SubmitChanges(); int currentId = jual.ID_PENJUALAN; string[] seat = seatCol.Split(','); for (int i = 0; i < seat.Count() - 1; i++) { var detail = new TRX_PENJUALAN_DETAIL(); detail.ID_PENJUALAN = currentId; detail.NAMA_PENUMPANG = txtNama.Text; detail.NO_KURSI = Convert.ToInt32(seat[i]); context.TRX_PENJUALAN_DETAILs.InsertOnSubmit(detail); context.SubmitChanges(); } var histori = new TRX_HISTORI_TRANSAKSI(); Random rdm = new Random(); histori.NO_TRANSAKSI = rdm.Next(100000000, 999999999).ToString(); histori.TGL = DateTime.Now; histori.JML_TAGIH = Convert.ToDecimal(txtJumlah.Text); histori.DIBAYAR = Convert.ToDecimal(txtDibayar.Text); histori.SISA = Convert.ToDecimal(txtSisa.Text); histori.ID_PENJUALAN = currentId; context.TRX_HISTORI_TRANSAKSIs.InsertOnSubmit(histori); context.SubmitChanges(); trxId = histori.ID_TRANSAKSI; //trxId = 2; string query = "SELECT ID_PENJUALAN_DETAIL, ID_PENJUALAN, NAMA_PENUMPANG, NO_KURSI FROM TRX_PENJUALAN_DETAIL " + "WHERE ID_PENJUALAN = {0}"; query = string.Format(query, currentId); var dtAdapter = new SqlDataAdapter(query, DbConnection.GetConnection()); var table = new DataTable { Locale = System.Globalization.CultureInfo.InvariantCulture }; dtAdapter.Fill(table); dgvKonsumen.DataSource = table; dgvKonsumen.Columns[0].Visible = false; dgvKonsumen.Columns[1].Visible = false; dgvKonsumen.Columns[2].HeaderText = "Nama"; dgvKonsumen.Columns[3].HeaderText = "No Kursi"; dgvKonsumen.Columns[1].MinimumWidth = 100; dgvKonsumen.Columns[2].MinimumWidth = 150; dgvKonsumen.Columns[3].MinimumWidth = 100; PopulateList(); MessageBox.Show("Berhasil disimpan.", "Transaksi", MessageBoxButtons.OK, MessageBoxIcon.Information); btnBatal_Click(sender, e); var rpt = new FrPrintReceipt(trxId); rpt.ShowDialog(); } else { if (chkCarter.Checked) MessageBox.Show("Jadwal carter ini sudah dipesan.", "Transaksi", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show("Sisa kursi yang tersedia " + av + " kursi.", "Transaksi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
partial void DeleteTRX_HISTORI_TRANSAKSI(TRX_HISTORI_TRANSAKSI instance);
partial void UpdateTRX_HISTORI_TRANSAKSI(TRX_HISTORI_TRANSAKSI instance);
partial void InsertTRX_HISTORI_TRANSAKSI(TRX_HISTORI_TRANSAKSI instance);
private void detach_TRX_HISTORI_TRANSAKSIs(TRX_HISTORI_TRANSAKSI entity) { this.SendPropertyChanging(); entity.TRX_PENJUALAN = null; }