public async Task <ActionResult <IncomeItem> > PostIncomeItem(IncomeItem incomeItem) { _context.IncomeItems.Add(incomeItem); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetIncomeItem), new { id = incomeItem.Id }, incomeItem)); }
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); }
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); }
public void AddItem(IncomeItem item) { if (item == null) { throw new Exception("item can't be null"); } this.Items.Add(item); }
public void RemoveItems(IncomeItem item) { if (item == null) { throw new Exception("item can't be null"); } this.Items.Remove(item); }
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(); } }
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); }
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(); } }
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); }
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 }); }
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); }
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); } } }
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); }
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()); }
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); }
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; } }
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"); } }
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); }
/// <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)); }
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))); }
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(); }