private void AddRecordToGrid(int counter, TransferStockViewModel stock)
{
if (selectedProducts.Contains(stock, new TranferStockComparer()))
{
return;
}
if (!UpdateRow)
{
counter = dgvProductList.Rows.Count > 0 ? dgvProductList.Rows.Add(stock.ProductName) : dgvProductList.Rows.Add();
}
dgvProductList.Rows[counter].Cells["colProductName"].Value = stock.ProductName;
dgvProductList.Rows[counter].Cells["colQuantity"].Value = stock.Quantity;
dgvProductList.Rows[counter].Cells["colCurrQty"].Value = stock.Quantity;
dgvProductList.Rows[counter].Cells["colProductID"].Value = stock.ProductID;
dgvProductList.Rows[counter].Cells["colLocationID"].Value = stock.LocationID;
DataGridViewComboBoxCell combocell = (DataGridViewComboBoxCell)dgvProductList.Rows[counter].Cells[2];
combocell.Value = stock.LocationID;
combocell.ReadOnly = true;
DataGridViewButtonCell buttoncell = (DataGridViewButtonCell)dgvProductList.Rows[counter].Cells[1];
buttoncell.Value = "...";
selectedProducts.Add(stock);
}
public TransferStockViewModel ReadById(int id)
{
var Query = from a in dbContext.TransferOutDocs
join b in dbContext.SPKDocs on a.Code equals b.Reference
join c in dbContext.TransferOutDocItems on a.Id equals c.TransferOutDocsId
where a.Code.Contains("EFR-KB/RTT") && b.DestinationName != "GUDANG TRANSFER STOCK BATEEQ" &&
a.Id == id
select new
{
id = (int)a.Id,
code = a.Code,
createdBy = a.CreatedBy,
createdDate = a.CreatedUtc,
destinationname = a.DestinationName,
sourcecode = a.SourceCode,
sourcename = a.SourceName,
password = b.Password,
transfercode = b.SourceCode,
destinationcode = a.DestinationCode,
referensi = a.Reference,
transfername = b.SourceName,
itemCode = c.ItemCode,
itemName = c.ItemName,
quantity = c.Quantity,
price = c.DomesticSale,
remark = c.Remark
};
List <TransferOutDocItemViewModel> transferOutDocsitems = new List <TransferOutDocItemViewModel>();
foreach (var i in Query)
{
transferOutDocsitems.Add(new TransferOutDocItemViewModel
{
item = new ItemViewModel
{
code = i.itemCode,
name = i.itemName,
domesticSale = i.price,
},
quantity = i.quantity,
remark = i.remark
});
}
TransferStockViewModel model = new TransferStockViewModel
{
code = Query.FirstOrDefault().code,
createdBy = Query.FirstOrDefault().createdBy,
createdDate = Query.FirstOrDefault().createdDate,
destinationcode = Query.FirstOrDefault().destinationcode,
destinationname = Query.FirstOrDefault().destinationname,
id = Query.FirstOrDefault().id,
password = Query.FirstOrDefault().password,
referensi = Query.FirstOrDefault().referensi,
sourcecode = Query.FirstOrDefault().sourcecode,
sourcename = Query.FirstOrDefault().sourcename,
transfercode = Query.FirstOrDefault().transfercode,
transfername = Query.FirstOrDefault().transfername,
items = transferOutDocsitems
};
//var model = dbSet.Where(m => m.Id == id)
// .Include(m => m.Items)
// .FirstOrDefault();
return(model);
}
