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));
            }
        }
Exemple #4
0
 public TaskRepository(MyTasksContext database)
 {
     _database = database;
 }
 public TokenRepository(MyTasksContext banco)
 {
     _base = banco;
 }
Exemple #6
0
 public TaskRepository(MyTasksContext context)
 {
     _context = context;
 }
Exemple #7
0
 public TaskRepository(MyTasksContext db)
 {
     _db = db;
 }