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