private void SetItemGudangStok(bool isNew)
{
IList listGudang = DataMaster.GetAll(typeof(MGudang));
MGudang gud;
TabPage tab;
NumericUpDown num;
ItemGudangStok itemGud;
for (int i = 0; i < listGudang.Count; i++)
{
gud = (MGudang)listGudang[i];
itemGud = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text, ItemGudangStok.ColumnNames.GudangId, gud.GudangId);
if (itemGud == null)
{
itemGud = new ItemGudangStok();
}
tab = tabControl_Gudang.TabPages["tabpages_" + gud.GudangId.ToString()];
//maks stok
num = (NumericUpDown)tab.Controls["num_maks_stok_" + gud.GudangId.ToString()];
num.Value = itemGud.ItemMaxStok;
//min stok
num = (NumericUpDown)tab.Controls["num_min_stok_" + gud.GudangId.ToString()];
num.Value = itemGud.ItemMinStok;
// stok
num = (NumericUpDown)tab.Controls["num_stok_" + gud.GudangId.ToString()];
num.Enabled = isNew;
num.Value = itemGud.ItemStok;
}
}
private void UpdateStok(string ItemId, decimal qty)
{
int gudangId = 1;
bool AddStok = true;
if (trans == ListOfTransaction.Sales)
{
AddStok = false;
}
decimal saldo = decimal.Zero;
ItemGudangStok stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, ItemId, ItemGudangStok.ColumnNames.GudangId, gudangId);
if (AddStok)
{
saldo = stok.ItemStok + qty;
}
else
{
saldo = stok.ItemStok - qty;
}
stok.ItemStok = saldo;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.UpdatePersistence(stok);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Anda yakin menyimpan data?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
decimal stokItem = 0;
string itemId;
int gudangId = 1;
ItemGudangStok stok;
bool isUpdate = false;
for (int i = 0; i < itemGudangStokDataGridView.RowCount; i++)
{
isUpdate = Convert.ToBoolean(itemGudangStokDataGridView.Rows[i].Cells[0].Value);
if (isUpdate)
{
itemId = itemGudangStokDataGridView.Rows[i].Cells[1].Value.ToString();
stokItem = Convert.ToDecimal(itemGudangStokDataGridView.Rows[i].Cells[4].Value);
stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemId, ItemGudangStok.ColumnNames.GudangId, gudangId);
if (stok == null)
{
stok = new ItemGudangStok();
stok.GudangId = gudangId;
stok.ItemId = itemId;
stok.ItemMaxStok = 0;
stok.ItemMinStok = 0;
stok.ItemStok = stokItem;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(stok);
}
else
{
stok.ItemStok = stokItem;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.UpdatePersistence(stok);
}
TStokCard krt = new TStokCard();
krt.ItemId = itemId;
krt.GudangId = gudangId;
krt.StokCardDate = DateTime.Today;
krt.StokCardPic = "Saldo Awal";
krt.StokCardQuantity = stokItem;
krt.StokCardSaldo = stokItem;
krt.StokCardStatus = true;
krt.TransactionId = 0;
krt.ModifiedBy = lbl_UserName.Text;
krt.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(krt);
}
}
MessageBox.Show("Stok Awal barang berhasil disimpan", AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private bool ValidateTransactionDetail()
{
RecreateBalloon();
balloonHelp.Caption = "Validasi data kurang";
if (quantityNumericUpDown.Value == 0)
{
balloonHelp.Content = "Kuantitas tidak boleh 0 !!";
balloonHelp.ShowBalloon(quantityNumericUpDown);
quantityNumericUpDown.Focus();
return(false);
}
if (string.IsNullOrEmpty(itemIdTextBox.Text))
{
balloonHelp.Content = "Item harus diisi !!";
balloonHelp.ShowBalloon(itemIdTextBox);
itemIdTextBox.Focus();
return(false);
}
else
{
MItem item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, itemIdTextBox.Text);
if (item == null)
{
balloonHelp.Content = "Item " + itemIdTextBox.Text + " tidak ada dalam database. \n Pastikan anda menulis kode yang tepat atau \n pilih item dengan mengklik gambar disamping untuk mencari Item.";
balloonHelp.ShowBalloon(itemIdTextBox);
itemIdTextBox.Focus();
return(false);
}
else
{
int gudangId = 1;
string gudangName = "Toko";
ItemGudangStok gud = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, item.ItemId, ItemGudangStok.ColumnNames.GudangId, gudangId);
if (gud == null)
{
if (MessageBox.Show("Stok Item di " + gudangName + " = 0. Anda yakin melanjutkan transaksi?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(false);
}
}
else
{
if (gud.ItemStok < quantityNumericUpDown.Value)
{
if (MessageBox.Show("Stok Item di " + gudangName + " tidak mencukupi untuk transaksi ini. Anda yakin melanjutkan transaksi?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(false);
}
}
}
}
}
return(true);
}
private void SaveItemGudangStok()
{
IList listGudang = DataMaster.GetAll(typeof(MGudang));
MGudang gud;
TabPage tab;
NumericUpDown num;
ItemGudangStok itemGud;
bool isSave = false;
TextBox txt;
for (int i = 0; i < listGudang.Count; i++)
{
gud = (MGudang)listGudang[i];
itemGud = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text, ItemGudangStok.ColumnNames.GudangId, gud.GudangId);
if (itemGud == null)
{
itemGud = new ItemGudangStok();
isSave = true;
}
else
{
isSave = false;
}
tab = tabControl_Gudang.TabPages["tabpages_" + gud.GudangId.ToString()];
//maks stok
num = (NumericUpDown)tab.Controls["num_maks_stok_" + gud.GudangId.ToString()];
itemGud.ItemMaxStok = num.Value;
//min stok
num = (NumericUpDown)tab.Controls["num_min_stok_" + gud.GudangId.ToString()];
itemGud.ItemMinStok = num.Value;
// stok
num = (NumericUpDown)tab.Controls["num_stok_" + gud.GudangId.ToString()];
itemGud.ItemStok = num.Value;
//nomor rak
txt = (TextBox)tab.Controls["txt_position_" + gud.GudangId.ToString()];
itemGud.ItemPosition = txt.Text;
itemGud.GudangId = gud.GudangId;
itemGud.ItemId = itemIdTextBox.Text;
itemGud.ModifiedBy = lbl_UserName.Text;
itemGud.ModifiedDate = DateTime.Now;
if (isSave)
{
DataMaster.SavePersistence(itemGud);
}
else
{
DataMaster.UpdatePersistence(itemGud);
}
}
}
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.GetObjectById(typeof(MItem), itemIdTextBox.Text);
DataMaster.Delete(item);
ItemGudangStok stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text, ItemGudangStok.ColumnNames.GudangId, defaultGudangIdComboBox.SelectedValue);
DataMaster.Delete(stok);
}
}
}
private void UpdateStok(int gudangId, string itemId, decimal qty, bool AddStok)
{
ItemGudangStok stok;
TStokCard krt;
decimal saldo = 0;
MItem item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, itemId);
if (item != null)
{
//if item == barang
if (item.ItemTypeId == 1)
{
//change stok
stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemId, ItemGudangStok.ColumnNames.GudangId, gudangId);
if (stok != null)
{
if (AddStok)
{
saldo = stok.ItemStok + qty;
}
else
{
saldo = stok.ItemStok - qty;
}
stok.ItemStok = saldo;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.UpdatePersistence(stok);
}
else
{
stok = new ItemGudangStok();
stok.GudangId = gudangId;
stok.ItemId = itemId;
stok.ItemMaxStok = decimal.Zero;
stok.ItemMinStok = decimal.Zero;
if (AddStok)
{
saldo = qty;
}
else
{
saldo = qty * -1;
}
stok.ItemStok = saldo;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(stok);
}
}
krt = new TStokCard();
krt.ItemId = itemId;
krt.GudangId = gudangId;
krt.StokCardDate = DateTime.Today;
krt.StokCardPic = transactionByTextBox.Text;
krt.StokCardQuantity = qty;
krt.StokCardSaldo = saldo;
krt.StokCardStatus = AddStok;
krt.TransactionId = Convert.ToDecimal(transactionIdLabel.Text);
krt.ModifiedBy = lbl_UserName.Text;
krt.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(krt);
}
}
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
if (itemIdTextBox.Enabled == true)
{
item = new MItem();
}
else
{
item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, itemIdTextBox.Text);
}
item.ItemId = itemIdTextBox.Text;
item.ItemName = itemNameTextBox.Text;
//item.DefaultGudangId = Convert.ToInt32(defaultGudangIdComboBox.SelectedValue);
item.DefaultGudangId = 1;
item.GroupId = Convert.ToInt32(groupIdComboBox.SelectedValue);
//item.ItemCommision = Convert.ToDecimal(itemCommisionTextBox.Text);
item.ItemCommision = 0;
item.ItemDesc = itemDescTextBox.Text;
item.ItemPriceMax = itemPriceMaxNumericUpDown.Value;
item.ItemPriceMaxVip = itemPriceMaxVipNumericUpDown.Value;
//item.ItemPriceMin = Convert.ToDecimal(itemPriceMinTextBox.Text);
//item.ItemPriceMinVip = Convert.ToDecimal(itemPriceMinVipTextBox.Text);
item.ItemPriceMin = 0;
item.ItemPriceMinVip = 0;
item.ItemSatuan = itemSatuanTextBox.Text;
item.ItemTypeId = Convert.ToInt32(itemTypeIdComboBox.SelectedValue);
item.ItemPricePurchase = itemPricePurchaseNumericUpDown.Value;
item.ModifiedBy = lbl_UserName.Text;
item.ModifiedDate = DateTime.Now;
if (itemIdTextBox.Enabled == true)
{
try
{
DataMaster.SavePersistence(item);
}
catch (NHibernate.NonUniqueObjectException)
{
RecreateBalloon();
balloonHelp.Caption = "Validasi data kurang";
balloonHelp.Content = "Item dengan kode " + itemIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain";
balloonHelp.ShowBalloon(itemIdTextBox);
itemIdTextBox.Focus();
return;
}
}
else
{
DataMaster.UpdatePersistence(item);
}
ItemGudangStok stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, itemIdTextBox.Text);
bool isSave = false;
if (stok == null)
{
isSave = true;
stok = new ItemGudangStok();
stok.ItemStok = itemStokNumericUpDown.Value;
}
stok.ItemId = itemIdTextBox.Text;
//stok.GudangId = Convert.ToInt32(defaultGudangIdComboBox.SelectedValue);
stok.GudangId = 1;
//if type == barang
if (groupBox2.Enabled == true)
{
stok.ItemMaxStok = itemMaxStokNumericUpDown.Value;
stok.ItemMinStok = itemMinStokNumericUpDown.Value;
}
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
if (isSave)
{
DataMaster.SavePersistence(stok);
}
else
{
DataMaster.UpdatePersistence(stok);
}
BindData();
}
private void SaveTransactionDetail()
{
TTransactionDetail det;
ItemGudangStok stok;
MItem item;
TStokCard krt;
int gudangId = 1;
bool AddStok = true;
decimal saldo = 0;
if ((trans == ListOfTransaction.Sales) || (trans == ListOfTransaction.ReturPurchase))
{
AddStok = false;
}
else if ((trans == ListOfTransaction.Purchase) || (trans == ListOfTransaction.ReturSales))
{
AddStok = true;
}
for (int i = 0; i < tTransactionDetailDataGridView.Rows.Count; i++)
{
saldo = 0;
det = new TTransactionDetail();
det.Description = string.Empty;
det.Disc = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[5].Value);
det.ExpiredDate = Convert.ToDateTime(tTransactionDetailDataGridView.Rows[i].Cells[8].Value);
det.ItemId = tTransactionDetailDataGridView.Rows[i].Cells[0].Value.ToString();
det.Jumlah = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[4].Value);
det.Ppn = 0;
det.Price = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[3].Value);
det.Quantity = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[2].Value);
//if corection, save item quantity for detail total
if (trans == ListOfTransaction.Correction)
{
det.Total = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[2].Value);
}
else
{
det.Total = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[7].Value);
}
det.TransactionId = Convert.ToDecimal(transactionIdLabel.Text);
det.Tuslah = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[6].Value);
det.ModifiedBy = lbl_UserName.Text;
det.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(det);
item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, tTransactionDetailDataGridView.Rows[i].Cells[0].Value.ToString());
if (item != null)
{
//if purchase, update item price avg
if (trans == ListOfTransaction.Purchase)
{
item.ItemPricePurchaseAvg = (item.ItemPricePurchaseAvg + Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[3].Value)) / 2;
DataMaster.UpdatePersistence(item);
}
//if item == barang
if (item.ItemTypeId == 1)
{
//change stok
stok = (ItemGudangStok)DataMaster.GetObjectByProperty(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.ItemId, tTransactionDetailDataGridView.Rows[i].Cells[0].Value.ToString(), ItemGudangStok.ColumnNames.GudangId, gudangId);
if (stok != null)
{
if (AddStok)
{
saldo = stok.ItemStok + Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[2].Value);
}
else
{
saldo = stok.ItemStok - Convert.ToDecimal(tTransactionDetailDataGridView.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 = gudangId;
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 = tTransactionDetailDataGridView.Rows[i].Cells[0].Value.ToString();
krt.GudangId = gudangId;
krt.StokCardDate = DateTime.Now;
krt.StokCardPic = lbl_UserName.Text;
krt.StokCardQuantity = Convert.ToDecimal(tTransactionDetailDataGridView.Rows[i].Cells[2].Value);
krt.StokCardSaldo = saldo;
krt.StokCardStatus = AddStok;
krt.TransactionId = Convert.ToDecimal(transactionIdLabel.Text);
krt.ModifiedBy = lbl_UserName.Text;
krt.ModifiedDate = DateTime.Now;
DataMaster.SavePersistence(krt);
}
}
}
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);
}
}
