public static string GetPPNPurchaseAccountNo()
{
string PPNPurchaseAccountNo = "PPNPurchase";
string defaultPPNPurchaseAccountNo = "320PPN001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, PPNPurchaseAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = PPNPurchaseAccountNo;
refer.NextId = defaultPPNPurchaseAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultPPNPurchaseAccountNo = refer.NextId;
}
return(defaultPPNPurchaseAccountNo);
}
public static string GetBiayaEkspedisiAccountNo()
{
string BiayaEkspedisiAccountNo = "BiayaEkspedisiAccountNo";
string defaultBiayaEkspedisiAccountNo = "830EKS001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, BiayaEkspedisiAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = BiayaEkspedisiAccountNo;
refer.NextId = defaultBiayaEkspedisiAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultBiayaEkspedisiAccountNo = refer.NextId;
}
return(defaultBiayaEkspedisiAccountNo);
}
public static string GetHPPAccountNo()
{
string HPPAccountNo = "HPPAccountNo";
string defaultHPPAccountNo = "700HAR001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, HPPAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = HPPAccountNo;
refer.NextId = defaultHPPAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultHPPAccountNo = refer.NextId;
}
return(defaultHPPAccountNo);
}
public static string GetCustomerName(string CustomerId, bool useSTNKName)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MCustomer cust = DataMaster.GetObjectByProperty(typeof(MCustomer), MCustomer.ColumnNames.CustomerId, CustomerId) as MCustomer;
if (cust != null)
{
if (useSTNKName)
{
return(cust.CustomerDesc);
}
else
{
return(cust.CustomerName);
}
}
else
{
return(string.Empty);
}
}
private void button2_Click(object sender, EventArgs e)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TStokCard card;
decimal stokId;
bool isDelete = false;;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
isDelete = Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value);
if (isDelete)
{
stokId = Convert.ToDecimal(dataGridView1.Rows[i].Cells[1].Value);
card = (TStokCard)DataMaster.GetObjectByProperty(typeof(TStokCard), TStokCard.ColumnNames.StokCardId, stokId);
if (card != null)
{
DataMaster.Delete(card);
}
}
}
}
public static string GenerateFacturNo(string DeskNo)
{
//DataMasterMgtServices DataMaster = new DataMasterMgtServices();
//MSetting set = (MSetting)DataMaster.GetObjectById(typeof(MSetting), AssemblyProduct);
//IList listTrans = DataMaster.GetAll(typeof(TTransaction));
//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;
//}
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AssemblyProduct);
//IList listTrans = DataMaster.GetAll(typeof(TTransaction));
string facturNoTemplate = set.FacturNoFormat;
//int no = listTrans.Count + 1;
int no = Convert.ToInt32(set.FacturNoNext) + 1;
int len = set.FacturNoLength - no.ToString().Length;
string factur = no.ToString();
for (int i = 0; i < len; i++)
{
factur = "0" + factur;
}
//update next faktur
set.FacturNoNext = set.FacturNoNext + 1;
DataMaster.UpdatePersistence(set);
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()));
}
private void buttonOK_Click(object sender, EventArgs e)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MUser user;
try
{
user = (MUser)DataMaster.GetObjectByProperty(typeof(MUser), MUser.ColumnNames.UserName, userNameTextBox.Text, MUser.ColumnNames.UserPassword, userPasswordTextBox.Text);
}
catch (Exception ex)
{
MessageBox.Show("Login gagal \n" + ex.Message, "Login Gagal", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (user != null)
{
if (!user.UserStatus)
{
RecreateBalloon();
balloonHelp.Caption = "Nama pengguna Tidak Valid";
balloonHelp.Content = "Nama pengguna tidak aktif";
balloonHelp.ShowBalloon(userNameTextBox);
userNameTextBox.Focus();
userNameTextBox.SelectAll();
return;
}
this.Hide();
if (f_Main != null)
{
if (!f_Main.IsDisposed)
{
f_Main.WindowState = FormWindowState.Normal;
f_Main.BringToFront();
f_Main.masukToolStripMenuItem.Enabled = false;
}
else
{
f_Main = new FormMain();
}
}
else
{
f_Main = new FormMain();
}
f_Main.toolStripStatusLabelLoginName.Text = userNameTextBox.Text;
//f_Main.FilterPriviledge();
f_Main.Show();
Inventori.Module.ModuleControlSettings.SaveLog(ListOfAction.Login, string.Empty, ListOfTable.None, userNameTextBox.Text);
}
else
{
RecreateBalloon();
balloonHelp.Caption = "Login Tidak Valid";
balloonHelp.Content = "Nama pengguna atau kata kunci tidak cocok !!";
balloonHelp.ShowBalloon(userNameTextBox);
userNameTextBox.Focus();
userNameTextBox.SelectAll();
}
}
private void transactionByTextBox_Validating(object sender, CancelEventArgs e)
{
if (!string.IsNullOrEmpty(transactionByTextBox.Text.Trim()))
{
MCustomer cust = (MCustomer)DataMaster.GetObjectByProperty(typeof(MCustomer), MCustomer.ColumnNames.CustomerId, transactionByTextBox.Text);
if (cust != null)
{
customerNameTextBox.Text = cust.CustomerName;
if (sender != null)
{
transactionByAddressTextBox.Text = cust.CustomerAddress;
transactionByPhoneTextBox.Text = cust.CustomerPhone;
transactionDescTextBox.Text = cust.CustomerDesc2;
transactionDesc2TextBox.Text = cust.CustomerDesc;
}
}
else
{
customerNameTextBox.ResetText();
}
}
}
private void UpdatePiHutang(object sender, EventArgs e)
{
if (!ValidatePiHutang())
{
return;
}
simpanToolStripButton.Enabled = false;
TJournal jur = new TJournal();
jur.JournalDate = journalDateDateTimePicker.Value;
jur.JournalDesc = journalDescTextBox.Text;
jur.JournalJumlah = journalJumlahNumericUpDown.Value;
jur.JournalPic = piHutangPicComboBox.SelectedValue.ToString();
if (!IsDelete)
{
if (PiHutang == ListOfPiHutangStatus.Piutang)
{
jur.JournalStatus = ListOfJournalStatus.Debet.ToString();
}
else if (PiHutang == ListOfPiHutangStatus.Hutang)
{
jur.JournalStatus = ListOfJournalStatus.Kredit.ToString();
}
}
else
{
if (PiHutang == ListOfPiHutangStatus.Piutang)
{
jur.JournalStatus = ListOfJournalStatus.Kredit.ToString();
}
else if (PiHutang == ListOfPiHutangStatus.Hutang)
{
jur.JournalStatus = ListOfJournalStatus.Debet.ToString();
}
}
//if (IsDelete)
//{
// jur.SubAccountId = subAccountIdComboBox.SelectedValue.ToString();
//}
//else
//{
jur.SubAccountId = subAccountIdComboBox.SelectedValue.ToString();
//}
jur.VoucherNo = voucherNoTextBox.Text;
jur.ModifiedBy = lbl_UserName.Text;
jur.ModifiedDate = DateTime.Now;
AppCode.SaveTJournal(jur);
TPiHutang piHut;
for (int i = 0; i < tPiHutangDataGridView.RowCount; i++)
{
if (Convert.ToBoolean(tPiHutangDataGridView.Rows[i].Cells[0].Value) == true)
{
piHut = (TPiHutang)DataMaster.GetObjectByProperty(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangId, Convert.ToDecimal(tPiHutangDataGridView.Rows[i].Cells[7].Value));
piHut.PiHutangDibayar += Convert.ToDecimal(tPiHutangDataGridView.Rows[i].Cells[6].Value);
piHut.PiHutangSisa = piHut.PiHutangJumlah - piHut.PiHutangRetur - piHut.PiHutangDibayar;
if (piHut.PiHutangSisa == decimal.Zero)
{
piHut.PiHutangLunasDate = journalDateDateTimePicker.Value;
if (piHutang == ListOfPiHutangStatus.Piutang && !IsDelete)
{
ShareCommissionInterface(piHut.TransactionId);
}
}
piHut.ModifiedBy = lbl_UserName.Text;
piHut.ModifiedDate = DateTime.Now;
DataMaster.UpdatePersistence(piHut);
jur = new TJournal();
jur.JournalDate = journalDateDateTimePicker.Value;
jur.JournalDesc = journalDescTextBox.Text;
jur.JournalJumlah = Convert.ToDecimal(tPiHutangDataGridView.Rows[i].Cells[6].Value);
jur.JournalPic = piHutangPicComboBox.SelectedValue.ToString();
if (!IsDelete)
{
if (PiHutang == ListOfPiHutangStatus.Piutang)
{
jur.JournalStatus = ListOfJournalStatus.Kredit.ToString();
}
else if (PiHutang == ListOfPiHutangStatus.Hutang)
{
jur.JournalStatus = ListOfJournalStatus.Debet.ToString();
}
}
else
{
if (PiHutang == ListOfPiHutangStatus.Piutang)
{
jur.JournalStatus = ListOfJournalStatus.Debet.ToString();
}
else if (PiHutang == ListOfPiHutangStatus.Hutang)
{
jur.JournalStatus = ListOfJournalStatus.Kredit.ToString();
}
}
jur.SubAccountId = tPiHutangDataGridView.Rows[i].Cells[8].Value.ToString();
jur.VoucherNo = voucherNoTextBox.Text;
jur.ModifiedBy = lbl_UserName.Text;
jur.ModifiedDate = DateTime.Now;
AppCode.SaveTJournal(jur);
}
}
MessageBox.Show(this.Text + " berhasil disimpan", AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
bool isSave = false;
//if (bankIdComboBox.Enabled)
//{
// giro = new TGiro();
// isSave = true;
//}
//else
//{
// giro = (TGiro)DataMaster.GetObjectByProperty(typeof(TGiro), TGiro.ColumnNames.GiroNo, giroNoTextBox.Text, TGiro.ColumnNames.BankId, bankIdComboBox.SelectedValue.ToString());
// isSave = false;
//}
if (giroIdNumericUpDown.Value != 0)
{
giro = (TGiro)DataMaster.GetObjectByProperty(typeof(TGiro), TGiro.ColumnNames.GiroId, giroIdNumericUpDown.Value);
isSave = false;
}
else
{
giro = new TGiro();
isSave = true;
}
giro.CurrencyId = currencyIdComboBox.SelectedItem.ToString();
giro.BankId = bankIdComboBox.SelectedValue.ToString();
giro.GiroAmmount = giroAmmountNumericUpDown.Value;
giro.GiroCairDate = giroCairDateDateTimePicker.Value;
giro.GiroTo = combo_Supplier.SelectedValue.ToString();
giro.GiroMaturityDate = giroMaturityDateDateTimePicker.Value;
giro.GiroNo = giroNoTextBox.Text;
if (isSave)
{
giro.GiroStatus = ListOfGiroStatus.Baru.ToString();
giro.GiroOutDate = DateTime.Now;
}
else
{
giro.GiroStatus = giroStatusLabel1.Text;
}
giro.ModifiedBy = lbl_UserName.Text;
giro.ModifiedDate = DateTime.Now;
DataMaster.SaveOrUpdate(giro);
if (isSave)
{
//try
//{
// DataMaster.SavePersistence(giro);
//}
//catch (NHibernate.NonUniqueObjectException)
//{
// RecreateBalloon();
// balloonHelp.Caption = "Validasi data kurang";
// balloonHelp.Content = "Nomor giro " + giroNoTextBox.Text + " sudah pernah diinput, silahkan input dengan nomor yang lain";
// balloonHelp.ShowBalloon(giroNoTextBox);
// giroNoTextBox.Focus();
// return;
//}
ModuleControlSettings.SaveLog(ListOfAction.Insert, bankIdComboBox.SelectedValue.ToString() + ";" + giroNoTextBox.Text + ";" + ListOfGiroStatus.Baru.ToString(), ListOfTable.TGiro, lbl_UserName.Text);
}
else
{
//DataMaster.UpdatePersistence(giro);
ModuleControlSettings.SaveLog(ListOfAction.Update, bankIdComboBox.SelectedValue.ToString() + ";" + giroNoTextBox.Text + ";" + giroStatusLabel1.Text, ListOfTable.TGiro, lbl_UserName.Text);
}
BindGiroData();
CalculateTotalUtang();
}
private void FillVStockDetailTransactionDealerDataSource()
{
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[10];
if (itemIdComboBox.SelectedIndex != 0)
{
expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, itemIdComboBox.SelectedValue);
}
if (stockDesc1ComboBox.SelectedIndex != 0)
{
expArrays[1] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDesc1, stockDesc1ComboBox.SelectedValue);
}
if (!string.IsNullOrEmpty(stockDesc2TextBox.Text.Trim()))
{
expArrays[2] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc2, stockDesc2TextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
}
if (!string.IsNullOrEmpty(stockDesc3TextBox.Text.Trim()))
{
expArrays[3] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc3, stockDesc3TextBox.Text, NHibernate.Expression.MatchMode.Anywhere);
}
if (listOfReports != ListOfReports.ReportRecapSisaStock)
{
if (FilterByDateCheckBox.Checked)
{
expArrays[4] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1));
}
//jika status stok terjual
if (StatusStockComboBox.SelectedIndex == 1)
{
expArrays[5] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value));
}
//jika status stok belum terjual
else if (StatusStockComboBox.SelectedIndex == 2)
{
expArrays[5] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value);
}
}
//jika gudang visible
if (ShowGudangIdPanel)
{
if (gudangIdComboBox.SelectedIndex != 0)
{
expArrays[6] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.GudangId, Convert.ToInt32(gudangIdComboBox.SelectedValue));
try
{
if (Convert.ToInt32(gudangIdComboBox.SelectedValue) == 4)
{
if (locationIdComboBox.SelectedIndex != 0)
{
expArrays[7] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.LocatonId, locationIdComboBox.SelectedValue);
}
}
}
catch (Exception)
{
}
}
}
if (listOfReports == ListOfReports.ReportRecapSisaStock)
{
expArrays[8] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value), NHibernate.Expression.Expression.Gt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1)));
//expArrays[8] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1));
expArrays[9] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateIn, transactionDateToDateTimePicker.Value.AddDays(1));
}
IList listStok = DataMaster.GetList(typeof(VTStockDetail), expArrays, null);
VTStockDetail s;
IList list = new List <VStockDetailTransactionDealer>();
VStockDetailTransactionDealer v;
VTotalTransactionDealer det;
for (int i = 0; i < listStok.Count; i++)
{
s = listStok[i] as VTStockDetail;
v = new VStockDetailTransactionDealer();
v.ChannelName = s.ChannelName;
v.ColourDesc = s.ColourDesc;
det = DataMaster.GetObjectByProperty(typeof(VTotalTransactionDealer), VTotalTransactionDealer.ColumnNames.StockId, s.StockId, VTotalTransactionDealer.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()) as VTotalTransactionDealer;
if (det != null)
{
v.CustomerName = det.CustomerName;
}
v.GudangId = s.GudangId;
v.GudangName = s.GudangName;
v.ItemId = s.ItemId;
v.ItemName = s.ItemName;
v.LocatonId = s.LocatonId;
v.StockBarcodeId = s.StockBarcodeId;
v.StockDateIn = s.StockDateIn;
v.StockDateOut = s.StockDateOut;
v.StockDesc1 = s.StockDesc1;
v.StockDesc2 = s.StockDesc2;
v.StockDesc3 = s.StockDesc3;
v.StockId = s.StockId;
v.StockInBy = s.StockInBy;
v.StockIsAvailable = s.StockIsAvailable;
v.StockOutBy = s.StockOutBy;
v.StockPriceIn = s.StockPriceIn;
v.StockPriceOut = s.StockPriceOut;
list.Add(v);
}
//expArrays[8] =NHibernate.Expression.Expression NHibernate.Expression.Expression.Eq(VStockDetailTransactionDealer.ColumnNames.ItemId, itemIdComboBox.SelectedValue);
bs = new BindingSource();
bs.DataSource = list;
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VStockDetailTransactionDealer", bs));
}
private void itemIdTextBox_Validating(object sender, CancelEventArgs e)
{
if (!string.IsNullOrEmpty(itemIdTextBox.Text.Trim()))
{
MItem item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, itemIdTextBox.Text);
if (item != null)
{
itemNameTextBox.Text = item.ItemName;
if (trans.Equals(ListOfTransaction.Sales))
{
if (transactionByNameComboBox.SelectedIndex != -1)
{
MCustomerGroup custGroup = (MCustomerGroup)DataMaster.GetObjectByProperty(typeof(MCustomerGroup), MCustomerGroup.ColumnNames.CustomerGroupId, transactionByNameComboBox.SelectedValue.ToString());
decimal persen = 0;
if (custGroup != null)
{
persen = custGroup.CustomerGroupPercentage;
}
priceNumericUpDown.Value = item.ItemPricePurchase * (1 + (persen / 100));
}
else
{
MessageBox.Show("Kategori Pelanggan belum dipilih!", "Error !!", MessageBoxButtons.OK, MessageBoxIcon.Error);
ResetTransactionDetail();
transactionByNameComboBox.Select();
}
}
else if (trans.Equals(ListOfTransaction.Purchase) || trans.Equals(ListOfTransaction.ReturPurchase))
{
priceNumericUpDown.Value = item.ItemPricePurchase;
}
//if (!trans.Equals(ListOfTransaction.Correction))
// num_Price.Value = item.ItemPriceMax;
}
}
}
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 BindData()
{
DataTable dt = new DataTable();
dt.Columns.Add("transaction id");
dt.Columns.Add("faktur");
dt.Columns.Add("trans status");
dt.Columns.Add("item id");
dt.Columns.Add("status add");
dt.Columns.Add("jumlah");
dt.Columns.Add("saldo");
dt.Columns.Add("saldo 2");
DataRow dr;
IList listItem = DataMaster.GetAll(typeof(MItem));
MItem item;
IList listStok;
TStokCard stok;
TTransaction trans;
decimal t = 0;
for (int i = 0; i < listItem.Count; i++)
{
item = (MItem)listItem[i];
listStok = DataMaster.GetListEq(typeof(TStokCard), TStokCard.ColumnNames.ItemId, item.ItemId);
t = 0;
for (int j = 0; j < listStok.Count; j++)
{
stok = (TStokCard)listStok[j];
trans = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, stok.TransactionId);
if (j == 0)
{
if (trans.TransactionStatus == ListOfTransaction.SalesVIP.ToString())
{
t = stok.StokCardSaldo - (stok.StokCardQuantity * 2);
}
else
{
t = stok.StokCardSaldo + (stok.StokCardQuantity * 2);
}
}
else
{
if (trans.TransactionStatus == ListOfTransaction.SalesVIP.ToString())
{
t = t - stok.StokCardQuantity;
}
else
{
t = t + stok.StokCardQuantity;
}
}
dr = dt.NewRow();
dr[0] = trans.TransactionId;
dr[1] = trans.TransactionFactur;
dr[2] = trans.TransactionStatus;
dr[3] = item.ItemId;
dr[4] = stok.StokCardStatus;
dr[5] = stok.StokCardQuantity;
dr[6] = stok.StokCardSaldo;
dr[7] = t;
dt.Rows.Add(dr);
}
}
dataGridView1.DataSource = dt;
dataGridView1.Show();
}
private void BindData(object sender, EventArgs e)
{
string myKeyWord = string.Empty;
string col = TStock.ColumnNames.StockDesc2;
if (sender == txt_SearchById)
{
if (!txt_SearchById.Text.Equals("<Cari Berdasar No Rangka>"))
{
myKeyWord = txt_SearchById.Text.Trim();
}
col = TStock.ColumnNames.StockDesc2;
}
else if (sender == txt_SearchByName)
{
if (!txt_SearchByName.Text.Equals("<Cari Berdasar No Mesin>"))
{
myKeyWord = txt_SearchByName.Text.Trim();
}
col = TStock.ColumnNames.StockDesc3;
}
//bindingSource_Search.Clear();
NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5];
expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, cb_ItemId.SelectedValue.ToString());
expArrays[1] = NHibernate.Expression.Expression.InsensitiveLike(col, myKeyWord, NHibernate.Expression.MatchMode.Anywhere);
expArrays[2] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.GudangId, GudangId);
if (!string.IsNullOrEmpty(LocationId))
{
expArrays[3] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.LocatonId, LocationId);
}
expArrays[4] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.StockIsAvailable, true);
IList listSearch = DataMaster.GetList(typeof(TStock), expArrays, null);
TStock stok;
MColour color;
MItem item;
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(TStock.ColumnNames.StockId);
dt.Columns.Add(TStock.ColumnNames.ItemId);
dt.Columns.Add(TStock.ColumnNames.StockDesc1);
dt.Columns.Add(TStock.ColumnNames.StockDesc2);
dt.Columns.Add(TStock.ColumnNames.StockDesc3);
for (int i = 0; i < listSearch.Count; i++)
{
stok = listSearch[i] as TStock;
dr = dt.NewRow();
dr[0] = stok.StockId;
//nama item
item = DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId) as MItem;
if (item == null)
{
item = new MItem();
}
dr[1] = item.ItemName;
//nama warna
color = DataMaster.GetObjectByProperty(typeof(MColour), MColour.ColumnNames.ColourId, stok.StockDesc1) as MColour;
if (color == null)
{
color = new MColour();
}
dr[2] = color.ColourDesc;
dr[3] = stok.StockDesc2;
dr[4] = stok.StockDesc3;
dt.Rows.Add(dr);
}
bindingSource_Search.DataSource = dt;
//if (listSearch.Count > 0)
// bindingSource_Search.DataSource = listSearch;
}
public void BindReport()
{
if (transactionByComboBox.SelectedValue != null)
{
DataId = transactionByComboBox.SelectedValue.ToString();
}
if (Param == ParameterView.Currency)
{
DataId = transactionByComboBox.SelectedItem.ToString();
}
title = "Laporan";
reportViewer1.Reset();
switch (rep)
{
case ListOfReports.MItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMItem.rdlc";
FillVItemDetailDataSource();
title = "Daftar Item";
break;
case ListOfReports.MGroup:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportSubItem.rdlc";
FillMGroupDataSource();
title = "Daftar Golongan Item";
break;
case ListOfReports.MSupplier:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMSupplier.rdlc";
FillVSupplierAccountDataSource();
title = "Daftar Supplier";
break;
case ListOfReports.MEmployee:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportMEmployee.rdlc";
FillMEmployeeDataSource();
title = "Daftar Karyawan";
break;
case ListOfReports.ReportTransactionTotalByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionTotalByItem.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId);
title = "Laporan Transaksi Per Item";
break;
case ListOfReports.TransactionDetail:
decimal transactionId = Convert.ToDecimal(DataId);
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionDetail.rdlc";
FillTransactionDetailSource(transactionId);
title = "Laporan Detail Transaksi";
break;
case ListOfReports.UtangDetail:
string suppId = DataId;
string currencyid = DataId2;
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUtangDetail.rdlc";
FillTransactionSource(suppId, currencyid);
FillGiroSource(suppId, currencyid);
title = "Laporan Utang";
break;
case ListOfReports.ReportPODetailForPrint:
transactionId = Convert.ToDecimal(DataId);
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPODetailForPrint.rdlc";
TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionId, transactionId);
FillTransactionDetailSource(transactionId);
FillMSupplierDataSource(tr.TransactionBy);
title = "Laporan Detail PO";
break;
case ListOfReports.ReportTransactionTotalByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionTotalByPIC.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId);
title = "Laporan Transaksi";
break;
case ListOfReports.ReportGiro:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportGiro.rdlc";
FillGiroSource(GiroGroup.ToString(), DataId);
title = "Laporan Giro";
break;
case ListOfReports.ReportUsageTotalByAlat:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUsageTotalByAlat.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId);
title = "Laporan Pemakaian Spare Parts Per Alat";
break;
case ListOfReports.ReportTransactionPerMonth:
// splitContainer1.Panel1Collapsed = false;
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTransactionPerMonth.rdlc";
if (transactionByComboBox.SelectedValue != null)
{
FillVTransactionSource(Trans.ToString(), DataId);
}
title = "Laporan Transaksi Per Bulan";
break;
case ListOfReports.ReportPOTotalByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPOTotalByItem.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.Item, DataId);
title = "Laporan Transaksi Per Item";
break;
case ListOfReports.ReportPOTotalByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportPOTotalByPIC.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId);
title = "Laporan Transaksi";
break;
case ListOfReports.ReportUserLog:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportUserLog.rdlc";
FillUserLogSource(dt_From.Value, dt_To.Value, DataId);
title = "Laporan Histori Pengguna";
break;
case ListOfReports.ReportListTransaction:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportListTransaction.rdlc";
FillTransactionTotalSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId);
if (Trans == ListOfTransaction.Purchase)
{
title = "Laporan List Pembelian";
}
else if (Trans == ListOfTransaction.PurchaseOrder)
{
title = "Laporan List Order Pembelian";
}
break;
case ListOfReports.ReportTagihan:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.Contractor.Forms.Reports.ReportTagihan.rdlc";
//FillVTransactionWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId, true);
FillVTransactionDetailWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, ReportBy.PIC, DataId, true);
button_Reset.Visible = true;
//object[] transBy = new object[checkedListBox_Parameter.CheckedItems.Count];
//string supp;
//for (int i = 0; i < checkedListBox_Parameter.CheckedItems.Count; i++)
//{
// supp = checkedListBox_Parameter.CheckedItems[i].ToString();
// supp = supp.Substring(0, supp.IndexOf(" ("));
// transBy[i] = supp;
//}
//FillVTransactionWithBankAccSource(Trans.ToString(), dt_From.Value, dt_To.Value, transBy);
title = "Laporan Tagihan";
break;
default:
break;
}
reportViewer1.LocalReport.SubreportProcessing += new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.reportViewer1.RefreshReport();
this.Text = title;
this.TabText = title;
}
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 FormTransaction_Load(object sender, EventArgs e)
{
//set numeric updown
ModuleControlSettings.SetNumericUpDown(num_Quantity);
ModuleControlSettings.SetNumericUpDown(num_Jumlah, true);
ModuleControlSettings.SetNumericUpDown(num_Disc);
ModuleControlSettings.SetNumericUpDown(num_Total, true);
ModuleControlSettings.SetNumericUpDown(num_Tax);
ModuleControlSettings.SetNumericUpDown(num_TaxValue);
ModuleControlSettings.SetNumericUpDown(num_GrandTotal, true);
ModuleControlSettings.SetNumericUpDown(num_Pay);
ModuleControlSettings.SetNumericUpDown(num_Back, true);
num_Back.Minimum = decimal.MinValue;
for (int i = 0; i < 7; i++)
{
grid_Trans.Columns.Add(i.ToString(), i.ToString());
}
// Mengatur lebar kolom
grid_Trans.Columns[0].Width = 192 - 1;
grid_Trans.Columns[1].Width = 223;
grid_Trans.Columns[2].Width = 65;
grid_Trans.Columns[3].Width = 73 - 1;
grid_Trans.Columns[4].Width = 101 - 1;
grid_Trans.Columns[5].Width = 60 - 1;
grid_Trans.Columns[6].Width = 89;
grid_Trans.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
grid_Trans.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
ModuleControlSettings.SetDateTimePicker(dt_TransactionDate);
dt_TransactionDate.Value = DateTime.Now;
txt_TransactionId.Text = DateTime.Now.ToFileTimeUtc().ToString();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);
if (set != null)
{
lbl_ShopName.Text = set.CompanyName;
lbl_ShopAddress.Text = set.CompanyAddress + " " + set.CompanyCity;
lbl_ShopTelp.Text = "Telp : " + set.CompanyTelp;
}
//set location shop header
float shopWidth = (lbl_ShopName.Text.Length * (lbl_ShopName.Font.Size - 2));
float xShop = (groupBox5.Width / 2) - (shopWidth / 2) + groupBox5.Location.X;
lbl_ShopName.Location = new Point(Convert.ToInt32(xShop), lbl_ShopName.Location.Y);
shopWidth = (lbl_ShopAddress.Text.Length * (lbl_ShopAddress.Font.Size - 2));
xShop = (groupBox5.Width / 2) - (shopWidth / 2) + groupBox5.Location.X;
lbl_ShopAddress.Location = new Point(Convert.ToInt32(xShop), lbl_ShopAddress.Location.Y);
shopWidth = (lbl_ShopTelp.Text.Length * (lbl_ShopTelp.Font.Size - 2));
xShop = (groupBox5.Width / 2) - (shopWidth / 2) + groupBox5.Location.X;
lbl_ShopTelp.Location = new Point(Convert.ToInt32(xShop), lbl_ShopTelp.Location.Y);
SetInitialSettings();
detailControl_KeyDown(null, null);
//show tunai group box
if (!(lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString())))
{
lbl_Pay.Visible = false;
num_Pay.Visible = false;
lbl_Back.Visible = false;
num_Back.Visible = false;
}
if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSalesVIP.ToString()))
{
lbl_Customer.Text = "Pelanggan :";
if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString()))
{
ModuleControlSettings.SetNumericUpDown(num_Price, true);
}
}
else if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Correction.ToString()))
{
SetFormToCorrection();
}
else
{
lbl_Customer.Text = "Supplier :";
}
PictureBox searchPic = new PictureBox();
ModuleControlSettings.SetSearchPictureBox(txt_CustId, ListOfSearchWindow.SearchCustomer.ToString(), searchPic);
searchPic.Click += new EventHandler(searchPicCustomer_Click);
txt_CustId.Controls.Add(searchPic);
searchPic = new PictureBox();
ModuleControlSettings.SetSearchPictureBox(txt_ItemId, ListOfSearchWindow.SearchItem.ToString(), searchPic);
searchPic.Click += new EventHandler(searchPicItem_Click);
txt_ItemId.Controls.Add(searchPic);
string j = "Penjualan";
if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString()))
{
j = "Penjualan";
}
else if (lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSalesVIP.ToString()))
{
j = "Retur Penjualan";
}
else if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Purchase.ToString()))
{
j = "Pembelian";
}
else if (lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturPurchase.ToString()))
{
j = "Retur Pembelian";
}
else if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Correction.ToString()))
{
j = "Penyesuaian";
}
this.TabText = j;
this.Text = j;
//fill suggest textbox
ModuleControlSettings.FillItemSuggestSource(txt_ItemId);
if (lbl_TempTransaction.Text.Equals(ListOfTransaction.Sales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSales.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.SalesVIP.ToString()) || lbl_TempTransaction.Text.Equals(ListOfTransaction.ReturSalesVIP.ToString()))
{
ModuleControlSettings.SetCustomerTextBoxSuggest(txt_CustId);
}
else
{
ModuleControlSettings.SetSupplierTextBoxSuggest(txt_CustId);
}
}
private void FillVItemDetail()
{
bs = new BindingSource();
IList listItemDetail = new List <VItemDetail>();
IList listItem = DataMaster.GetAll(typeof(MItem));
MItem item;
IList listGudang = DataMaster.GetAll(typeof(MGudang));
MGudang gud;
ItemGudangStok stok;
VItemDetail itemDetail;
MGroup group;
MItemType tipe;
for (int i = 0; i < listItem.Count; i++)
{
item = (MItem)listItem[i];
group = (MGroup)DataMaster.GetObjectByProperty(typeof(MGroup), MGroup.ColumnNames.GroupId, item.GroupId);
tipe = (MItemType)DataMaster.GetObjectByProperty(typeof(MItemType), MItemType.ColumnNames.ItemTypeId, item.ItemTypeId);
for (int j = 0; j < listGudang.Count; j++)
{
gud = (MGudang)listGudang[j];
stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, item.ItemId, ItemGudangStok.ColumnNames.GudangId, gud.GudangId);
itemDetail = new VItemDetail();
itemDetail.DefaultGudangId = item.DefaultGudangId;
itemDetail.GroupId = item.GroupId;
if (group != null)
{
itemDetail.GroupName = group.GroupName;
}
itemDetail.GudangId = gud.GudangId;
itemDetail.GudangName = gud.GudangName;
itemDetail.ItemCommision = item.ItemCommision;
itemDetail.ItemDesc = item.ItemDesc;
itemDetail.ItemId = item.ItemId;
if (stok != null)
{
itemDetail.ItemMaxStok = stok.ItemMaxStok;
itemDetail.ItemMinStok = stok.ItemMinStok;
itemDetail.ItemPosition = stok.ItemPosition;
itemDetail.ItemStok = stok.ItemStok;
}
itemDetail.ItemName = item.ItemName;
itemDetail.ItemPriceMax = item.ItemPriceMax;
itemDetail.ItemPriceMaxVip = item.ItemPriceMaxVip;
itemDetail.ItemPriceMin = item.ItemPriceMin;
itemDetail.ItemPriceMinVip = item.ItemPriceMinVip;
itemDetail.ItemPricePurchase = item.ItemPricePurchase;
itemDetail.ItemPricePurchaseAvg = item.ItemPricePurchaseAvg;
itemDetail.ItemSatuan = item.ItemSatuan;
itemDetail.ItemTypeId = item.ItemTypeId;
if (tipe != null)
{
itemDetail.ItemTypeName = tipe.ItemTypeName;
}
itemDetail.ModifiedBy = item.ModifiedBy;
itemDetail.ModifiedDate = item.ModifiedDate;
itemDetail.SupplierId = item.SupplierId;
listItemDetail.Add(itemDetail);
}
}
bs.DataSource = listItemDetail;
//bs.DataSource = DataMaster.GetAll(typeof(VItemDetail));
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VItemDetail", 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 bool ValidateClosing()
{
period = numericUpDown_Year.Value.ToString() + comboBox_Month.SelectedValue.ToString();
TRekapSubAccount rekap = (TRekapSubAccount)DataMaster.GetObjectByProperty(typeof(TRekapSubAccount), TRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period);
if (rekap != null)
{
if (MessageBox.Show("Proses akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString() + " sudah dilakukan. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return(false);
}
}
string today = DateTime.Today.Month.ToString();
if (DateTime.Today.Month < 10)
{
today = decimal.Zero.ToString() + DateTime.Today.Month.ToString();
}
today = DateTime.Today.Year.ToString() + today;
if (Convert.ToDecimal(today) <= Convert.ToDecimal(period))
{
if (MessageBox.Show("Proses akhir bulan hanya bisa dilakukan untuk periode bulan sebelumnya. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return(false);
}
}
IList listAcc = DataMaster.GetAll(typeof(MAccount));
MAccount acc;
decimal totDebet = 0;
decimal totKredit = 0;
for (int i = 0; i < listAcc.Count; i++)
{
acc = (MAccount)listAcc[i];
if (acc.AccountStatus == ListOfJournalStatus.Debet.ToString())
{
totDebet += acc.AccountSaldo;
}
else if (acc.AccountStatus == ListOfJournalStatus.Kredit.ToString())
{
totKredit += acc.AccountSaldo;
}
}
if (totKredit != totDebet)
{
decimal selisih = totDebet - totKredit;
if (selisih < 0)
{
selisih = selisih * -1;
}
MessageBox.Show("Proses akhir bulan belum dapat dilakukan, terjadi selisih sebesar " + ModuleControlSettings.NumericFormat(selisih, true), AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
private void transactionReferenceFacturTextBox_Validating(object sender, CancelEventArgs e)
{
TTransaction tr = (TTransaction)DataMaster.GetObjectByProperty(typeof(TTransaction), TTransaction.ColumnNames.TransactionFactur, transactionReferenceFacturTextBox.Text);
if (tr != null)
{
transactionReferenceIdTextBox.Text = tr.TransactionId.ToString();
FillTransaction(tr);
FillTransactionDetail(tr);
button_Detail.Visible = true;
RecreateBalloon();
balloonHelp.Caption = "Detail Transaksi";
balloonHelp.Content = "Klik disini untuk melihat detail transaksi";
balloonHelp.ShowBalloon(button_Detail);
}
else
{
transactionReferenceIdTextBox.ResetText();
button_Detail.Visible = false;
//tTransactionDeliveryDetailDataGridView.DataSource = null;
}
}