public static int DoRegisterNewPassword(PasswordInfo passwordDetails)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO password(passwordId,name,email,userId,password,secretQuestion,secretAnswer,otherInfo) "
+ "VALUES(@passwordId,@name,@email,@userId,@password,@secretQuestion,@secretAnswer,@otherInfo)";
msqlCommand.Parameters.AddWithValue("@passwordId", passwordDetails.id);
msqlCommand.Parameters.AddWithValue("@name", passwordDetails.name);
msqlCommand.Parameters.AddWithValue("@email", passwordDetails.email);
msqlCommand.Parameters.AddWithValue("@userId", passwordDetails.userId);
msqlCommand.Parameters.AddWithValue("@password", passwordDetails.password);
msqlCommand.Parameters.AddWithValue("@secretQuestion", passwordDetails.scrtqstn);
msqlCommand.Parameters.AddWithValue("@secretAnswer", passwordDetails.scrtans);
msqlCommand.Parameters.AddWithValue("@otherInfo", passwordDetails.otherInfo);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
private static List<PasswordInfo> QueryAllPasswordList()
{
List<PasswordInfo> PasswordList = new List<PasswordInfo>();
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "Select * From password ;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
PasswordInfo Password = new PasswordInfo();
Password.id = msqlReader.GetString("id");
Password.name = msqlReader.GetString("name");
Password.email = msqlReader.GetString("email");
Password.userId = msqlReader.GetString("userId");
Password.password = msqlReader.GetString("password");
Password.scrtqstn = msqlReader.GetString("secretQuestion");
Password.scrtans = msqlReader.GetString("secretAnswer");
Password.otherInfo = msqlReader.GetString("otherInfo");
PasswordList.Add(Password);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return PasswordList;
}
private void paswrdSave_Click(object sender, RoutedEventArgs e)
{
DNBSNData.PasswordInfo newPassword = new DNBSNData.PasswordInfo();
newPassword.id = GenerateId();
newPassword.name = passNameTB.Text;
newPassword.email = emailforpassTB.Text;
newPassword.userId = userIdTB.Text;
newPassword.password = pawsrdTB.Text;
newPassword.scrtqstn = scrtQstnTB.Text;
newPassword.scrtans = secrtAnsTB.Text;
newPassword.otherInfo = othersInfoTB.Text;
DNBSNDb.DbInteraction.DoRegisterNewPassword(newPassword);
passNameTB.Text = emailforpassTB.Text = userIdTB.Text = pawsrdTB.Text = scrtQstnTB.Text = secrtAnsTB.Text = othersInfoTB.Text = "";
addpassInfoExpndr.IsExpanded = false;
fetchPasswordData();
}