public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BudgetItem budgetItem = _db.BudgetItems.Find(id); if (budgetItem == null) { return(HttpNotFound()); } budgetItem.Budget = _db.Budgets.Find(budgetItem.BudgetId); if (budgetItem.Budget == null) { return(RedirectToAction("Index", "Households")); } var currentUserHouseholdId = Helpers.HelperMethods.GetCurrentUserHouseholdId(); if (currentUserHouseholdId == null || budgetItem.Budget.HouseholdId != currentUserHouseholdId) { return(RedirectToAction("Index", "Households")); } var householdViewModel = new MainDashboardViewModel(); if (householdViewModel.Budgets.Count == 0) { return(RedirectToAction("Create", "Budgets")); } ViewBag.BudgetId = new SelectList(householdViewModel.Budgets, "Id", "Name"); return(View(budgetItem)); }
public ActionResult Create(BudgetItem budgetItem, int?id, string budgetItemName, string budgetItemDescription, string budgetItemTargetAmount, string budgetItemCurrentAmount) { var budgetId = id == null ? budgetItem.BudgetId : id; var budget = _db.Budgets.Find(budgetId); if (budget == null) { ModelState.AddModelError("Budget", @"Failed to find associated Budget"); return(RedirectToAction("Dashboard", "Home")); } if (ModelState.IsValid) { var currentUserHouseholdId = Helpers.HelperMethods.GetCurrentUserHouseholdId(); if (currentUserHouseholdId == null || budget.HouseholdId != currentUserHouseholdId) { return(RedirectToAction("Dashboard", "Home")); } var userId = User.Identity.GetUserId(); if (String.IsNullOrWhiteSpace(userId)) { return(RedirectToAction("Dashboard", "Home")); } budgetItem.BudgetId = budget.Id; budgetItem.Created = DateTime.Now; if (String.IsNullOrWhiteSpace(budgetItem.Name)) { budgetItem.Name = budgetItemName; } if (String.IsNullOrWhiteSpace(budgetItem.Description)) { budgetItem.Description = budgetItemDescription; } if (budgetItem.TargetAmount == default(Decimal)) { var targetAmount = budgetItemTargetAmount.TrimStart(new Char[] { '$' }); budgetItem.TargetAmount = Decimal.Parse(targetAmount); } var childBudgetItemsTargetTotal = 0m; foreach (var item in budget.BudgetItems) { childBudgetItemsTargetTotal += item.TargetAmount; } childBudgetItemsTargetTotal += budgetItem.TargetAmount; if (childBudgetItemsTargetTotal > budget.TargetAmount) { ModelState.AddModelError("Budget", @"BudgetItem Amounts cannot exceed (Parent) Budget Amount"); return(RedirectToAction("Details", "Budgets", new { id = budgetId })); } _db.BudgetItems.Add(budgetItem); var ret = _db.SaveChanges(); } return(RedirectToAction("Details", "Budgets", new { id = budgetId })); }
public ActionResult DeleteConfirmed(int id) { BudgetItem budgetItem = db.BudgetItems.Find(id); db.BudgetItems.Remove(budgetItem); db.SaveChanges(); return RedirectToAction("Index"); }
public ActionResult ConfigureHouse(ConfigureHouseVM model) { var bankAccount = new BankAccount(model.StartingBalance, model.BankAccount.WarningBalance, model.BankAccount.AccountName); bankAccount.AccountType = model.BankAccount.AccountType; db.BankAccounts.Add(bankAccount); var budget = new Budget(); budget.HouseholdId = (int)model.HouseholdId; budget.BudgetName = model.Budget.BudgetName; db.Budgets.Add(budget); db.SaveChanges(); var budgetItem = new BudgetItem(); budgetItem.BudgetId = budget.Id; budgetItem.TargetAmount = model.BudgetItem.TargetAmount; budgetItem.ItemName = model.BudgetItem.ItemName; db.BudgetItems.Add(budgetItem); db.SaveChanges(); return(RedirectToAction("Dashboard", "Home")); }
public ActionResult New() { ViewBag.Title = "New Budget Item"; BudgetItem budgetItem = new BudgetItem(); return(View("BudgetItemForm", budgetItem)); }
public ActionResult Create(BudgetItem budgetItem) { _context.BudgetItems.Add(budgetItem); _context.SaveChanges(); return(RedirectToAction("Index", "BudgetItems")); }
public ActionResult Save(BudgetItem budgetItem) { if (string.IsNullOrEmpty(budgetItem.CategoryName) || !ModelState.IsValid) { return(View("BudgetItemForm", budgetItem)); } if (budgetItem.Id == 0) // if new budgetItem { _context.BudgetItems.Add(budgetItem); } else { var budgetItemInDb = _context.BudgetItems.Single(b => b.Id == budgetItem.Id); budgetItemInDb.Amount = budgetItem.Amount; budgetItemInDb.CategoryName = budgetItem.CategoryName; budgetItemInDb.DateUpdated = budgetItem.DateUpdated; budgetItemInDb.Description = budgetItem.Description; } try { _context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } return(RedirectToAction("Index", "BudgetItems")); }
public void getByBudgetIdTest() { int id = 37; List <BudgetItem> expected = new List <BudgetItem>(); BudgetItem c = new BudgetItem(); c.BudgetId = 37; c.Cost = 50; c.Id = 22; c.Name = "watermelon"; expected.Add(c); BudgetItem b = new BudgetItem(); b.BudgetId = 37; b.Cost = 60; b.Id = 23; b.Name = "papaya"; expected.Add(b); List <BudgetItem> actual = BudgetItemModel.getByBudgetId(id); Assert.AreEqual(expected.Count, actual.Count); Console.Out.Write("Length is " + actual.Count); for (int i = 0; i < actual.Count; i++) { Console.Out.WriteLine("Actual is " + actual[i].Name); Console.Out.WriteLine("Expected is " + expected[i].Name); Assert.IsTrue(this.PropertiesEqual(actual[i], expected[i])); } }
public string EnterNewBudgetItem(BudgetListItem ListItemToAdd, Guid CustomerId, string InputType) { try { int Type = (InputType == "SuggestedInput") ? 0 : 1; var Context = new Central(); BudgetItem MyBudgetItem = new BudgetItem(); MyBudgetItem.BudgetItemId = Guid.NewGuid(); MyBudgetItem.BudgetId = GetBudgetId(CustomerId); MyBudgetItem.BudgetItemAmount = ListItemToAdd.BudgetListItemAmount; MyBudgetItem.BudgetItemCategory = ListItemToAdd.BudgetListItemCategory; MyBudgetItem.BudgetItemName = ListItemToAdd.BudgetListItemName; MyBudgetItem.BudgetItemFrequency = ListItemToAdd.BudgetListItemFrequency; MyBudgetItem.BudgetItemType = Type; MyBudgetItem.CreationDate = DateTime.Now; MyBudgetItem.UpdateDate = DateTime.Now; Context.BudgetItems.Add(MyBudgetItem); Context.SaveChanges(); string Status = "Success"; return(Status); } catch (Exception e) { return(e.ToString()); } }
public ActionResult Index(HomeModel model) { if (ModelState.IsValid) { var budget = _BudgetService.CreateBudget("Temp"); IList <BudgetItem> itemsToAdd = new List <BudgetItem>(); foreach (var item in model.ExpenseItems) { var theStandardItem = _StandardItemService.GetStandardItem(item.StandardItemId); var newItem = new BudgetItem(budget, theStandardItem, item.DefaultValue, item.Name, ItemType.Expense); budget.AddItem(newItem); } foreach (var incomeItems in model.IncomeItems) { var theIncomeStandardItem = _StandardItemService.GetStandardItem(incomeItems.StandardItemId); var newIncomeItem = new BudgetItem(budget, theIncomeStandardItem, incomeItems.DefaultValue, incomeItems.Name, ItemType.Income); budget.AddItem(newIncomeItem); } _BudgetService.SaveBudget(budget); //Look at passing the budget tp the next view via temp data return(RedirectToAction("NextSteps")); } return(View(model)); }
public async Task<IHttpActionResult> Create(BudgetItem model) { var user = db.Users.Find(User.Identity.GetUserId()); if (!ModelState.IsValid) { return BadRequest(ModelState); } var budgetItemExits = user.HouseHold.BudgetItems.Any(bi => bi.Name == model.Name); if (budgetItemExits) { return Ok("You already have a budget item called: " + model.Name + " . Please chose another name."); } else { var budgetItem = new BudgetItem() { Name = model.Name, Amount = model.Amount, HouseHoldId = (int)user.HouseHoldId, CategoryId = model.CategoryId, Frequency = model.Frequency }; db.BudgetItems.Add(budgetItem); await db.SaveChangesAsync(); return Ok(budgetItem); } }
public void ConfigureCategoryLimits(BudgetItem budgetItem, Budget budget) { switch (budgetItem.Category) { case ("Coffee"): budget.CoffeeCategoryLimit += budgetItem.Amount; break; case ("Dining Out"): budget.DiningOutCategoryLimit += budgetItem.Amount; break; case ("Entertainment"): budget.EntertainmentCategoryLimit += budgetItem.Amount; break; case ("Gas"): budget.GasCategoryLimit += budgetItem.Amount; break; case ("Groceries"): budget.GroceriesCategoryLimit += budgetItem.Amount; break; } budget.MonthlyLimit += budgetItem.Amount; _repo.Budgets.Update(budget); _repo.Save(); }
public ActionResult BudgetRollbackToVersion(Guid budgetid, Guid versionid, bool ignorecheck = false) { string message = string.Empty; if (!SecurityCache.FormCan("Budget", "RollbackVersion")) { message = OptimaJet.Localization.LocalizationProvider.Provider.Get("Access is denied"); return(new ContentResult { ContentType = "text/html", Content = DynamicEntityJSONDataSource.GetNotSuccess(message) }); } bool needConfirm; var success = BudgetItem.RollbackToVersion(budgetid, versionid, ignorecheck, out needConfirm, out message); if (!success) { return new ContentResult { ContentType = "text/html", Content = DynamicEntityJSONDataSource.GetNotSuccess(message) } } ; return(new ContentResult { ContentType = "text/html", Content = DynamicEntityJSONDataSource.GetSuccess(message, needConfirm) }); }
public async Task <ActionResult <BudgetItem> > PostBudgetItem(BudgetItem budgetItem) { _context.BudgetItems.Add(budgetItem); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBudgetItem", new { id = budgetItem.Id }, budgetItem)); }
public ActionResult CreateBudgetItem(BudgetItem budgetItem) { try { var userId = this.User.FindFirstValue(ClaimTypes.NameIdentifier); var budgeteer = _repo.Budgeteers.GetBudgeteerByUserId(userId); var budget = _repo.Budgets.GetBudgetByBudgeteerIdMonthAndYear(budgeteer.BudgeteerId, DateTime.Now.Month, DateTime.Now.Year); var newBudgetItem = new BudgetItem { BudgetItemName = budgetItem.BudgetItemName, Category = budgetItem.Category, Amount = budgetItem.Amount, BudgeteerId = budgeteer.BudgeteerId }; _repo.BudgetItems.Create(newBudgetItem); _repo.Save(); ConfigureCategoryLimits(newBudgetItem, budget); return(RedirectToAction(nameof(Index))); } catch { return(View(budgetItem)); } }
private List <BudgetItem> GetBudgetItems() { List <BudgetItem> result = new List <BudgetItem>(); try { for (int i = 0; i < dataGridView.Rows.Count - 1; i++) { DataGridViewRow gridRow = dataGridView.Rows[i]; BudgetItem budgetItem = new BudgetItem() { Name = gridRow.Cells["Name"].Value.ToString(), Count = int.Parse(gridRow.Cells["Count"].Value.ToString().Split(new[] { ' ' })[0]), UnitPrice = decimal.Parse(gridRow.Cells["Price"].Value.ToString().Split(new[] { ' ' })[0]), }; result.Add(budgetItem); } } catch (Exception ex) { BasicMessagesHandler.ShowErrorMessage("Po4as vytvárania rozpočtu sa vyskytla chyba", ex); result = null; } return(result); }
public async Task <IHttpActionResult> Edit(int id, BudgetItem model) { var oldBudgetItem = db.BudgetItems.FirstOrDefault(bi => bi.id == model.id); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //check if name changed if (oldBudgetItem.Name != model.Name) { oldBudgetItem.Name = model.Name; await db.SaveChangesAsync(); } //check if amount changed if (oldBudgetItem.Amount != oldBudgetItem.Amount) { oldBudgetItem.Amount = model.Amount; await db.SaveChangesAsync(); } //check if frquency changed if (oldBudgetItem.Frequency != model.Frequency) { oldBudgetItem.Frequency = model.Frequency; await db.SaveChangesAsync(); } return(Ok(oldBudgetItem)); }
public ActionResult Create([Bind(Include = "Id,Name,TargetAmount,HouseholdId")] Budget budget, string budgetItems, string returnUrl) { if (ModelState.IsValid) { if (budgetItems != null) { var budgetItemList = budgetItems.Split(",".ToCharArray()); foreach (var item in budgetItemList) { var BudgetItem = new BudgetItem() { Name = item, HouseholdId = budget.HouseholdId }; budget.BudgetItems.Add(BudgetItem); } } db.Budgets.Add(budget); db.SaveChanges(); return(Redirect(returnUrl)); } return(Redirect(returnUrl)); }
//SELECIONA APENAS UM ITEM public BudgetItem Select(int id) { BudgetItem obj = null; System.Data.IDbConnection objConexao; System.Data.IDbCommand objCommand; System.Data.IDataReader objDataReader; objConexao = Mapped.Connection(); objCommand = Mapped.Command("SELECT * FROM orcamento_item WHERE ori_id = ?id", objConexao); objCommand.Parameters.Add(Mapped.Parameter("?id", id)); objDataReader = objCommand.ExecuteReader(); while (objDataReader.Read()) { obj = new BudgetItem(); obj.Id = Convert.ToInt32(objDataReader["ori_id"]); obj.Description = Convert.ToString(objDataReader["ori_descricao"]); obj.Type = Convert.ToString(objDataReader["ori_tipo"]); obj.Amount = Convert.ToInt32(objDataReader["ori_quantidade"]); obj.Price = Convert.ToDouble(objDataReader["ori_preco_uni"]); obj.Active = Convert.ToInt32(objDataReader["ori_ativo"]); } objDataReader.Close(); objConexao.Close(); objCommand.Dispose(); objConexao.Dispose(); objDataReader.Dispose(); return(obj); }
//[Authorize(Roles = "New User")] public async Task <ActionResult> BuildHouse(BuildHouseWizardVM model, bool isPersonalAccount = false) { if (ModelState.IsValid) { // success path db.Households.Add(model.Household); db.SaveChanges(); var user = db.Users.Find(User.Identity.GetUserId()); user.HouseholdId = model.Household.Id; rolesHelper.UpdateUserRole(user.Id, "Head"); db.SaveChanges(); await AuthorizeExtensions.RefreshAuthentication(HttpContext, user); // add bank account info var bankAccount = new BankAccount ( model.StartingBalance, model.BankAccount.WarningBalance, model.BankAccount.AccountName ); bankAccount.HouseholdId = (int)user.HouseholdId; bankAccount.AccountType = model.BankAccount.AccountType; if (isPersonalAccount) { bankAccount.OwnerId = user.Id; } else { bankAccount.OwnerId = null; } db.BankAccounts.Add(bankAccount); // add budget info var budget = new Budget(); budget.HouseholdId = (int)model.Household.Id; budget.BudgetName = model.Budget.BudgetName; db.Budgets.Add(budget); db.SaveChanges(); // add budget item info var budgetItem = new BudgetItem(); budgetItem.BudgetId = budget.Id; budgetItem.TargetAmount = model.BudgetItem.TargetAmount; budgetItem.ItemName = model.BudgetItem.ItemName; db.BudgetItems.Add(budgetItem); db.SaveChanges(); // now that the household has been established, refresh their login and send them to the dashboard. return(RedirectToAction("Dashboard", "Home")); } // error return(View(model)); }
public ActionResult Setup(BankAccount bankAccount, Budget budget, BudgetItem budgetItem) { try { var houseId = db.Users.Find(User.Identity.GetUserId()).Household.Id; if (ModelState.IsValid) { bankAccount.HouseholdId = houseId; db.BankAccounts.Add(bankAccount); budget.HouseholdId = houseId; db.Budgets.Add(budget); db.SaveChanges(); budgetItem.BudgetId = budget.Id; db.BudgetItems.Add(budgetItem); var household = db.Households.Find(houseId); household.IsConfigured = true; db.SaveChanges(); } return(RedirectToAction("Dashboard", "Household", new { houseId })); } catch { return(RedirectToAction("Lobby", "Home")); } }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } try { var user = db.Users.Find(User.Identity.GetUserId()); BudgetItem budgetItem = db.BudgetItems.Single(b => b.Id == id && b.Budgets.HouseholdId == user.HouseholdId); if (user.Households == null) { return(RedirectToAction("Create", "Households")); } return(View(budgetItem)); } catch (Exception) { return(RedirectToAction("page404", "Home")); } }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } try { var user = db.Users.Find(User.Identity.GetUserId()); BudgetItem budgetItem = db.BudgetItems.Single(b => b.Id == id && b.Budgets.HouseholdId == user.HouseholdId); if (user.Households == null) { return(RedirectToAction("Create", "Households")); } var getBudget = db.Budgets.Where(u => u.HouseholdId == user.HouseholdId).ToList(); ViewBag.BudgetId = new SelectList(getBudget, "Id", "Name", budgetItem.BudgetId); ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", budgetItem.CategoryId); return(View(budgetItem)); } catch { return(RedirectToAction("page404", "Home")); } }
public async Task <IActionResult> PutBudgetItem(int id, BudgetItem budgetItem) { if (id != budgetItem.Id) { return(BadRequest()); } _context.Entry(budgetItem).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BudgetItemExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
// GET: BudgetItems/Edit/5 public PartialViewResult Edit(int?id) { if (id == null) { return(PartialView(null)); //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BudgetItem budgetItem = db.BudgetItems.Find(id); var hh = db.Households.Find(Convert.ToInt32(User.Identity.GetHouseholdId())); if (!hh.BudgetItems.Contains(budgetItem)) // if budgetItem id does not belong to household - refuse access { budgetItem = null; } if (budgetItem == null) { return(PartialView(null)); // return HttpNotFound(); } ViewBag.CategoryId = new SelectList(hh.Categories, "Id", "Name", budgetItem.CategoryId); //ViewBag.HouseholdId = new SelectList(db.Households, "Id", "Name", budgetItem.HouseholdId); return(PartialView(budgetItem)); }
public BudgetItem AddBudgetItem(BudgetItem newBudgetItem, User user) { AuthenticateUser(user); this.ChechIsAdmin(user, typeof(BudgetItem)); using (CFAPContext ctx = new CFAPContext()) { ctx.Configuration.ProxyCreationEnabled = false; try { ctx.BudgetItems.Add(newBudgetItem); ctx.SaveChanges(DbConcurencyUpdateOptions.ClientPriority); } catch (DbEntityValidationException ex) { throw new FaultException <DataNotValidException>(new DataNotValidException(ex.EntityValidationErrors)); } catch (Exception ex) { throw new FaultException <DbException>(new DbException(ex)); } } return(newBudgetItem); }
public ActionResult Edit([Bind(Include = "Id,BudgetId,Name,Description,SpendingTarget")] BudgetItem budgetItem, string Name) { var oldBudgetItem = db.budgetItems.AsNoTracking().FirstOrDefault(i => i.Id == budgetItem.Id); if (ModelState.IsValid) { var userId = User.Identity.GetUserId(); var user = db.Users.AsNoTracking().FirstOrDefault(i => i.Id == userId); var category = db.budgetItems.AsNoTracking().FirstOrDefault(i => i.Id == budgetItem.Id); category.Name = budgetItem.Name; category.CurrentSpending = budgetItem.CurrentSpending; category.Description = budgetItem.Description; category.SpendingTarget = budgetItem.SpendingTarget; category.Budget = db.Budgets.AsNoTracking().FirstOrDefault(i => i.HouseholdId == user.HouseholdId); category.Id = budgetItem.Id; var budget = category.Budget; budget.SpendingTarget = budget.SpendingTarget - oldBudgetItem.SpendingTarget + category.SpendingTarget; db.Entry(budget).State = EntityState.Modified; db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "BudgetViewModel")); } ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "Name", budgetItem.BudgetId); return(View(budgetItem)); }
public void WhenPut_ValidItem_ReturnsOk() { // Arrange int itemId = 2; var newItem = new BudgetItem { Id = itemId, Notes = "Office Lunch", BudgetLocationId = 2, BudgetSubCategoryId = 2, Amount = 15, DateOccured = DateTime.Now, IsExpense = true, IsFixed = false }; IEnumerable <BudgetItem> fakeItems = GetFakeItems(); _itemRepository.Setup(x => x.GetItem(itemId)).Returns(fakeItems.FirstOrDefault(p => p.Id == itemId)); _itemRepository.Setup(x => x.UpdateItem(newItem)).Returns(newItem); var controller = new ItemsController(_itemRepository.Object); // Act IHttpActionResult actionResult = controller.Put(2, newItem); // Assert Assert.IsNotNull(actionResult); var item = actionResult as OkNegotiatedContentResult <BudgetItem>; Assert.IsNotNull(item); Assert.AreEqual(item.Content.BudgetLocationId, 2); }
public async Task <IHttpActionResult> Create(BudgetItem model) { var user = db.Users.Find(User.Identity.GetUserId()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var budgetItemExits = user.HouseHold.BudgetItems.Any(bi => bi.Name == model.Name); if (budgetItemExits) { return(Ok("You already have a budget item called: " + model.Name + " . Please chose another name.")); } else { var budgetItem = new BudgetItem() { Name = model.Name, Amount = model.Amount, HouseHoldId = (int)user.HouseHoldId, CategoryId = model.CategoryId, Frequency = model.Frequency }; db.BudgetItems.Add(budgetItem); await db.SaveChangesAsync(); return(Ok(budgetItem)); } }
public void WhenPut_InValidItem_CreatesNewItem() { // Arrange var fakeId = 100; var newItem = new BudgetItem { Id = fakeId, Notes = "Office Lunch", BudgetLocationId = 2, BudgetSubCategoryId = 2, Amount = 15, DateOccured = DateTime.Now, IsExpense = true, IsFixed = false }; IEnumerable <BudgetItem> fakeItems = GetFakeItems(); _itemRepository.Setup(x => x.GetItem(fakeId)).Returns(fakeItems.FirstOrDefault(p => p.Id == fakeId)); var controller = new ItemsController(_itemRepository.Object); // Act IHttpActionResult actionResult = controller.Put(fakeId, newItem); // Assert Assert.IsNotNull(actionResult); var createdResult = actionResult as CreatedAtRouteNegotiatedContentResult <BudgetItem>; // Assert Assert.IsNotNull(createdResult); Assert.AreEqual("DefaultApi", createdResult.RouteName); Assert.AreEqual(fakeId, createdResult.RouteValues["id"]); }
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 static BudgetItem createObj(BudgetItem e) { using (var context = new EventContainer()) { context.BudgetItems.Add(e); context.SaveChanges(); return e; } }
public void AdjustBudgetItemBalance(BudgetItem budgetItem, bool isWithdrawal, decimal amount) { budgetItem.Balance = isWithdrawal ? budgetItem.Balance - amount : budgetItem.Balance + amount; if (budgetItem.Balance > budgetItem.Amount) budgetItem.Amount = budgetItem.Balance; FinancialPlannerRepository.EditBudgetItem(budgetItem); FinancialPlannerRepository.Save(); }
public static BudgetItem create(String name, int cost, int budgetId) { using (var context = new EventContainer()) { BudgetItem item = new BudgetItem { Name = name, Cost = cost, BudgetId = budgetId }; context.BudgetItems.Add(item); context.SaveChanges(); return item; } }
public BudgetItem AddBudgetItem(EditBudgetItemViewModel vm) { var budgetItem = new BudgetItem { Name = vm.Name, Amount = vm.Amount, BudgetId = vm.SelectedBudgetId, Balance = vm.Amount }; FinancialPlannerRepository.AddBudgetItem(budgetItem); FinancialPlannerRepository.Save(); return budgetItem; }
public static BudgetItem update(String name, int cost, int budgetId) { using (var context = new EventContainer()) { BudgetItem item = new BudgetItem { Name = name, Cost = cost, BudgetId = budgetId }; context.BudgetItems.Attach(item); context.Entry(item).State = EntityState.Modified; context.SaveChanges(); return item; } }
public static BudgetItem Parse(string user, string message, DateTime timeStamp) { var split = message.Trim().Split(' '); var splitList = split.ToList<string>(); var costText = split[splitList.Count - 1]; var cost = float.Parse(costText); splitList.RemoveAt(splitList.Count - 1); var itemText = message.Replace(costText, string.Empty); BudgetItem item = new BudgetItem(); item.User = user; item.Category = itemText; item.Cost = cost; item.Timestamp = timeStamp; return item; }
public async Task<IHttpActionResult> Edit(int id, BudgetItem model) { var oldBudgetItem = db.BudgetItems.FirstOrDefault(bi => bi.id == model.id); if (!ModelState.IsValid) { return BadRequest(ModelState); } //check if name changed if (oldBudgetItem.Name != model.Name) { oldBudgetItem.Name = model.Name; await db.SaveChangesAsync(); } //check if amount changed if (oldBudgetItem.Amount != oldBudgetItem.Amount) { oldBudgetItem.Amount = model.Amount; await db.SaveChangesAsync(); } //check if frquency changed if (oldBudgetItem.Frequency != model.Frequency) { oldBudgetItem.Frequency = model.Frequency; await db.SaveChangesAsync(); } return Ok(oldBudgetItem); }
protected void btnAdd_Click(object sender, ImageClickEventArgs e) { if (ucCurrFieldQuantityData.CurrencyValue == decimal.Zero) { ShowError("Quantidade não pode ser 0(zero)!"); return; } BudgetItem budgetItem = new BudgetItem(); Product product = SelProductAndService.Product.Duplicate(); if (product.ProductId == 0) product.Name = SelProductAndService.Name; Service service = SelProductAndService.Service.Duplicate() ?? new Service(); if (SelProductAndService.IsProduct) { if (pnlEdit.Visible && Convert.ToInt32(Page.ViewState["InsertItemID"]) == Convert.ToInt32(Page.ViewState["EditItemID"])) { product.Description = DescriptionTextBox.Value; pnlEdit.Visible = false; } Page.ViewState["InsertItemID"] = product.ProductId; budgetItem.ProductId = product.ProductId; budgetItem.SpecialProductName = product.Name; budgetItem.ProductDescription = pnlEdit.Visible ? DescriptionTextBox.Value : product.Description; pnlEdit.Visible = false; } if (SelProductAndService.IsService) { Page.ViewState["InsertItemID"] = service.ServiceId; budgetItem.ServiceId = service.ServiceId; budgetItem.SpecialProductName = service.Name; budgetItem.ProductDescription = pnlEdit.Visible ? DescriptionTextBox.Value : String.Empty; pnlEdit.Visible = false; } if (!SelProductAndService.IsProduct && !SelProductAndService.IsService) budgetItem.SpecialProductName = SelProductAndService.Name; var inventory = new Inventory(); if (product != null && product.ProductId != 0) { if (Deposit != null) inventory = new InventoryManager(this).GetProductInventory(Company.CompanyId, product.ProductId, Deposit.DepositId); } budgetItem.UnitPrice = ucCurrFieldUnitPrice.CurrencyValue.Value; budgetItem.Quantity = ucCurrFieldQuantityData.IntValue; budgetItem.Reference = txtReference.Text; budgetItem.ProductCode = product.ProductCode; budgetItem.ModifiedDate = DateTime.Now; if (inventory != null) budgetItem.UnitCost = inventory.RealCost; BudgetItemList.Add(budgetItem); grdProducts.DataSource = BudgetItemList; grdProducts.DataBind(); ClearFields(); DescriptionTextBox.Value = String.Empty; SelProductAndService.ClearField(); }
/// <summary> /// This method loads budgetItems objects to grid /// </summary> /// </summary> private void LoadBudgetItemsToGrid() { BudgetItemList = null; foreach (var item in saleManager.GetBudgetItemByBudget(BudgetId, Company.CompanyId)) { var budgetItem = new BudgetItem(); budgetItem.BudgetId = item.BudgetId; budgetItem.BudgetItemId = item.BudgetItemId; budgetItem.ModifiedDate = item.ModifiedDate; budgetItem.Observation = item.Observation; if (item.ProductId.HasValue) budgetItem.SpecialProductName = item.Product.Name; else if (item.ServiceId.HasValue) budgetItem.SpecialProductName = item.Service.Name; else budgetItem.SpecialProductName = item.SpecialProductName; budgetItem.ProductCode = item.ProductId.HasValue ? item.Product.ProductCode : item.ProductCode; budgetItem.ProductDescription = item.ProductDescription; budgetItem.ProductId = item.ProductId; budgetItem.ServiceId = item.ServiceId; budgetItem.UnitCost = item.UnitCost; budgetItem.UnitPrice = item.UnitPrice; budgetItem.Quantity = item.Quantity; budgetItem.Reference = item.Reference; BudgetItemList.Add(budgetItem); } grdProducts.DataSource = BudgetItemList; grdProducts.DataBind(); }
/// <summary> /// This method deletes a record in the table. /// Change this method to alter how records are deleted. /// </summary> /// <param name=entity>entity</param> public void DeleteBudgetItem(BudgetItem entity) { DbContext.BudgetItems.DeleteOnSubmit(entity); DbContext.SubmitChanges(); }
/// <summary> /// This method inserts a new record in the table. /// Change this method to alter how records are inserted. /// </summary> /// <param name=entity>entity</param> public void InsertBudgetItem(BudgetItem entity) { if (entity.ProductId == 0) entity.ProductId = null; entity.ModifiedDate = DateTime.Now; DbContext.BudgetItems.InsertOnSubmit(entity); DbContext.SubmitChanges(); }
public void EditBudgetItemBalance(BudgetItem budgetItem) { SharedOperationsService.EditBudgetItemBalance(budgetItem); }
public void AddBudgetItem(BudgetItem budgetItem) { }
public static BudgetItem updateObj(BudgetItem e) { using (var context = new EventContainer()) { context.Entry(e).State = EntityState.Modified; context.SaveChanges(); return e; } }
private void EditBudgetItem(BudgetItem budgetItem) { SharedOperationsService.EditBudgetItemBalance(budgetItem); }
public void AdjustBudgetItemBalance(BudgetItem budgetItem, EditTransactionViewModel vm) { SharedOperationsService.AdjustBudgetItemBalance(budgetItem, vm.IsWithdrawal, vm.Amount); }
public void EditBudgetItemBalance(BudgetItem budgetItem, Transaction transaction) { SharedOperationsService.AdjustBudgetItemBalance(budgetItem, transaction.IsWithdrawal, transaction.Amount); }
public void EditBudgetItemBalance(BudgetItem budgetItem) { var budgetItemTransactions = FinancialPlannerRepository.GetTransactions().Where(m => m.BudgetItemId == budgetItem.Id).ToList(); var budgetItemWithdrawalSum = budgetItemTransactions.Where(m => m.IsWithdrawal).Sum(m => m.Amount); var budgetItemDepositSum = budgetItemTransactions.Where(m => !m.IsWithdrawal).Sum(m => m.Amount); budgetItem.Balance = budgetItem.Amount + budgetItemDepositSum - budgetItemWithdrawalSum; FinancialPlannerRepository.EditBudgetItem(budgetItem); FinancialPlannerRepository.Save(); }
private void FillActuals(User user) { var month = this.Budget.Month; var transactions = user.Transactions.Where(t => t.Date.Year == month.Year && t.Date.Month == month.Month && !string.IsNullOrEmpty(t.BudgetCategoryName)); foreach (var transaction in transactions) { var actualItem = this.Budget.ActualItems.FirstOrDefault(i => i.CategoryName == transaction.BudgetCategoryName); if (actualItem == null) { actualItem = new BudgetItem(); actualItem.CategoryName = transaction.BudgetCategoryName; this.Budget.ActualItems.Add(actualItem); } if (transaction.Amount > 0) actualItem.CreditAmount += transaction.Amount; else actualItem.DebitAmount += -transaction.Amount; } }
/// <summary> /// This method updates a record in the table. /// Change this method to alter how records are updated. /// </summary> /// <param name=original_entity>original_entity</param> /// <param name=entity>entity</param> public void UpdateBudgetItem(BudgetItem original_entity, BudgetItem entity) { original_entity.CopyPropertiesFrom(entity); DbContext.SubmitChanges(); }