private BudgetPlanItemVM FindBudgetPlanItemVMFor(BudgetPlan budgetPlan)
{
Diagnostics.Start();
var budgetPlanItem = AllBudgetPlanList
.Where(x => x.CashFlow.Id == budgetPlan.CashFlowId && x.Budget.Id == budgetPlan.BudgetId)
.First();
Diagnostics.Stop();
return(budgetPlanItem);
}
public void DeleteBudgetPlanItem(BudgetPlan planItem)
{
Diagnostics.Start();
using (var tx = Database.GetTransaction())
{
Database.Delete(planItem);
tx.Complete();
var budgetPlanItem = FindBudgetPlanItemVMFor(planItem);
budgetPlanItem.Values.Remove(planItem);
PublishRefreshRequest(planItem);
}
Diagnostics.Stop();
}
public ActionResult DeleteConfirmed(int id)
{
BudgetPlan budgetPlan = db.BudgetPlans.Find(id);
var user = db.Users.Find(User.Identity.GetUserId());
if (user.HouseholdId != null && budgetPlan.HouseholdId == user.HouseholdId)
{
db.BudgetPlans.Remove(budgetPlan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("NotAuthorized", "Account"));
}
public BudgetPlan AddValue(decimal value, string description)
{
var plan = new BudgetPlan
{
Value = value,
Description = description,
Budget = Budget,
CashFlow = CashFlow,
};
Budget.BudgetPlanItems.Add(plan);
Values.Add(plan);
return(plan);
}
public int CreateNewBudgetPlan(string name)
{
BudgetPlan bp = new BudgetPlan();
bp.Name = name;
bp.UserId = UserId;
using (BudgetingEntities db = new BudgetingEntities())
{
db.BudgetPlans.Add(bp);
db.Entry(bp).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
}
return(bp.BudgetPlanId);
}
public async Task <BudgetPlan> AddNewBudgetPlanAsync(Guid TripId)
{
/* var budget = await _context.Budgets.FirstOrDefaultAsync(x=>x.Name == Name);
* if(budget!=null)
* {
* throw new Exception($"Budget with that name: '{Name}' already exists.");
* }*/
var budget = new BudgetPlan(TripId);
await _context.Budgets.AddAsync(budget);
await _context.SaveChangesAsync();
return(budget);
}
public ActionResult Create([Bind(Include = "Id,Name,Description,CategoryId,AmountBudgeted")] BudgetPlan budgetPlan)
{
var user = db.Users.Find(User.Identity.GetUserId());
if (ModelState.IsValid)
{
budgetPlan.OwnerId = user.Id;
budgetPlan.HouseholdId = user.HouseholdId.Value;
budgetPlan.IsActive = true;
db.BudgetPlans.Add(budgetPlan);
db.SaveChanges();
return(RedirectToAction("Details", new { id = budgetPlan.Id }));
}
ViewBag.CategoryId = new SelectList((db.BudgetPlanCategories.Where(bc => bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId)), "Id", "Category");
//ViewBag.BudgetItems = new SelectList((db.BudgetItems.Where(bc => (bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId) && bc.IsActive == true)), "Id", "Name");
return(View(budgetPlan));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetPlan budgetPlan = db.BudgetPlans.Find(id);
var user = db.Users.Find(User.Identity.GetUserId());
if (user.HouseholdId != null && budgetPlan.HouseholdId == user.HouseholdId)
{
if (budgetPlan == null)
{
return(HttpNotFound());
}
return(View(budgetPlan));
}
return(RedirectToAction("NotAuthorized", "Account"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetPlan budgetPlan = db.BudgetPlans.Find(id);
var user = db.Users.Find(User.Identity.GetUserId());
if (user.HouseholdId != null && budgetPlan.HouseholdId == user.HouseholdId)
{
if (budgetPlan == null)
{
return(HttpNotFound());
}
ViewBag.CategoryId = new SelectList((db.BudgetPlanCategories.Where(bc => bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId)), "Id", "Category");
//ViewBag.BudgetItems = new SelectList((db.BudgetItems.Where(bc => bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId)), "Id", "Name");
return(View(budgetPlan));
}
return(RedirectToAction("NotAuthorized", "Account"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Description,IsActive,CategoryId,HouseholdId,OwnerId,AmountBudgeted")] BudgetPlan budgetPlan)
{
var user = db.Users.Find(User.Identity.GetUserId());
if (user.HouseholdId == null || budgetPlan.HouseholdId != user.HouseholdId)
{
return(RedirectToAction("NotAuthorized", "Account"));
}
if (ModelState.IsValid)
{
if (budgetPlan.IsActive == false)
{
budgetPlan.Deactivated = DateTime.UtcNow;
}
db.Entry(budgetPlan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = budgetPlan.Id }));
}
ViewBag.CategoryId = new SelectList((db.BudgetPlanCategories.Where(bc => bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId)), "Id", "Category");
//ViewBag.BudgetItems = new SelectList((db.BudgetItems.Where(bc => (bc.HouseholdId == null || bc.HouseholdId == user.HouseholdId) && bc.IsActive == true)), "Id", "Name");
return(View(budgetPlan));
}
public static BudgetPlan CreateBudgetPlan(string documentNumber,
string scenario,
global::System.Guid lineReferenceId,
decimal transactionCurrencyAmount,
decimal transactionUnitPrice,
global::System.DateTimeOffset effectiveDate,
decimal unitPrice,
int rank,
decimal quantity)
{
BudgetPlan budgetPlan = new BudgetPlan();
budgetPlan.DocumentNumber = documentNumber;
budgetPlan.Scenario = scenario;
budgetPlan.LineReferenceId = lineReferenceId;
budgetPlan.TransactionCurrencyAmount = transactionCurrencyAmount;
budgetPlan.TransactionUnitPrice = transactionUnitPrice;
budgetPlan.EffectiveDate = effectiveDate;
budgetPlan.UnitPrice = unitPrice;
budgetPlan.Rank = rank;
budgetPlan.Quantity = quantity;
return(budgetPlan);
}
private void SaveBudgetPlan(BudgetPlan budgetPlan)
{
Diagnostics.Start();
Save(budgetPlan);
Diagnostics.Stop();
}
public async Task Add(BudgetPlan budgetPlan)
{
context.BudgetPlans.Add(budgetPlan);
await context.SaveChangesAsync();
}
