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;
}
