public CounselMemo(object v1) { if (v1 != null) { this.id = ((Counsel_table)v1).ID; mind = new MindController(); Crypt crypt = mind.GetCrypt(); InitializeComponent(); this.counsel_Table = mind.GetCounsel_Table(id); this.client = mind.GetMember(counsel_Table.ClientID); this.counselor = mind.GetMember(counsel_Table.MemberID); // 피내담자(고객) this.txt_clientID.Text = client.GetID().ToString(); this.txt_clientName.Text = client.GetName().ToString(); this.txt_clientPhone.Text = client.GetPhone().ToString(); // 상담자 this.txt_counselorID.Text = counselor.GetID().ToString(); this.txt_counselorName.Text = counselor.GetName().ToString(); this.txt_counselorPhone.Text = counselor.GetPhone().ToString(); // 내용 this.txt_clientSubject.Text = counsel_Table.Subject; this.txt_clientMemo.Text = counsel_Table.Memo; this.lbl_firstdate.Text = counsel_Table.Firstdate.ToString(); // 코멘트 this.txt_Comment.Text = crypt.Decrypt(counsel_Table.Comment.ToString()); this.lbl_comdate.Text = counsel_Table.Comdate.ToString(); } }
private void Btn_counselMemo_Click(object sender, EventArgs e) { Boolean state = true; Crypt crypt = mind.GetCrypt(); string passwd = crypt.Encrypt(txt_strPasswd.Text); Counsel_table counsel_Table = new Counsel_table(); counsel_Table.ID = int.Parse(dataGridView.Rows[dataGridView.CurrentCellAddress.Y].Cells[0].Value.ToString()); if (txt_strPasswd.Text.Length == 0 && state == true) { MessageBox.Show("상담자 비밀번호를 입력하세요\r(Enter the counselor password)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (mind.CheckPassword(passwd) == false && state == true) { MessageBox.Show("비밀번호가 일치하지 않습니다.\r(Mismatch password.)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } //MessageBox.Show(mind.CheckPassword(passwd).ToString()) // state가 true일 때 if (state == true) { counselMemoFrm = new CounselMemo((object)counsel_Table); counselMemoFrm.Owner = this; counselMemoFrm.ShowDialog(); } }
public Counsel_table GetCounsel_Table(int id) { Counsel_table counsel_Table = new Counsel_table(); MySqlConnection conn; string strconn = GetStrConn(); string query = "select * from counsel_table where id = @id"; // MySQL = 스타일1 conn = new MySqlConnection(strconn); conn.Open(); //본인의 DB이름 MySqlCommand cmd = new MySqlCommand { Connection = conn, CommandText = query }; cmd.Parameters.Add("@id", MySqlDbType.Int32); cmd.Parameters[0].Value = id; MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { counsel_Table.ID = int.Parse(rdr["id"].ToString()); counsel_Table.Subject = rdr["subject"].ToString(); counsel_Table.Memo = crypt.Decrypt(rdr["memo"].ToString()); // 암호 해독 counsel_Table.Firstdate = (DateTime)rdr["firstdate"]; counsel_Table.Comment = rdr["comment"].ToString(); try { counsel_Table.Comdate = (DateTime)rdr["comdate"]; } catch (Exception e) { e.Message.ToString(); } counsel_Table.ClientID = int.Parse(rdr["clientID"].ToString()); counsel_Table.MemberID = int.Parse(rdr["memberID"].ToString()); } conn.Close(); return(counsel_Table); }
private void Btn_counselSubmit_Click(object sender, EventArgs e) { Boolean state = true; Crypt crypt = mind.GetCrypt(); string passwd = crypt.Encrypt(txt_counselorPasswd.Text); Counsel_table counsel_Table = new Counsel_table(); counsel_Table.Subject = this.txt_clientSubject.Text; counsel_Table.Memo = crypt.Encrypt(this.txt_clientMemo.Text); counsel_Table.Firstdate = DateTime.Now; counsel_Table.ClientID = int.Parse(txt_clientID.Text); counsel_Table.MemberID = int.Parse(txt_counselorID.Text); //MessageBox.Show(passwd); //MessageBox.Show( mind.CheckPassword(passwd).ToString() ); if (txt_clientSubject.Text.Length == 0) { MessageBox.Show("제목을 입력하세요\r(Enter the subject)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (txt_clientMemo.Text.Length == 0 && state == true) { MessageBox.Show("내용을 입력하세요\r(Enter the memo)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (txt_counselorPasswd.Text.Length == 0 && state == true) { MessageBox.Show("상담자 비밀번호를 입력하세요\r(Enter the counselor password)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (mind.CheckPassword(passwd) == false && state == true) { MessageBox.Show("비밀번호가 일치하지 않습니다.\r(Mismatch password.)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } // 추가 Query if (state == true) { string query = "INSERT INTO counsel_table(subject, memo, " + "firstdate, comment, comdate, clientID, memberID) VALUES(" + "@subject, @memo, @firstdate, @comment, @comdate, @clientID, @memberID)"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Parameters.Add("@subject", MySqlDbType.VarChar, 50); cmd.Parameters.Add("@memo", MySqlDbType.Text); cmd.Parameters.Add("@firstdate", MySqlDbType.DateTime); cmd.Parameters.Add("@comment", MySqlDbType.Text); cmd.Parameters.Add("@comdate", MySqlDbType.DateTime); cmd.Parameters.Add("@clientID", MySqlDbType.Int32, 11); cmd.Parameters.Add("@memberID", MySqlDbType.Int32, 11); cmd.Parameters[0].Value = counsel_Table.Subject; cmd.Parameters[1].Value = counsel_Table.Memo; cmd.Parameters[2].Value = counsel_Table.Firstdate; cmd.Parameters[3].Value = null; cmd.Parameters[4].Value = null; cmd.Parameters[5].Value = counsel_Table.ClientID; cmd.Parameters[6].Value = counsel_Table.MemberID; mind.InsertUpdate(cmd); MessageBox.Show("성공적으로 등록되었습니다.\r(Successfully registered.)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); var myParent = (MainFrm)this.Owner; myParent.ParentMethod(); } }
private void Btn_counselUpdate_Click(object sender, EventArgs e) { Boolean state = true; Counsel_table usrTbl = new Counsel_table(); Crypt crypt = mind.GetCrypt(); string passwd = crypt.Encrypt(txt_counselorPasswd.Text); usrTbl.ID = id; usrTbl.Subject = txt_clientSubject.Text; usrTbl.Memo = crypt.Encrypt(txt_clientMemo.Text); usrTbl.Comment = txt_Comment.Text; usrTbl.Comdate = DateTime.Now; usrTbl.MemberID = int.Parse(txt_counselorID.Text); if (txt_clientSubject.Text.Length == 0) { MessageBox.Show("제목을 입력하세요\r(Enter the subject)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (txt_clientMemo.Text.Length == 0 && state == true) { MessageBox.Show("내용을 입력하세요\r(Enter the memo)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (txt_counselorPasswd.Text.Length == 0 && state == true) { MessageBox.Show("상담자 비밀번호를 입력하세요\r(Enter the counselor password)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } if (mind.CheckPassword(passwd) == false && state == true) { MessageBox.Show("비밀번호가 일치하지 않습니다.\r(Mismatch password.)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); state = false; } // 추가 Query if (state == true) { string query = "UPDATE counsel_table set subject = @subject, " + "memo = @memo, comment = @comment, comdate = @comdate where id = @id"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Parameters.Add("@subject", MySqlDbType.VarChar, 50); cmd.Parameters.Add("@memo", MySqlDbType.Text); cmd.Parameters.Add("@comment", MySqlDbType.Text); cmd.Parameters.Add("@comdate", MySqlDbType.DateTime); cmd.Parameters.Add("@id", MySqlDbType.Int32, 11); cmd.Parameters[0].Value = usrTbl.Subject; cmd.Parameters[1].Value = usrTbl.Memo; cmd.Parameters[2].Value = crypt.Encrypt(usrTbl.Comment); cmd.Parameters[3].Value = DateTime.Now; cmd.Parameters[4].Value = counsel_Table.ID; mind.InsertUpdate(cmd); MessageBox.Show("성공적으로 수정되었습니다.\r(Successfully updated.)", "알림(Alert)", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); var myParent = (DetailShowFrm)this.Owner; myParent.ParentMethod(); } }