private void buttonEkle_Click(object sender, EventArgs e) { baglanti.Open(); SqlCommand komut = new SqlCommand("insert into Project (P_Name,Date_Start,Date_Finish) values('" + textBoxProjeAdi.Text + "','" + dateTimePickerKursBaslangic.Value.ToString("yyyy-MM-dd") + "','" + dateTimePickerKursBitis.Value.ToString("yyyy-MM-dd") + "')", baglanti); komut.ExecuteNonQuery(); baglanti.Close(); var temp = DAO_Proje.IdEkleProje("Project", textBoxProjeAdi.Text); /*personel id*/ int cordi = DAO_Proje.cagirComboBoxID(comboBoxPrjSrm, "Personel"); /*cordinator id*/ for (int i = 0; i < checkedListBoxPersoneller.Items.Count; i++) { if (checkedListBoxPersoneller.GetItemChecked(i)) { string str = (string)checkedListBoxPersoneller.Items[i]; int tc = DAO_Proje.IdEkleChecklist("Personel", str); string str1 = $"insert into PersonelProject (P_TC,Cordinator,Project_ID)" + $"values({tc},{cordi},{temp});"; baglanti.Open(); SqlCommand cmd = new SqlCommand(str1, baglanti); cmd.ExecuteNonQuery(); baglanti.Close(); } } MessageBox.Show("Proje Eklendi!"); }
public ProjeEkle() { InitializeComponent(); baglanti = new SqlConnection("Data Source=SQL7004.site4now.net;Initial Catalog=DB_A43BB8_vtysproje;User Id=DB_A43BB8_vtysproje_admin;Password=vtysproje18;"); DAO_Proje.cagirComboBox(comboBoxPrjSrm, "Personel"); DAO_Proje.cagirCheckListBox(checkedListBoxPersoneller, "Personel"); }