public static void deleteTask(String taskId) { using (var db = new ToDoListDB()) { task t = db.tasks.First(c => c.id.Equals(taskId)); db.tasks.Remove(t); db.SaveChanges(); } }
public static string getTasks() { using (var db = new ToDoListDB()) { int userId = Convert.ToInt32(HttpContext.Current.Session["userId"]); var json = JsonConvert.SerializeObject(db.tasks.Where(c => c.UserId == userId)); return(json); } }
public static void addTask(task t) { using (var db = new ToDoListDB()) { t.UserId = Convert.ToInt32(HttpContext.Current.Session["userId"]); db.tasks.Add(t); db.SaveChanges(); } }
public static void updateTask(task t) { using (var db = new ToDoListDB()) { t.UserId = Convert.ToInt32(HttpContext.Current.Session["userId"]); var entity = db.tasks.Find(t.id); db.Entry(entity).CurrentValues.SetValues(t); db.SaveChanges(); } }
protected void register_Click(object sender, EventArgs e) { using (var db = new ToDoListDB()) { user foundeduser = null; foundeduser = db.users.Where(i => i.Email == emailInput.Text) .DefaultIfEmpty(null) .First(); //check if there's empty input field if (checkEmptyInput()) { //There is no such a user , so we create new one if (foundeduser == null) { if (passwordInput.Text.Equals(confirmedPassword.Text) && passwordInput.Text.Length >= 8) { foundeduser = new user() { FirstName = firstNameInput.Text, LastName = lastNameInput.Text, Email = emailInput.Text, Password = passwordInput.Text }; db.users.Add(foundeduser); db.SaveChanges(); Response.Redirect("Login.aspx"); } else { Response.Write("<script>alert(' passwords must be the same and greater than 8 charcters!')</script>"); passErrMsg.Visible = true; passwordInput.Text = ""; confirmedPassword.Text = ""; } } else { Response.Write("<script>alert(' username is already exists!')</script>"); regErrMsg.Visible = true; emailInput.Text = ""; passwordInput.Text = ""; confirmedPassword.Text = ""; } } } }
protected void loginBtn_Click(object sender, EventArgs e) { using (var db = new ToDoListDB()) { var user = db.users.Where(i => i.Email == usernameInput.Text && i.Password == passwordInput.Text).DefaultIfEmpty(null).First(); if (user == null) { loginErrMsg.Visible = true; } else { //redirect + update seassion HttpContext.Current.Session["userId"] = user.UserId; HttpContext.Current.Session["username"] = user.FirstName + " " + user.LastName; Response.Redirect("Default.aspx"); } } }