public void musaitRandevuKayit(int isyeriID, ArrayList dize) { int sifir, bir, iki, uc, dort, bes, alti, yedi, gunID, k = 0, veriVarMi; SqlCommand kontrol = new SqlCommand(); kontrol.CommandText = "SELECT COUNT(*) FROM musaitRandevuZamanlari WHERE isyeriID= @isyeriID"; kontrol.Parameters.AddWithValue("isyeriID", isyeriID); SqlConnection conn = veritabaniBaglantisiKur(kontrol); veriVarMi = (int)kontrol.ExecuteScalar(); if (veriVarMi > 0) { MusaitRandevuGuncelle guncelle = new MusaitRandevuGuncelle(); conn.Close(); guncelle.musaitRandevuZamaniGuncelle(isyeriID, dize); return; } for (int i = 0; i < 40; i += 8) { gunID = k; k++; sifir = Convert.ToInt32(dize[i]); bir = Convert.ToInt32(dize[i + 1]); iki = Convert.ToInt32(dize[i + 2]); uc = Convert.ToInt32(dize[i + 3]); dort = Convert.ToInt32(dize[i + 4]); bes = Convert.ToInt32(dize[i + 5]); alti = Convert.ToInt32(dize[i + 6]); yedi = Convert.ToInt32(dize[i + 7]); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO musaitRandevuZamanlari (isyeriID, gun, zamanAralik0, zamanAralik1, zamanAralik2, zamanAralik3, zamanAralik4, zamanAralik5, zamanAralik6, zamanAralik7) VALUES (@isyeriID, @gunID, @sifir, @bir, @iki, @uc, @dort, @bes, @alti, @yedi)"; cmd.Parameters.AddWithValue("isyeriID", isyeriID); cmd.Parameters.AddWithValue("gunID", gunID); cmd.Parameters.AddWithValue("sifir", sifir); cmd.Parameters.AddWithValue("bir", bir); cmd.Parameters.AddWithValue("iki", iki); cmd.Parameters.AddWithValue("uc", uc); cmd.Parameters.AddWithValue("dort", dort); cmd.Parameters.AddWithValue("bes", bes); cmd.Parameters.AddWithValue("alti", alti); cmd.Parameters.AddWithValue("yedi", yedi); SqlConnection connect = veritabaniBaglantisiKur(cmd); cmd.ExecuteNonQuery(); connect.Close(); } k = 0; conn.Close(); }
private void musaitZamanlariGuncelleButton_Click(object sender, EventArgs e) { ArrayList dize = new ArrayList(); foreach (Control item in pazGrup.Controls) { if ((item is CheckBox) && ((CheckBox)item).Checked) { dize.Add(1); } else { dize.Add(0); } } foreach (Control item in salGrup.Controls) { if ((item is CheckBox) && ((CheckBox)item).Checked) { dize.Add(1); } else { dize.Add(0); } } foreach (Control item in carGrup.Controls) { if ((item is CheckBox) && ((CheckBox)item).Checked) { dize.Add(1); } else { dize.Add(0); } } foreach (Control item in perGrup.Controls) { if ((item is CheckBox) && ((CheckBox)item).Checked) { dize.Add(1); } else { dize.Add(0); } } foreach (Control item in cuGrup.Controls) { if ((item is CheckBox) && ((CheckBox)item).Checked) { dize.Add(1); } else { dize.Add(0); } } if (insertedOnce == false) { MusaitRandevuZamani musaitRandevu = new MusaitRandevuZamani(); musaitRandevu.musaitRandevuKayit(isyeriIDGetir(), dize); } else { MusaitRandevuGuncelle guncelle = new MusaitRandevuGuncelle(); guncelle.musaitRandevuZamaniGuncelle(isyeriIDGetir(), dize); } dize.Clear(); insertedOnce = true; }