private void changeP_Click(object sender, EventArgs e)
{
if (userName.Text == "")
{
MessageBox.Show("Please do enter user name it is mandatory!");
}
else if (pwd.Text == "")
{
MessageBox.Show("Password Mandatory!");
}
else if (newPwd.Text != pwd.Text)
{
MessageBox.Show("Re enter password carefully!");
}
else
{
try
{
con1.Open();
string cmdstr = "update user set password ='******' where name='" + userName.Text + "';";
MySqlCommand cmd = new MySqlCommand(cmdstr, con1);
cmd.ExecuteNonQuery();
MessageBox.Show("Password changed successfully!!", "Change Password");
Welcome newform = new Welcome();
newform.Show();
this.Close();
}
catch (Exception test)
{
MessageBox.Show("Unable to change the password due to error! " + test.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Welcome newformm = new Welcome();
newformm.Show();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (user.Text == "" || password.Text == "")
{
MessageBox.Show("Please enter all mandatory fields");
}
else
{
con1.Open();
string command = "select password from user where name='" + user.Text + "';";
MySqlCommand cmd = new MySqlCommand(command, con1);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string pd = dr.GetString(0);
if (pd == password.Text)
{
//correct password
{
Program.userName = user.Text;
//logout.Enabled = true;
this.Hide();
Welcome form1 = new Welcome();
form1.Closed += (s, args) => this.Close();
form1.Show();
}
}
else
{
MessageBox.Show("Incorrect password ! try again!!");
}
}
else
{
MessageBox.Show("Incorrect user name !", "Attention required");
}
}
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
con1.Close();
}
private void Save_Click(object sender, System.EventArgs e)
{
dob = agebox.Value.ToString("yyyy-MM-dd");
findUID();
string gender = string.Empty;
if (male.Checked && female.Checked)
{
MessageBox.Show("Select one gender");
}
if (male.Checked)
{
gender = "Male";
}
else if (female.Checked)
{
gender = "Female";
}
else
{
MessageBox.Show("Please select a gender:");
}
if (!email_Text())
{
return;
}
if (!phone_Text())
{
return;
}
string height = ht.Value.ToString();
string weight = wt.Value.ToString();
string Query = "insert into user (userid,name,password,dob,gender,phoneNo,email,height,weight,category,GoalCalorieIntake) values (" + res + ",'" + name.Text + "','" + NewUser.password + "','" + dob + "','" + gender + "','" + phone.Text + "','" + email.Text + "'," + height + "," + weight + ",'" + category.SelectedItem.ToString() + "',0);";
MySqlCommand cmd = new MySqlCommand(Query, con1);
try
{
con1.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Saved Successfully! Now you re ready to rock!! Please go set the goals ! You can check if our advised goals are sufficient ", "Getting Ready", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Welcome newPage = new Welcome();
newPage.Show();
this.Close();
con1.Close();
// this.Close();
}
catch (MySqlException error)
{
MessageBox.Show(error.Message);
}
catch (SystemException er)
{
MessageBox.Show(er.Message);
}
con1.Close();
}
