private void submitAddressBtn_Click(object sender, RoutedEventArgs e)
{
ExpenseManagerData.AddressInfo newAddress = new ExpenseManagerData.AddressInfo();
newAddress.id = GenerateId();
newAddress.name = nameBtn.Text;
newAddress.mobile = mobBtn.Text;
newAddress.home = homeBtn.Text;
newAddress.office = ofcBtn.Text;
newAddress.address = addressBtn.Text;
newAddress.email = emailBtn.Text;
newAddress.note = noteBtn.Text;
ExpenseManagerDb.DbInteraction.DoEnterAddress(newAddress);
addressTC.SelectedIndex = 0;
}
private static List<AddressInfo> QueryAllAddressList()
{
List<AddressInfo> AllAddressList = new List<AddressInfo>();
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 address;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
AddressInfo Address = new AddressInfo();
Address.id = msqlReader.GetString("id");
Address.name = msqlReader.GetString("name");
Address.mobile = msqlReader.GetString("mobile");
Address.home = msqlReader.GetString("home");
Address.office = msqlReader.GetString("office");
Address.address = msqlReader.GetString("address");
Address.email = msqlReader.GetString("email");
Address.note = msqlReader.GetString("note");
AllAddressList.Add(Address);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return AllAddressList;
}
public static int DoEnterAddress(AddressInfo NewAddress)
{
return DoRegisterNewAddressindb(NewAddress);
}
private static int DoRegisterNewAddressindb(AddressInfo NewAddress)
{
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 address(id,name,mobile,home,office,address,email,note) "
+ "VALUES(@id,@name,@mobile,@home,@office,@address,@email,@note)";
msqlCommand.Parameters.AddWithValue("@id", NewAddress.id);
msqlCommand.Parameters.AddWithValue("@name", NewAddress.name);
msqlCommand.Parameters.AddWithValue("@mobile", NewAddress.mobile);
msqlCommand.Parameters.AddWithValue("@home", NewAddress.home);
msqlCommand.Parameters.AddWithValue("@office", NewAddress.office);
msqlCommand.Parameters.AddWithValue("@address", NewAddress.address);
msqlCommand.Parameters.AddWithValue("@email", NewAddress.email);
msqlCommand.Parameters.AddWithValue("@note", NewAddress.note);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}