void financeIdComboBox_SelectedIndexChanged(object sender, EventArgs e) { IList list = new List <TTransaction>(); if (financeIdComboBox.SelectedIndex != 0) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionDesc2, financeIdComboBox.SelectedValue.ToString()); expArrays[1] = NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()); //sisa utang tidak nol expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionPpn, decimal.Zero)); NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(TTransaction.ColumnNames.TransactionDate); list = DataMaster.GetList(typeof(TTransaction), expArrays, orderArrays); for (int i = 0; i < list.Count; i++) { TTransaction t = list[i] as TTransaction; t.TransactionByName = AppCode.GetCustomerName(t.TransactionBy, true); } } tTransactionBindingSource.DataSource = list; }
private bool ValidateTransaction() { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; if (string.IsNullOrEmpty(transactionFacturTextBox.Text.Trim())) { balloonHelp.Content = "Nomor faktur harus diisi !!"; balloonHelp.ShowBalloon(transactionFacturTextBox); transactionFacturTextBox.Focus(); return(false); } if (serviceTypeComboBox.SelectedIndex == -1) { balloonHelp.Content = "Pilih jenis service !!"; balloonHelp.ShowBalloon(serviceTypeComboBox); serviceTypeComboBox.Focus(); return(false); } if (!string.IsNullOrEmpty(transactionFacturTextBox.Text.Trim())) { TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionFactur, transactionFacturTextBox.Text.Trim(), TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()); if (tr != null) { balloonHelp.Content = "Nomor faktur " + transactionFacturTextBox.Text + " sudah pernah diinput, silahkan input nomor faktur yang lain."; balloonHelp.ShowBalloon(transactionFacturTextBox); transactionFacturTextBox.Focus(); return(false); } } return(true); }
private void FillTransactionDelivery(TTransactionDelivery del) { TTransaction t = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, del.TransactionId); if (t != null) { transactionReferenceFacturTextBox.Text = t.TransactionFactur; transactionReferenceFacturTextBox_Validating(null, null); deliveryExpedissionTextBox.Text = del.DeliveryExpedission; deliveryExpedissionTextBox_Validating(null, null); deliveryNumberExpedissionTextBox.Text = del.DeliveryNumberExpedission; deliverySentDateDateTimePicker.Value = del.DeliverySentDate; deliveryReceiveDateDateTimePicker.Value = del.DeliveryReceiveDate; deliveryCostNumericUpDown.Value = del.DeliveryCost; deliveryDescTextBox.Text = del.DeliveryDesc; transactionPaymentComboBox.Enabled = false; transactionPaymentComboBox.SelectedItem = del.DeliveryPayment; TPiHutang pihut = (TPiHutang)DataMaster.GetObjectByProperty(typeof(TPiHutang), TPiHutang.ColumnNames.TransactionId, del.DeliveryId); if (pihut != null) { piHutangCreditLongNumericUpDown.Value = pihut.PiHutangCreditLong; } } }
private void toolStripButton_Cash_Click(object sender, EventArgs e) { if (!ConfirmSave()) { return; } if (MessageBox.Show("Pembayaran transaksi " + this.Text + " akan dilakukan. Anda yakin?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { return; } TTransaction t = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, decimal.Parse(transactionIdLabel.Text)); if (t != null) { t.TransactionStatus = ListOfTransaction.Service.ToString(); t.ModifiedBy = lbl_UserName.Text; t.ModifiedDate = DateTime.Now; DataMaster.UpdatePersistence(t); groupBox_TransHeader.Enabled = false; splitContainer_Detail_Detail.Enabled = false; isInEdit = false; toolStripButton_Save.Enabled = false; toolStripButton_Cetak.Enabled = true; toolStripButton_Cash.Enabled = false; toolStripButton_Delete.Enabled = true; UpdateStok(); MessageBox.Show("Pembayaran transaksi " + this.Text + " berhasil dilakukan.", AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void SaveTransaction() { TTransaction t = new TTransaction(); t.TransactionId = transactionIdNumericUpDown.Value; t.TransactionStatus = trans.ToString(); DataMaster.SavePersistence(t); }
private void SaveTransaction() { bool isSave = false; TTransaction t = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, decimal.Parse(transactionIdLabel.Text)); if (t == null) { isSave = true; t = new TTransaction(); } t.CurrencyId = ListOfCurrency.Rupiah.ToString(); t.EmployeeId = servicePicTextBox.Text; t.GudangId = 1; t.TransactionBy = transactionByTextBox.Text; t.TransactionByAddress = transactionByAddressTextBox.Text; t.TransactionByPhone = transactionByPhoneTextBox.Text; t.TransactionDesc = transactionDescTextBox.Text; t.TransactionDesc2 = transactionDesc2TextBox.Text; t.TransactionCommision = decimal.Zero; t.TransactionDate = transactionDateDateTimePicker.Value; t.TransactionDisc = decimal.Zero; t.TransactionFactur = transactionFacturTextBox.Text; t.TransactionGrandTotal = transactionGrandTotalNumericUpDown.Value; t.TransactionId = decimal.Parse(transactionIdLabel.Text); t.TransactionPaid = transactionGrandTotalNumericUpDown.Value; t.TransactionPayment = "Cash"; t.TransactionReferenceId = decimal.Zero; t.TransactionPpn = decimal.Zero; t.TransactionSisa = decimal.Zero; t.TransactionStatus = ListOfTransaction.Temp.ToString(); t.TransactionSubTotal = transactionSubTotalNumericUpDown.Value; t.TransactionUsePpn = false; t.ModifiedBy = lbl_UserName.Text; t.ModifiedDate = DateTime.Now; if (isSave) { DataMaster.SavePersistence(t); } else { DataMaster.UpdatePersistence(t); } }
public void BindData(object sender, EventArgs e) { string myKeyWord = "%" + txt_SearchById.Text.Trim() + "%"; if (txt_SearchById.Text.Equals("<Cari Berdasar No Faktur>")) { myKeyWord = "%%"; } bindingSource_Search.Clear(); IList listSearch = null; if (trans_Type == ListOfTransaction.Sales) { listSearch = new List <TTransaction>(); IList listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); TTransaction trans; for (int i = 0; i < listTemp.Count; i++) { trans = (TTransaction)listTemp[i]; listSearch.Add(trans); } listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); for (int i = 0; i < listTemp.Count; i++) { trans = (TTransaction)listTemp[i]; listSearch.Add(trans); } } else { listSearch = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, trans_Type.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); } if (trans_Type == ListOfTransaction.SalesVIP || trans_Type == ListOfTransaction.Sales || trans_Type == ListOfTransaction.ReturSales || trans_Type == ListOfTransaction.ReturSalesVIP) { for (int i = 0; i < listSearch.Count; i++) { TTransaction t = listSearch[i] as TTransaction; t.TransactionByName = AppCode.GetCustomerName(t.TransactionBy, true); } } else { for (int i = 0; i < listSearch.Count; i++) { TTransaction t = listSearch[i] as TTransaction; t.TransactionByName = AppCode.GetSupplierName(t.TransactionBy); } } if (listSearch.Count > 0) { bindingSource_Search.DataSource = listSearch; } }
private void UpdateTransaction() { if (tTransactionBindingSource.Current != null) { TTransaction t = (tTransactionBindingSource.Current as TTransaction); t.TransactionPpn = t.TransactionSisa - paymentAmmountNumericUpDown.Value; DataMaster.UpdatePersistence(t); } }
/// <summary> /// Gets a typed representaion of the executing transaction /// </summary> /// <typeparam name="TTransaction">Type to return</typeparam> /// <returns>Current transaction, null if no transaction in scope</returns> public static TTransaction GetCurrent <TTransaction>() where TTransaction : class, IDbTransaction { TTransaction current = default(TTransaction); if (TransactionBase <TConnection> .Current != null) { current = TransactionBase <TConnection> .Current as TTransaction; } return(current); }
public AccountItem(TTransaction trans, int connectionId) { AccountCode = trans.accountCode; Amount = (double)trans.amount; BankCode = trans.bankCode; Description = trans.description; Id = trans.id; InputDate = trans.inputDate; MandateId = trans.mndtId; PartnerName = trans.partnerName; Type = trans.text; ValueDate = trans.valueDate; ConnectionId = connectionId; }
private void ShareCommissionInterface(decimal transactionId) { TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, transactionId); if (tr != null) { IList listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, tr.TransactionId); TTransactionDetail det; for (int i = 0; i < listDet.Count; i++) { det = (TTransactionDetail)listDet[i]; ShareCommission(det.Commission, det.IsPacket, tr.EmployeeId, tr.EmployeeId2, tr.TransactionDesk, tr.TransactionId, tr.TransactionFactur); } } }
private void SaveTransaction() { TTransaction t = new TTransaction(); t.TransactionBy = txt_CustId.Text; t.TransactionDate = dt_TransactionDate.Value; t.TransactionDisc = 0; t.TransactionFactur = txt_Factur.Text; t.TransactionGrandTotal = num_GrandTotal.Value; t.TransactionId = Convert.ToDecimal(txt_TransactionId.Text); t.TransactionPaid = num_GrandTotal.Value; t.TransactionPpn = num_Tax.Value; t.TransactionSisa = 0; t.TransactionStatus = lbl_TempTransaction.Text; t.TransactionSubTotal = Convert.ToDecimal(txt_SubTotal.Text); t.TransactionDesk = lbl_TempDesk.Text; t.EmployeeId = lbl_EmployeeId.Text; t.ModifiedBy = lbl_UserName.Text; t.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(t); }
private void transactionReferenceFacturTextBox_Validating(object sender, CancelEventArgs e) { TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionFactur, transactionReferenceFacturTextBox.Text); if (tr != null) { transactionReferenceIdTextBox.Text = tr.TransactionId.ToString(); FillTransaction(tr); FillTransactionDetail(tr); button_Detail.Visible = true; RecreateBalloon(); balloonHelp.Caption = "Detail Transaksi"; balloonHelp.Content = "Klik disini untuk melihat detail transaksi"; balloonHelp.ShowBalloon(button_Detail); } else { transactionReferenceIdTextBox.ResetText(); button_Detail.Visible = false; //tTransactionDeliveryDetailDataGridView.DataSource = null; } }
private void FillTransaction(TTransaction tr) { deliveryNumberPicTextBox.Text = tr.TransactionDesc2; transactionByTextBox.Text = tr.TransactionBy; }
/* Summary Initialize global variables defined */ private void Initialize() { scriptfile = ""; playscriptfile = ""; Resetreg = 0xE600; Maxaddr = 0x4000; Max_Ctlxfer_size = 0x1000; bRecording = false; Xaction = new TTransaction(); list = new ArrayList(); list1 = new ArrayList(); curEndpt = null; curCyUsbDev = null; curHidDev = null; curHidReport = null; }
public void BindReport() { if (transactionByComboBox.SelectedValue != null) { DataId = transactionByComboBox.SelectedValue.ToString(); } if (Param == ParameterView.Currency) { DataId = transactionByComboBox.SelectedItem.ToString(); } title = "Laporan"; reportViewer1.Reset(); switch (rep) { case ListOfReports.MItem: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMItem.rdlc"; FillVItemDetailDataSource(); title = "Daftar Item"; break; case ListOfReports.MGroup: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportSubItem.rdlc"; FillMGroupDataSource(); title = "Daftar Golongan Item"; break; case ListOfReports.MSupplier: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMSupplier.rdlc"; FillVSupplierAccountDataSource(); title = "Daftar Supplier"; break; case ListOfReports.MEmployee: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMEmployee.rdlc"; FillMEmployeeDataSource(); title = "Daftar Karyawan"; break; case ListOfReports.ReportTransactionTotalByItem: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionTotalByItem.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId); title = "Laporan Transaksi Per Item"; break; case ListOfReports.TransactionDetail: decimal transactionId = Convert.ToDecimal(DataId); reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionDetail.rdlc"; FillTransactionDetailSource(transactionId); title = "Laporan Detail Transaksi"; break; case ListOfReports.UtangDetail: string suppId = DataId; string currencyid = DataId2; reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUtangDetail.rdlc"; FillTransactionSource(suppId, currencyid); FillGiroSource(suppId, currencyid); title = "Laporan Utang"; break; case ListOfReports.ReportPODetailForPrint: transactionId = Convert.ToDecimal(DataId); reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPODetailForPrint.rdlc"; TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, transactionId); FillTransactionDetailSource(transactionId); FillMSupplierDataSource(tr.TransactionBy); title = "Laporan Detail PO"; break; case ListOfReports.ReportTransactionTotalByPIC: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionTotalByPIC.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId); title = "Laporan Transaksi"; break; case ListOfReports.ReportGiro: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportGiro.rdlc"; FillGiroSource(GiroGroup.ToString(), DataId); title = "Laporan Giro"; break; case ListOfReports.ReportUsageTotalByAlat: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUsageTotalByAlat.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId); title = "Laporan Pemakaian Spare Parts Per Alat"; break; case ListOfReports.ReportTransactionPerMonth: // splitContainer1.Panel1Collapsed = false; reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionPerMonth.rdlc"; if (transactionByComboBox.SelectedValue != null) { FillVTransactionSource(Trans.ToString(), DataId); } title = "Laporan Transaksi Per Bulan"; break; case ListOfReports.ReportPOTotalByItem: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPOTotalByItem.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId); title = "Laporan Transaksi Per Item"; break; case ListOfReports.ReportPOTotalByPIC: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPOTotalByPIC.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId); title = "Laporan Transaksi"; break; case ListOfReports.ReportUserLog: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUserLog.rdlc"; FillUserLogSource(dt_From.Value, dt_To.Value, DataId); title = "Laporan Histori Pengguna"; break; case ListOfReports.ReportListTransaction: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportListTransaction.rdlc"; FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId); if (Trans == ListOfTransaction.Purchase) { title = "Laporan List Pembelian"; } else if (Trans == ListOfTransaction.PurchaseOrder) { title = "Laporan List Order Pembelian"; } break; case ListOfReports.ReportTagihan: reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTagihan.rdlc"; //FillVTransactionWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId, true); FillVTransactionDetailWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId, true); button_Reset.Visible = true; //object[] transBy = new object[checkedListBox_Parameter.CheckedItems.Count]; //string supp; //for (int i = 0; i < checkedListBox_Parameter.CheckedItems.Count; i++) //{ // supp = checkedListBox_Parameter.CheckedItems[i].ToString(); // supp = supp.Substring(0, supp.IndexOf(" (")); // transBy[i] = supp; //} //FillVTransactionWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, transBy); title = "Laporan Tagihan"; break; default: break; } reportViewer1.LocalReport.SubreportProcessing += new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(LocalReport_SubreportProcessing); this.reportViewer1.RefreshReport(); this.Text = title; this.TabText = title; }
void btn_Click(object sender, EventArgs e) { if (!ConfirmSave()) { return; } if (activeButton != null) { activeButton.BackColor = noneBackColor; activeButton.ForeColor = noneForeColor; } activeButton = (Button)sender; activeButton.BackColor = activeBackCoor; activeButton.ForeColor = activeForeColor; if (activeButton.Tag != null) { transactionIdLabel.Text = activeButton.Tag.ToString(); IList tr = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, decimal.Parse(activeButton.Tag.ToString())); if (tr.Count > 0) { tTransactionBindingSource.DataSource = tr; transactionByTextBox_Validating(null, null); TTransaction t = (TTransaction)tr[0]; if (t.TransactionStatus == ListOfTransaction.Service.ToString()) { splitContainer_Detail_Detail.Enabled = false; groupBox_TransHeader.Enabled = false; toolStripButton_Save.Enabled = false; toolStripButton_Cetak.Enabled = true; toolStripButton_Cash.Enabled = false; toolStripButton_Delete.Enabled = true; } else if (t.TransactionStatus == ListOfTransaction.Temp.ToString()) { splitContainer_Detail_Detail.Enabled = true; groupBox_TransHeader.Enabled = true; toolStripButton_Save.Enabled = true; toolStripButton_Cetak.Enabled = false; toolStripButton_Cash.Enabled = true; toolStripButton_Delete.Enabled = false; } } else { tTransactionBindingSource.Clear(); transactionFacturTextBox.Text = AppCode.GenerateFacturNo(ListOfTransaction.Sales, string.Empty); customerNameTextBox.ResetText(); splitContainer_Detail_Detail.Enabled = true; groupBox_TransHeader.Enabled = true; toolStripButton_Save.Enabled = true; toolStripButton_Cetak.Enabled = false; toolStripButton_Cash.Enabled = false; toolStripButton_Delete.Enabled = false; } tr = DataMaster.GetListEq(typeof(TTransactionService), TTransactionService.ColumnNames.TransactionId, decimal.Parse(activeButton.Tag.ToString())); if (tr.Count > 0) { tTransactionServiceBindingSource.DataSource = tr; servicePicTextBox_Validating(null, null); } else { tTransactionServiceBindingSource.Clear(); employeeNameTextBox.ResetText(); } FillGridDetailTransaction(); } isInEdit = true; groupBox_TransDetail.Visible = false; }
bool ValidateTransaction() { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; if (string.IsNullOrEmpty(transactionFacturTextBox.Text.Trim())) { balloonHelp.Content = "Nomor faktur harus diisi !!"; balloonHelp.ShowBalloon(transactionFacturTextBox); transactionFacturTextBox.Focus(); return(false); } if (string.IsNullOrEmpty(transactionByTextBox.Text)) { string errMsg = ""; if ((trans == ListOfTransaction.Sales) || (trans == ListOfTransaction.ReturSales)) { errMsg = "Pelanggan harus diisi !!"; } else if ((trans == ListOfTransaction.Purchase) || (trans == ListOfTransaction.ReturPurchase)) { errMsg = "Supplier harus diisi !!"; } else if ((trans == ListOfTransaction.Correction)) { errMsg = "Pelapor harus diisi !!"; } balloonHelp.Content = errMsg; balloonHelp.ShowBalloon(transactionByTextBox); transactionByTextBox.Focus(); return(false); } if (transactionByNameComboBox.Visible) { if (transactionByNameComboBox.SelectedIndex == -1) { balloonHelp.Content = "Nomor faktur harus diisi !!"; balloonHelp.ShowBalloon(transactionByNameComboBox); transactionByNameComboBox.Focus(); return(false); } } if (tTransactionDetailDataGridView.RowCount == 0) { MessageBox.Show("Transaksi yang kosong tidak bisa diproses.", "Transaksi tidak bisa diproses.", MessageBoxButtons.OK, MessageBoxIcon.Error); itemIdTextBox.Select(); itemIdTextBox.Focus(); return(false); } if (!string.IsNullOrEmpty(transactionFacturTextBox.Text.Trim())) { TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionFactur, transactionFacturTextBox.Text.Trim()); if (tr != null) { balloonHelp.Content = "Nomor faktur " + transactionFacturTextBox.Text + " sudah pernah diinput, silahkan input nomor faktur yang lain."; balloonHelp.ShowBalloon(transactionFacturTextBox); transactionFacturTextBox.Focus(); return(false); } } return(true); }
void SaveTransaction() { TTransaction t = new TTransaction(); t.CurrencyId = ListOfCurrency.Rupiah.ToString(); t.EmployeeId = string.Empty; t.GudangId = 1; t.TransactionBy = transactionByTextBox.Text; if (transactionByNameComboBox.SelectedIndex != -1) { t.TransactionByName = transactionByNameComboBox.SelectedValue.ToString(); } t.TransactionDate = transactionDateDateTimePicker.Value; t.TransactionDesc = transactionDescTextBox.Text; if (transactionDeskComboBox.SelectedIndex != -1) { t.TransactionDesk = transactionDeskComboBox.SelectedValue.ToString(); } t.TransactionDisc = 0; t.TransactionFactur = transactionFacturTextBox.Text; t.TransactionGrandTotal = GrandTotalNumericUpDown.Value; t.TransactionId = Convert.ToDecimal(transactionIdLabel.Text); if (salesPayment == Payment.Cash) { t.TransactionPaid = GrandTotalNumericUpDown.Value; } else if (salesPayment == Payment.Credit) { t.TransactionPaid = 0; } t.TransactionPayment = salesPayment.ToString(); if (!string.IsNullOrEmpty(transactionReferenceIdTextBox.Text.Trim())) { t.TransactionReferenceId = Convert.ToDecimal(transactionReferenceIdTextBox.Text); } else { t.TransactionReferenceId = 0; } t.TransactionPpn = ppnNumericUpDown.Value; if (salesPayment == Payment.Cash) { t.TransactionSisa = 0; } else if (salesPayment == Payment.Credit) { t.TransactionSisa = GrandTotalNumericUpDown.Value; } t.TransactionStatus = trans.ToString(); t.TransactionSubTotal = totalSubTotalNumericUpDown.Value; t.TransactionUsePpn = transactionUsePpnCheckBox.Checked; t.ModifiedBy = lbl_UserName.Text; t.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(t); }
private void FillTransactionDetail(TTransaction tr) { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("AddDetail", typeof(bool)); dt.Columns.Add("ItemId", typeof(string)); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("Quantity", typeof(decimal)); dt.Columns.Add("QuantityDeliveryLast", typeof(decimal)); dt.Columns.Add("QuantityDelivery", typeof(decimal)); dt.Columns.Add("TransactionDetailId", typeof(decimal)); dt.Columns.Add("DeliveryDetailId", typeof(decimal)); IList listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, tr.TransactionId); NHibernate.Expression.ICriterion[] expArrays; if (isInEdit) { expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.TransactionId, tr.TransactionId); expArrays[1] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.DeliveryId, delId)); } else { expArrays = new NHibernate.Expression.ICriterion[1]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.TransactionId, tr.TransactionId); } NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Asc(TTransactionDelivery.ColumnNames.DeliveryReceiveDate); IList listDel = DataMaster.GetList(typeof(TTransactionDelivery), expArrays, ordArrays); TTransactionDetail det; MItem item; TTransactionDelivery del; TTransactionDeliveryDetail delDet; decimal delCount = decimal.Zero; for (int i = 0; i < listDet.Count; i++) { delCount = decimal.Zero; det = (TTransactionDetail)listDet[i]; dr = dt.NewRow(); dr[0] = false; dr[1] = det.ItemId; item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, det.ItemId); if (item != null) { dr[2] = item.ItemName; } dr[3] = det.Quantity; for (int j = 0; j < listDel.Count; j++) { del = (TTransactionDelivery)listDel[j]; delDet = (TTransactionDeliveryDetail)DataMaster.GetObjectByProperty(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId, TTransactionDeliveryDetail.ColumnNames.TransactionDetailId, det.TransactionDetailId); if (delDet != null) { delCount += delDet.DeliveryDetailQuantity; } //listDelDet = DataMaster.GetListEq(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId); //for (int k = 0; k < listDelDet.Count; k++) //{ // delDet = (TTransactionDeliveryDetail)listDelDet[k]; // delCount += delDet.DeliveryDetailQuantity; //} } dr[4] = delCount; if (isInEdit) { del = (TTransactionDelivery)DataMaster.GetObjectByProperty(typeof(TTransactionDelivery), TTransactionDeliveryDetail.ColumnNames.DeliveryId, delId); if (del != null) { delDet = (TTransactionDeliveryDetail)DataMaster.GetObjectByProperty(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId, TTransactionDeliveryDetail.ColumnNames.TransactionDetailId, det.TransactionDetailId); if (delDet != null) { dr[5] = delDet.DeliveryDetailQuantity; dr[7] = delDet.DeliveryDetailId; } else { dr[5] = decimal.Zero; dr[7] = decimal.Zero; } } } else { dr[5] = decimal.Zero; dr[7] = decimal.Zero; } dr[6] = det.TransactionDetailId; dt.Rows.Add(dr); } tTransactionDeliveryDetailDataGridView.DataSource = dt; tTransactionDeliveryDetailDataGridView.Show(); }