private void SaveStock()
{
for (int i = 0; i < tStockDataGridView.RowCount; i++)
{
TStock s = new TStock();
s.ItemId = tStockDataGridView.Rows[i].Cells[2].Value.ToString();
s.StockBarcodeId = tStockDataGridView.Rows[i].Cells[0].Value.ToString();
s.StockLocation = tStockDataGridView.Rows[i].Cells[1].Value.ToString();
DataMaster.SaveOrUpdate(s);
}
}
public string CreateTable <TStock>()
where TStock : Style, new()
{
DBExtend helper = dbHelper;
TStock obj1 = new TStock();
TModel obj2 = new TModel();
string msg = obj1.CreateTable(helper);
msg += obj2.CreateTable(helper);
return(msg);
}
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
stok = (TStock)DataMaster.GetObjectByProperty(typeof(TStock), TStock.ColumnNames.StockId, stockIdLabel1.Text);
stok.ItemId = itemIdComboBox.SelectedValue.ToString();
stok.StockDesc1 = stockDesc1ComboBox.SelectedValue.ToString();
stok.StockDesc2 = stockDesc2TextBox.Text;
stok.StockDesc3 = stockDesc3TextBox.Text;
stok.ModifiedBy = lbl_UserName.Text;
stok.ModifiedDate = DateTime.Now;
DataMaster.UpdatePersistence(stok);
BindData();
}
private decimal UpdateStock(DateTime?transDate, string transDesc, string transStatus, MItem itemId, decimal?price, decimal?qty, TTransDet det, bool addStock, MWarehouse mWarehouse)
{
decimal hpp = 0;
if (addStock)
{
TStock stock = new TStock();
stock.SetAssignedIdTo(Guid.NewGuid().ToString());
stock.ItemId = det.ItemId;
stock.TransDetId = det;
stock.StockDate = transDate;
stock.StockDesc = det.TransDetDesc;
stock.StockPrice = det.TransDetPrice;
stock.StockQty = det.TransDetQty;
stock.StockStatus = transStatus;
stock.WarehouseId = mWarehouse;
stock.DataStatus = EnumDataStatus.New.ToString();
stock.CreatedBy = User.Identity.Name;
stock.CreatedDate = DateTime.Now;
_tStockRepository.Save(stock);
//set hpp equals price * quantity
decimal checkqty = qty.HasValue ? qty.Value : 0;
decimal checkprice = price.HasValue ? price.Value : 0;
hpp = checkqty * checkprice;
}
else
{
IList list = _tStockRepository.GetSisaStockList(det.ItemId, mWarehouse);
TStock stock;
object[] arr;
decimal? sisa;
TStockRef stockRef;
for (int i = 0; i < list.Count; i++)
{
arr = (object[])list[i];
stock = arr[0] as TStock;
sisa = (decimal)arr[1];
stockRef = new TStockRef(stock);
stockRef.SetAssignedIdTo(Guid.NewGuid().ToString());
stockRef.StockId = stock;
if (sisa >= qty)
{
stockRef.StockRefQty = qty;
}
else
{
stockRef.StockRefQty = sisa;
}
stockRef.TransDetId = det;
stockRef.StockRefPrice = det.TransDetPrice;
stockRef.StockRefDate = transDate;
stockRef.StockRefStatus = transStatus;
stockRef.StockRefDesc = det.TransDetDesc;
stockRef.CreatedBy = User.Identity.Name;
stockRef.CreatedDate = DateTime.Now;
stockRef.DataStatus = EnumDataStatus.New.ToString();
_tStockRefRepository.Save(stockRef);
qty = qty - sisa;
decimal checkqty = stockRef.StockRefQty.HasValue ? stockRef.StockRefQty.Value : 0;
decimal checkprice = stock.StockPrice.HasValue ? stock.StockPrice.Value : 0;
hpp += checkqty * checkprice;
if (qty <= 0)
{
break;
}
}
}
return(hpp);
}
