public ActionResult Create(Tbl_Task task) { if (ModelState.IsValid) { using (var databaseContext = new TODOListDBEntities()) { try { if (Session["UserInfo"] != null) { loginUser = (Tbl_User)Session["UserInfo"]; } task.UserId = loginUser.Id; task.CreatedDate = DateTime.Now; task.ModifiedDate = DateTime.Now; databaseContext.Tbl_Task.Add(task); databaseContext.SaveChanges(); } catch (DbEntityValidationException e) { ViewBag.Message = "All fields are compulsory"; return(View("Create")); } } ViewBag.Message = "Task Added"; return(View("Create")); } else { return(View()); } }
public ActionResult AddUser(Tbl_User registerUser) { if (ModelState.IsValid) { using (var databaseContext = new TODOListDBEntities()) { try { registerUser.Password = Encrypt(registerUser.Password); databaseContext.Tbl_User.Add(registerUser); databaseContext.SaveChanges(); }catch (DbUpdateException e) { ViewBag.Message = "Username ALready Exists"; return(View("Register")); } } ViewBag.Message = "User Details Saved"; return(View("Register")); } else { //If the validation fails, we are returning the model object with errors to the view, which will display the error messages. return(View("Register", registerUser)); } }
public ActionResult IsValidUser(Tbl_User loginUser) { using (var dataContext = new TODOListDBEntities()) { //String password = Decrypt(loginUser.Password); //Retireving the user details from DB based on username and password enetered by user. Tbl_User addedUser = dataContext.Tbl_User.Where(query => query.Username.Equals(loginUser.Username)).SingleOrDefault(); //If user is not present, then false is returned. if (addedUser == null) { ViewBag.Message = "Incorrect username"; return(View("Login")); } //If user is present true is returned. else { String testpassword = loginUser.Password; String password = Decrypt(addedUser.Password); if (password.Equals(testpassword)) { Session["UserInfo"] = addedUser; return(RedirectToAction("ToDo", "Task")); } ViewBag.Message = "Incorrect password"; return(View("Login")); } } }
//GET: EditToDo public ActionResult Edit(int id) { using (var dataContext = new TODOListDBEntities()) { Tbl_Task editTask = dataContext.Tbl_Task.Where(query => query.Id == id).FirstOrDefault(); return(View(editTask)); } }
//POST: DeleteToDo public ActionResult Delete(int id) { using (var dataContext = new TODOListDBEntities()) { Tbl_Task _Task = dataContext.Tbl_Task.Where(query => query.Id == id).FirstOrDefault(); dataContext.Tbl_Task.Remove(_Task); dataContext.SaveChanges(); return(RedirectToAction("ToDo")); } }
public ActionResult Edit(Tbl_Task task) { using (var dataContext = new TODOListDBEntities()) { Tbl_Task editTask = dataContext.Tbl_Task.Where(query => query.Id == task.Id).FirstOrDefault(); editTask.Id = task.Id; editTask.TaskName = task.TaskName; editTask.Description = task.Description; editTask.IsCompleted = task.IsCompleted; editTask.ModifiedDate = DateTime.Now; dataContext.Entry(editTask).State = System.Data.Entity.EntityState.Modified; dataContext.SaveChanges(); } ViewBag.Message = "Task Updated"; return(View()); }
public ActionResult ToDo() { using (var dataContext = new TODOListDBEntities()) { loginUser = new Tbl_User(); if (Session["UserInfo"] != null) { loginUser = (Tbl_User)Session["UserInfo"]; } tasks = new List <Tbl_Task>(); foreach (Tbl_Task task in dataContext.Tbl_Task.Where(c => c.UserId == loginUser.Id)) { tasks.Add(task); } } return(View(tasks)); }