// 후기 중복체크 false면 중복아님(진행), true면 이미작성해서 작성불가
private bool check_double_write_review()
{
ConnDB();
cmd.CommandText = "select rev_place,rev_field,w_num from review where rev_id=@rev_id and rev_comname=@comName and rev_field=@rev_field " +
"intersect select a_com_place,a_com_field,w_num from a_list where a_id=@a_id and a_com_name =@a_comName and a_com_field=@com_field";
cmd.Parameters.AddWithValue("@rev_id", IMemberMainForm.getID());
cmd.Parameters.AddWithValue("@a_id", IMemberMainForm.getID());
cmd.Parameters.AddWithValue("@comName", com_names);
cmd.Parameters.AddWithValue("@a_comName", com_names);
cmd.Parameters.AddWithValue("@rev_field", com_field);
cmd.Parameters.AddWithValue("@com_field", com_field);
DataSet ds = new DataSet();
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
double_check_input = DR["w_num"].ToString();
}
}
Console.WriteLine("double_check_input = " + double_check_input);
DR.Close();
conn.Close();
if (double_check_input != null)
{
double_check = true;
}
else
{
double_check = false;
}
return(double_check);
}
public Write_Review(string a_num)
{
InitializeComponent();
txtb_rev_ID.Text = IMemberMainForm.getID();
this.a_num = a_num;
get_info();
}
// 이름, 주소, 이메일, 핸드폰번호 수정
private void btn_update_Click(object sender, EventArgs e)
{
if (check_customer_textbox())
{
SqlConnection sqlcon = new SqlConnection(DBConnection.strconn);
try
{
sqlcon.Open();
SqlCommand cmd = new SqlCommand("update CUSTOMER set NAME=@name, ADDR=@addr, EMAIL=@email, PHONE=@phone where ID=@id", sqlcon);
cmd.Parameters.AddWithValue("@name", text_name.Text);
cmd.Parameters.AddWithValue("@addr", text_addr.Text);
cmd.Parameters.AddWithValue("@email", text_email.Text);
cmd.Parameters.AddWithValue("@phone", text_phone.Text);
cmd.Parameters.AddWithValue("@id", IMemberMainForm.getID());
cmd.ExecuteNonQuery();
MessageBox.Show("수정이 완료되었습니다!");
sendMsg("OK");
Log.printLog("개인회원 정보 수정 완료");
}
catch (Exception)
{
Log.printLog("개인회원 정보 수정 에러");
MessageBox.Show("에러");
}
finally
{
sqlcon.Close();
this.Close();
}
}
}
//중복지원인지 확인
private void checkOverlap()
{
SqlConnection sqlcon = new SqlConnection(strconn);
try
{
sqlcon.Open();
string cmdText = "select * from A_LIST where W_NUM = @w_num";
SqlCommand cmd = new SqlCommand(cmdText, sqlcon);
cmd.CommandText = cmdText;
cmd.Parameters.AddWithValue("@w_num", PostInfo.getWnum());
DataSet ds = new DataSet();
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(ds);
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
if (DR["A_ID"].ToString() == IMemberMainForm.getID())
{
checkOver = true;
this.Close();
}
}
}
DR.Close();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
MessageBox.Show(ee.StackTrace);
}
}
private void ChangeInMyInfo_Load(object sender, EventArgs e)
{
FormBorderStyle = FormBorderStyle.None;
text_phone.Text = IMemberMainForm.getPhone();
text_name.Text = IMemberMainForm.getName();
text_addr.Text = IMemberMainForm.getAddr();
text_email.Text = IMemberMainForm.getEmail();
}
private void View_Review_Load(object sender, EventArgs e)
{
// 로그인아이디와 글작성아이디가 같으면 삭제버튼이 생긴다
if (dr["rev_id"].Equals(IMemberMainForm.getID()))
{
btn_delete_review.Visible = true;
}
Console.WriteLine("로그인한아이디 = " + IMemberMainForm.getID());
Console.WriteLine("글 작성 아이디 = " + dr["rev_id"]);
label_rev_subject.Text = dr["rev_subject"].ToString();
label_rev_content.Text = dr["content"].ToString();
label_rev_num.Text = dr["rev_num"].ToString();
r_num = label_rev_num.Text;
label_rev_field.Text = dr["rev_field"].ToString();
label_rev_comName.Text = dr["rev_comName"].ToString();
switch (dr["rev_STAR_PT"].ToString())
{
case "1":
label_rev_rate_pic.Size = new Size(25, 20);
break;
case "2":
label_rev_rate_pic.Size = new Size(49, 20);
break;
case "3":
label_rev_rate_pic.Size = new Size(74, 20);
break;
case "4":
label_rev_rate_pic.Size = new Size(98, 20);
break;
case "5":
label_rev_rate_pic.Size = new Size(123, 20);
break;
default:
break;
}
label_rev_place.Text = dr["rev_place"].ToString();
DateTime w_date = (DateTime)dr["r_date"];
label_rev_date.Text = w_date.ToString("yyyy/MM/dd");
}
//지원하기
private void button1_Click(object sender, EventArgs e)
{
readRESUMEInfo();
if (IMemberMainForm.getID() == "admin")
{
MessageBox.Show("관리자 모드입니다");
}
//이력서 없으면 지원불가
else if (checkResume == false)
{
MessageBox.Show("이력서 작성후 지원 가능합니다");
}
else
{
checkApply ca = new checkApply();
ca.Show();
}
this.Close();
}
// 콤보박스2 값 선택시 변화
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
label_com_field.Text = comboBox2.SelectedItem.ToString();
try
{
ConnDB();
cmd.CommandText = "select a_num,a_com_name,w_num,a_com_field from a_list where (a_id = @id AND a_com_name = @com_name) AND a_com_field = @com_field";
cmd.Parameters.AddWithValue("@id", IMemberMainForm.getID());
cmd.Parameters.AddWithValue("@com_name", label_comname.Text);
cmd.Parameters.AddWithValue("@com_field", label_com_field.Text);
//Console.WriteLine("cmd 할때 id,comname,comfield = " + IMemberMainForm.getID() + label_comname.Text + com_field);
DataSet ds = new DataSet();
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
a_num = DR["a_num"].ToString();
com_names = DR["a_com_name"].ToString();
w_num = DR["w_num"].ToString();
com_field = DR["a_com_field"].ToString();
}
}
DR.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.Source);
Console.WriteLine(ex.StackTrace);
}
finally
{
conn.Close();
}
//Console.WriteLine("마지막 com_name = " + label_comname.Text);
//Console.WriteLine("마지막 a_num = " + a_num);
//Console.WriteLine("마지막 com_field = " + com_field);
//Console.WriteLine("마지막 w_num = " + w_num);
//Console.WriteLine("------------------------");
}
// 콤보박스1 값 선택시 변화
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
label_comname.Text = comboBox1.SelectedItem.ToString();
ConnDB();
cmd.CommandText = "SELECT w_num,a_com_name,a_com_field FROM a_list WHERE (a_id = @id AND a_com_name = @a_com_name)";
cmd.Parameters.AddWithValue("@id", IMemberMainForm.getID());
cmd.Parameters.AddWithValue("@a_com_name", label_comname.Text);
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
com_field = DR["a_com_field"].ToString();
comboBox2.Items.Add(com_field);
}
}
DR.Close();
conn.Close();
}
// 콤보박스 리스트에만 보여주는것
private void ConnectDB()
{
ConnDB();
cmd.CommandText = "SELECT w_num,a_com_name,a_com_field FROM a_list WHERE a_id = @id";
cmd.Parameters.AddWithValue("@id", IMemberMainForm.getID());
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
com_names = DR["a_com_name"].ToString();
if (!comboBox1.Items.Contains(com_names)) // 콤보박스 추가시, 동일한 이름이 들어가있지 않다면
{
comboBox1.Items.Add(com_names); // 추가하기!
}
}
}
DR.Close();
conn.Close();
}
//이력서 있는지 확인
public void readRESUMEInfo()
{
SqlConnection sqlcon = new SqlConnection(strconn);
try
{
sqlcon.Open();
SqlCommand cmd = new SqlCommand("select * from RESUME where id = @id", sqlcon);
cmd.Parameters.AddWithValue("@id", IMemberMainForm.getID());
DataSet ds = new DataSet();
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(ds);
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
if (DR["ID"].ToString() == IMemberMainForm.getID())
{
checkResume = true;
}
}
}
DR.Close();
}
catch (Exception)
{
Console.WriteLine("error");
}
finally
{
if (sqlcon != null)
{
sqlcon.Close();
}
}
}
private void delete_review()
{
// 의미없는 if지만 혹시모를 변수를 위해 삭제안함
if (dr["rev_id"].Equals(IMemberMainForm.getID()))
{
conn.ConnectionString = DBConnection.strconn;
conn = new SqlConnection(conn.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete from review where rev_num = @r_num";
cmd.Parameters.AddWithValue("@r_num", r_num);
cmd.ExecuteNonQuery();
conn.Close();
Log.printLog("후기 삭제 완료");
Close();
MessageBox.Show("삭제 완료");
}
else
{
MessageBox.Show("자신이 작성한 글만 삭제할 수 있습니다.");
}
}
private void login()
{
SqlConnection conn = new SqlConnection(strconn);
SqlCommand cmd;
SqlDataAdapter sda;
DataSet ds = new DataSet();
try
{
conn.Open();
// 고객 회원으로 로그인
if (rbtn_customer.Checked == true)
{
table_name = "CUSTOMER";
cmd = new SqlCommand($"select ID from {table_name} where ID = @ID and PW = @PW", conn);
cmd.Parameters.AddWithValue("@ID", text_id.Text);
cmd.Parameters.AddWithValue("@PW", text_pw.Text);
sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
// db에 정보가 있을 경우
if (ds.Tables[0].Rows.Count == 1)
{
//MessageBox.Show("개인 회원으로 로그인 되었습니다.");
IMemberMainForm imain = new IMemberMainForm();
readUserInfo(table_name, text_id.Text);
//IMemberMainForm.setID(text_id.Text);
IMemberMainForm.setFormOpen(true);
conn.Close();
Log.printLog(text_id.Text + " 개인회원 로그인 성공");
imain.Show();
this.Close();
}
// db에 정보가 없을 경우
else
{
MessageBox.Show("등록된 회원 정보가 없습니다.");
//conn.Close();
}
}
// 기업 회원으로 로그인
else
{
table_name = "COM_CUSTOMER";
cmd = new SqlCommand($"select ID from {table_name} where ID = @ID and PW = @PW", conn);
cmd.Parameters.AddWithValue("@ID", text_id.Text);
cmd.Parameters.AddWithValue("@PW", text_pw.Text);
sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
// db에 정보가 있을 경우
if (ds.Tables[0].Rows.Count == 1)
{
//MessageBox.Show("기업 회원으로 로그인 되었습니다.");
ds.Reset();
MainForm main = new MainForm();
readUserInfo(table_name, text_id.Text);
//MainForm.setID(text_id.Text);
MainForm.setFormOpen(true);
conn.Close();
Log.printLog(text_id.Text + " 기업회원 로그인 성공");
main.Show();
this.Close();
}
// db에 정보가 없을 경우
else
{
MessageBox.Show("등록된 회원 정보가 없습니다.");
//conn.Close();
}
}
}
catch (Exception)
{
MessageBox.Show("에러");
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void insertData()
{
SqlConnection sqlconn = new SqlConnection(strconn);
try
{
sqlconn.Open();
string cmdText = "Insert into A_LIST (A_NUM, W_NUM, A_ID, A_NAME, A_PHONE, A_ADDR, A_COM_NAME," +
"A_COM_FIELD, A_COM_PAY, A_COM_PLACE) VALUES(NEXT VALUE FOR A_NUMBER, @w_num, @a_id, @a_name, @a_phone, @a_addr, @a_com_name, @a_com_field, @a_com_pay, @a_com_place)";
SqlCommand cmd = new SqlCommand(cmdText, sqlconn);
cmd.Parameters.AddWithValue("@w_num", PostInfo.getWnum());
cmd.Parameters.AddWithValue("@a_id", IMemberMainForm.getID());
cmd.Parameters.AddWithValue("@a_name", IMemberMainForm.getName());
cmd.Parameters.AddWithValue("@a_phone", IMemberMainForm.getPhone());
cmd.Parameters.AddWithValue("@a_addr", IMemberMainForm.getAddr());
cmd.Parameters.AddWithValue("@a_com_name", PostInfo.getCname());
cmd.Parameters.AddWithValue("@a_com_field", PostInfo.getCfield());
cmd.Parameters.AddWithValue("@a_com_pay", PostInfo.getCpay());
cmd.Parameters.AddWithValue("@a_com_place", PostInfo.getCplace());
checkOverlap();
if (checkOver == true)
{
MessageBox.Show("중복 지원할 수 없습니다");
this.Close();
}
else
{
cmd.ExecuteNonQuery();
//해당 공고의 지원자 수 증가
cmd.CommandText = "Update RECRUIT set A_COUNT = (select A_COUNT from RECRUIT where W_NUM = @w_num1)+1 where W_NUM = @w_num2";
cmd.Parameters.AddWithValue("@w_num1", PostInfo.getWnum());
cmd.Parameters.AddWithValue("@w_num2", PostInfo.getWnum());
cmd.ExecuteNonQuery();
//회사 정보 폼의 회사 지원수 증가
cmd.CommandText = "select * from COM_INFO where COM_NAME = @com_name";
cmd.Parameters.AddWithValue("@com_name", PostInfo.getCname());
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adpt.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int a_count = int.Parse(dr["AP_COUNT"].ToString());
cmd.CommandText = $"update COM_INFO set AP_COUNT = AP_COUNT+1 where COM_NAME = '{PostInfo.getCname()}'";
//cmd.Parameters.AddWithValue("@a_count", a_count+1);
Console.WriteLine($"{PostInfo.getCname()} = 회사이름 확인");
Console.WriteLine($"{a_count+1} = 지원자수 증가확인");
cmd.ExecuteNonQuery();
}
MessageBox.Show("지원이 완료되었습니다!");
Log.printLog($"{PostInfo.getWnum()}번글 지원 완료");
}
}
catch (Exception ee)
{
Log.printLog("지원 실패");
MessageBox.Show(ee.StackTrace);
MessageBox.Show(ee.Message);
}
finally
{
sqlconn.Close();
this.Close();
}
}
private void Apply_Cancle_Click(object sender, EventArgs e)
{
//지원내역 없으면 취소불가
readApplyInfo();
if (checkAinfo == false)
{
MessageBox.Show("지원내역이 없습니다");
}
else
{
//해당공고에 지원내역 있으면 삭제
try
{
SqlConnection sqlcon = new SqlConnection(strconn);
sqlcon.Open();
SqlCommand cmd = new SqlCommand($"delete from A_LIST where W_NUM = @w_num and A_ID = '{IMemberMainForm.getID()}'", sqlcon);
cmd.Parameters.AddWithValue("@w_num", PostInfo.getWnum());
cmd.ExecuteNonQuery();
Console.WriteLine("A_LIST delete ok"); //테스트
//해당 공고의 지원자 수 감소
cmd.CommandText = "Update RECRUIT set A_COUNT = (select A_COUNT from RECRUIT where W_NUM = @w_num1)-1 where W_NUM = @w_num2";
cmd.Parameters.AddWithValue("@w_num1", PostInfo.getWnum());
cmd.Parameters.AddWithValue("@w_num2", PostInfo.getWnum());
cmd.ExecuteNonQuery();
//회사 정보 폼의 회사 지원수 감소
cmd.CommandText = "select * from COM_INFO where COM_NAME = @com_name";
cmd.Parameters.AddWithValue("@com_name", PostInfo.getCname());
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adpt.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int a_count = int.Parse(dr["AP_COUNT"].ToString());
cmd.CommandText = $"update COM_INFO set AP_COUNT = AP_COUNT-1 where COM_NAME = '{PostInfo.getCname()}'";
//cmd.Parameters.AddWithValue("@a_count", a_count+1);
Console.WriteLine($"{PostInfo.getCname()} = 회사이름 확인");
Console.WriteLine($"{a_count -1} = 지원자수 감소확인");
cmd.ExecuteNonQuery();
}
MessageBox.Show("지원취소 되었습니다");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
finally
{
this.Close();
}
}
}
