public void UpdateBtn_Click(object sender, EventArgs e)
{
//declare variables needed for operations
string Vegetarian = "";
string Gender = GenderBox.Text;
string Password = oldPasswBox.Text;
string ModifWeightIn = modifLastWeightIn.Text;
if (yesRadioBtn.Checked)
{
Vegetarian = "Yes";
}
if (noRadioBtn.Checked)
{
Vegetarian = "No";
}
string con = MyMethodsLib.GetConnectionString();
if (nameBox.Text != "")
{
MyMethodsLib.ChangeUserName(Username, nameBox.Text, con); nameBox.Text = "";
}
if (surnameBox.Text != "")
{
MyMethodsLib.ChangeUserSurName(Username, surnameBox.Text, con); surnameBox.Text = "";
}
if (emailBx.Text != "")
{
MyMethodsLib.ChangeEmail(Username, emailBx.Text, con); emailBx.Text = "";
}
using (SqlConnection sqlConnect = new SqlConnection(MyMethodsLib.GetConnectionString()))
{
if (Vegetarian != "")
{
try
{
sqlConnect.Open();
SqlCommand sqlCmdUpdateVegetarian = new SqlCommand("VegetarianUpdate", sqlConnect)
{
CommandType = CommandType.StoredProcedure
};
SqlCommand cmdUpdateVegetarian = new SqlCommand
{
CommandText = "SELECT * from [tblUserNamePassw] WHERE UserName=@UserName"
};
cmdUpdateVegetarian.Parameters.AddWithValue("@Username", Username);
cmdUpdateVegetarian.Parameters.AddWithValue("@Vegetarian", Vegetarian);
cmdUpdateVegetarian.Connection = sqlConnect;
sqlCmdUpdateVegetarian.Parameters.AddWithValue("@Username", Username);
sqlCmdUpdateVegetarian.Parameters.AddWithValue("@Vegetarian", Vegetarian);
sqlCmdUpdateVegetarian.ExecuteNonQuery();
MessageBox.Show("Vegetarian option was changed!");
sqlConnect.Close();
yesRadioBtn.Checked = false;
noRadioBtn.Checked = false;
}
catch (System.Exception)
{
MessageBox.Show("SQL Query unsuccessful");
}
}
//code to update Gender
if (Gender != "")
{
try
{
sqlConnect.Open();
SqlCommand sqlCmdUpdateGender = new SqlCommand("GenderUpdate", sqlConnect)
{
CommandType = CommandType.StoredProcedure
};
SqlCommand sqlCommand = new SqlCommand
{
CommandText = "SELECT * from [tblUserNamePassw] WHERE UserName=@UserName"
};
SqlCommand cmdUpdateGender = sqlCommand;
cmdUpdateGender.Parameters.AddWithValue("@Username", Username);
cmdUpdateGender.Parameters.AddWithValue("@Gender", Gender);
cmdUpdateGender.Connection = sqlConnect;
sqlCmdUpdateGender.Parameters.AddWithValue("@Username", Username);
sqlCmdUpdateGender.Parameters.AddWithValue("@Gender", Gender);
sqlCmdUpdateGender.ExecuteNonQuery();
MessageBox.Show("Gender changed successfully!");
GenderBox.SelectedItem = "";
sqlConnect.Close();
}
catch (System.Exception)
{
MessageBox.Show("SQL Query unsuccessful");
}
}
// fun now... .code to update Password
if (Password != "")
{
try
{
sqlConnect.Open();
SqlCommand sqlCmdUpdatePassword = new SqlCommand("PasswordUpdate", sqlConnect)
{
CommandType = CommandType.StoredProcedure
};
SqlCommand cmdUpdatePassword = new SqlCommand
{
CommandText = "SELECT Password from [tblUserNamePassw] WHERE UserName=@UserName"
};
cmdUpdatePassword.Parameters.AddWithValue("@Username", Username);
cmdUpdatePassword.Connection = sqlConnect;
try
{
string oldPassword = "";
SqlDataReader dataReader = cmdUpdatePassword.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
oldPassword = dataReader.GetSqlString(0).ToString();
}
}
dataReader.Close();
if (Password == oldPassword)
{
if (newPasswBox.Text != "" && newPasswBox.Text.Count() > 6)
{
Password = newPasswBox.Text;
}
else
{
MessageBox.Show("Please make sure your new password contains at least 7 letters!");
}
}
}
catch (System.Exception)
{
MessageBox.Show("Unsuccessful operation!");
}
sqlCmdUpdatePassword.Parameters.AddWithValue("@Username", Username);
sqlCmdUpdatePassword.Parameters.AddWithValue("@Password", Password);
sqlCmdUpdatePassword.ExecuteNonQuery();
sqlConnect.Close();
MessageBox.Show("Password successfullly changed!");
}
catch (System.Exception)
{
MessageBox.Show("SQL Query unsuccessful");
}
}
//code to update last weight
if (ModifWeightIn != "")
{
try
{
var Date = DateTime.Now.Date;
SqlCommand cmdUpdateWeight = new SqlCommand
{
CommandText = "SELECT Date from [tblMeasures] WHERE UserName=@UserName AND Date=@Date"
};
cmdUpdateWeight.Parameters.AddWithValue("@Username", Username);
cmdUpdateWeight.Parameters.AddWithValue("@Weight", ModifWeightIn);
cmdUpdateWeight.Parameters.AddWithValue("@Date", Date);
cmdUpdateWeight.Connection = sqlConnect;
string dateFromDbs = "";
SqlCommand sqlCmdUpdateWeight = new SqlCommand();
sqlConnect.Open();
try
{
SqlDataReader dataReader = cmdUpdateWeight.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dateFromDbs = dataReader.GetDateTime(0).Date.ToString();
}
dataReader.Close();
if (dateFromDbs == Date.ToString())
{
try
{
sqlCmdUpdateWeight.CommandText = "UPDATE [tblMeasures] SET Weight=@Weight WHERE UserName= @UserName and Date=@Date";
sqlCmdUpdateWeight.Parameters.AddWithValue("@Username", Username);
sqlCmdUpdateWeight.Parameters.AddWithValue("@Weight", ModifWeightIn);
sqlCmdUpdateWeight.Parameters.AddWithValue("@Date", Date);
sqlCmdUpdateWeight.Connection = sqlConnect;
sqlCmdUpdateWeight.ExecuteNonQuery();
sqlConnect.Close();
weightBox.Text = ModifWeightIn;
//string con = MyMethodsLib.GetConnectionString();
string height = MyMethodsLib.GetHeightFromDbs(Username, con).ToString();
BMIBox.Text = MyMethodsLib.CalculateBMI(ModifWeightIn, height);
MessageBox.Show("Today's Weight Input modified successfully!");
}
catch (System.Exception)
{
MessageBox.Show("Ooops");
}
}
sqlConnect.Close();
}
else
{
MessageBox.Show("ATTEMPT FAILED. You can only modify today's input.");
sqlConnect.Close();
}
}
catch (System.Exception)
{
MessageBox.Show("Shit happened");
if (sqlConnect.State == ConnectionState.Open)
{
sqlConnect.Close();
}
}
}
catch (System.Exception)
{
MessageBox.Show("SQL Query unsuccessful");
}
}
}
double kgToLoose = MyMethodsLib.KgToLoose(Username, weightBox.Text);
kgBox.Text = MyMethodsLib.WeightResultOutput(Username, kgToLoose, weightBox.Text);
nameBox.Text = "";
surnameBox.Text = "";
oldPasswBox.Text = "";
newPasswBox.Text = "";
modifLastWeightIn.Text = "";
}