public void editAddButton_Click(object sender, EventArgs e) { try { if (editNameTextbox.Text != "" && editNumTextbox.Text != "") { mainForm.insert_updateTool("update add_user set name ='" + editNameTextbox.Text + "',phone_num ='" + editNumTextbox.Text + "',job ='" + editJobTextbox.Text + "',email='" + editEmailTextbox.Text + "',memo='" + editMemoTextbox.Text + "'where name ='" + mainForm.name + "'"); mainForm.dataLoad(); MessageBox.Show("수정 완료!"); } else if (editNameTextbox.Text == "") { MessageBox.Show("이름을 입력해주세요!"); } else if (editNumTextbox.Text == "") { MessageBox.Show("전화번호를 입력해주세요!"); } } catch { MessageBox.Show("연락처 변경 실패 - 정보를 정확히 입력해주세요!"); } this.Close(); }
public void addAddButton_Click(object sender, EventArgs e) { int number = 0; /* DB에 연락처 저장 */ if (mainForm.count < 100) { string date = DateTime.Now.ToString("yyyyMMdd"); string addNumText = addNumberTextbox.Text; //int callnum = 0; try { if (addNameTextbox.Text == "") { MessageBox.Show("이름을 입력해주세요!"); } else if (int.TryParse(addNumberTextbox.Text, out number) == true) { conn.Open(); if (addNumText.Substring(0, 1) == "0") { String sql = "INSERT INTO add_user(name,phone_num,job,email,memo)" + "VALUES ('" + addNameTextbox.Text + "','" + "0" + number.ToString() + "','" + addJobTextbox.Text + "','" + addEmailTextbox.Text + "','" + addMemoTextbox.Text + "')"; MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); } else { String sql = "INSERT INTO add_user(name,phone_num,job,email,memo)" + "VALUES ('" + addNameTextbox.Text + "','" + number.ToString() + "','" + addJobTextbox.Text + "','" + addEmailTextbox.Text + "','" + addMemoTextbox.Text + "')"; MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); } conn.Close(); mainForm.dataLoad(); mainForm.phone_num(); } else { MessageBox.Show("전화번호는 숫자로 입력해주세요!"); } } catch { MessageBox.Show("같은 데이터가 존재하거나 문자를 잘못 입력하셨어요!"); } } else { MessageBox.Show("전화번호부가 가득 찼어요!"); } this.Close(); }