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;
}
public void BindData(object sender, EventArgs e)
{
string myKeyWord = "%" + txt_SearchById.Text.Trim() + "%";
if (txt_SearchById.Text.Equals("<Cari Berdasar No Surat Jalan Supplier>"))
{
myKeyWord = "%%";
}
bindingSource_Search.Clear();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2];
expArrays[0] = NHibernate.Expression.Expression.Between(TTransactionDelivery.ColumnNames.DeliveryReceiveDate, dt_From.Value, dt_To.Value);
expArrays[1] = NHibernate.Expression.Expression.Like(TTransactionDelivery.ColumnNames.DeliveryNumberPic, myKeyWord);
NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1];
ordArrays[0] = NHibernate.Expression.Order.Asc(TTransactionDelivery.ColumnNames.DeliveryReceiveDate);
IList listSearch = DataMaster.GetList(typeof(TTransactionDelivery), expArrays, ordArrays);
if (listSearch.Count > 0)
{
bindingSource_Search.DataSource = listSearch;
}
}
private void BindData()
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3];
if (itemToolStripComboBox.ComboBox.SelectedValue != null)
{
if (itemToolStripComboBox.ComboBox.SelectedValue.ToString() != string.Empty)
{
expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, itemToolStripComboBox.ComboBox.SelectedValue);
}
}
expArrays[1] = NHibernate.Expression.Expression.Like(TStock.ColumnNames.StockDesc2, stockDesc2ToolStripTextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
expArrays[2] = NHibernate.Expression.Expression.Like(TStock.ColumnNames.StockDesc3, stockDesc3ToolStripTextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
IList listMaster = DataMaster.GetList(typeof(TStock), expArrays, null);
if (listMaster.Count > 0)
{
bindingSource_Master.DataSource = listMaster;
}
else
{
bindingSource_Master.Clear();
}
bindingSource_Master_PositionChanged(null, null);
}
private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC)
{
string ItemOrPIC_Temp = ItemOrPIC;
if (ItemOrPIC_Temp.Equals(""))
{
ItemOrPIC_Temp = "%%";
}
bs = new BindingSource();
bs.Clear();
//if (!transStatus.Equals(lbl_Param1.Name))
switch (reportBy)
{
case ReportBy.Item:
NHibernate.Expression.ICriterion[] expArray = new NHibernate.Expression.ICriterion[3];
expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp);
expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString()));
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null);
//bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp);
break;
case ReportBy.PIC:
expArray = new NHibernate.Expression.ICriterion[3];
expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp);
expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString()));
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null);
//bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp);
break;
default:
break;
}
//else
// bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs));
try
{
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString(AppCode.DateTimeFormat));
parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString(AppCode.DateTimeFormat));
reportViewer1.LocalReport.SetParameters(parameters);
}
catch (Exception)
{
}
}
private int CalculateStockAkhir(string ItemId)
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3];
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId);
expArrays[1] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value);
expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateIn, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
int stokMasuk = DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count;
expArrays = new NHibernate.Expression.ICriterion[3];
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId);
expArrays[1] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateOut, transactionDateDateTimePicker.Value);
expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
int stokKeluar = DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count;
return(stokMasuk - stokKeluar);
}
private void FillVStockDetailDataSource()
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2];
if (itemIdComboBox.SelectedIndex != 0)
{
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, itemIdComboBox.SelectedValue);
}
if (FilterByDateCheckBox.Checked)
{
expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
}
bs = new BindingSource();
bs.DataSource = DataMaster.GetList(typeof(VTStockDetail), expArrays, null);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTStockDetail", bs));
}
private void FillTPihutang(string piHutangStatus)
{
bs = new BindingSource();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[1];
expArrays[0] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangStatus, piHutangStatus);
//expArrays[1] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString());
//expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero));
NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1];
ordArrays[0] = NHibernate.Expression.Order.Desc(TPiHutang.ColumnNames.PiHutangDate);
bs.DataSource = DataMaster.GetList(typeof(TPiHutang), expArrays, ordArrays);
//bs.DataSource = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangStatus, piHutangStatus, TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Today);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TPiHutang", bs));
}
private decimal CalculateStock(bool isIn, string ItemId)
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3];
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId);
if (isIn)
{
expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateIn, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
}
else
{
expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateOut, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
}
return(DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count);
}
private void FillVTransactionWithBankAccSource(string transStatus, DateTime from, DateTime to, object[] transBy)
{
bs = new BindingSource();
bs.Clear();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3];
expArrays[0] = NHibernate.Expression.Expression.Eq(VTransactionWithBankAcc.ColumnNames.TransactionStatus, transStatus);
expArrays[1] = NHibernate.Expression.Expression.Between(VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to);
expArrays[2] = NHibernate.Expression.Expression.In(VTransactionWithBankAcc.ColumnNames.TransactionBy, transBy);
NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1];
ordArrays[0] = NHibernate.Expression.Order.Asc(VTransactionWithBankAcc.ColumnNames.TransactionFactur);
bs.DataSource = DataMaster.GetList(typeof(VTransactionWithBankAcc), expArrays, ordArrays);
//bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTransactionWithBankAcc), VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTransactionWithBankAcc", bs));
}
private void FillVTotalDelivery(DateTime DateFrom, DateTime DateTo, string likeValue)
{
if (string.IsNullOrEmpty(likeValue))
{
likeValue = "%%";
}
bs = new BindingSource();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2];
expArrays[0] = NHibernate.Expression.Expression.Between(VTotalTransactionDelivery.ColumnNames.DeliveryReceiveDate, DateFrom, DateTo);
expArrays[1] = NHibernate.Expression.Expression.Like(VTotalTransactionDelivery.ColumnNames.DeliveryExpedission, likeValue);
NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1];
ordArrays[0] = NHibernate.Expression.Order.Asc(VTotalTransactionDelivery.ColumnNames.DeliveryReceiveDate);
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDelivery), expArrays, ordArrays);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDelivery", bs));
}
private void piHutangPicComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (piHutangPicComboBox.SelectedIndex == -1)
{
return;
}
tPiHutangDataGridView.Rows.Clear();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3];
expArrays[0] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangStatus, PiHutang.ToString());
expArrays[1] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString());
expArrays[2] = NHibernate.Expression.Expression.Gt(TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero);
NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1];
orderArrays[0] = NHibernate.Expression.Order.Desc(TPiHutang.ColumnNames.TransactionId);
IList piHutangList = DataMaster.GetList(typeof(TPiHutang), expArrays, orderArrays);
//IList piHutangList = DataMaster.GetListEqGreatThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangStatus, PiHutang.ToString(), TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero);
TPiHutang piHut;
for (int i = 0; i < piHutangList.Count; i++)
{
piHut = (TPiHutang)piHutangList[i];
object[] piHutangDetail = new object[9];
piHutangDetail[0] = false;
piHutangDetail[1] = piHut.PiHutangDesc;
piHutangDetail[2] = piHut.PiHutangJatuhTempo;
piHutangDetail[3] = piHut.PiHutangJumlah;
piHutangDetail[4] = piHut.PiHutangRetur;
piHutangDetail[5] = piHut.PiHutangSisa;
piHutangDetail[6] = string.Empty;
piHutangDetail[7] = piHut.PiHutangId;
piHutangDetail[8] = piHut.SubAccountId;
tPiHutangDataGridView.Rows.Add(piHutangDetail);
}
}
private void FillVTotalTransactionDataSource(decimal p)
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5];
if (gudangIdComboBox.SelectedIndex != 0)
{
int t = 0;
if (int.TryParse(gudangIdComboBox.SelectedValue.ToString(), out t))
{
expArrays[0] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.GudangId, int.Parse(gudangIdComboBox.SelectedValue.ToString()));
}
}
if (locationIdComboBox.SelectedIndex != 0)
{
expArrays[1] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.LocationId, locationIdComboBox.SelectedValue);
}
if (transactionByComboBox.SelectedIndex != 0)
{
expArrays[2] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.TransactionBy, transactionByComboBox.SelectedValue);
}
if (FilterByDateCheckBox.Checked)
{
expArrays[3] = NHibernate.Expression.Expression.Between(VTotalTransactionDealer.ColumnNames.TransactionDate, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
}
expArrays[4] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.TransactionStatus, listOfTransaction.ToString());
NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1];
orderArrays[0] = NHibernate.Expression.Order.Asc(VTotalTransactionDealer.ColumnNames.TransactionDate);
bs = new BindingSource();
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDealer), expArrays, orderArrays);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDealer", bs));
}
private void DeleteTransaction(DateTime from, DateTime to)
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2];
expArrays[0] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString()));
expArrays[1] = NHibernate.Expression.Expression.Between(TTransaction.ColumnNames.TransactionDate, from, to);
IList list = DataMaster.GetList(typeof(TTransaction), expArrays, null);
TTransaction t;
TTransactionDetail det;
for (int i = 0; i < list.Count; i++)
{
t = (TTransaction)list[i];
IList listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, t.TransactionId);
for (int j = 0; j < listDet.Count; j++)
{
det = (TTransactionDetail)listDet[j];
DataMaster.Delete(det);
}
DataMaster.Delete(t);
}
MessageBox.Show("Transaksi Berhasil dihapus", "Hapus Transaksi Berhasil.", MessageBoxButtons.OK, MessageBoxIcon.Information);
groupBox1.Enabled = false;
}
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();
}
private void FillVStockDetailTransactionDealerDataSource()
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[10];
if (itemIdComboBox.SelectedIndex != 0)
{
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, itemIdComboBox.SelectedValue);
}
if (stockDesc1ComboBox.SelectedIndex != 0)
{
expArrays[1] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDesc1, stockDesc1ComboBox.SelectedValue);
}
if (!string.IsNullOrEmpty(stockDesc2TextBox.Text.Trim()))
{
expArrays[2] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc2, stockDesc2TextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
}
if (!string.IsNullOrEmpty(stockDesc3TextBox.Text.Trim()))
{
expArrays[3] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc3, stockDesc3TextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
}
if (listOfReports != ListOfReports.ReportRecapSisaStock)
{
if (FilterByDateCheckBox.Checked)
{
expArrays[4] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
}
//jika status stok terjual
if (StatusStockComboBox.SelectedIndex == 1)
{
expArrays[5] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
}
//jika status stok belum terjual
else if (StatusStockComboBox.SelectedIndex == 2)
{
expArrays[5] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value);
}
}
//jika gudang visible
if (ShowGudangIdPanel)
{
if (gudangIdComboBox.SelectedIndex != 0)
{
expArrays[6] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.GudangId, Convert.ToInt32(gudangIdComboBox.SelectedValue));
try
{
if (Convert.ToInt32(gudangIdComboBox.SelectedValue) == 4)
{
if (locationIdComboBox.SelectedIndex != 0)
{
expArrays[7] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.LocatonId, locationIdComboBox.SelectedValue);
}
}
}
catch (Exception)
{
}
}
}
if (listOfReports == ListOfReports.ReportRecapSisaStock)
{
expArrays[8] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value), NHibernate.Expression.Expression.Gt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1)));
//expArrays[8] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1));
expArrays[9] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateIn, transactionDateToDateTimePicker.Value.AddDays(1));
}
IList listStok = DataMaster.GetList(typeof(VTStockDetail), expArrays, null);
VTStockDetail s;
IList list = new List <VStockDetailTransactionDealer>();
VStockDetailTransactionDealer v;
VTotalTransactionDealer det;
for (int i = 0; i < listStok.Count; i++)
{
s = listStok[i] as VTStockDetail;
v = new VStockDetailTransactionDealer();
v.ChannelName = s.ChannelName;
v.ColourDesc = s.ColourDesc;
det = DataMaster.GetObjectByProperty(typeof(VTotalTransactionDealer), VTotalTransactionDealer.ColumnNames.StockId, s.StockId, VTotalTransactionDealer.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()) as VTotalTransactionDealer;
if (det != null)
{
v.CustomerName = det.CustomerName;
}
v.GudangId = s.GudangId;
v.GudangName = s.GudangName;
v.ItemId = s.ItemId;
v.ItemName = s.ItemName;
v.LocatonId = s.LocatonId;
v.StockBarcodeId = s.StockBarcodeId;
v.StockDateIn = s.StockDateIn;
v.StockDateOut = s.StockDateOut;
v.StockDesc1 = s.StockDesc1;
v.StockDesc2 = s.StockDesc2;
v.StockDesc3 = s.StockDesc3;
v.StockId = s.StockId;
v.StockInBy = s.StockInBy;
v.StockIsAvailable = s.StockIsAvailable;
v.StockOutBy = s.StockOutBy;
v.StockPriceIn = s.StockPriceIn;
v.StockPriceOut = s.StockPriceOut;
list.Add(v);
}
//expArrays[8] =NHibernate.Expression.Expression NHibernate.Expression.Expression.Eq(VStockDetailTransactionDealer.ColumnNames.ItemId, itemIdComboBox.SelectedValue);
bs = new BindingSource();
bs.DataSource = list;
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VStockDetailTransactionDealer", bs));
}
private void UpdatePrice(string ItemId)
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2];
expArrays[0] = NHibernate.Expression.Expression.Between(TTransaction.ColumnNames.TransactionDate, transactionDateFromDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
expArrays[1] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Purchase.ToString()));
IList listTrans = DataMaster.GetList(typeof(TTransaction), expArrays, null);
IList listDet;
IList listStock;
TTransaction t;
TTransactionDetail det;
TStock stok;
decimal total = decimal.Zero;
for (int i = 0; i < listTrans.Count; i++)
{
t = listTrans[i] as TTransaction;
total = decimal.Zero;
listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, t.TransactionId, TTransactionDetail.ColumnNames.ItemId, ItemId);
for (int j = 0; j < listDet.Count; j++)
{
det = listDet[j] as TTransactionDetail;
if (t.TransactionStatus == ListOfTransaction.Sales.ToString())
{
det.Price = itemPriceMaxNumericUpDown.Value;
DataMaster.UpdatePersistence(det);
total += det.Price;
}
else if (true)
{
det.Price = itemPricePurchaseNumericUpDown.Value;
DataMaster.UpdatePersistence(det);
total += det.Price;
}
listStock = DataMaster.GetListEq(typeof(TStock), TStock.ColumnNames.StockId, det.StockId, TStock.ColumnNames.ItemId, ItemId);
for (int k = 0; k < listStock.Count; k++)
{
stok = listStock[k] as TStock;
if (t.TransactionStatus == ListOfTransaction.Sales.ToString())
{
stok.StockPriceIn = itemPriceMaxNumericUpDown.Value;
}
else if (true)
{
stok.StockPriceOut = itemPricePurchaseNumericUpDown.Value;
}
}
}
if (listDet.Count > 0)
{
t.TransactionSubTotal = total;
t.TransactionGrandTotal = total;
if (t.TransactionPayment == ListOfPayment.Credit.ToString())
{
t.TransactionSisa = t.TransactionGrandTotal - t.TransactionPaid + t.TransactionPotongan;
t.TransactionPpn = t.TransactionGrandTotal - t.TransactionPaid + t.TransactionPotongan;
}
}
}
}
private void BindData(object sender, EventArgs e)
{
string myKeyWord = string.Empty;
string col = TStock.ColumnNames.StockDesc2;
if (sender == txt_SearchById)
{
if (!txt_SearchById.Text.Equals("<Cari Berdasar No Rangka>"))
{
myKeyWord = txt_SearchById.Text.Trim();
}
col = TStock.ColumnNames.StockDesc2;
}
else if (sender == txt_SearchByName)
{
if (!txt_SearchByName.Text.Equals("<Cari Berdasar No Mesin>"))
{
myKeyWord = txt_SearchByName.Text.Trim();
}
col = TStock.ColumnNames.StockDesc3;
}
//bindingSource_Search.Clear();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5];
expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, cb_ItemId.SelectedValue.ToString());
expArrays[1] = NHibernate.Expression.Expression.InsensitiveLike(col, myKeyWord, NHibernate.Expression.MatchMode.Anywhere);
expArrays[2] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.GudangId, GudangId);
if (!string.IsNullOrEmpty(LocationId))
{
expArrays[3] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.LocatonId, LocationId);
}
expArrays[4] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.StockIsAvailable, true);
IList listSearch = DataMaster.GetList(typeof(TStock), expArrays, null);
TStock stok;
MColour color;
MItem item;
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(TStock.ColumnNames.StockId);
dt.Columns.Add(TStock.ColumnNames.ItemId);
dt.Columns.Add(TStock.ColumnNames.StockDesc1);
dt.Columns.Add(TStock.ColumnNames.StockDesc2);
dt.Columns.Add(TStock.ColumnNames.StockDesc3);
for (int i = 0; i < listSearch.Count; i++)
{
stok = listSearch[i] as TStock;
dr = dt.NewRow();
dr[0] = stok.StockId;
//nama item
item = DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId) as MItem;
if (item == null)
{
item = new MItem();
}
dr[1] = item.ItemName;
//nama warna
color = DataMaster.GetObjectByProperty(typeof(MColour), MColour.ColumnNames.ColourId, stok.StockDesc1) as MColour;
if (color == null)
{
color = new MColour();
}
dr[2] = color.ColourDesc;
dr[3] = stok.StockDesc2;
dr[4] = stok.StockDesc3;
dt.Rows.Add(dr);
}
bindingSource_Search.DataSource = dt;
//if (listSearch.Count > 0)
// bindingSource_Search.DataSource = listSearch;
}
