public void Save()
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO hikers (hiker_name, first_name, last_name, zip, phone_number, email, gender, car) VALUES (@hikerHikerName, @hikerFirstName, @hikerLastName, @hikerZip, @hikerPhone, @hikerEmail, @hikerGender, @hikerCar);";
MySqlParameter hikerHikerName = new MySqlParameter();
hikerHikerName.ParameterName = "@hikerHikerName";
hikerHikerName.Value = this._hikerName;
cmd.Parameters.Add(hikerHikerName);
MySqlParameter hikerFirstName = new MySqlParameter();
hikerFirstName.ParameterName = "@hikerFirstName";
hikerFirstName.Value = this._firstName;
cmd.Parameters.Add(hikerFirstName);
MySqlParameter hikerLastName = new MySqlParameter();
hikerLastName.ParameterName = "@hikerLastName";
hikerLastName.Value = this._lastName;
cmd.Parameters.Add(hikerLastName);
MySqlParameter hikerZip = new MySqlParameter();
hikerZip.ParameterName = "@hikerZip";
hikerZip.Value = this._zip;
cmd.Parameters.Add(hikerZip);
MySqlParameter hikerPhone = new MySqlParameter();
hikerPhone.ParameterName = "@hikerPhone";
hikerPhone.Value = this._phone;
cmd.Parameters.Add(hikerPhone);
MySqlParameter hikerEmail = new MySqlParameter();
hikerEmail.ParameterName = "@hikerEmail";
hikerEmail.Value = this._email;
cmd.Parameters.Add(hikerEmail);
MySqlParameter hikerGender = new MySqlParameter();
hikerGender.ParameterName = "@hikerGender";
hikerGender.Value = this._gender;
cmd.Parameters.Add(hikerGender);
MySqlParameter hikerCar = new MySqlParameter();
hikerCar.ParameterName = "@hikerCar";
hikerCar.Value = this._car;
cmd.Parameters.Add(hikerCar);
cmd.ExecuteNonQuery();
_id = (int)cmd.LastInsertedId;
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
public void Edit(string newHikerName, string newFirstName, string newLastName, int newZip, string newPhone, string newEmail, int newGender, int newCar)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"UPDATE hikers SET hiker_name = @hikerHikerName WHERE id = @hikerId; UPDATE hikers SET first_name = @hikerFirstName WHERE id = @hikerId; UPDATE hikers SET last_name = @hikerLastName WHERE id = @hikerId; UPDATE hikers SET zip = @hikerZip WHERE id = @hikerId; UPDATE hikers SET phone_number = @hikerPhoneNumber WHERE id = @hikerId; UPDATE hikers SET email = @hikerEmail WHERE id = @hikerId; UPDATE hikers SET gender = @hikerGender WHERE id = @hikerId; UPDATE hikers SET car = @hikerCar WHERE id = @hikerId;";
MySqlParameter hikerHikerNameParameter = new MySqlParameter();
hikerHikerNameParameter.ParameterName = "@hikerHikerName";
hikerHikerNameParameter.Value = newHikerName;
cmd.Parameters.Add(hikerHikerNameParameter);
MySqlParameter hikerFirstNameParameter = new MySqlParameter();
hikerFirstNameParameter.ParameterName = "@hikerFirstName";
hikerFirstNameParameter.Value = newFirstName;
cmd.Parameters.Add(hikerFirstNameParameter);
MySqlParameter hikerLastNameParameter = new MySqlParameter();
hikerLastNameParameter.ParameterName = "@hikerLastName";
hikerLastNameParameter.Value = newLastName;
cmd.Parameters.Add(hikerLastNameParameter);
MySqlParameter hikerZipParameter = new MySqlParameter();
hikerZipParameter.ParameterName = "@hikerZip";
hikerZipParameter.Value = newZip;
cmd.Parameters.Add(hikerZipParameter);
MySqlParameter hikerPhoneParameter = new MySqlParameter();
hikerPhoneParameter.ParameterName = "@hikerPhoneNumber";
hikerPhoneParameter.Value = newPhone;
cmd.Parameters.Add(hikerPhoneParameter);
MySqlParameter hikerEmailParameter = new MySqlParameter();
hikerEmailParameter.ParameterName = "@hikerEmail";
hikerEmailParameter.Value = newEmail;
cmd.Parameters.Add(hikerEmailParameter);
MySqlParameter hikerGenderParameter = new MySqlParameter();
hikerGenderParameter.ParameterName = "@hikerGender";
hikerGenderParameter.Value = newGender;
cmd.Parameters.Add(hikerGenderParameter);
MySqlParameter hikerCarParameter = new MySqlParameter();
hikerCarParameter.ParameterName = "@hikerCar";
hikerCarParameter.Value = newCar;
cmd.Parameters.Add(hikerCarParameter);
MySqlParameter hikerIdParameter = new MySqlParameter();
hikerIdParameter.ParameterName = "@hikerId";
hikerIdParameter.Value = this._id;
cmd.Parameters.Add(hikerIdParameter);
cmd.ExecuteNonQuery();
_hikerName = newHikerName;
_firstName = newFirstName;
_lastName = newLastName;
_zip = newZip;
_phone = newPhone;
_email = newEmail;
_gender = newGender;
_car = newCar;
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
