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");
}
}
}
