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