private void Signup()
{
using (moyEntities db = new moyEntities())
{
var signup = db.USERs.Where(a => a.Email.Equals(email.Text)).FirstOrDefault();
if (signup == null)
{
USER save = new USER();
save.Email = email.Text.Trim();
save.Name = name.Text.Trim();
save.Surname = surname.Text.Trim();
save.Password = pwd.Text.Trim();
db.USERs.Add(save);
db.SaveChanges();
Session.Add("Id", save.Id);
Session.Add("name", save.Name);
Session.Add("surname", save.Surname);
Session.Add("email", save.Email);
Session.Add("password", save.Password);
email.Text = string.Empty;
name.Text = string.Empty;
surname.Text = string.Empty;
Response.Redirect("Dashboard.aspx");
}
else
{
emailerror.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
int usrname = Session["Id"].GetHashCode();
var user = db.USERs.Where(a => a.Id == usrname).FirstOrDefault();
username.Text = user.Name;
}
}
public void Done_List()
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"]);
List <Done> done = db.Dones.Where(a => a.UserId == userid).OrderBy(a => a.DONE1).ToList();
DoneList.DataSource = done;
DoneList.DataTextField = "Done1";
DoneList.DataValueField = "Id";
DoneList.DataBind();
}
}
public void Willdo_List()
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"]);
List <Willdo> willdo = db.Willdoes.Where(a => a.UserId == userid).OrderBy(a => a.Willdo1).ToList();
WilldoList.DataSource = willdo;
WilldoList.DataTextField = "Willdo1";
WilldoList.DataValueField = "Id";
WilldoList.DataBind();
}
}
protected void DeleteDoingList(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"]);
var remove = db.Doings.Where(a => a.UserId == userid && a.Doing1 == DoingList.SelectedItem.Text).FirstOrDefault();
db.Doings.Remove(remove);
db.SaveChanges();
}
Doing_List();
Response.Redirect("list.aspx");
}
protected void Add_OnClick(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
Willdo willdo = new Willdo();
willdo.UserId = Session["Id"].GetHashCode();
willdo.Willdo1 = txtwilldo.Text;
db.Willdoes.Add(willdo);
db.SaveChanges();
}
txtwilldo.Text = "";
Willdo_List();
Response.Redirect("list.aspx");
}
protected void AddDoneList(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
Done done = new Done();
done.UserId = Session["Id"].GetHashCode();
done.DONE1 = txtdone.Text;
db.Dones.Add(done);
db.SaveChanges();
}
txtdone.Text = "";
Doing_List();
Response.Redirect("list.aspx");
}
protected void AddDoing_OnClick(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
Doing doing = new Doing();
doing.UserId = Session["Id"].GetHashCode();
doing.Doing1 = txtdoing.Text;
db.Doings.Add(doing);
db.SaveChanges();
}
txtdoing.Text = "";
Doing_List();
Response.Redirect("list.aspx");
}
protected bool IsEmailValid(string email)
{
USER userToEdit = new USER();
using (moyEntities db = new moyEntities())
{
userToEdit = db.USERs.Where(a => a.Email == email).FirstOrDefault();
}
if (userToEdit == null)
{
return(true);
}
else
{
return(false);
}
}
protected void PassDoingList(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities()) {
int userid = Convert.ToInt32(Session["Id"]);
Doing doing = new Doing();
doing.Doing1 = WilldoList.SelectedItem.Text;
doing.UserId = Session["Id"].GetHashCode();
db.Doings.Add(doing);
db.SaveChanges();
Willdo willdo = new Willdo();
var remove = db.Willdoes.Where(a => a.UserId == userid && a.Willdo1 == WilldoList.SelectedItem.Text).FirstOrDefault();
db.Willdoes.Remove(remove);
db.SaveChanges();
}
Willdo_List();
Doing_List();
Response.Redirect("list.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities())
{
CONTACT save = new CONTACT();
save.Email = email.Text.Trim();
save.Message = message.Text.Trim();
if (Session["Id"] != null)
{
save.UserId = Session["Id"].GetHashCode();
}
db.CONTACTs.Add(save);
db.SaveChanges();
sucmessage.Visible = true;
}
email.Text = string.Empty;
message.Text = string.Empty;
}
public void btnsave1_click(object sender, EventArgs e)
{
int length = 8;
string oldpassword = txtold1.Text.Trim();
string newpassword1 = txtnew1.Text.Trim();
string newpassword2 = txtnew2.Text.Trim();
string UserID = Session["Id"].ToString();
string DBPassword = string.Empty;
if (newpassword1.Length >= length && newpassword1 == newpassword2)
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"].GetHashCode());
USER loggedUser = db.USERs.Where(a => a.Id == userid).FirstOrDefault();
if (loggedUser != null)
{
DBPassword = loggedUser.Password;
}
}
if (oldpassword != newpassword1 && newpassword1 == newpassword2)
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"].GetHashCode());
USER loggedUser = db.USERs.Where(a => a.Id == userid).FirstOrDefault();
loggedUser.Password = newpassword1;
db.SaveChanges();
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showSuccess():", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showError();", true);
}
}
protected void login_button_Click(object sender, EventArgs e)
{
using (moyEntities db = new moyEntities()) // connect to database.
{
var login = db.USERs.Where(a => a.Email == email.Text && a.Surname == surname.Text && a.Name == name.Text && a.Password == pwd.Text).FirstOrDefault();
if (login != null)
{
Session.Add("Id", login.Id);
Session.Add("name", login.Name);
Session.Add("surname", login.Surname);
Session.Add("email", login.Email);
Session.Add("password", login.Password);
Response.Redirect("Dashboard.aspx");
}
else
{
Label1.Visible = true;
}
}
}
protected void btnsave2_click(object sender, EventArgs e)
{
bool validEmail = IsEmailValid(txtemail.Text);
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"].GetHashCode());
USER editedUser = db.USERs.Where(a => a.Id == userid).FirstOrDefault();
if (validEmail == true)
{
editedUser.Email = txtemail.Text;
}
db.SaveChanges();
}
txtemail.Text = null;
txtusername.Text = null;
}