Пример #1
0
        public async Task <ActionResult <IncomeItem> > PostIncomeItem(IncomeItem incomeItem)
        {
            _context.IncomeItems.Add(incomeItem);
            await _context.SaveChangesAsync();

            return(CreatedAtAction(nameof(GetIncomeItem), new { id = incomeItem.Id }, incomeItem));
        }
Пример #2
0
        public async Task <BudgetItemViewModel> AddBudgetItemAsync()
        {
            BudgetItemViewModel vm = new BudgetItemViewModel(this.dbFilePath);

            vm.ItemUpdated += OnItemUpdate;
            BudgetItem item = null;

            if (this.CategoryType == BudgetCategoryType.Income)
            {
                item          = new IncomeItem();
                item.ItemType = BudgetItemType.Income;
            }
            else
            {
                item          = new ExpenseItem();
                item.ItemType = BudgetItemType.Expense;
            }
            item.budgetCategory   = model;
            item.budgetCategoryId = model.id;
            item.StartDate        = DateTime.Now;
            item.recurring        = true;
            item.frequency        = Frequency.Monthly;
            await vm.PopulateVMAsync(item);

            vm.IsNew = true;
            this.BudgetItems.Add(vm);
            this.SelectedBudgetItem = vm;
            return(vm);
        }
Пример #3
0
        public async Task <IActionResult> PutIncomeItem(long id, IncomeItem incomeItem)
        {
            if (id != incomeItem.Id)
            {
                return(BadRequest());
            }

            _context.Entry(incomeItem).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException e)
            {
                if (!IncomeItemExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw e;
                }
            }

            return(NoContent());
        }
        private void GoToEditPage()
        {
            IncomeItem income = this;

            MainViewModel.GetInstance().IncomeItemViewModel = new IncomeItemViewModel(income);
            App.Navigator.PushAsync(new IncomeItemPage());
        }
        public async Task <IncomeItem> AddIncomeItemAsync(IncomeItem income)
        {
            var inserted = await connection.InsertAsync(income);

            //income.IsNew = false;
            return(income);
        }
Пример #6
0
        public void AddItem(IncomeItem item)
        {
            if (item == null)
            {
                throw new Exception("item can't be null");
            }

            this.Items.Add(item);
        }
Пример #7
0
        public void RemoveItems(IncomeItem item)
        {
            if (item == null)
            {
                throw new Exception("item can't be null");
            }

            this.Items.Remove(item);
        }
Пример #8
0
 public void AddIncome(IncomeItem item)
 {
     using (var DataContext = new Entities())
     {
         DataContext.Incomes.Add(new Incomes {
             Amount = item.Amount, Description = item.Description, Frequency = Convert.ToString(item.Frequency), User_Id = item.User_Id
         });
         DataContext.SaveChanges();
     }
 }
Пример #9
0
        private IncomeItem CreateIncomeItem()
        {
            IncomeItem incomeItem = new IncomeItem();

            incomeItem.ProductID  = _product.ID;
            incomeItem.Quantity   = Convert.ToInt32(txtProdQuantity.Text);
            incomeItem.UnityPrice = Convert.ToDouble(txtProdPrice.Text);
            incomeItem.Profit     = Convert.ToDouble(txtProductProfit.Text);

            return(incomeItem);
        }
Пример #10
0
 public void EditIncome(IncomeItem item)
 {
     using (var DataContext = new Entities())
     {
         var itemToEdit = DataContext.Incomes.Where(b => b.Id == item.ID).FirstOrDefault();
         itemToEdit.Amount      = item.Amount;
         itemToEdit.Description = item.Description;
         itemToEdit.Frequency   = Convert.ToString(item.Frequency);
         DataContext.SaveChanges();
     }
 }
Пример #11
0
        public IncomeItem FindIncome(int id)
        {
            IncomeItem item;

            using (var DataContext = new Entities())
            {
                var budgetItem = DataContext.Incomes.Where(b => b.Id == id).FirstOrDefault();
                item = new IncomeItem(id: Convert.ToInt32(budgetItem.Id), amount: Convert.ToDecimal(budgetItem.Amount), description: budgetItem.Description, frequency: Convert.ToChar(budgetItem.Frequency), user_id: budgetItem.User_Id);
            }
            return(item);
        }
Пример #12
0
 public static EditIncome ToViewModel(this IncomeItem item)
 {
     return(new EditIncome
     {
         Id = item.Id,
         AccountId = item.AccountId,
         IncomeTypeId = item.IncomeTypeId,
         DateTime = item.DateTime.ToStandardString(),
         Total = item.Total.ToStandardString(),
         OwnerId = item.OwnerId,
         IsCorrection = item.IsCorrection
     });
 }
Пример #13
0
        private static IncomeItem MapToIncomeItem(InvoiceItem item)
        {
            var result = new IncomeItem()
            {
                CatalogNum  = item.Sku,
                Description = item.Description,
                Price       = item.Price,
                Quantity    = item.Quantity,
                VatType     = item.VatIncluded ? 1 : 0
            };

            return(result);
        }
Пример #14
0
        public Response ValidateIncomeItem(IncomeItem incomeitem)
        {
            Validator validator = new Validator();

            ValidatePrice(incomeitem.UnityPrice.ToString(), validator);
            ValidateQuantity(incomeitem.Quantity.ToString(), validator);
            ValidateProductId(incomeitem.ProductID, validator);
            ValidateProfit(incomeitem.Profit.ToString(), validator);

            Response result = validator.Validate();

            return(result);
        }
        public async Task DeleteIncomeItemAsync(IncomeItem income)
        {
            if (context.IncomeItem.Any(i => i.id == income.id))
            {
                await Task.Run(() => context.IncomeItem.Attach(income));

                await Task.Run(() => context.Entry(income).State = Microsoft.EntityFrameworkCore.EntityState.Deleted);

                if (income.budgetCategory != null)
                {
                    await Task.Run(() => context.Entry(income.budgetCategory).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
                }
            }
        }
Пример #16
0
        public void CreateIncome(IncomeItem income, decimal balance)
        {
            var transaction = new Transaction
            {
                OwnerId     = income.OwnerId,
                InitiatorId = income.AccountId,
                DateTime    = income.DateTime,
                IncomeId    = income.Id,
                Total       = income.Total,
                Balance     = balance
            };

            _repository.Create(transaction);
        }
Пример #17
0
        public async Task UpdateIncome(int accountId, IncomeItem income, decimal balance)
        {
            var transaction =
                await _transactionQueries.GetIncomeTransaction(accountId, income.Id).ConfigureAwait(false);

            if (transaction == null)
            {
                return;
            }
            transaction.InitiatorId = income.AccountId;
            transaction.Total       = income.Total;
            transaction.Balance     = balance;
            _repository.Update(transaction.ToEntity());
        }
Пример #18
0
        public IncomeItem CreateIncome(int typeId, DateTime dateTime, decimal total, int accountId)
        {
            var commands = _unitOfWork.GetCommandRepository <IncomeItem>();
            var entity   = new IncomeItem
            {
                AccountId    = accountId,
                DateTime     = dateTime,
                IncomeTypeId = typeId,
                Total        = total,
                OwnerId      = UserSession.UserId
            };

            commands.Create(entity);
            return(entity);
        }
Пример #19
0
        public async Task <Response> Update(IncomeItem incomeItem)
        {
            try
            {
                var response = await ApiService
                               .GetInstance()
                               .Update("api/incomes/update", incomeItem, incomeItem.Id);

                return(response);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Пример #20
0
 public SizeWidgetViewModel(
     IncomeItem selectItem,
     INavigationManager navigationManager,
     IUnitOfWork uoW,
     SizeService sizeService,
     IList <IncomeItem> existItems = null) : base(navigationManager)
 {
     this.sizeService = sizeService;
     IsModal          = true;
     Title            = "Добавить размеры:";
     nomenclature     = selectItem.Nomenclature;
     selectItemHeigt  = selectItem.Height;
     this.uoW         = uoW;
     ExistItems       = existItems;
     ConfigureSizes();
 }
        public async Task UpdateIncomeItemAsync(IncomeItem income)
        {
            if (context.IncomeItem.Any(c => c.id == income.id))
            {
                await Task.Run(() => context.IncomeItem.Attach(income));

                await Task.Run(() => context.Entry(income).State = Microsoft.EntityFrameworkCore.EntityState.Modified);

                if (income.budgetCategory != null)
                {
                    await Task.Run(() => context.Entry(income.budgetCategory).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
                }
            }
            else
            {
                throw new Exception("Unable to locate existing Income Item record with provided Primary Key value");
            }
        }
Пример #22
0
        private void InsertIncomeItem()
        {
            IncomeItem incomeItem = CreateIncomeItem();
            Response   response   = _incomeBLL.ValidateIncomeItem(incomeItem);

            if (!response.Success)
            {
                MessageBox.Show(response.Message);
                return;
            }
            if (_incomeItems.Any(x => x.ProductID == incomeItem.ProductID))
            {
                MessageBox.Show("Produto já adicionado. Caso queira alterar a quantidade, remova o item adicionado com dois cliques e insira o produto novamente.");
                return;
            }
            _incomeItems.Add(incomeItem);

            UpdateToTalValue();
        }
        public async Task <IncomeItem> AddIncomeItemAsync(IncomeItem income)
        {
            if (!context.IncomeItem.Any(i => i.id == income.id))
            {
                await Task.Run(() => context.IncomeItem.Add(income));

                await Task.Run(() => context.Entry(income).State = Microsoft.EntityFrameworkCore.EntityState.Added);

                if (income.budgetCategory != null)
                {
                    await Task.Run(() => context.Entry(income.budgetCategory).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
                }
            }
            else
            {
                throw new Exception("An income item record already exists with the same Primary Key value");
            }
            return(income);
        }
Пример #24
0
        /// <summary>
        /// 获取数据源
        /// </summary>
        /// <param name="start">开始日期</param>
        /// <param name="end">结束日期</param>
        /// <param name="key">关键字</param>
        /// <returns></returns>
        public string getDataSource(DateTime?startTime, DateTime?end, int start, int length, int draw)
        {
            var total = 0;
            //获取时间分页
            List <DateTime> dateList = new List <DateTime>();

            if (end == null)
            {
                end = DateTime.Now.Date;
            }
            if (startTime == null)
            {
                startTime = end.Value.AddDays(-7);
            }
            for (int i = 0; i <= (end - startTime).Value.TotalDays; i++)
            {
                dateList.Add(startTime.Value.AddDays(i));
            }
            total = dateList.Count;
            List <DateTime> datePage = dateList.OrderBy(q => q).Skip(start).Take(length).ToList();

            //获取时间内的总收入和人数
            List <IncomeItem> list = new List <IncomeItem>();

            foreach (var item in datePage)
            {
                DateTime tempStart = item.Date;
                DateTime tempEnd   = tempStart.AddDays(1);

                IncomeItem income = new IncomeItem()
                {
                    Date      = tempStart.ToString("yyyy-MM-dd"),
                    AllCount  = DB.Member_Info.Where(q => q.CreateTime >= tempStart && q.CreateTime < tempEnd).Count(),
                    AllAmount = DB.Member_Info.Where(q => q.CreateTime >= tempStart && q.CreateTime < tempEnd)
                                .Select(q => q.ActiveAmount).Sum() ?? 0
                };
                list.Add(income);
            }

            return(ToPage(list, total, start, length, draw));
        }
Пример #25
0
        public IActionResult AddToIncome(int medItemId, int count)
        {
            var incomeItem = new IncomeItem()
            {
                MedicalItemId = medItemId,
                Count         = count
            };

            var incomeList = HttpContext.Session.Get <List <IncomeItem> >("Incomes");

            if (incomeList.Any(i => i.MedicalItemId == incomeItem.MedicalItemId))
            {
                incomeList.Find(i => i.MedicalItemId == incomeItem.MedicalItemId).Count += incomeItem.Count;
            }
            else
            {
                incomeList.Add(incomeItem);
            }

            HttpContext.Session.Set("Incomes", incomeList);

            return(RedirectToAction(nameof(Create)));
        }
Пример #26
0
        public IList <OperationToDocumentReference> GetReferencedDocuments(params int[] operationsIds)
        {
            OperationToDocumentReference docAlias = null;
            EmployeeIssueOperation       employeeIssueOperationAlias = null;
            ExpenseItem           expenseItemAlias           = null;
            IncomeItem            incomeItemAlias            = null;
            CollectiveExpenseItem collectiveExpenseItemAlias = null;
            WriteoffItem          writeoffItemAlias          = null;

            var result = RepoUow.Session.QueryOver <EmployeeIssueOperation>(() => employeeIssueOperationAlias)
                         .JoinEntityAlias(() => expenseItemAlias, () => expenseItemAlias.EmployeeIssueOperation.Id == employeeIssueOperationAlias.Id, JoinType.LeftOuterJoin)
                         .JoinEntityAlias(() => collectiveExpenseItemAlias, () => collectiveExpenseItemAlias.EmployeeIssueOperation.Id == employeeIssueOperationAlias.Id, JoinType.LeftOuterJoin)
                         .JoinEntityAlias(() => incomeItemAlias, () => incomeItemAlias.ReturnFromEmployeeOperation.Id == employeeIssueOperationAlias.Id, JoinType.LeftOuterJoin)
                         .JoinEntityAlias(() => writeoffItemAlias, () => writeoffItemAlias.EmployeeWriteoffOperation.Id == employeeIssueOperationAlias.Id, JoinType.LeftOuterJoin)
                         .Where(x => x.Id.IsIn(operationsIds))
                         .SelectList(list => list
                                     .Select(i => i.Id).WithAlias(() => docAlias.OperationId)
                                     .Select(() => expenseItemAlias.Id).WithAlias(() => docAlias.ExpenceItemId)
                                     .Select(() => expenseItemAlias.ExpenseDoc.Id).WithAlias(() => docAlias.ExpenceId)
                                     .Select(() => collectiveExpenseItemAlias.Id).WithAlias(() => docAlias.CollectiveExpenseItemId)
                                     .Select(() => collectiveExpenseItemAlias.Document.Id).WithAlias(() => docAlias.CollectiveExpenseId)
                                     .Select(() => incomeItemAlias.Id).WithAlias(() => docAlias.IncomeItemId)
                                     .Select(() => incomeItemAlias.Document.Id).WithAlias(() => docAlias.IncomeId)
                                     .Select(() => writeoffItemAlias.Id).WithAlias(() => docAlias.WriteoffItemId)
                                     .Select(() => writeoffItemAlias.Document.Id).WithAlias(() => docAlias.WriteoffId)
                                     )
                         .TransformUsing(Transformers.AliasToBean <OperationToDocumentReference>())
                         .List <OperationToDocumentReference>();

            foreach (var item in result)
            {
                item.OperationType = OperationType.EmployeeIssue;
            }

            return(result);
        }
 public IActionResult AddAccount(IncomeItem account)
 {
     return(Ok(_incomeItemService.AddAccount(account)));
 }
 public IncomeManagingViewModel(IncomeItem incomeItem)
 {
     this.Frequencies = new FrequencyRepository().GetAllIndicators();
     this.Users       = new UserRepository().GetAllUsers();
     this.IncomeItem  = incomeItem;
 }
        protected IQueryOver <WarehouseOperation> ItemsQuery(IUnitOfWork uow)
        {
            StockMovmentsJournalNode resultAlias = null;

            WarehouseOperation warehouseOperationAlias = null;

            ExpenseItem            expenseItemAlias            = null;
            IncomeItem             incomeItemAlias             = null;
            TransferItem           transferItemAlias           = null;
            CollectiveExpenseItem  collectiveExpenseItemAlias  = null;
            WriteoffItem           writeOffItemAlias           = null;
            EmployeeCard           employeeCardAlias           = null;
            EmployeeIssueOperation employeeIssueOperationAlias = null;
            CompletionResultItem   completionResultItemAlias   = null;
            CompletionSourceItem   completionSourceItemAlias   = null;

            Nomenclature     nomenclatureAlias = null;
            ItemsType        itemTypesAlias    = null;
            MeasurementUnits unitsAlias        = null;
            Size             sizeAlias         = null;
            Size             heightAlias       = null;

            var queryStock = uow.Session.QueryOver(() => warehouseOperationAlias)
                             .JoinAlias(() => warehouseOperationAlias.WearSize, () => sizeAlias, JoinType.LeftOuterJoin)
                             .JoinAlias(() => warehouseOperationAlias.Height, () => heightAlias, JoinType.LeftOuterJoin);

            if (Filter.Warehouse != null)
            {
                queryStock.Where(x => x.ReceiptWarehouse == Filter.Warehouse || x.ExpenseWarehouse == Filter.Warehouse);
            }

            if (Filter.StartDate.HasValue)
            {
                queryStock.Where(x => x.OperationTime >= Filter.StartDate.Value);
            }

            if (Filter.EndDate.HasValue)
            {
                queryStock.Where(x => x.OperationTime < Filter.EndDate.Value.AddDays(1));
            }

            if (Filter.StockPosition != null)
            {
                queryStock.Where(x => x.Nomenclature == Filter.StockPosition.Nomenclature);
                queryStock.Where(x => x.WearSize == Filter.StockPosition.WearSize);
                queryStock.Where(x => x.Height == Filter.StockPosition.Height);
                queryStock.Where(x => x.WearPercent == Filter.StockPosition.WearPercent);
            }

            if (Filter.Nomenclature != null)
            {
                queryStock.Where(x => x.Nomenclature == Filter.Nomenclature);
            }

            if (Filter.Size != null)
            {
                queryStock.Where(x => x.WearSize.Id == Filter.Size.Id);
            }

            if (Filter.Height != null)
            {
                queryStock.Where(x => x.Height.Id == Filter.Height.Id);
            }

            IProjection receiptProjection, expenseProjection;

            if (Filter.Warehouse != null)
            {
                receiptProjection = Projections.Conditional(
                    Restrictions.Eq(Projections
                                    .Property <WarehouseOperation>(x => x.ReceiptWarehouse.Id), Filter.Warehouse.Id),
                    Projections.Constant(true),
                    Projections.Constant(false)
                    );
                expenseProjection = Projections.Conditional(
                    Restrictions.Eq(Projections
                                    .Property <WarehouseOperation>(x => x.ExpenseWarehouse.Id), Filter.Warehouse.Id),
                    Projections.Constant(true),
                    Projections.Constant(false)
                    );

                switch (Filter.Direction)
                {
                case DirectionOfOperation.expense:
                    queryStock.Where(x => x.ExpenseWarehouse.Id == Filter.Warehouse.Id);
                    break;

                case DirectionOfOperation.receipt:
                    queryStock.Where(x => x.ReceiptWarehouse.Id == Filter.Warehouse.Id);
                    break;
                }
            }
            else
            {
                receiptProjection = Projections.Conditional(
                    Restrictions.IsNotNull(Projections
                                           .Property <WarehouseOperation>(x => x.ReceiptWarehouse.Id)),
                    Projections.Constant(true),
                    Projections.Constant(false)
                    );
                expenseProjection = Projections.Conditional(
                    Restrictions.IsNotNull(Projections
                                           .Property <WarehouseOperation>(x => x.ExpenseWarehouse.Id)),
                    Projections.Constant(true),
                    Projections.Constant(false)
                    );

                switch (Filter.Direction)
                {
                case DirectionOfOperation.expense:
                    queryStock.Where(x => x.ReceiptWarehouse == null);
                    break;

                case DirectionOfOperation.receipt:
                    queryStock.Where(x => x.ExpenseWarehouse == null);
                    break;
                }
            }

            queryStock
            .JoinAlias(() => warehouseOperationAlias.Nomenclature, () => nomenclatureAlias)
            .JoinAlias(() => nomenclatureAlias.Type, () => itemTypesAlias)
            .JoinAlias(() => itemTypesAlias.Units, () => unitsAlias)
            .JoinEntityAlias(() => expenseItemAlias, () => expenseItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => collectiveExpenseItemAlias, () => collectiveExpenseItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => incomeItemAlias, () => incomeItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => transferItemAlias, () => transferItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => writeOffItemAlias, () => writeOffItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => employeeIssueOperationAlias, () => employeeIssueOperationAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => employeeCardAlias, () => employeeIssueOperationAlias.Employee.Id == employeeCardAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => completionResultItemAlias, () => completionResultItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .JoinEntityAlias(() => completionSourceItemAlias, () => completionSourceItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin)
            .Where(GetSearchCriterion(
                       () => employeeCardAlias.FirstName,
                       () => employeeCardAlias.LastName,
                       () => employeeCardAlias.Patronymic
                       ));

            if (Filter.CollapseOperationItems)
            {
                queryStock.SelectList(list => list
                                      .SelectGroup(() => warehouseOperationAlias.Nomenclature.Id)
                                      .Select(() => warehouseOperationAlias.OperationTime).WithAlias(() => resultAlias.OperationTime)
                                      .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName)
                                      .Select(receiptProjection).WithAlias(() => resultAlias.Receipt)
                                      .Select(expenseProjection).WithAlias(() => resultAlias.Expense)
                                      .SelectSum(() => warehouseOperationAlias.Amount).WithAlias(() => resultAlias.Amount)
                                      .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName)
                                      .Select(() => employeeCardAlias.FirstName).WithAlias(() => resultAlias.EmployeeName)
                                      .Select(() => employeeCardAlias.LastName).WithAlias(() => resultAlias.EmployeeSurname)
                                      .Select(() => employeeCardAlias.Patronymic).WithAlias(() => resultAlias.EmployeePatronymic)

                                      //Ссылки
                                      .SelectGroup(() => expenseItemAlias.ExpenseDoc.Id).WithAlias(() => resultAlias.ExpenceId)
                                      .SelectGroup(() => collectiveExpenseItemAlias.Document.Id).WithAlias(() => resultAlias.CollectiveExpenseId)
                                      .SelectCount(() => employeeCardAlias.Id).WithAlias(() => resultAlias.NumberOfCollapsedRows)
                                      .SelectGroup(() => incomeItemAlias.Document.Id).WithAlias(() => resultAlias.IncomeId)
                                      .SelectGroup(() => transferItemAlias.Document.Id).WithAlias(() => resultAlias.TransferItemId)
                                      .SelectGroup(() => writeOffItemAlias.Document.Id).WithAlias(() => resultAlias.WriteoffId)
                                      .SelectGroup(() => completionResultItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromResultId)
                                      .SelectGroup(() => completionSourceItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromSourceId)

                                      .SelectGroup(() => sizeAlias.Name).WithAlias(() => resultAlias.WearSizeName)
                                      .SelectGroup(() => heightAlias.Name).WithAlias(() => resultAlias.HeightName)
                                      .SelectGroup(() => warehouseOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent)
                                      );
            }
            else
            {
                queryStock.SelectList(list => list
                                      .Select(() => warehouseOperationAlias.Id).WithAlias(() => resultAlias.Id)
                                      .Select(() => warehouseOperationAlias.OperationTime).WithAlias(() => resultAlias.OperationTime)
                                      .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName)
                                      .Select(receiptProjection).WithAlias(() => resultAlias.Receipt)
                                      .Select(expenseProjection).WithAlias(() => resultAlias.Expense)
                                      .Select(() => warehouseOperationAlias.Amount).WithAlias(() => resultAlias.Amount)
                                      .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName)
                                      .Select(() => sizeAlias.Name).WithAlias(() => resultAlias.WearSizeName)
                                      .Select(() => heightAlias.Name).WithAlias(() => resultAlias.HeightName)
                                      .Select(() => warehouseOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent)
                                      //Ссылки
                                      .Select(() => expenseItemAlias.Id).WithAlias(() => resultAlias.ExpenceItemId)
                                      .Select(() => expenseItemAlias.ExpenseDoc.Id).WithAlias(() => resultAlias.ExpenceId)
                                      .Select(() => collectiveExpenseItemAlias.Id).WithAlias(() => resultAlias.CollectiveExpenseItemId)
                                      .Select(() => collectiveExpenseItemAlias.Document.Id).WithAlias(() => resultAlias.CollectiveExpenseId)
                                      .Select(() => incomeItemAlias.Id).WithAlias(() => resultAlias.IncomeItemId)
                                      .Select(() => incomeItemAlias.Document.Id).WithAlias(() => resultAlias.IncomeId)
                                      .Select(() => transferItemAlias.Id).WithAlias(() => resultAlias.TransferId)
                                      .Select(() => transferItemAlias.Document.Id).WithAlias(() => resultAlias.TransferItemId)
                                      .Select(() => writeOffItemAlias.Id).WithAlias(() => resultAlias.WriteoffItemId)
                                      .Select(() => writeOffItemAlias.Document.Id).WithAlias(() => resultAlias.WriteoffId)
                                      .Select(() => employeeCardAlias.FirstName).WithAlias(() => resultAlias.EmployeeName)
                                      .Select(() => employeeCardAlias.LastName).WithAlias(() => resultAlias.EmployeeSurname)
                                      .Select(() => employeeCardAlias.Patronymic).WithAlias(() => resultAlias.EmployeePatronymic)
                                      .Select(() => completionResultItemAlias.Id).WithAlias(() => resultAlias.CompletionResultItemId)
                                      .Select(() => completionSourceItemAlias.Id).WithAlias(() => resultAlias.CompletionSourceItemId)
                                      .Select(() => completionSourceItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromSourceId)
                                      .Select(() => completionResultItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromResultId)
                                      );
            }

            return(queryStock
                   .OrderBy(x => x.OperationTime).Desc
                   .ThenBy(x => x.Id).Asc
                   .TransformUsing(Transformers.AliasToBean <StockMovmentsJournalNode>()));
        }
 public void Put(int id, [FromBody] IncomeItem item)
 {
     throw new NotImplementedException();
 }