public INVTransferLineCollection SelectByField(int transferHeaderID)
{
List <INVTransferLine> transferLineList = new List <INVTransferLine>();
INVTransferLineCollection invtransferLineCollection = transferLineService.SelectByField("TransferHeaderID", transferHeaderID, null, DataLayer.TypeOperation.Equal);
transferLineList = (
from line in invtransferLineCollection
join product in productService.SelectAll() on line.ProductID equals product.ProductID
select new INVTransferLine
{
TransferLineID = line.TransferLineID,
TransferHeaderID = line.TransferHeaderID,
ProductID = line.ProductID,
ProductName = product.ProductName,
Qty = line.Qty,
CreatedBy = line.CreatedBy,
CreateDate = line.CreateDate,
UpdatedBy = line.UpdatedBy,
UpdateDate = line.UpdateDate,
IsDeleted = line.IsDeleted,
DeletedBy = line.DeletedBy,
DeletedDate = line.DeletedDate
}
).ToList();
invtransferLineCollection = new INVTransferLineCollection();
invtransferLineCollection.AddRange(transferLineList);
return(invtransferLineCollection);
}
public List <INVAdjustStock> getAllINVAdjustStock()
{
List <INVAdjustStock> resultList = new List <INVAdjustStock>();
try
{
resultList = (from item in SelectAll()
join product in productService.SelectAll() on item.ProductID equals product.ProductID
join invt in invinventoryService.SelectAll() on item.InventoryID equals invt.InventoryID
join aRes in invAdjustStockReasonService.SelectAll() on item.AdjustReasonID equals aRes.AdjustStockReasonID
join sType in invStockTypeService.SelectAll() on item.StockTypeID equals sType.StockTypeID
join oldSType in invStockTypeService.SelectAll() on item.OldStockTypeID equals oldSType.StockTypeID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
select new INVAdjustStock()
{
AdjustReasonID = item.AdjustReasonID,
AdjustStockID = item.AdjustStockID,
BatchID = item.BatchID,
CreatedBy = item.CreatedBy,
CreatedByName = usr.UserName,
CredateDate = item.CredateDate,
InventoryID = item.InventoryID,
ProductID = item.ProductID,
ProductName = product.ProductName,
Qty = item.Qty,
StockTypeID = item.StockTypeID,
UpdateDate = item.UpdateDate,
UpdatedBy = item.UpdatedBy,
StockTypeName = sType.StockTypeName,
OldStockTypeName = oldSType.StockTypeName,
InventoryName = invt.InventoryName,
AdjustReasonName = aRes.AdjustStockreasonName
}
).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(resultList);
}
private void FrmOpenTakingInventory_Load(object sender, EventArgs e)
{
INVInventoryService inventoryService = new INVInventoryService();
cmb_inventory.DataSource = inventoryService.SelectAll();
cmb_inventory.DisplayMember = "InventoryName";
cmb_inventory.ValueMember = "InventoryID";
BDProductService productService = new BDProductService();
cmb_Product.DataSource = productService.SelectAll();
cmb_Product.DisplayMember = "ProductName";
cmb_Product.ValueMember = "ProductID";
BDProductGroupService productGroupService = new BDProductGroupService();
cmb_productGroup.DataSource = productGroupService.SelectAll();
cmb_productGroup.DisplayMember = "ProductGroupName";
cmb_productGroup.ValueMember = "ProductGroupID";
ResetFields();
}