private List <StockList> GenerateList(DataTable dt)
{
List <StockList> StockList = new List <Class.StockList>();
foreach (DataRow DataRow in dt.Rows)
{
StockList Stock = new Class.StockList();
Stock.ItemCode = DataRow["ItemCode"].ToString();
Stock.ItemName = DataRow["ItemName"].ToString();
Stock.Location = DataRow["Location"].ToString();
Stock.LocationID = Convert.ToInt16(DataRow["LocationID"]);
Stock.Measurement = DataRow["Measurement"].ToString();
Stock.ProductID = Convert.ToInt16(DataRow["ProductID"]);
if (!DataRow.IsNull("Quantity"))
{
Stock.Quantity = Convert.ToDecimal(DataRow["Quantity"]);
}
else
{
Stock.Quantity = 0;
}
if (!DataRow.IsNull("Cost"))
{
Stock.Cost = Convert.ToDecimal(DataRow["Cost"]);
}
else
{
Stock.Cost = 0;
}
StockList.Add(Stock);
}
return(StockList);
}
private async void item_movementDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Class.StockList _item_movement = item_inventoryDataGrid.SelectedItem as Class.StockList;
if (_item_movement != null)
{
int id_item_product = _item_movement.ProductID;
int id_location = _item_movement.LocationID;
using (db db = new db())
{
item_movementViewSource = ((CollectionViewSource)(FindResource("item_movementViewSource")));
item_movementViewSource.Source = await db.item_movement.Where(x => x.id_company == entity.CurrentSession.Id_Company &&
x.id_item_product == id_item_product &&
x.app_location.id_location == id_location &&
x.status == Status.Stock.InStock &&
x.trans_date <= InventoryDate
).OrderByDescending(x => x.trans_date).ToListAsync();
foreach (item_movement item_movement in item_movementViewSource.View.Cast <item_movement>().ToList())
{
if (item_movement.item_movement_dimension.Count() > 0)
{
foreach (item_movement_dimension item_movement_dimension in item_movement.item_movement_dimension)
{
if (!(item_movement.comment.Contains(item_movement_dimension.app_dimension.name)))
{
item_movement.comment += " " + item_movement_dimension.app_dimension.name + " : " + Math.Round(item_movement_dimension.value, 2) + ",";
}
}
}
}
}
}
}
