public ActionResult NewOrEdit(FixedExpenses model, FormCollection frm)
{
try
{
var db = DB.Entities;
if (model.ID == 0)
{
// Edit
db.FixedExpenses.AddObject(model);
}
else
{
// Add new
db.AttachTo("FixedExpenses", model);
db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
SelectOption(model);
return(View(model));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Frequence,ByDate,Id,Title,Amount,TransactionDate,CategoriesId")] FixedExpenses fixedExpenses)
{
if (id != fixedExpenses.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(fixedExpenses);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FixedExpensesExists(fixedExpenses.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoriesId"] = new SelectList(_context.Categories, "Id", "Name", fixedExpenses.CategoriesId);
return(View(fixedExpenses));
}
public ActionResult NewOrEdit(int?id = 0)
{
var obj = new FixedExpenses();
if (id != 0)
{
obj = DB.Entities.FixedExpenses.FirstOrDefault(m => m.ID == id);
}
SelectOption(obj);
return(View(obj));
}
void SelectOption(FixedExpenses obj)
{
#region SELECT OPTION
string[] lst = new string[] { "Daily", "Weekly", "Monthly" };
ViewBag.dataFrequency = CommonFunction.BuildDropdown(lst, lst, obj.Frequency, null);
#endregion
var lstfix = DB.Entities.FixedExpenses.ToList();
ViewBag.dataFilterFixed = CommonFunction.BuildDropdown(lstfix.Select(m => m.ID.ToString()).ToArray(),
lstfix.Select(m => m.Expenses).ToArray(), null, "--Select fixed expenses--");
}
public async Task <IActionResult> Create([Bind("Frequence,ByDate,Id,Title,Amount,TransactionDate,CategoriesId")] FixedExpenses fixedExpenses)
{
if (ModelState.IsValid)
{
_context.Add(fixedExpenses);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoriesId"] = new SelectList(_context.Categories, "Id", "Name", fixedExpenses.CategoriesId);
return(View(fixedExpenses));
}
public Money TotalFixedExpenses(int month, int year) => FixedExpenses
.Where(activity =>
activity.EndDate == null ||
activity.EndDate.Value.Month >= month &&
activity.EndDate.Value.Year >= year)
.Sum(activity => (decimal?)activity.Total) ?? 0;
public Money TotalFixedExpenses(DateTime date) => FixedExpenses .Where(activity => activity.StartDate.Day == date.Day) .Sum(activity => (decimal?)activity.Total) ?? 0;
public Money TotalFixedExpenses() => FixedExpenses.Sum(activity => (decimal?)activity.Total) ?? 0;
