private void btn_Sorgula_Click(object sender, EventArgs e)
{
using (DurakIhlalTespitiEntities1 database = new DurakIhlalTespitiEntities1())
{
var bilgi = (from b in database.Arac_cezalı
where b.plaka == txtBoxPlakaSorgu.Text
select new
{
b.plaka,
b.gun,
b.ay,
b.yıl
});
if (bilgi == null)
{
MessageBox.Show("Plakaya ait Ceza bulunmamakta", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
dataGridViewSorgu.DataSource = bilgi.ToList();
dataGridViewSorgu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSorgu.Visible = true;
}
}
}
private void btnKameralistesi_Click(object sender, EventArgs e)
{
DurakIhlalTespitiEntities1 libraryentity = new DurakIhlalTespitiEntities1();
var kamera = from x in libraryentity.Kamera_bilgi
select new
{
x.Kamera_kodu,
x.Il,
x.Ilce,
x.Cadde,
x.Arıza_durum
};
dataGridViewkamera.DataSource = kamera.ToList();
dataGridViewkamera.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//lblCountofuser.Text = users.Count().ToString();
}
public void splitjson(string veri)
{
string[] arac = veri.Split('}');
string[] seri2;
string[] seri1;
for (int i = 0; i < arac.Length; i++)
{
try
{
seri1 = arac[i].Split('"');
arackey = seri1[1];
plaka = seri1[5];
ay = seri1[8];
gun = seri1[10];
seri2 = seri1[12].Split('}');
yıl = seri2[0];
using (DurakIhlalTespitiEntities1 entity = new DurakIhlalTespitiEntities1())
{
Arac_cezalı cz_arac = new Arac_cezalı();
cz_arac.ID = Convert.ToString(sayac);
cz_arac.plaka = this.Plaka;
cz_arac.gun = this.Gun;
cz_arac.ay = this.Ay;
cz_arac.yıl = this.Yıl;
entity.Arac_cezalı.Add(cz_arac);
entity.SaveChanges();
}
}
catch
{
}
sayac++;
}
}
private void dataGridViewSorgu_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (seciliislem == "Gunluk")
{
string deger = dataGridViewSorgu.CurrentRow.Cells["Gun"].Value.ToString();
using (DurakIhlalTespitiEntities1 en = new DurakIhlalTespitiEntities1())
{
var bilgiler = (from b in en.Arac_cezalı
where b.gun == deger
select new
{
b.plaka,
b.gun,
b.ay,
b.yıl
});
dataGridViewSecilPlaka.DataSource = bilgiler.ToList();
dataGridViewSecilPlaka.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSecilPlaka.Visible = true;
btnKapat.Visible = true;
PanelSeciliArac.Visible = true;
}
}
else if (seciliislem == "Aylık")
{
string deger = dataGridViewSorgu.CurrentRow.Cells["Ay"].Value.ToString();
using (DurakIhlalTespitiEntities1 en = new DurakIhlalTespitiEntities1())
{
var bilgiler = (from b in en.Arac_cezalı
where b.ay == deger
select new
{
b.plaka,
b.gun,
b.ay,
b.yıl
});
dataGridViewSecilPlaka.DataSource = bilgiler.ToList();
dataGridViewSecilPlaka.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSecilPlaka.Visible = true;
btnKapat.Visible = true;
PanelSeciliArac.Visible = true;
}
}
else if (seciliislem == "Yıllık")
{
string deger = dataGridViewSorgu.CurrentRow.Cells["Yıl"].Value.ToString();
using (DurakIhlalTespitiEntities1 en = new DurakIhlalTespitiEntities1())
{
var bilgiler = (from b in en.Arac_cezalı
where b.yıl == deger
select new
{
b.plaka,
b.gun,
b.ay,
b.yıl
});
dataGridViewSecilPlaka.DataSource = bilgiler.ToList();
dataGridViewSecilPlaka.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSecilPlaka.Visible = true;
btnKapat.Visible = true;
PanelSeciliArac.Visible = true;
}
}
else
{
string deger = dataGridViewSorgu.CurrentRow.Cells["Plaka"].Value.ToString();
using (DurakIhlalTespitiEntities1 en = new DurakIhlalTespitiEntities1())
{
var bilgiler = (from b in en.Arac_cezalı
where b.plaka == deger
select new
{
b.plaka,
b.gun,
b.ay,
b.yıl
});
dataGridViewSecilPlaka.DataSource = bilgiler.ToList();
dataGridViewSecilPlaka.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSecilPlaka.Visible = true;
btnKapat.Visible = true;
PanelSeciliArac.Visible = true;
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DurakIhlalTespitiEntities1 entityihlal = new DurakIhlalTespitiEntities1();
if (radioButton_Gunluk.Checked == true)
{
seciliislem = "Gunluk";
var ihlal = from p in entityihlal.Arac_cezalı
group p by p.gun into g
select new
{
Gun = g.Key,
İhlal_Sayısı = g.Count()
};
dataGridViewSorgu.DataSource = ihlal.ToList();
dataGridViewSorgu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSorgu.Visible = true;
radioButton_Gunluk.Checked = false;
}
else if (radioButton_Aylik.Checked == true)
{
seciliislem = "Aylık";
var ihlal = from p in entityihlal.Arac_cezalı
group p by p.ay into g
select new
{
Ay = g.Key,
İhlal_Sayısı = g.Count()
};
dataGridViewSorgu.DataSource = ihlal.ToList();
dataGridViewSorgu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSorgu.Visible = true;
radioButton_Aylik.Checked = false;
}
else if (radioButton_Yillik.Checked == true)
{
seciliislem = "Yıllık";
var ihlal = from p in entityihlal.Arac_cezalı
group p by p.yıl into g
select new
{
Yıl = g.Key,
İhlal_Sayısı = g.Count()
};
dataGridViewSorgu.DataSource = ihlal.ToList();
dataGridViewSorgu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSorgu.Visible = true;
radioButton_Yillik.Checked = false;
}
else
{
var ihlal = from tablo in entityihlal.Arac_cezalı
select new
{
tablo.plaka,
tablo.gun,
tablo.ay,
tablo.yıl
};
dataGridViewSorgu.DataSource = ihlal.ToList();
dataGridViewSorgu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewSorgu.Visible = true;
}
}