public bool CreateMembership(SetMembershipText st) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = @"insert into staff(staffID, staffName, phNum, postalCode, birth, jobClassifyID, staffPwd, priAddress, detAddress) values (@staffID, @staffName, @phNum, @postalCode, @birth, @jobClassifyID, @staffPwd, @priAddress, @detAddress);"; cmd.Connection = conn; cmd.Parameters.Add("@staffID", MySqlDbType.VarChar); cmd.Parameters["@staffID"].Value = st.staffID; cmd.Parameters.Add("@staffName", MySqlDbType.VarChar); cmd.Parameters["@staffName"].Value = st.staffName; cmd.Parameters.Add("@phNum", MySqlDbType.VarChar); cmd.Parameters["@phNum"].Value = st.staffNum; cmd.Parameters.Add("@postalCode", MySqlDbType.VarChar); cmd.Parameters["@postalCode"].Value = st.addrCode; cmd.Parameters.Add("@birth", MySqlDbType.Date); cmd.Parameters["@birth"].Value = st.staffBirth; cmd.Parameters.Add("@jobClassifyID", MySqlDbType.VarChar); cmd.Parameters["@jobClassifyID"].Value = st.jobClassify; cmd.Parameters.Add("@staffPwd", MySqlDbType.VarChar); cmd.Parameters["@staffPwd"].Value = st.staffPwd; cmd.Parameters.Add("@priAddress", MySqlDbType.VarChar); cmd.Parameters["@priAddress"].Value = st.priAddr; cmd.Parameters.Add("@detAddress", MySqlDbType.VarChar); cmd.Parameters["@detAddress"].Value = st.detAddr; int rows = cmd.ExecuteNonQuery(); if (rows > 0) { return(true); } else { return(false); } } catch (Exception err) { throw err; } }
private void button1_Click(object sender, EventArgs e) { try { MembershipDB db = new MembershipDB(); SetMembershipText st = new SetMembershipText(txtID.Text, txtPwd.Text, txtName.Text, txtNum.Text, dtpBirth.Value, cboJob.Text, txtPostalCode.Text, txtPriAddr.Text, txtDetAddr.Text); bool bFlag = db.CreateMembership(st); if (bFlag) { MessageBox.Show("가입이 완료되었습니다."); } else { MessageBox.Show("형식을 잘못 입력하였거나 빈 항목이 있습니다."); } } catch (Exception err) { MessageBox.Show(err.Message); } }