//
// GET: /Items/
public ActionResult Index()
{
List<UserItem> UserItems;
using (YearnlyEntities context = new YearnlyEntities())
{
UserItems = context.UserItems.Where(ui => ui.UserId == WebSecurity.CurrentUserId).ToList();
}
ViewBag.UserItems = UserItems;
return View();
}
//This method will either load a user or load an empty user.
public static UserProfile LoadUserByUserName(String userName, YearnlyEntities db)
{
UserProfile returnedUser = new UserProfile();
UserProfile user = db.UserProfiles.Where(up => up.UserName == userName).FirstOrDefault();
if (user != null)
{
returnedUser = user;
}
return returnedUser;
}
//This is a quick checker to see if a user exists
public static Boolean DoesUserExist(String userName, YearnlyEntities db)
{
Boolean returnValue = false;
UserProfile user = db.UserProfiles.Where(up => up.UserName == userName).FirstOrDefault();
if (user != null)
{
returnValue = true;
}
return returnValue;
}
//
// GET: /List/
public ActionResult Index()
{
IEnumerable<UserList> usersList;
using (YearnlyEntities context = new YearnlyEntities())
{
usersList = context.UserLists.Where(ul => ul.UserId == WebSecurity.CurrentUserId).ToList();
}
ViewBag.UsersLists = usersList;
return View();
}
public ActionResult Create(UserItem input)
{
input.UserId = WebSecurity.CurrentUserId;
using (YearnlyEntities context = new YearnlyEntities())
{
context.UserItems.Add(input);
context.SaveChanges();
}
return RedirectToAction("index", "items");
}
public ActionResult Edit(int id)
{
UserList editList;
using (YearnlyEntities context = new YearnlyEntities())
{
editList = context.UserLists.Where(ul => ul.Id == id).FirstOrDefault();
}
ViewBag.EditList = editList;
return View();
}
public ActionResult Create(String listname)
{
UserList newList = new UserList();
newList.Name = listname;
newList.UserId = WebSecurity.CurrentUserId;
newList.DateCreated = DateTime.UtcNow;
using (YearnlyEntities context = new YearnlyEntities())
{
context.UserLists.Add(newList);
context.SaveChanges();
}
return RedirectToAction("index", "list");
}
public ListsController()
{
db = new YearnlyEntities();
}
public static IEnumerable<UserProfile> SearchUsers(string searchText, YearnlyEntities db)
{
return db.UserProfiles.Where(up => up.UserName.Contains(searchText) || up.FirstName.Contains(searchText) || up.LastName.Contains(searchText)).ToList();
}
public static UserProfile LoadUserByUserId(int userId, YearnlyEntities db)
{
UserProfile returnedUser = new UserProfile();
returnedUser = db.UserProfiles.Where(up => up.UserId == userId).FirstOrDefault();
return returnedUser;
}
public PublicViewController()
{
db = new YearnlyEntities();
}
public ItemsController()
{
db = new YearnlyEntities();
loggedInUser = UserProfile.LoadUserByUserName(WebSecurity.CurrentUserName, db);
}
public HomeController()
{
db = new YearnlyEntities();
}
