//회원가입 완료 버튼을 눌렀을 때 private void buttonConfirmClicked(object sender, EventArgs e) { if (buttonDoubleCheck.Enabled == false) { string id = textBoxID.Text; string password = textBoxPasswd.Text; string name = textBoxName.Text; string email = textBoxEmail.Text; DateTime birth = dateTimePickerBirth.Value.Date; if (id != "" && password != "" && name != "" && email != "") { if (mode.Equals("고객")) { oracleCommand1.CommandText = "insert into consumer values(:id,:password,:name,:email,:birth,'F',0)"; oracleCommand1.Parameters["id"].Value = id; oracleCommand1.Parameters["password"].Value = password; oracleCommand1.Parameters["name"].Value = name; oracleCommand1.Parameters["email"].Value = email; oracleCommand1.Parameters["birth"].Value = birth; } oracleCommand1.ExecuteNonQuery(); MessageBox.Show("회원가입 성공!"); this.Visible = false; mainform.Activate(); } else { MessageBox.Show("모든 값을 제대로 넣어 주십시오"); } } else { MessageBox.Show("중복 확인을 해주세요"); } }
//확인버튼을 눌렀을 때 private void buttonConfirmClicked(object sender, EventArgs e) { string name = textBoxFindIdName.Text; DateTime date = dateTimePickerBirth.Value.Date; string birth = date.Year + "-" + date.Month + "-" + date.Day; if (name != "") { oracleCommand1.CommandText = "select consu_id from consumer where consu_name='" + name + "' AND consu_birth=TO_DATE('" + birth + "', 'YYYY-MM-DD')"; OracleDataReader rdr = oracleCommand1.ExecuteReader(); int flag = 0; while (rdr.Read()) { MessageBox.Show("아이디는 " + rdr["consu_id"] + "입니다"); flag++; this.Visible = false; mainform.Activate(); } if (flag == 0) { MessageBox.Show("해당하는 정보의 사용자가 없습니다."); } } else { MessageBox.Show("이름을 입력해 주세요"); } }
private void labelLogoutMouseUp(object sender, MouseEventArgs e) { MessageBox.Show("로그아웃 되었습니다"); this.Visible = false; FormMain frm = new FormMain(); frm.Owner = this; frm.Show(); frm.Activate(); }
private void MessageAlert(int a) { if (a == 1) { MessageBox.Show("비밀번호가 변경되었습니다"); mainform.Activate(); } else { MessageBox.Show("비밀번호 변경이 실패되었습니다"); } }
private void buttonConfirmClicked(object sender, EventArgs e) { if (buttonDoubleCheck.Enabled == false) { string id = textBoxID.Text; string password = textBoxPasswd.Text; string name = textBoxName.Text; string email = textBoxEmail.Text; if (id != "" && password != "" && name != "" && email != "") { switch (mode) { case "직원": oracleCommand1.CommandText = "insert into employee values(:id,:password,:name,:email)"; break; case "관리자": oracleCommand1.CommandText = "insert into administer values(:id,:password,:name,:email)"; break; } oracleCommand1.Parameters["id"].Value = id; oracleCommand1.Parameters["password"].Value = password; oracleCommand1.Parameters["name"].Value = name; oracleCommand1.Parameters["email"].Value = email; oracleCommand1.ExecuteNonQuery(); MessageBox.Show("회원가입 성공!"); this.Visible = false; mainform.Activate(); } else { MessageBox.Show("모든 값을 제대로 넣어 주십시오"); } } else { MessageBox.Show("중복 확인을 해주세요"); } }
private void buttonConfirmClick(object sender, EventArgs e) { string name = textBoxFindIdName.Text; string email = textBoxEmail.Text; if (name != "" && email != "") { switch (mode) { case "직원": oracleCommand1.CommandText = "select employ_id from employee where employ_name='" + name + "' AND employ_email='" + email + "'"; break; case "관리자": oracleCommand1.CommandText = "select admin_id from administer where admin_name='" + name + "' AND admin_email='" + email + "'"; break; } OracleDataReader rdr = oracleCommand1.ExecuteReader(); int flag = 0; while (rdr.Read()) { MessageBox.Show("아이디는 " + rdr[0] + "입니다"); flag++; this.Visible = false; mainform.Activate(); } if (flag == 0) { MessageBox.Show("해당하는 정보의 사용자가 없습니다."); } } else { MessageBox.Show("모든 값을 입력해 주세요"); } }