public async Task <JsonResult> Create([FromBody] Movement movement) { movement.DateAdded = DateTime.Now; _context.Add(movement); await _context.SaveChangesAsync(); return(Json(new { success = true })); }
public async Task <JsonResult> Create([FromBody] Category category) { _context.Add(category); await _context.SaveChangesAsync(); return(Json(new { success = true })); }
public async Task <JsonResult> Create([FromBody] RecurringMovement recurringMovement) { try { Category rCategory = recurringMovement.Category; recurringMovement.Category = null; _context.Add(recurringMovement); await _context.SaveChangesAsync(); if (rCategory != null) { Category category = _context.Categories.First(c => c.CategoryID == rCategory.CategoryID); IQueryable toUpdate = _context.RecurringMovements.Where(m => m.Description == recurringMovement.Description && m.Amount == recurringMovement.Amount); foreach (RecurringMovement movement in toUpdate) { movement.Category = category; _context.Update(movement); } await _context.SaveChangesAsync(); } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, error = e.Message })); } }
public async Task <IActionResult> Create([Bind("ExpenseId,UserId,MortgageRent,Phone,Gas,WaterSewerTrash,Electricity,CableInternet,HomeAlarmSystem,MaintenanceRepairs,VehiclePayment,Insurance,Fuel,UberLyft,LicenseRegistration,Maintenance,HomeRenters,Health,Dental,Vision,Pet,Life,Groceries,DiningOut,Coffee,ClothesShoes,SchoolTuitionSupplies,SportsOrganizationFees,Childcare,LunchMoney,ToysGames,HairCutsSalon,ManiPediWaxing,ClothesShoesAccessories,DryCleaning,GymSupplements,OrganizationDuesFees,Music,Video,MovieTheater,Concerts,SportingEvents,DateNights,Alchohol,TobaccoVaping,PersonalLoan,CreditCard,StudentLoan,Federal,State,Medicare,SocialSecurityFICA,EmergencySavings,CDsMoneyMarkets,IRA401k,StocksMutualFunds,Tithesffering,Charity,RetirementHome,Attorney,AlimonyChildSupport,LienJudgmentPayment,MonthlyIncome,TotalCost,IncomeVsTotal")] Expenses expenses) { if (ModelState.IsValid) { expenses.UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; expenses.TotalCost = expenses.MortgageRent + expenses.Phone + expenses.Gas + expenses.WaterSewerTrash + expenses.Electricity + expenses.CableInternet + expenses.HomeAlarmSystem + expenses.MaintenanceRepairs + expenses.VehiclePayment + expenses.Insurance + expenses.Fuel + expenses.UberLyft + expenses.LicenseRegistration + expenses.Maintenance + expenses.HomeRenters + expenses.Health + expenses.Dental + expenses.Vision + expenses.Pet + expenses.Life + expenses.Groceries + expenses.DiningOut + expenses.Coffee + expenses.ClothesShoes + expenses.SchoolTuitionSupplies + expenses.SportsOrganizationFees + expenses.Childcare + expenses.LunchMoney + expenses.ToysGames + expenses.HairCutsSalon + expenses.ManiPediWaxing + expenses.ClothesShoesAccessories + expenses.DryCleaning + expenses.GymSupplements + expenses.OrganizationDuesFees + expenses.Music + expenses.Video + expenses.MovieTheater + expenses.Concerts + expenses.SportingEvents + expenses.DateNights + expenses.Alchohol + expenses.TobaccoVaping + expenses.PersonalLoan + expenses.CreditCard + expenses.StudentLoan + expenses.Federal + expenses.State + expenses.Medicare + expenses.SocialSecurityFICA + expenses.EmergencySavings + expenses.CDsMoneyMarkets + expenses.IRA401k + expenses.StocksMutualFunds + expenses.Tithesffering + expenses.Charity + expenses.RetirementHome + expenses.Attorney + expenses.AlimonyChildSupport + expenses.LienJudgmentPayment; expenses.IncomeVsTotal = expenses.MonthlyIncome - expenses.TotalCost; _context.Add(expenses); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.ApplicationUsers, "Id", "Id", expenses.UserId); return(View(expenses)); }
public async Task Will_List_Categories_SecondPage() { // arrange using (var context = new BudgetContext(_options)) { context.Add(new Category() { Id = Guid.NewGuid(), Label = "1" }); context.Add(new Category() { Id = Guid.NewGuid(), Label = "2" }); context.Add(new Category() { Id = Guid.NewGuid(), Label = "3", IsArchived = true }); context.Add(new Category() { Id = Guid.NewGuid(), Label = "4" }); await context.SaveChangesAsync(); } var query = new CategoryListQuery() { PerPage = 2, Page = 1, OrderBy = nameof(Category.Label), Descending = true }; using (var context = new BudgetContext(_options)) { // act var service = new CategoryService(context, _mapper); var result = await service.Handle(query, CancellationToken.None); Assert.IsFalse(result.IsEmpty); Assert.AreEqual(3, result.TotalResults); Assert.AreEqual(1, result.Results.Count()); Assert.AreEqual(2, result.TotalPages); Assert.AreEqual("1", result.Results.ElementAt(0).Label); } }
public async Task <IActionResult> Create([Bind("PaymentMethodId,PaymentMethodName")] PaymentMethod paymentMethod) { if (ModelState.IsValid) { _context.Add(paymentMethod); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(paymentMethod)); }
public async Task <IActionResult> Create([Bind("CatId,CategoryName")] ExpenseCategory expenseCategory) { if (ModelState.IsValid) { _context.Add(expenseCategory); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(expenseCategory)); }
public async Task <IActionResult> Create([Bind("SubcatId,SubcatName,CatId")] Subcat subcat) { if (ModelState.IsValid) { _context.Add(subcat); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CatId"] = new SelectList(_context.ExpenseCategories, "CatId", "CategoryName", subcat.CatId); return(View(subcat)); }
public async Task <IActionResult> Create([Bind("PurchaseId,CatId,PurchaseName,Price,PaymentMethodId,Note,Necessity,PurchaseDate, UserId")] Purchase purchase) { if (ModelState.IsValid) { purchase.UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; _context.Add(purchase); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CatId"] = new SelectList(_context.ExpenseCategories, "CatId", "CategoryName", purchase.CatId); ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethods, "PaymentMethodId", "PaymentMethodName", purchase.PaymentMethodId); return(View(purchase)); }
public async Task Add(Income income) { income.ClientId = _userAccessor.GetId(); income.Source = await _sourceResolver.Resolve(income.Source.Name); _context.Add(income); await _context.SaveChangesAsync(); var clientSource = await _clientSourceResolver.Resolve(income.ClientId, income.Source.Id); if (clientSource != null) { _context.ClientSources.Add(clientSource); await _context.SaveChangesAsync(); } }
public async Task <IActionResult> Create([Bind("SubcatId,ActualCost,Difference,UserId,CatId,Id")] List <MonthlyCost> monthlyCost) { for (int i = 0; i < monthlyCost.Count(); i++) { if (ModelState.IsValid) { monthlyCost[i].UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; _context.Add(monthlyCost); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Create))); } } //ViewData["SubcatId"] = new SelectList(_context.Subcats, "SubcatId", "SubcatName", monthlyCostSubcatId); //ViewData["CatId"] = new SelectList(_context.ExpenseCategories, "CatId", "CategoryName", monthlyCost.CatId); return(RedirectToAction("Create")); }
public void Add(T entity) { _context.Add(entity); }