public JsonResult Login(string UserName, string Password) { string message = ""; try { using (Models.MembershipEntities1 memberDatabase = new MembershipEntities1()) { if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password)) { Models.User user = memberDatabase.Users.Where(User => User.UserName == UserName && User.Password == Password).SingleOrDefault(); if(user == null) { message = "The username or password you entered was invalid"; } else { Session["userId"] = user.ID.ToString(); } } else { throw new Exception("Username and password must have a value"); } } } catch (Exception ex) { message = ex.Message; } return Json(message, JsonRequestBehavior.AllowGet); }
public void MembershipEntitiesTest() { using (MembershipEntities1 memberDatabase = new MembershipEntities1()) { User newuser = memberDatabase.Users.FirstOrDefault(); Assert.AreNotEqual(null, newuser); } }
public JsonResult AddUserFavorite(string articleID) { int userId = Convert.ToInt32(Session["userId"]); string message = ""; using (Models.MembershipEntities1 memberDatabase = new MembershipEntities1()) { memberDatabase.UserArticles.Add(new UserArticle { ArticleId = Convert.ToInt32(articleID), UserId = userId }); try { memberDatabase.SaveChanges(); } catch (Exception) { message = "Article has already been added to favorites"; } } return Json(message, JsonRequestBehavior.AllowGet); }
public JsonResult RegisterUser(string UserName, string Password, string EmailAddress) { string message = ""; try { using (Models.MembershipEntities1 memberDatabase = new MembershipEntities1()) { if(!EmailAddress.Contains('@') || (!EmailAddress.Contains(".com"))) { throw new Exception("Must have valid Email"); } else if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password) && !string.IsNullOrEmpty(EmailAddress)) { Models.User newuser = new Models.User { Email = EmailAddress, UserName = UserName, Password = Password }; memberDatabase.Users.Add(newuser); try { memberDatabase.SaveChanges(); } catch(Exception ex) { message = "User already exists"; } } else { throw new Exception("Username, password, and email must have a value"); } } } catch (Exception ex) { message = ex.Message; } return Json(message, JsonRequestBehavior.AllowGet); // If we got this far, something failed, redisplay form }
public ActionResult UserFavorites() { List<int> favorites = null; int ID = Convert.ToInt32(Session["userId"]); using (Models.MembershipEntities1 memberDatabase = new MembershipEntities1()) { favorites = memberDatabase.UserArticles.Where(User => User.UserId == ID).Select(Article => Article.ArticleId).ToList(); } var articles = db.T_Article.Where(Article => favorites.Contains(Article.ID)).ToList(); //var articles = from article in db.T_Article // select article; return View(articles); }