private List <StockList> GenerateList(DataTable dt)
{
List <StockList> StockList = new List <StockList>();
foreach (DataRow DataRow in dt.Select("QtyBalance > 0"))
{
StockList Stock = new StockList();
Stock.MovementID = Convert.ToInt32(DataRow["MovementID"]);
Stock.TranDate = Convert.ToDateTime(DataRow["TransDate"]);
Stock.QtyBalance = Convert.ToDecimal(DataRow["QtyBalance"]);
Stock.Cost = Convert.ToDecimal(DataRow["Cost"]);
StockList.Add(Stock);
}
return(StockList);
}
/// <summary>
/// Why is this here???
/// </summary>
/// <param name="id_transfer_detail"></param>
/// <param name="id_item_product"></param>
/// <returns></returns>
public List <StockList> MovementForTransfer(int id_transfer_detail, int id_item_product)
{
List <StockList> StockList = new List <StockList>();
using (db db = new db())
{
List <item_movement> Items_InStockLIST = db.item_movement.Where(x => x.id_transfer_detail == id_transfer_detail && x.id_item_product == id_item_product && x.debit > 0).ToList();
foreach (item_movement item_movement in Items_InStockLIST)
{
StockList Stock = new StockList();
Stock.MovementID = (int)item_movement.id_movement;
Stock.TranDate = item_movement.trans_date;
Stock.QtyBalance = item_movement.debit;
Stock.Cost = item_movement.item_movement_value.Sum(x => x.unit_value);
StockList.Add(Stock);
}
}
return(StockList);
}