public ICollection<ApprovedDetail> GetApprovedDetail(int orderId) { ICollection<ApprovedDetail> stockInformations = new Collection<ApprovedDetail>(); var balance = new Balance(); var approvedInformationTable = balance.GetApprovedByOrderID(orderId); foreach (DataRowView approvedInformationRow in approvedInformationTable) { var itemID = Convert.ToInt32(approvedInformationRow["ItemID"]); var unitID = Convert.ToInt32(approvedInformationRow["UnitID"]); var stockInformation = new ApprovedDetail { Item = _itemRepository.FindSingle(Convert.ToInt32(itemID)), Unit = _unitOfIssueRepository.FindSingle(Convert.ToInt32(unitID)), Manufacturer = DBNull.Value != approvedInformationRow["ManufacturerId"] ? _manufacturerRepository.FindSingle(Convert.ToInt32(approvedInformationRow["ManufacturerId"])) : null, ActivityGroup = _activityRepository.FindSingle(Convert.ToInt32(approvedInformationRow["ActivityID"]), Convert.ToBoolean(approvedInformationRow["IsDeliveryNote"])), ExpiryDate = DBNull.Value != approvedInformationRow["ExpiryDate"] ? Convert.ToDateTime(approvedInformationRow["ExpiryDate"]) : (DateTime?)null, physicalStore = DBNull.Value != approvedInformationRow["PhysicalStoreID"] ? _physicalStoreRepository.FindSingle(Convert.ToInt32(approvedInformationRow["PhysicalStoreID"])) : null, Quantity = Convert.ToDecimal(approvedInformationRow["ApprovedQuantity"]) }; stockInformations.Add(stockInformation); } return stockInformations; }