private void bindingSource_Master_PositionChanged(object sender, EventArgs e) { SetNavigatorDisplay(); MMenu mmenu; TMenuUser tmenu; IList listMenu = DataMaster.GetListEq(typeof(MMenu), MMenu.ColumnNames.SettingId, appl); grid_MenuAccess.Rows.Clear(); bool hasAccess = false; for (int i = 0; i < listMenu.Count; i++) { mmenu = (MMenu)listMenu[i]; tmenu = (TMenuUser)DataMaster.GetObjectByProperty(typeof(TMenuUser), TMenuUser.ColumnNames.UserName, userNameTextBox.Text, TMenuUser.ColumnNames.MenuId, mmenu.MenuId, TMenuUser.ColumnNames.SettingId, appl); if (tmenu != null) { hasAccess = tmenu.HasAccess; } else { hasAccess = false; } grid_MenuAccess.Rows.Add(); grid_MenuAccess.Rows[i].Cells[0].Value = hasAccess; grid_MenuAccess.Rows[i].Cells[1].Value = mmenu.MenuName; grid_MenuAccess.Rows[i].Cells[2].Value = mmenu.MenuId; } }
private void FillVTransactionSource(string transStatus, string transactionBy) { bs = new BindingSource(); bs.Clear(); //if (!transStatus.Equals(lbl_Param1.Name)) bs.DataSource = DataMaster.GetListEq(typeof(VTransaction), VTransaction.ColumnNames.TransactionStatus, transStatus, VTransaction.ColumnNames.TransactionBy, transactionBy); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTransaction", bs)); }
private void BindData() { mSettingBindingSource.Clear(); if (DataMaster.GetListEq(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct).Count > 0) { mSettingBindingSource.DataSource = DataMaster.GetListEq(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); tBilliardSettingBindingSource.DataSource = DataMaster.GetListEq(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); } }
private void BindData() { IList listMaster = DataMaster.GetListEq(typeof(MItem), MItem.ColumnNames.ItemTypeId, 1); if (listMaster.Count > 0) { bindingSource_Master.DataSource = listMaster; } bindingSource_Master_PositionChanged(null, null); detailControl_KeyDown(null, null); }
private void bindingSource_Master_PositionChanged(object sender, EventArgs e) { SetNavigatorDisplay(); mSupplierAccountBindingSource.Clear(); IList listAccount = DataMaster.GetListEq(typeof(MSupplierAccount), MSupplierAccount.ColumnNames.SupplierId, supplierIdTextBox.Text); if (listAccount.Count > 0) { mSupplierAccountBindingSource.DataSource = listAccount; } SetAccountTab(false); }
private void UpdateGiroMaturity() { IList listGiro = DataMaster.GetListEq(typeof(TGiro), TGiro.ColumnNames.GiroStatus, ListOfGiroStatus.Baru.ToString()); TGiro g; for (int i = 0; i < listGiro.Count; i++) { g = (TGiro)listGiro[i]; if (Convert.ToDateTime(g.GiroMaturityDate.ToShortDateString()) <= Convert.ToDateTime(DateTime.Now.ToShortDateString())) { g.GiroStatus = ListOfGiroStatus.JatuhTempo.ToString(); DataMaster.UpdatePersistence(g); } } }
private void BindData(string keyWord, string columnName) { string myKeyWord = "%" + keyWord + "%"; bindingSource_Search.Clear(); IList listSearch = null; if (TransactionId == null) { listSearch = DataMaster.GetListLike(typeof(MPacket), columnName, myKeyWord); } else { tableLayoutPanel1.RowStyles[0].Height = 0f; listSearch = new List <MPacket>(); IList detList = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, Convert.ToDecimal(TransactionId), TTransactionDetail.ColumnNames.IsPacket, true); TTransactionDetail det; MPacket paket; for (int i = 0; i < detList.Count; i++) { det = (TTransactionDetail)detList[i]; paket = (MPacket)DataMaster.GetObjectByProperty(typeof(MPacket), MPacket.ColumnNames.PacketId, det.ItemId); if (paket != null) { listSearch.Add(paket); } } } if (listSearch.Count > 0) { bindingSource_Search.DataSource = listSearch; } }
private void bindingSource_Master_PositionChanged(object sender, EventArgs e) { if (bindingSource_Master.Count > 0) { setEnableGroupBox1(false); bindingNavigatorAddNewItem.Enabled = true; bindingNavigatorEditItem.Enabled = true; bindingNavigatorDeleteItem.Enabled = true; bindingNavigatorSaveItem.Enabled = false; } else { setEnableGroupBox1(false); bindingNavigatorAddNewItem.Enabled = true; bindingNavigatorEditItem.Enabled = false; bindingNavigatorDeleteItem.Enabled = false; bindingNavigatorSaveItem.Enabled = false; } MMenu mmenu; TMenuUser tmenu; IList listMenu = DataMaster.GetListEq(typeof(MMenu), MMenu.ColumnNames.SettingId, AppCode.AssemblyProduct); grid_MenuAccess.Rows.Clear(); bool hasAccess = false; for (int i = 0; i < listMenu.Count; i++) { mmenu = (MMenu)listMenu[i]; tmenu = (TMenuUser)DataMaster.GetObjectByProperty(typeof(TMenuUser), TMenuUser.ColumnNames.UserName, userNameTextBox.Text, TMenuUser.ColumnNames.MenuId, mmenu.MenuId, TMenuUser.ColumnNames.SettingId, AppCode.AssemblyProduct); if (tmenu != null) { hasAccess = tmenu.HasAccess; } else { hasAccess = false; } grid_MenuAccess.Rows.Add(); grid_MenuAccess.Rows[i].Cells[0].Value = hasAccess; grid_MenuAccess.Rows[i].Cells[1].Value = mmenu.MenuName; grid_MenuAccess.Rows[i].Cells[2].Value = mmenu.MenuId; } }
private void DeleteTMenuUser() { IList listMenuUser = DataMaster.GetListEq(typeof(TMenuUser), TMenuUser.ColumnNames.UserName, userNameTextBox.Text, TMenuUser.ColumnNames.SettingId, appl); for (int i = 0; i < listMenuUser.Count; i++) { menuUser = (TMenuUser)listMenuUser[i]; DataMaster.Delete(menuUser); } }
private void DeleteTMenuUser() { IList listMenuUser = DataMaster.GetListEq(typeof(TMenuUser), "UserName", userNameTextBox.Text); for (int i = 0; i < listMenuUser.Count; i++) { menuUser = (TMenuUser)listMenuUser[i]; DataMaster.Delete(menuUser); } }
private void bindingSource_Master_PositionChanged(object sender, EventArgs e) { itemIdTextBox.Enabled = true; itemStokLabel.Text = "Stok Item"; itemGudangStokBindingSource.Clear(); IList liststok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text, ItemGudangStok.ColumnNames.GudangId, 1); if (liststok.Count > 0) { itemGudangStokBindingSource.DataSource = liststok; } }
private void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e) { mSettingBindingSource.Clear(); mSettingBindingSource.DataSource = DataMaster.GetListEq(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); e.DataSources.Add(new ReportDataSource("Inventori_Data_MSetting", mSettingBindingSource)); if (lbl_TempReport.Text.Equals(ListOfReports.MItem.ToString())) { BindingSource bsstok = new BindingSource(); bsstok.DataSource = DataMaster.GetAll(typeof(ItemGudangStok)); e.DataSources.Add(new ReportDataSource("Inventori_Data_ItemGudangStok", bsstok)); } }
private void FillVRekapSubAccountDataSource(string period) { bs = new BindingSource(); //IList listVRekap = new List<VRekapSubAccount>(); //IList listRekap = DataMaster.GetListEq(typeof(TRekapSubAccount),TRekapSubAccount.ColumnNames., TRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period); //TRekapSubAccount rekap; //VRekapSubAccount vrekap; //MSubAccount sub; //MAccount acc; //for (int i = 0; i < listVRekap.Count; i++) //{ // rekap = (TRekapSubAccount)listVRekap[i]; // sub = (MSubAccount)DataMaster.GetObjectByProperty(typeof(MSubAccount), MSubAccount.ColumnNames.SubAccountId, rekap.SubAccountId); // acc = (MAccount)DataMaster.GetObjectByProperty(typeof(MAccount), MAccount.ColumnNames.AccountId, rekap.AccountId); // vrekap = new VRekapSubAccount(); // if (acc != null) // { // vrekap.AccountDesc = acc.AccountDesc; // vrekap.AccountId = acc.AccountId; // vrekap.AccountName = acc.AccountName; // vrekap.AccountPosition = acc.AccountPosition; // vrekap.AccountSaldo = acc.AccountSaldo; // vrekap.AccountStatus = acc.AccountStatus; // } // vrekap.RekapSubaccountDesc = rekap.RekapSubaccountDesc; // vrekap.RekapSubAccountId = rekap.RekapSubAccountId; // vrekap.RekapSubAccountPeriode = rekap.RekapSubAccountPeriode; // vrekap.RekapSubaccountSaldo = rekap.RekapSubaccountSaldo; // if (sub != null) // { // vrekap.SubAccountDesc = sub.SubAccountDesc; // vrekap.SubAccountName = sub.SubAccountName; // } // vrekap.SubAccountId = rekap.SubAccountId; // listVRekap.Add(vrekap); //} //bs.DataSource = listVRekap; bs.DataSource = DataMaster.GetListEq(typeof(VRekapSubAccount), VRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VRekapSubAccount", bs)); }
private void FillGridPacketItem() { mPacketItemDataGridView.Rows.Clear(); IList listItemPaket = DataMaster.GetListEq(typeof(MPacketItem), MPacketItem.ColumnNames.PacketId, packetIdTextBox.Text); MPacketItem paketItem; MItem item; object[] paketitemRow; string itemName = string.Empty; decimal itemPrice, itemPriceTot; for (int i = 0; i < listItemPaket.Count; i++) { paketItem = (MPacketItem)listItemPaket[i]; item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, paketItem.ItemId); if (item != null) { itemName = item.ItemName; itemPrice = item.ItemPricePurchase; } else { itemName = string.Empty; itemPrice = decimal.Zero; } itemPriceTot = itemPrice * paketItem.PacketItemQuantity; paketitemRow = new object[5]; paketitemRow[0] = paketItem.ItemId; paketitemRow[1] = itemName; paketitemRow[2] = paketItem.PacketItemQuantity; paketitemRow[3] = itemPrice; paketitemRow[4] = itemPriceTot; mPacketItemDataGridView.Rows.Add(paketitemRow); } }
public static void SetTransactionTextBoxSuggest(TextBox txt, ListOfTransaction tr, string SupplierId) { txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txt.AutoCompleteSource = AutoCompleteSource.CustomSource; txt.AutoCompleteCustomSource.Clear(); DataMasterMgtServices DataMaster = new DataMasterMgtServices(); IList listTrans = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, tr.ToString(), TTransaction.ColumnNames.TransactionBy, SupplierId); TTransaction trans; for (int i = 0; i < listTrans.Count; i++) { trans = (TTransaction)listTrans[i]; txt.AutoCompleteCustomSource.Add(trans.TransactionFactur); } }
void SetInitialCommonSettings() { //kas dropdownlist mSubAccountBindingSource.DataSource = DataMaster.GetListEq(typeof(MSubAccount), MSubAccount.ColumnNames.AccountId, AppCode.GetKasAccountNo()); //numeric up down ModuleControlSettings.SetNumericUpDown(kasJumlahNumericUpDown, true); ModuleControlSettings.SetNumericUpDown(journalJumlahNumericUpDown); //add column to grid for (int i = 0; i < 4; i++) { tJournalDataGridView.Columns.Add(i.ToString(), i.ToString()); } //set width for grid view tJournalDataGridView.Columns[0].Width = label_AccId.Width; tJournalDataGridView.Columns[1].Width = label_AccName.Width; tJournalDataGridView.Columns[2].Width = label_JournalJumlah.Width; tJournalDataGridView.Columns[3].Width = label_JournalDesc.Width; //set format tJournalDataGridView.Columns[2].DefaultCellStyle.Format = "N"; tJournalDataGridView.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //journal date ModuleControlSettings.SetDateTimePicker(journalDateDateTimePicker, false); //search sub acc PictureBox searchPic = new PictureBox(); ModuleControlSettings.SetSearchPictureBox(subAccountIdTextBox, ListOfSearchWindow.SearchSubAccount.ToString(), searchPic); searchPic.Click += new EventHandler(searchPicSubAcc_Click); subAccountIdTextBox.Controls.Add(searchPic); //set display if (JournalStatus == ListOfJournalStatus.Debet) { SetInitialDebetSettings(); } else if (JournalStatus == ListOfJournalStatus.Kredit) { SetInitialKreditSettings(); } }
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 bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(itemIdTextBox.Text.Trim())) { if (MessageBox.Show("Anda yakin menghapus data?", "Konfirmasi Hapus Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, itemIdTextBox.Text); DataMaster.Delete(item); IList listStok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text); ItemGudangStok stok; for (int i = 0; i < listStok.Count; i++) { stok = (ItemGudangStok)listStok[i]; if (stok != null) { DataMaster.Delete(stok); } } ModuleControlSettings.SaveLog(ListOfAction.Delete, itemIdTextBox.Text, ListOfTable.MItem, lbl_UserName.Text); BindData(); } } }
private void SetInitialCommonSettings() { //servce typr mItemBindingSource.DataSource = DataMaster.GetListEq(typeof(MItem), MItem.ColumnNames.ItemTypeId, 2); //set date time picker ModuleControlSettings.SetDateTimePicker(transactionDateDateTimePicker, false); ModuleControlSettings.SetDateTimePicker(serviceRequestDateDateTimePicker, true); ModuleControlSettings.SetDateTimePicker(serviceStartWorkDateTimePicker, true); ModuleControlSettings.SetDateTimePicker(serviceEndWorkDateTimePicker, true); //set numeric up down ModuleControlSettings.SetNumericUpDown(quantityNumericUpDown); ModuleControlSettings.SetNumericUpDown(priceNumericUpDown); ModuleControlSettings.SetNumericUpDown(jumlahNumericUpDown, true); ModuleControlSettings.SetNumericUpDown(discNumericUpDown); ModuleControlSettings.SetNumericUpDown(totalNumericUpDown, true); ModuleControlSettings.SetNumericUpDown(transactionSubTotalNumericUpDown, true); ModuleControlSettings.SetNumericUpDown(serviceChargeNumericUpDown, true); ModuleControlSettings.SetNumericUpDown(transactionGrandTotalNumericUpDown, true); //search item PictureBox searchPic = new PictureBox(); ModuleControlSettings.SetSearchPictureBox(itemIdTextBox, ListOfSearchWindow.SearchItem.ToString(), searchPic); searchPic.Click += new EventHandler(searchPicItem_Click); itemIdTextBox.Controls.Add(searchPic); //search customer searchPic = new PictureBox(); ModuleControlSettings.SetSearchPictureBox(transactionByTextBox, ListOfSearchWindow.SearchCustomer.ToString(), searchPic); searchPic.Click += new EventHandler(searchPicTransactionBy_Click); transactionByTextBox.Controls.Add(searchPic); //search employee searchPic = new PictureBox(); ModuleControlSettings.SetSearchPictureBox(servicePicTextBox, ListOfSearchWindow.SearchEmployee.ToString(), searchPic); searchPic.Click += new EventHandler(searchPicEmployee_Click); servicePicTextBox.Controls.Add(searchPic); }
private void SaveTransactionDetail() { TTransactionDetail det; ItemGudangStok stok; MItem item; TStokCard krt; //clear data if from billiard desk if (!lbl_TempDesk.Text.Equals(ListOfDesk.Cafe.ToString())) { IList listOfTransDetail = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, Convert.ToDecimal(txt_TransactionId.Text)); for (int i = 0; i < listOfTransDetail.Count; i++) { det = (TTransactionDetail)listOfTransDetail[i]; DataMaster.Delete(det); } TDesk t = (TDesk)DataMaster.GetObjectByProperty(typeof(TDesk), TDesk.ColumnNames.DeskTransactionId, Convert.ToDecimal(txt_TransactionId.Text)); if (t != null) { t.DeskStatus = ListOfBilliardPaymentStatus.Paid.ToString(); t.ModifiedBy = lbl_UserName.Text; t.ModifiedDate = DateTime.Now; DataMaster.UpdatePersistence(t); } } bool AddStok = true; decimal saldo = 0; if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturPurchase.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString())) { AddStok = false; } else { AddStok = true; } for (int i = 0; i < grid_Trans.Rows.Count; i++) { saldo = 0; det = new TTransactionDetail(); det.Disc = Convert.ToDecimal(grid_Trans.Rows[i].Cells[5].Value); det.ItemId = grid_Trans.Rows[i].Cells[0].Value.ToString(); det.Ppn = 0; det.Price = Convert.ToDecimal(grid_Trans.Rows[i].Cells[3].Value); det.Quantity = Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); //if corection, save item quantity for detail total if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Correction.ToString())) { det.Total = Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); } else { det.Total = Convert.ToDecimal(grid_Trans.Rows[i].Cells[6].Value); } det.TransactionId = Convert.ToDecimal(txt_TransactionId.Text); det.Jumlah = Convert.ToDecimal(grid_Trans.Rows[i].Cells[4].Value); det.ModifiedBy = lbl_UserName.Text; det.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(det); item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, grid_Trans.Rows[i].Cells[0].Value.ToString()); if (item != null) { //if item == barang if (item.ItemTypeId == 1) { //change stok stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, grid_Trans.Rows[i].Cells[0].Value.ToString()); if (stok != null) { if (AddStok) { saldo = stok.ItemStok + Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); } else { saldo = stok.ItemStok - Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); } stok.ItemStok = saldo; stok.ModifiedBy = lbl_UserName.Text; stok.ModifiedDate = DateTime.Now; DataMaster.UpdatePersistence(stok); } else { stok = new ItemGudangStok(); stok.GudangId = 1; stok.ItemId = det.ItemId; stok.ItemMaxStok = 0; stok.ItemMinStok = 0; if (AddStok) { stok.ItemStok = det.Quantity; } else { stok.ItemStok = det.Quantity * -1; } stok.ModifiedBy = lbl_UserName.Text; stok.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(stok); } } } krt = new TStokCard(); krt.ItemId = grid_Trans.Rows[i].Cells[0].Value.ToString(); krt.StokCardDate = DateTime.Now; krt.StokCardPic = lbl_UserName.Text; krt.StokCardQuantity = Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); krt.StokCardSaldo = saldo; krt.StokCardStatus = AddStok; krt.TransactionId = Convert.ToDecimal(txt_TransactionId.Text); krt.ModifiedBy = lbl_UserName.Text; krt.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(krt); } }
void SetInitialCommonSettings() { if (IsDelete) { if (PiHutang == ListOfPiHutangStatus.Piutang) { //beban penghapusan piutang dropdownlist mSubAccountBindingSource.DataSource = DataMaster.GetListEq(typeof(MSubAccount), MSubAccount.ColumnNames.SubAccountId, AppCode.GetPiutangBebanAccountNo()); } else if (PiHutang == ListOfPiHutangStatus.Hutang) { //pendapatan penghapusan hutang dropdownlist mSubAccountBindingSource.DataSource = DataMaster.GetListEq(typeof(MSubAccount), MSubAccount.ColumnNames.AccountId, AppCode.GetOtherRevenueAccountNo()); } } else { //kas dropdownlist mSubAccountBindingSource.DataSource = DataMaster.GetListEq(typeof(MSubAccount), MSubAccount.ColumnNames.AccountId, AppCode.GetKasAccountNo()); } //journal date ModuleControlSettings.SetDateTimePicker(journalDateDateTimePicker, false); //numeric up down ModuleControlSettings.SetNumericUpDown(journalJumlahNumericUpDown, true); //add column to grid tPiHutangDataGridView.ReadOnly = false; DataGridViewCheckBoxColumn cekColoumn = new DataGridViewCheckBoxColumn(false); cekColoumn.ReadOnly = false; tPiHutangDataGridView.Columns.Add(cekColoumn); for (int i = 1; i < 9; i++) { tPiHutangDataGridView.Columns.Add(i.ToString(), i.ToString()); tPiHutangDataGridView.Columns[i].ReadOnly = true; } //set width for grid view tPiHutangDataGridView.Columns[0].Width = label_Pay.Width; tPiHutangDataGridView.Columns[1].Width = label_FacturNo.Width; tPiHutangDataGridView.Columns[2].Width = label_DueDate.Width; tPiHutangDataGridView.Columns[3].Width = label_Jumlah.Width; tPiHutangDataGridView.Columns[4].Width = label_Retur.Width; tPiHutangDataGridView.Columns[5].Width = label_Sisa.Width; tPiHutangDataGridView.Columns[6].Width = label_Ammount.Width; tPiHutangDataGridView.Columns[7].Width = label_Ammount.Width; tPiHutangDataGridView.Columns[8].Width = label_Ammount.Width; tPiHutangDataGridView.Columns[2].DefaultCellStyle.Format = ModuleControlSettings.DateFormat(); //set format for (int i = 3; i < 7; i++) { tPiHutangDataGridView.Columns[i].DefaultCellStyle.Format = "N"; tPiHutangDataGridView.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } tPiHutangDataGridView.Columns[6].ReadOnly = false; tPiHutangDataGridView.Columns[7].Visible = false; tPiHutangDataGridView.Columns[8].Visible = false; //journal date ModuleControlSettings.SetDateTimePicker(journalDateDateTimePicker, false); //set display if (PiHutang == ListOfPiHutangStatus.Hutang) { SetInitialHutangSettings(); } else if (PiHutang == ListOfPiHutangStatus.Piutang) { SetInitialPiutangSettings(); } }
private void CalculateItemValue() { //IList listGudang = DataMaster.GetAll(typeof(MGudang)); //MGudang gud; //IList listItemStok; //ItemGudangStok stok; //MItem item; //decimal itemvalue = 0; //for (int i = 0; i < listGudang.Count; i++) //{ // gud = (MGudang)listGudang[i]; // listItemStok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.GudangId, gud.GudangId); // for (int j = 0; j < listItemStok.Count; j++) // { // stok = (ItemGudangStok)listItemStok[j]; // item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId); // if (item != null) // { // itemvalue += stok.ItemStok * item.ItemPricePurchaseAvg; // } // } //} IList listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); IList listDet; TTransaction trans; TTransactionDetail det; decimal salesTot = 0; decimal retSalesTot = 0; decimal hppSalesTot = 0; decimal hppRetSalesTot = 0; //decimal purTot = 0; //decimal retPurTot = 0; for (int i = 0; i < listTrans.Count; i++) { trans = (TTransaction)listTrans[i]; if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString() || trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString()) { salesTot += trans.TransactionGrandTotal; } else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { retSalesTot += trans.TransactionGrandTotal; } listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int j = 0; j < listDet.Count; j++) { det = (TTransactionDetail)listDet[j]; if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString()) { hppSalesTot += det.CostPrice; } else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { hppRetSalesTot += det.CostPrice; } } } //else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) // retSalesTot += trans.TransactionGrandTotal; //else if (trans.TransactionStatus == ListOfTransaction.Purchase.ToString()) // purTot += trans.TransactionGrandTotal; //else if (trans.TransactionStatus == ListOfTransaction.ReturPurchase.ToString()) // retPurTot += trans.TransactionGrandTotal; } decimal salesNet = salesTot - retSalesTot; decimal hppNet = hppSalesTot - hppRetSalesTot; decimal laba = salesNet - hppNet; ListViewItem v = new ListViewItem(); v.Text = "Penjualan"; v.SubItems.Add(salesTot.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Retur Penjualan"; v.SubItems.Add(retSalesTot.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = string.Empty; v.SubItems.Add("--------------------------"); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Penjualan Bersih"; v.SubItems.Add(string.Empty); v.SubItems.Add(salesNet.ToString("N")); listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Pembelian"; //v.SubItems.Add(purTot.ToString("N")); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Retur Pembelian"; //v.SubItems.Add(retPurTot.ToString("N")); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = string.Empty; //v.SubItems.Add("--------------------------"); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Pembelian Bersih"; //v.SubItems.Add(string.Empty); //v.SubItems.Add(purNet.ToString("N")); //listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Harga Pokok Penjualan Periode " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); v.SubItems.Add(string.Empty); v.SubItems.Add(hppNet.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = string.Empty; v.SubItems.Add(string.Empty); v.SubItems.Add("--------------------------"); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Laba / Rugi"; v.SubItems.Add(string.Empty); v.SubItems.Add(laba.ToString("N")); listView1.Items.Add(v); SaveRekap(listAcc.Sales, "Penjualan", salesTot); SaveRekap(listAcc.ReturSales, "Retur Penjualan", retSalesTot); SaveRekap(listAcc.SalesNet, "Penjualan Bersih", salesNet); SaveRekap(listAcc.HPP, "Harga Pokok Penjualan", hppNet); SaveRekap(listAcc.RugiLaba, "Laba / Rugi", laba); //string voucherno = AppCode.GetVoucherNo(); //TJournal jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Persediaan barang akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = itemvalue; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Debet.ToString(); //jur.SubAccountId = AppCode.GetPersediaanAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); //jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Ikhtiar Rugi Laba bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = itemvalue; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Kredit.ToString(); //jur.SubAccountId = AppCode.GetIkhtiarRLAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); }
private void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e) { mSettingBindingSource.Clear(); mSettingBindingSource.DataSource = DataMaster.GetListEq(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); e.DataSources.Add(new ReportDataSource("Inventori_Data_MSetting", mSettingBindingSource)); }
public static string GenerateFacturNo(ListOfTransaction tr, string DeskNo) { //return ""; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AssemblyProduct); if (set != null) { IList listTrans = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, tr.ToString()); string facturNoTemplate = set.FacturNoFormat; int no = listTrans.Count + 1; int len = set.FacturNoLength - no.ToString().Length; string factur = no.ToString(); for (int i = 0; i < len; i++) { factur = "0" + factur; } string typeTrans = ""; switch (tr) { case ListOfTransaction.Correction: typeTrans = "Kor"; break; case ListOfTransaction.Purchase: typeTrans = "P"; break; case ListOfTransaction.PurchaseOrder: typeTrans = "PO"; break; case ListOfTransaction.ReturPurchase: typeTrans = "RP"; break; case ListOfTransaction.ReturSales: typeTrans = "RS"; break; case ListOfTransaction.ReturSalesVIP: typeTrans = "RSVIP"; break; case ListOfTransaction.Sales: typeTrans = "S"; break; case ListOfTransaction.SalesVIP: typeTrans = "SVIP"; break; case ListOfTransaction.Usage: typeTrans = "U"; break; default: break; } return(facturNoTemplate.Replace("[xxx]", factur).Replace("[meja]", DeskNo).Replace("[tanggal]", DateTime.Now.Day.ToString()).Replace("[bulan]", DateTime.Now.Month.ToString()).Replace("[tahun]", DateTime.Now.Year.ToString()).Replace("[TipeTransaksi]", typeTrans)); } else { return(""); } }
private void FillVRekapSubAccountDataSource(string period) { bs = new BindingSource(); bs.DataSource = DataMaster.GetListEq(typeof(VRekapSubAccount), VRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VRekapSubAccount", bs)); }
private void FillVTotalTransactionServiceDataSourceByCustomer() { IList listSrv = new List <VTransactionService>(); IList listCust = DataMaster.GetListEq(typeof(MCustomer), MCustomer.ColumnNames.CustomerStatus, ListOfCustomerStatus.ServiceBerkala.ToString()); MCustomer cust; VTransactionService trans; IList listTemp; for (int i = 0; i < listCust.Count; i++) { cust = (MCustomer)listCust[i]; listTemp = DataMaster.GetListEq(typeof(VTransactionService), VTransactionService.ColumnNames.TransactionStatus, ListOfTransaction.Service.ToString(), VTransactionService.ColumnNames.TransactionBy, cust.CustomerId); for (int j = 0; j < listTemp.Count; j++) { trans = (VTransactionService)listTemp[j]; if (trans != null) { listSrv.Add(trans); } } } bs = new BindingSource(); bs.DataSource = listSrv; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionService", bs)); }
private void buttonOK_Click(object sender, EventArgs e) { if (MessageBox.Show("Anda yakin melakukan tutup periode?", "Konfirmasi tutup periode", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, dt_ClosingFrom.Value.ToLongDateString() + ";" + dt_ClosingTo.Value.ToLongDateString(), ListOfTable.TRekapTransaction, lbl_UserName.Text); pb_Loading.Visible = true; lbl_Loading.Visible = true; pb_Loading.Maximum = 5; pb_Loading.Value = 0; this.Refresh(); DateTime from = dt_ClosingFrom.Value; DateTime to = dt_ClosingTo.Value; IList listTrans; TTransaction trans; IList listDet; TTransactionDetail transDet; TRekapTransaction rekapTrans; decimal totSales = 0; decimal totSalesVIP = 0; decimal totReturSales = 0; decimal totReturSalesVIP = 0; decimal totPurchase = 0; decimal totReturPurchase = 0; decimal totCorrection = 0; decimal q = 0; pb_Loading.Value = 1; //sum transaction grand total by date listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString())) { totSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString())) { totSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString())) { totReturSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString())) { totReturSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString())) { totPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString())) { totReturPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString())) { listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int k = 0; k < listDet.Count; k++) { transDet = (TTransactionDetail)listDet[k]; q = transDet.Quantity; if (transDet.Quantity < 0) { q = transDet.Quantity * -1; } totCorrection += q; } } } rekapTrans = new TRekapTransaction(); rekapTrans.RekapDateFrom = from; rekapTrans.RekapDateTo = to; rekapTrans.TotalCorrection = totCorrection; rekapTrans.TotalPurchase = totPurchase; rekapTrans.TotalReturPurchase = totReturPurchase; rekapTrans.TotalReturSales = totReturSales; rekapTrans.TotalReturSalesVip = totReturSalesVIP; rekapTrans.TotalSales = totSales; rekapTrans.TotalSalesVip = totSalesVIP; rekapTrans.ModifiedBy = lbl_UserName.Text; rekapTrans.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapTrans); pb_Loading.Value = 4; ////delete before transaction //listTrans = DataMaster.GetListLessThan(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from); //for (int j = 0; j < listTrans.Count; j++) //{ // trans = (TTransaction)listTrans[j]; // DataMaster.Delete(trans); // listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); // for (int k = 0; k < listDet.Count; k++) // { // transDet = (TTransactionDetail)listDet[k]; // DataMaster.Delete(transDet); // } //} pb_Loading.Value = 5; pb_Loading.Visible = false; //lbl_Loading.Visible = false; buttonOK.Enabled = false; lbl_Loading.Text = "Tutup periode berhasil dilakukan."; try { System.Threading.Thread.Sleep(2000); } catch (Exception) { } f_ViewReport = new FormViewReport(); f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportTransactionTotal.ToString(); // f_ViewReport.lbl_Param1.Text = ListOfTransaction.Sales.ToString(); f_ViewReport.lbl_Param2.Text = dt_ClosingFrom.Value.ToString(); f_ViewReport.lbl_Param3.Text = dt_ClosingTo.Value.ToString(); f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation; f_ViewReport.WindowState = FormWindowState.Maximized; f_ViewReport.Show(); f_ViewReport.reportViewer1.RefreshReport(); //export to excel string exportDir = Application.StartupPath; TCafeSetting cafeSet = (TCafeSetting)DataMaster.GetObjectByProperty(typeof(TCafeSetting), TCafeSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (cafeSet != null) { exportDir = cafeSet.ExportedDir; } string fileName = exportDir + "\\Cafe " + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; Warning[] warnings; string[] streamids; string mimeType; string encoding; string filenameExtension; byte[] bytes = f_ViewReport.reportViewer1.LocalReport.Render( "Excel", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings); using (FileStream fs = new FileStream(fileName, FileMode.Create)) { fs.Write(bytes, 0, bytes.Length); } if (MessageBox.Show("Laporan berhasil diekspor ke \n " + fileName + "\n Buka file?", "Ekspor Laporan ke File Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Excel.Application exc = new Excel.Application; //Excel.Workbook wb = exc.Workbooks.Open( //System.IO.File.OpenRead(fileName); try { System.Diagnostics.Process.Start(fileName); } catch (Exception) { MessageBox.Show("File hasil ekspor gagal dibuka. Silahkan buka secara manual di lokasi hasil ekspor laporan.", "Laporan", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void CalculateItemValue() { //IList listGudang = DataMaster.GetAll(typeof(MGudang)); //MGudang gud; //IList listItemStok; //ItemGudangStok stok; //MItem item; //decimal itemvalue = 0; //for (int i = 0; i < listGudang.Count; i++) //{ // gud = (MGudang)listGudang[i]; // listItemStok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.GudangId, gud.GudangId); // for (int j = 0; j < listItemStok.Count; j++) // { // stok = (ItemGudangStok)listItemStok[j]; // item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId); // if (item != null) // { // itemvalue += stok.ItemStok * item.ItemPricePurchaseAvg; // } // } //} //IList listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); //IList listDet; //TTransaction trans; //TTransactionDetail det; //decimal salesTot = 0; //decimal retSalesTot = 0; //decimal hppSalesTot = 0; //decimal hppRetSalesTot = 0; ////decimal purTot = 0; ////decimal retPurTot = 0; //for (int i = 0; i < listTrans.Count; i++) //{ // trans = (TTransaction)listTrans[i]; // if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) // { // listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); // for (int j = 0; j < listDet.Count; j++) // { // det = (TTransactionDetail)listDet[j]; // if (trans.TransactionStatus == ListOfTransaction.Sales.ToString()) // hppSalesTot += det.CostPrice; // else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) // hppRetSalesTot += det.CostPrice; // } // } //} //decimal hppNet = hppSalesTot - hppRetSalesTot; //string voucherno = AppCode.GetVoucherNo(); //TJournal jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Harga Pokok Penjualan bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = hppNet; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Debet.ToString(); //jur.SubAccountId = AppCode.GetHPPAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); //jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Ikhtiar Rugi Laba bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = hppNet; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Kredit.ToString(); //jur.SubAccountId = AppCode.GetIkhtiarRLAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); IList listSubAcc = DataMaster.GetAll(typeof(MSubAccount)); MSubAccount sub; MAccount acc; decimal rl = 0; for (int i = 0; i < listSubAcc.Count; i++) { sub = (MSubAccount)listSubAcc[i]; SaveRekap(sub.AccountId, sub.SubAccountId, sub.SubAccountName, sub.SubAccountSaldo); acc = (MAccount)DataMaster.GetObjectByProperty(typeof(MAccount), MAccount.ColumnNames.AccountId, sub.AccountId); if (acc != null) { if (acc.AccountPosition == ListOfAccountPosition.RugiLaba.ToString()) { rl += sub.SubAccountSaldo; } } } string voucherno = AppCode.GetVoucherNo(); if (comboBox_Month.SelectedValue.ToString() == "12") { TJournal jur; IList listAcc = DataMaster.GetListEq(typeof(MAccount), MAccount.ColumnNames.AccountPosition, ListOfAccountPosition.RugiLaba.ToString()); for (int i = 0; i < listAcc.Count; i++) { acc = (MAccount)listAcc[i]; listSubAcc = DataMaster.GetListEq(typeof(MSubAccount), MSubAccount.ColumnNames.AccountId, acc.AccountId); for (int j = 0; j < listSubAcc.Count; j++) { sub = (MSubAccount)listSubAcc[j]; jur = new TJournal(); jur.JournalDate = DateTime.Today; jur.JournalDesc = "Jurnal Pembalik periode " + numericUpDown_Year.Value.ToString(); jur.JournalJumlah = sub.SubAccountSaldo; jur.JournalPic = lbl_UserName.Text; jur.JournalStatus = ListOfJournalStatus.Debet.ToString(); jur.SubAccountId = sub.SubAccountId; jur.VoucherNo = voucherno; jur.ModifiedBy = lbl_UserName.Text; jur.ModifiedDate = DateTime.Now; AppCode.SaveTJournal(jur); } } sub = (MSubAccount)DataMaster.GetObjectByProperty(typeof(MSubAccount), MSubAccount.ColumnNames.SubAccountId, AppCode.GetLabaDitahanAccountNo()); jur = new TJournal(); jur.JournalDate = DateTime.Today; jur.JournalDesc = "Laba Tahun " + numericUpDown_Year.Value.ToString(); jur.JournalJumlah = rl; jur.JournalPic = lbl_UserName.Text; jur.JournalStatus = ListOfJournalStatus.Kredit.ToString(); jur.SubAccountId = sub.SubAccountId; jur.VoucherNo = voucherno; jur.ModifiedBy = lbl_UserName.Text; jur.ModifiedDate = DateTime.Now; AppCode.SaveTJournal(jur); SaveRekap(sub.AccountId, sub.SubAccountId, sub.SubAccountName, rl); } else { SaveRekap("", "", "Laba/Rugi Periode Berjalan", rl); } }
private void buttonOK_Click(object sender, EventArgs e) { if (MessageBox.Show("Anda yakin melakukan tutup hari?", "Konfirmasi tutup hari", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } pb_Loading.Visible = true; lbl_Loading.Visible = true; pb_Loading.Maximum = 5; pb_Loading.Value = 0; this.Refresh(); DateTime from = dt_ClosingFrom.Value; DateTime to = dt_ClosingTo.Value; IList listEmployee = DataMaster.GetAll(typeof(MEmployee)); MEmployee emp; IList listTrans; TTransaction trans; IList listDet; TTransactionDetail transDet; TRekapTransaction rekapTrans; TRekapCommission rekapCom; decimal refereePrice = 0; string billiardItem = "Rental Meja"; TBilliardSetting bilSet = (TBilliardSetting)DataMaster.GetObjectByProperty(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (bilSet == null) { MessageBox.Show("Setting untuk menghitung komisi wasit tidak terdaftar, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK); return; } else { if (bilSet.RefereeBonus == 0) { MessageBox.Show("Bonus wasit 0, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK); return; } else { refereePrice = bilSet.RefereeBonus; } } decimal totSales = 0; decimal totSalesVIP = 0; decimal totReturSales = 0; decimal totReturSalesVIP = 0; decimal totPurchase = 0; decimal totReturPurchase = 0; decimal totCorrection = 0; decimal q = 0; decimal totDuration; decimal totBonus; pb_Loading.Value = 1; //looping for available employee for (int i = 0; i < listEmployee.Count; i++) { emp = (MEmployee)listEmployee[i]; listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, emp.EmployeeId); if (listTrans.Count > 0) { totDuration = 0; totBonus = 0; //looping for list transaction for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; //searching transaction detail for billiard item listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%"); if (listDet.Count > 0) { transDet = (TTransactionDetail)listDet[0]; if (transDet != null) { totDuration += transDet.Quantity; totBonus += transDet.Quantity * refereePrice; } } } totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice; rekapCom = new TRekapCommission(); rekapCom.EmployeeId = emp.EmployeeId; rekapCom.RefereePrice = refereePrice; rekapCom.RefereePriceVip = refereePrice; rekapCom.RekapBonus = totBonus; rekapCom.RekapDateFrom = from; rekapCom.RekapDateTo = to; //duration in minutes rekapCom.RekapTotalDuration = totDuration * 60; rekapCom.ModifiedBy = lbl_UserName.Text; rekapCom.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapCom); } } //trans does not have referee listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, string.Empty); if (listTrans.Count > 0) { totDuration = 0; totBonus = 0; //looping for list transaction for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; //searching transaction detail for billiard item listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%"); if (listDet.Count > 0) { transDet = (TTransactionDetail)listDet[0]; if (transDet != null) { totDuration += transDet.Quantity; totBonus += transDet.Quantity * refereePrice; } } } totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice; rekapCom = new TRekapCommission(); rekapCom.EmployeeId = string.Empty; rekapCom.RefereePrice = refereePrice; rekapCom.RefereePriceVip = refereePrice; rekapCom.RekapBonus = totBonus; rekapCom.RekapDateFrom = from; rekapCom.RekapDateTo = to; //duration in minutes rekapCom.RekapTotalDuration = totDuration * 60; rekapCom.ModifiedBy = lbl_UserName.Text; rekapCom.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapCom); } pb_Loading.Value = 3; //sum transaction grand total by date listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString())) { totSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString())) { totSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString())) { totReturSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString())) { totReturSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString())) { totPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString())) { totReturPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString())) { listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int k = 0; k < listDet.Count; k++) { transDet = (TTransactionDetail)listDet[k]; q = transDet.Quantity; if (transDet.Quantity < 0) { q = transDet.Quantity * -1; } totCorrection += q; } } } pb_Loading.Value = 4; rekapTrans = new TRekapTransaction(); rekapTrans.RekapDateFrom = from; rekapTrans.RekapDateTo = to; rekapTrans.TotalCorrection = totCorrection; rekapTrans.TotalPurchase = totPurchase; rekapTrans.TotalReturPurchase = totReturPurchase; rekapTrans.TotalReturSales = totReturSales; rekapTrans.TotalReturSalesVip = totReturSalesVIP; rekapTrans.TotalSales = totSales; rekapTrans.TotalSalesVip = totSalesVIP; rekapTrans.ModifiedBy = lbl_UserName.Text; rekapTrans.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapTrans); pb_Loading.Value = 5; pb_Loading.Visible = false; lbl_Loading.Visible = false; buttonOK.Enabled = false; FormViewReport f_ViewReport = new FormViewReport(); f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportListTransaction.ToString(); f_ViewReport.lbl_Param1.Text = ListOfTransaction.Sales.ToString(); f_ViewReport.lbl_Param2.Text = dt_ClosingFrom.Value.ToString(); f_ViewReport.lbl_Param3.Text = dt_ClosingTo.Value.ToString(); f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation; f_ViewReport.WindowState = FormWindowState.Maximized; f_ViewReport.Show(); }
private void FillVTotalTransactionDataSource(string TransactionStatus) { bs = new BindingSource(); bs.DataSource = DataMaster.GetListEq(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionStatus, TransactionStatus); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs)); }