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