public PersonelEkle() { InitializeComponent(); baglanti = new SqlConnection("Data Source=SQL7004.site4now.net;Initial Catalog=DB_A43BB8_vtysproje;User Id=DB_A43BB8_vtysproje_admin;Password=vtysproje18;"); DAO_Personel.cagirCheckListBox(checkedListBox1, "Expertise"); DAO_Personel.cagirComboBox(comboBoxUzmanlik, "Education_level"); DAO_Personel.cagirComboBox(comboBoxGorev, "Duty"); DAO_Personel.cagirComboBox(comboBoxBolum, "Company"); }
private void buttonEkle_Click(object sender, EventArgs e) { DAO_Personel.passwordEkle(textBoxTCno, textBoxPwd, comboBoxYetki); int com = DAO_Personel.IdEkle(comboBoxBolum, "Company", "C_name"); int edu = DAO_Personel.IdEkle(comboBoxUzmanlik, "Education_level", "Edu_level_name"); int duty = DAO_Personel.IdEkle(comboBoxGorev, "Duty", "Duty_name"); var o_tc = DAO_Personel.IdPass("PersonelLogin", "O_TC", textBoxTCno); baglanti.Open(); SqlCommand komut = new SqlCommand ("insert into Personel (P_name,P_surname,Edu_id,P_date_start,Duty_id,C_id,Salary,O_TC) " + "values('" + textBoxPad.Text + "','" + textBoxPsoyad.Text + "','" + edu + "','" + dateTimePickerBaslama.Value.ToString("yyyy-MM-dd") + "','" + duty + "','" + com + "'," + textBoxSalary.Text + ",'" + o_tc + "')", baglanti); komut.ExecuteNonQuery(); baglanti.Close(); string soyad = textBoxPsoyad.Text; string ad = textBoxPad.Text; var temp = DAO_Personel.IdEkleChecklist("Personel", ad, soyad);/*personel id*/ baglanti.Open(); if (!(String.IsNullOrEmpty(textBoxUzmanadi.Text.Trim()))) { var s2 = $"insert into Expertise (Expertise_field, P_TC) values ('{textBoxUzmanadi.Text.Trim()}',{temp});"; SqlCommand ins = new SqlCommand(s2, baglanti); ins.ExecuteNonQuery(); } baglanti.Close(); for (int i = 0; i < checkedListBox1.Items.Count; i++) { if (checkedListBox1.GetItemChecked(i)) { string str = (string)checkedListBox1.Items[i]; /*uzmanlık id */ string str1 = $"insert into Expertise (P_TC,Expertise_field)" + $"values({temp},'{str}');"; baglanti.Open(); SqlCommand cmd = new SqlCommand(str1, baglanti); cmd.ExecuteNonQuery(); baglanti.Close(); } } MessageBox.Show("Personel Eklendi!"); }