private void PopulateStockCorrectionItem(StockCorrectionItem stockCorrectionItem)
{
var item = new ListViewItem(stockCorrectionItem.ProductId.ToString());
item.SubItems.Add(stockCorrectionItem.Product.Name);
item.SubItems.Add(stockCorrectionItem.Product.Unit);
item.SubItems.Add(stockCorrectionItem.QtyPlus.ToString("N0").Replace(",", "."));
item.SubItems.Add(stockCorrectionItem.QtyMinus.ToString("N0").Replace(",", "."));
item.SubItems.Add(stockCorrectionItem.ValuePlus.ToString("N0").Replace(",", "."));
item.SubItems.Add(stockCorrectionItem.ValueMinus.ToString("N0").Replace(",", "."));
lvwStockCorrection.Items.Add(item);
}
public void Delete(IEntityManager em, Transaction tx, StockCorrectionItem stockCorrectionItem)
{
try
{
string[] columns = { "QtyPlus", "QtyMinus", "ValuePlus", "ValueMinus" };
object[] values = { 0, 0, 0, 0 };
var q = new Query().Select(columns).From(tableName).Update(values)
.Where("StockCorrectionId").Equal("{" + stockCorrectionItem.StockCorrectionId + "}");
em.ExecuteNonQuery(q.ToSql(), tx);
}
catch (Exception ex)
{
throw ex;
}
}
public void Save(IEntityManager em, Transaction tx, StockCorrectionItem stockCorrectionItem)
{
try
{
string[] columns = { "ID", "StockCorrectionId", "ProductId", "QtyPlus", "QtyMinus", "ValuePlus", "ValueMinus", "Notes" };
object[] values = { Guid.NewGuid(), stockCorrectionItem.StockCorrectionId, stockCorrectionItem.ProductId,
stockCorrectionItem.QtyPlus, stockCorrectionItem.QtyMinus,
stockCorrectionItem.ValuePlus, stockCorrectionItem.ValueMinus, stockCorrectionItem.Notes };
var q = new Query().Select(columns).From(tableName).Insert(values);
em.ExecuteNonQuery(q.ToSql(), tx);
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveStockCorrection()
{
if (dtpDate.Value.Month != Store.ActiveMonth || dtpDate.Value.Year != Store.ActiveYear)
{
MessageBox.Show("Tanggal diluar periode aktif", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (lvwStockCorrection.Items.Count == 0)
{
MessageBox.Show("Detail tidak boleh kosong", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var stockCorrection = new StockCorrection();
stockCorrection.Code = lblCode.Text;
stockCorrection.Date = dtpDate.Value;
stockCorrection.Notes = txtNotes.Text;
stockCorrection.CreatedBy = string.Empty;
var stockCorrectionItems = new List <StockCorrectionItem>();
foreach (ListViewItem item in lvwStockCorrection.Items)
{
string productId = item.SubItems[0].Text;
string qtyPlus = item.SubItems[3].Text;
string qtyMinus = item.SubItems[4].Text;
string valuePlus = item.SubItems[5].Text;
string valueMinus = item.SubItems[6].Text;
StockCorrectionItem si = new StockCorrectionItem();
si.ProductId = new Guid(productId);
si.QtyPlus = int.Parse(qtyPlus.Replace(".", ""));
si.QtyMinus = int.Parse(qtyMinus.Replace(".", ""));
si.ValuePlus = decimal.Parse(valuePlus.Replace(".", ""));
si.ValueMinus = decimal.Parse(valueMinus.Replace(".", ""));
si.Notes = "";
stockCorrectionItems.Add(si);
}
stockCorrection.StockCorrectionItems = stockCorrectionItems;
if (formMode == FormMode.Add)
{
stockCorrectionRepository.Save(stockCorrection);
ShowStockCorrectionReport();
GetLastStockCorrection();
}
else if (formMode == FormMode.Edit)
{
stockCorrection.ID = new Guid(txtID.Text);
stockCorrection.ModifiedBy = Store.ActiveUser;
stockCorrection.Notes = txtNotes.Text;
stockCorrectionRepository.Update(stockCorrection);
ShowStockCorrectionReport();
}
LoadStockCorrectionItems(new Guid(txtID.Text));
DisableForm();
formMode = FormMode.View;
FillCode();
this.Text = "Koreksi Stok";
}
}
