public ActionResult List(int id) { // get list of tasks in a project using (MyTasksContext ctx = new MyTasksContext()) { var project = (from p in ctx.Projects where p.Id == id select p).SingleOrDefault(); ViewBag.ProjectTitle = project.Title; var tasks = from t in ctx.Tasks.ToList <Task>() where t.ProjectId == id select t; return(View(tasks)); } }
public ActionResult ChangePassword(ChangePasswordModel model) { if (ModelState.IsValid) { try { using (MyTasksContext ctx = new MyTasksContext()) { string email = Session["email"].ToString(); var user = (from u in ctx.Users where u.Email == email select u).SingleOrDefault(); // verifica se a senha naterior é a mesma que a do database if (user.Password == model.Password) { user.Password = model.NewPassword; ctx.SaveChanges(); ViewBag.Message = "A senha foi alterada com sucesso !"; } else { ViewBag.Message = "A senha anterior esta incorreta !"; } } return(View(model)); } catch (Exception ex) { ViewBag.Message = "Não foi possível processar sua requisição."; System.Web.HttpContext.Current.Trace.Write("UserController.ChangePasssword() --> " + ex.Message); return(View(model)); } } else { ViewBag.Message = "Informação inválida !"; return(View(model)); } }
public ActionResult Login(LoginModel model) { if (ModelState.IsValid) { try { using (MyTasksContext ctx = new MyTasksContext()) { var user = (from u in ctx.Users where u.Email == model.Email && u.Password == model.Password select u).SingleOrDefault(); if (user == null) { ViewBag.Message = "Login inválido, tente novamente !"; return(View(model)); } else { Session.Add("userid", user.Id); Session.Add("email", user.Email); FormsAuthentication.SetAuthCookie(user.Email, false); return(RedirectToAction("Home")); } } } catch (Exception ex) { ViewBag.Message = "Não foi possível processar o login."; System.Web.HttpContext.Current.Trace.Write("UserController.Login() --> " + ex.Message); return(View(model)); } } else { ViewBag.Message = "Informe o email e a senha !"; return(View(model)); } }
public TaskRepository(MyTasksContext database) { _database = database; }
public TokenRepository(MyTasksContext banco) { _base = banco; }
public TaskRepository(MyTasksContext context) { _context = context; }
public TaskRepository(MyTasksContext db) { _db = db; }