public ActionResult AddTransaction(BudgetItems budgetItems) { var errors = false; if (Convert.ToInt32(budgetItems.TypeOfBudget) == 0) { ViewBag.Error = "Please select a budget category from the dropdown."; errors = true; } if (budgetItems.Cost <= 0) { ViewBag.Error = "Please enter a price greater than $0.00 for your transaction."; errors = true; } if (!errors && ModelState.IsValid) { budgetItems.Email = User.Identity.Name; budgetItems.Month = DateTime.Now.Month; budgetItems.Date = DateTime.Now; _unitOfWork.BudgetItemsRepository.Add(budgetItems); _unitOfWork.Complete(); ViewBag.SuccessTransactionAdded = ($"Transaction Added! {budgetItems.Description}: ${budgetItems.Cost}"); budgetItems.TypeOfBudget = 0; } var transactions = _unitOfWork.BudgetItemsRepository.GetBudgetItemsListByMonth(User.Identity.Name, DateTime.Now.Month); return(View(transactions)); }
private void AddReadOnlyTotalRow(BudgetItems.tttBudgetItemsRow expenseRow, BudgetItems originalBudget) { //BudgetItems.tttBudgetItemsRow btRow = dtsBudgetReadOnly.tttBudgetItems.NewtttBudgetItemsRow() string itemName = expenseRow[dtsChartBudget.tttBudgetItems.ItemNameColumn].ToString(); decimal itemAmount = (decimal)expenseRow[dtsChartBudget.tttBudgetItems.ItemAmountColumn]; decimal itemBudgetAmount = 0; string itemType = ""; //itemExpenseAmount = (decimal) 1.99; foreach (BudgetItems.tttBudgetItemsRow bdgRow in originalBudget.tttBudgetItems) { if (bdgRow[originalBudget.tttBudgetItems.ItemNameColumn.Ordinal].ToString() == itemName) { itemBudgetAmount = (decimal)bdgRow[originalBudget.tttBudgetItems.ItemAmountColumn.Ordinal]; itemType = (string)bdgRow[originalBudget.tttBudgetItems.ItemTypeColumn.Ordinal]; } } decimal itemBudgetAmountSpan = itemBudgetAmount * monthSpan; decimal difference = itemAmount - itemBudgetAmountSpan; dtsBudgetReadOnly.tttBudgetItemsReadOnly.AddtttBudgetItemsReadOnlyRow(itemName, itemBudgetAmountSpan, itemType, 0, itemAmount, difference); }
public ActionResult DeleteConfirmed(int id) { BudgetItems budgetItems = db.Budgetitem.Find(id); db.Budgetitem.Remove(budgetItems); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { BudgetItems budgetItems = db.BudgetItems.Find(id); db.BudgetItems.Remove(budgetItems); db.SaveChanges(); return(RedirectToAction("Details", "Budgets", new { id = budgetItems.BudgetId })); }
public void Calculate() { BaseTotal = BudgetItems.Sum(bi => bi.BaseAmount); foreach (BudgetItem item in BudgetItems) { item.Percent = Percent.Value(item.BaseAmount, BaseTotal); } }
// GET: BudgetItems/Edit/5 public PartialViewResult _Edit(int?id) { var userId = User.Identity.GetUserId(); var hh = userId.GetHousehold(); BudgetItems budgetItems = db.BudgetItems.Find(id); ViewBag.CategoryId = new SelectList(db.Category.Where(c => c.HouseHoldId == hh.Id), "Id", "Name", budgetItems.CategoryId); ViewBag.WarningId = new SelectList(db.Warning, "Id", "WarningLimit", budgetItems.WarningId); return(PartialView(budgetItems)); }
internal static void PopulateContextMenu(ContextMenuStrip cmsBudgetItems) { BudgetItems bi = new BudgetItems(); Model.BudgetFormModel.GetBudgetData(ref bi); foreach (BudgetItems.tttBudgetItemsRow dtrB in bi.tttBudgetItems.Rows) { cmsBudgetItems.Items.Add(dtrB[bi.tttBudgetItems.ItemNameColumn.ColumnName].ToString()); } }
public ActionResult Edit([Bind(Include = "Id,Created,Name,TargetAmount,CurrentAmount")] BudgetItems budgetItems) { if (ModelState.IsValid) { db.Entry(budgetItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(budgetItems)); }
// GET: BudgetItems/Delete/5 public PartialViewResult _Delete(int?id) { BudgetItems budgetItems = db.BudgetItems.Find(id); //if (budgetItems == null) //{ // return HttpNotFound(); //} return(PartialView(budgetItems)); }
public ActionResult Edit([Bind(Include = "Id,BudgetId,Created,Name,Amount,Frequency,IncomeExpense")] BudgetItems budgetItems) { if (ModelState.IsValid) { db.Entry(budgetItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", "Budgets", new { id = budgetItems.BudgetId })); } ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "OwnerId", budgetItems.BudgetId); return(View(budgetItems)); }
public ActionResult Create([Bind(Include = "Id,Created,Name,TargetAmount,CurrentAmount")] BudgetItems budgetItems) { if (ModelState.IsValid) { db.BudgetItems.Add(budgetItems); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(budgetItems)); }
public ActionResult Edit([Bind(Include = "Id,CategoriesId,BudgetId,Amount")] BudgetItems budgetItems) { if (ModelState.IsValid) { db.Entry(budgetItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BudgetId = new SelectList(db.Budget, "Id", "Name", budgetItems.BudgetId); ViewBag.CategoriesId = new SelectList(db.Category, "Id", "Name", budgetItems.CategoriesId); return(View(budgetItems)); }
private void LoadBudgetReadOnlyData() { BudgetItems originalBudget = new BudgetItems(); Model.BudgetFormModel.GetBudgetData(ref originalBudget); dtsBudgetReadOnly.Clear(); foreach (BudgetItems.tttBudgetItemsRow dtrBudg in dtsChartBudget.tttBudgetItems.Rows) { AddReadOnlyTotalRow(dtrBudg, originalBudget); } ColorDataGridViewCells(); }
// GET: BudgetItems/Create public ActionResult Create() { var user = User.Identity.GetUserId(); var currentUser = db.Users.Find(user); var houseBudget = db.Budgets.Where(b => b.HouseholdId == currentUser.HouseholdId); var houseBudgetId = db.Budgets.Where(b => b.HouseholdId == currentUser.HouseholdId).Select(i => i.Id).FirstOrDefault(); var budgetItem = new BudgetItems(); budgetItem.BudgetId = houseBudgetId; ViewBag.BudgetId = new SelectList(houseBudget, "Id", "Name"); ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", "Group", 1); return(View(budgetItem)); }
// GET: BudgetItems/Details/5 public PartialViewResult _Details(int?id) { //if (id == null) //{ // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); //} BudgetItems budgetItems = db.BudgetItems.Find(id); //if (budgetItems == null) //{ // return HttpNotFound(); //} return(PartialView(budgetItems)); }
public ActionResult Create([Bind(Include = "Id,CategoryId,BudgetId,Amount")] BudgetItems budgetItems) { if (!ModelState.IsValid) { ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "Name", budgetItems.BudgetId); ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", budgetItems.CategoryId); return(View(budgetItems)); } UpdateBudget(budgetItems); db.BudgetItems.Add(budgetItems); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: BudgetItems/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BudgetItems budgetItems = db.Budgetitem.Find(id); if (budgetItems == null) { return(HttpNotFound()); } return(View(budgetItems)); }
// GET: BudgetItems/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BudgetItems budgetItems = db.BudgetItems.Find(id); if (budgetItems == null) { return(HttpNotFound()); } ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "OwnerId", budgetItems.BudgetId); return(View(budgetItems)); }
//Reverse Expense public void ReverseBudgetItem(BudgetItems budgetItem) { var oldBudget = db.Budgets.Find(budgetItem.BudgetId); var oldBudgetItem = db.BudgetItems.Find(budgetItem.Id); if (oldBudgetItem.CategoryId < 7) { oldBudget.Income -= oldBudgetItem.Amount; } else { oldBudget.Expense -= oldBudgetItem.Amount; } db.Entry(oldBudget).State = EntityState.Modified; db.SaveChanges(); return; }
public ActionResult DeleteConfirmed(int id) { BudgetItems budgetItems = db.BudgetItems.Find(id); var userId = User.Identity.GetUserId(); var hh = userId.GetHousehold(); var transac = db.Transactions.Where(t => t.BudgetItemId == id); var misc = hh.Category.FirstOrDefault(c => c.Name == "Miscellaneous"); foreach (var trans in transac) { trans.Category.Id = misc.Id; } budgetItems.IsSoftDeleted = true; db.BudgetItems.Remove(budgetItems); db.SaveChanges(); return(RedirectToAction("Index", "BudgetItems")); }
public ActionResult Edit([Bind(Include = "Id,Name,AmountLimit,Balance,CategoryId,HouseHoldId,CreatorId,Income,WarningId")] BudgetItems budgetItems) { var userId = User.Identity.GetUserId(); var hh = userId.GetHousehold(); if (ModelState.IsValid) { budgetItems.HouseHoldId = hh.Id; db.Entry(budgetItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "BudgetItems")); } ViewBag.CategoryId = new SelectList(db.Category.Where(c => c.HouseHoldId == hh.Id), "Id", "Name", budgetItems.CategoryId); //ViewBag.CreatorId = new SelectList(db.ApplicationUsers, "Id", "FirstName", budgetItems.CreatorId); //ViewBag.HouseHoldId = new SelectList(db.HouseHolds, "Id", "Name", budgetItems.HouseHoldId); ViewBag.WarningId = new SelectList(db.Warning, "Id", "WarningLimit", budgetItems.WarningId); return(View(budgetItems)); }
public ActionResult Create([Bind(Include = "Id,BudgetId,Created,Name,Amount,Frequency,IncomeExpense")] BudgetItems budgetItems) { if (ModelState.IsValid) { var userId = User.Identity.GetUserId(); var user = db.Users.Find(userId); var houseId = user.HouseholdId; var house = db.Households.Find(houseId); var budgetId = house.Budgets.FirstOrDefault().Id; budgetItems.BudgetId = budgetId; budgetItems.Created = DateTime.Now; db.BudgetItems.Add(budgetItems); db.SaveChanges(); return(RedirectToAction("Details", "Budgets", new { id = budgetItems.BudgetId })); } ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "OwnerId", budgetItems.BudgetId); return(View(budgetItems)); }
public MainDashboardViewModel() { if (CurrentUserHouseholdId != 0) { Household = _db.Households.AsNoTracking().FirstOrDefault(h => h.Id == CurrentUserHouseholdId); BankAccounts.AddRange(_db.BankAccounts.AsNoTracking().Where(b => b.HouseholdId == CurrentUserHouseholdId).ToList()); Budgets.AddRange(_db.Budgets.AsNoTracking().Where(b => b.HouseholdId == CurrentUserHouseholdId).ToList()); BudgetItems.AddRange(Budgets.SelectMany(b => b.BudgetItems)); var transactions = _db.Transactions.AsNoTracking(); foreach (var transaction in transactions) { if (BankAccounts.Any(ba => ba.Id == transaction.BankAccountId)) { Transactions.Add(transaction); } } } }
public ActionResult Edit([Bind(Include = "Id,CategoryId,BudgetId,Amount")] BudgetItems budgetItems) { if (!ModelState.IsValid) { ViewBag.BudgetId = new SelectList(db.Budgets, "Id", "Name", budgetItems.BudgetId); ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", budgetItems.CategoryId); return(View(budgetItems)); } // Reverse last budget item and update new ReverseBudgetItem(budgetItems); var amount = UpdateBudget(budgetItems); var oldbudgetItems = db.BudgetItems.Find(budgetItems.Id); oldbudgetItems.CategoryId = budgetItems.CategoryId; oldbudgetItems.Amount = amount; db.Entry(oldbudgetItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
//Update Budget Catetories public decimal UpdateBudget(BudgetItems budgetItem) { var currentBudget = db.Budgets.Find(budgetItem.BudgetId); // Check amount sign and reverse if necessary if ((budgetItem.CategoryId < 7 && budgetItem.Amount < 0) || (budgetItem.CategoryId >= 7 && budgetItem.Amount > 0)) { budgetItem.Amount *= -1; } if (budgetItem.CategoryId < 7) { currentBudget.Income += budgetItem.Amount; } else if (budgetItem.CategoryId >= 7) { currentBudget.Expense += budgetItem.Amount; } db.Entry(currentBudget).State = EntityState.Modified; db.SaveChanges(); return(budgetItem.Amount); }
static void DisplayGetBudgetItems(List <BudgetItems> items) { BudgetItems item = BudgetItems.NONE; string userResponse; DisplayScreenHeader("Budget Items to Consider for your trip"); Console.WriteLine(" Choose from the 9 items below. When finished type DONE. "); Console.WriteLine("a) Car Rental "); Console.WriteLine("b) Fuel"); Console.WriteLine("c) Plane Ticket"); Console.WriteLine("d) Baggage Fee"); Console.WriteLine("e) Food"); Console.WriteLine("f) Beverages"); Console.WriteLine("g) Excursions"); Console.WriteLine("h) Souveniers"); Console.WriteLine("i) Hotel"); DisplayContinuePrompt(); while (item != BudgetItems.DONE) { Console.Write("Enter Command:"); userResponse = Console.ReadLine().ToLower(); switch (item) { case BudgetItems.CAR: break; case BudgetItems.FUEL: break; case BudgetItems.PLANE: break; case BudgetItems.BAG: break; case BudgetItems.FOOD: break; case BudgetItems.ALCOHOL: break; case BudgetItems.EXCURSIONS: break; case BudgetItems.SOUVENIERS: break; case BudgetItems.HOTEL: break; case BudgetItems.DONE: break; default: Console.WriteLine(); Console.WriteLine("Please enter a valid Budget Item."); Console.WriteLine(); break; } Enum.TryParse(userResponse, out item); if (item != BudgetItems.NONE) { items.Add(item); } } Console.WriteLine($"Budget Items have been entered to the list."); DisplayContinuePrompt(); DisplayBudgetItems(items); Console.WriteLine("*****************************************************"); DisplayContinuePrompt(); }
public void Add(BudgetItems budgetItems) { _context.BudgetItems.Add(budgetItems); }
public static IdentityMessage CreateBudgetWarningMessage(this ApplicationUser user, BudgetItems budget, decimal budBal) { var admin = user; var msg = new IdentityMessage(); msg.Destination = admin.Email; //ConfigurationManager.AppSettings["ContactEmail"]; msg.Body = "This is a notification from Fruitful to let you know that a budget in your household -" + budget.Name + " - is getting close to its limit. You requested to be notified when the budget approached $" + budget.Warning.WarningLimit + " and the balance is currently at $" + budBal + ". <br/><br/> To view your budget and transactions, click <a href=\"https://csimmons-budgetprogram.azurewebsites.net/BudgetItems/Index\">here</a>. To see your household overview, click <a href=\"https://csimmons-budgetprogram.azurewebsites.net/Households/Index\">here</a>."; msg.Subject = "Warning! Budget Limit has been exceeded"; //the " + budget.Name + " " + budget.HouseHold + " return(msg); }
public void RemoveItem(BudgetItems budgetItem) { _context.BudgetItems.Remove(budgetItem); }