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(); } }