public List <ViewModels.InternalMovementLogViewModel> GetAllInternalMovmentLog() { List <ViewModels.InternalMovementLogViewModel> internalMovmentLogViewModel = new List <ViewModels.InternalMovementLogViewModel>(); ViewModels.InternalMovementLogViewModel _internalMovment; var movements = _unitOfWork.InternalMovementRepository.GetAll(); var internalMovments = (from c in movements select c).ToList(); foreach (var internalMovment in internalMovments) { foreach (var transaction in internalMovment.TransactionGroup.Transactions) { if (transaction.TransactionGroupID == internalMovment.TransactionGroupID) { if (transaction.QuantityInMT >= 0) { var fromStore = _unitOfWork.TransactionRepository.FindBy(c => c.TransactionGroupID == internalMovment.TransactionGroupID && c.QuantityInMT < 0).Select(q => q.Store.Name + " - " + q.Store.StoreManName).FirstOrDefault(); var fromStack = _unitOfWork.TransactionRepository.FindBy(c => c.TransactionGroupID == internalMovment.TransactionGroupID && c.QuantityInMT < 0).Select(q => q.Stack.Value).FirstOrDefault(); var commodity = _unitOfWork.CommodityRepository.FindBy(c => c.CommodityID == transaction.CommodityID).Select(c => c.Name).Single(); _internalMovment = new ViewModels.InternalMovementLogViewModel(); _internalMovment.TransactionId = transaction.TransactionID; _internalMovment.FromStore = fromStore; // (from c in db.Transactions where ((c.TransactionGroupID == internalMovment.TransactionGroupID) && (c.QuantityInMT < 0)) select (c.Store.Name + " - " + c.Store.StoreManName)).FirstOrDefault(); _internalMovment.FromStack = fromStack; // (from c in db.Transactions where ((c.TransactionGroupID == internalMovment.TransactionGroupID) && (c.QuantityInMT < 0)) select c.Stack.Value).FirstOrDefault(); _internalMovment.SelectedDate = internalMovment.TransferDate; _internalMovment.ToStore = string.Format("{0} - {1} ", transaction.Store.Name, transaction.Store.StoreManName); _internalMovment.ToStack = transaction.Stack.Value; _internalMovment.RefernaceNumber = internalMovment.ReferenceNumber; _internalMovment.CommodityName = commodity;// repository.Commodity.FindById(transaction.CommodityID).Name; _internalMovment.Program = transaction.Program.Name; _internalMovment.ProjectCodeName = transaction.ProjectCode.Value; _internalMovment.ShippingInstructionNumber = transaction.ShippingInstruction.Value; _internalMovment.Unit = transaction.Unit.Name; _internalMovment.QuantityInUnit = transaction.QuantityInUnit; _internalMovment.QuantityInMt = transaction.QuantityInMT; _internalMovment.Reason = internalMovment.Detail.Description; _internalMovment.Note = internalMovment.Notes; _internalMovment.ApprovedBy = internalMovment.ApprovedBy; _internalMovment.Reason = internalMovment.Detail.Name; internalMovmentLogViewModel.Add(_internalMovment); } } } } return(internalMovmentLogViewModel); }
public List<ViewModels.InternalMovementLogViewModel> GetAllInternalMovmentLog() { List<ViewModels.InternalMovementLogViewModel> internalMovmentLogViewModel = new List<ViewModels.InternalMovementLogViewModel>(); ViewModels.InternalMovementLogViewModel _internalMovment; var movements = _unitOfWork.InternalMovementRepository.GetAll(); var internalMovments = (from c in movements select c).ToList(); foreach (var internalMovment in internalMovments) { foreach (var transaction in internalMovment.TransactionGroup.Transactions) { if (transaction.TransactionGroupID == internalMovment.TransactionGroupID) { if (transaction.QuantityInMT >= 0) { var fromStore = _unitOfWork.TransactionRepository.FindBy(c=>c.TransactionGroupID == internalMovment.TransactionGroupID && c.QuantityInMT < 0).Select(q=>q.Store.Name + " - " + q.Store.StoreManName).FirstOrDefault(); var fromStack = _unitOfWork.TransactionRepository.FindBy(c => c.TransactionGroupID == internalMovment.TransactionGroupID && c.QuantityInMT < 0).Select(q => q.Stack.Value).FirstOrDefault(); var commodity = _unitOfWork.CommodityRepository.FindBy(c=>c.CommodityID == transaction.CommodityID).Select(c => c.Name).Single(); _internalMovment = new ViewModels.InternalMovementLogViewModel(); _internalMovment.TransactionId = transaction.TransactionID; _internalMovment.FromStore = fromStore;// (from c in db.Transactions where ((c.TransactionGroupID == internalMovment.TransactionGroupID) && (c.QuantityInMT < 0)) select (c.Store.Name + " - " + c.Store.StoreManName)).FirstOrDefault(); _internalMovment.FromStack = fromStack;// (from c in db.Transactions where ((c.TransactionGroupID == internalMovment.TransactionGroupID) && (c.QuantityInMT < 0)) select c.Stack.Value).FirstOrDefault(); _internalMovment.SelectedDate = internalMovment.TransferDate; _internalMovment.ToStore = string.Format("{0} - {1} ", transaction.Store.Name, transaction.Store.StoreManName); _internalMovment.ToStack = transaction.Stack.Value; _internalMovment.RefernaceNumber = internalMovment.ReferenceNumber; _internalMovment.CommodityName = commodity;// repository.Commodity.FindById(transaction.CommodityID).Name; _internalMovment.Program = transaction.Program.Name; _internalMovment.ProjectCodeName = transaction.ProjectCode.Value; _internalMovment.ShippingInstructionNumber = transaction.ShippingInstruction.Value; _internalMovment.Unit = transaction.Unit.Name; _internalMovment.QuantityInUnit = transaction.QuantityInUnit; _internalMovment.QuantityInMt = transaction.QuantityInMT; _internalMovment.Reason = internalMovment.Detail.Description; _internalMovment.Note = internalMovment.Notes; _internalMovment.ApprovedBy = internalMovment.ApprovedBy; _internalMovment.Reason = internalMovment.Detail.Name; internalMovmentLogViewModel.Add(_internalMovment); } } } } return internalMovmentLogViewModel; }