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