public PaycheckBudgetResponse AddBudget(PaycheckBudgetViewModel budgetViewModel)
{
var budget = new Budget
{
BudgetAmount = budgetViewModel.Amount,
BudgetDate = budgetViewModel.Date
};
foreach (var budgetItem in budgetViewModel.BudgetItems)
{
budget.BudgetItems.Add(new BudgetItem
{
Amount = budgetItem.Amount,
Description = budgetItem.Description,
IsPaid = budgetItem.IsPaid,
DueDate = budgetItem.DueDate,
DatePaid = budgetItem.DueDate // When adding a new budget, the date paid has to have a valid date, so give it the due date.
});
}
_db.Budgets.AddObject(budget);
_db.SaveChanges();
return(GetCurrentBudgets());
}
public ActionResult Create([Bind(Include = "CategoryID,CategoryName")] Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public void LogUserLogin(User currentUser, ExpenseTrackerEntities _db, HttpContext currentContext)
{
//currentUser.LastLoggedIn = DateTime.Now;
currentUser.LAST_ACCESS_IP = ExpenseTracker.Utilities.Web.GetClientIPAddress(currentContext);
_db.SaveChanges();
}
public void Add(DTO.ExpenseGroup newItem)
{
Entities.ExpenseGroup newEntity = _mapper.CreateEntityFromDTO(newItem) as Entities.ExpenseGroup;
db.ExpenseGroups.Add(newEntity);
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "ItemId,ItemName,ItemCategory,ItemAmount,ExpeseDate,CategoryId,UserId")] Item item)
{
if (ModelState.IsValid)
{
// var = User.Identity.Name;
item.UserId = db.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault().UserId;
item.ItemCategory = db.Categories.Where(x => x.CategoryID == item.CategoryId).FirstOrDefault().CategoryName;
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryID", "CategoryName", item.CategoryId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "UserName", item.UserId);
return(View(item));
}
public void Add(T newItem)
{
Entities.IEntity newEntity = _mapper.CreateEntityFromDTO(newItem);
Type entityType = newEntity.GetType();
db.Set(entityType).Add(newEntity);
db.SaveChanges();
}
public override bool ValidateUser(string username, string password)
{
using (ExpenseTrackerEntities _db = new ExpenseTrackerEntities())
{
try
{
var user = _db.Users.FirstOrDefault(u => u.UserEmail == username);
user.UserPassword = password;
_db.SaveChanges();
if (user != null)
{
//Update on every login validation success
this.LogUserLogin(user, _db, HttpContext.Current);
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
}
public ActionResult Index(User user)
{
try
{
if (ModelState.IsValid)
{
user.UserRole = "U";
_context.Users.Add(user);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View("Index"));
}
}
catch (Exception e1)
{
return(RedirectToAction("Index"));
}
}