public void exceldenguncelle()
{
for (int l = 0; l < dataGridView1.Rows.Count - 1; l++)
{
using (var bdb = new BrowserContext(baglanti))
{
string ogrencino = dataGridView1.Rows[l].Cells[0].Value.ToString();
User ogrenci = bdb.UserSet.FirstOrDefault(o => o.OgrenciNo == ogrencino);
if (ogrenci == null)
{
var user = bdb.UserSet.Add(new User()
{
username = dataGridView1.Rows[l].Cells[3].Value.ToString(),
pass = dataGridView1.Rows[l].Cells[4].Value.ToString(),
AdSoyad = dataGridView1.Rows[l].Cells[1].Value.ToString(),
Sinif = dataGridView1.Rows[l].Cells[2].Value.ToString(),
OgrenciNo = dataGridView1.Rows[l].Cells[0].Value.ToString(),
SonGuncelleme = DateTime.Now,
Izin = Convert.ToInt32(dataGridView1.Rows[l].Cells[5].Value.ToString()),
Durum = 0
});
}
else
{
ogrenci.username = dataGridView1.Rows[l].Cells[3].Value.ToString();
ogrenci.pass = dataGridView1.Rows[l].Cells[4].Value.ToString();
ogrenci.AdSoyad = dataGridView1.Rows[l].Cells[1].Value.ToString();
ogrenci.OgrenciNo = dataGridView1.Rows[l].Cells[0].Value.ToString();
ogrenci.Sinif = dataGridView1.Rows[l].Cells[2].Value.ToString();
ogrenci.Izin = Convert.ToInt32(dataGridView1.Rows[l].Cells[5].Value.ToString());
}
bdb.SaveChanges();
}
}
string[] sutunAdi = { "username", "pass", "AdSoyad", "Sinif", "Durum", "Izin" };
for (int m = 0; m < sutunAdi.Length; m++)
{
if (sutunAdi[m] == "Durum" || sutunAdi[m] == "Izin")
{
using (var bdb = new BrowserContext(baglanti))
{
List <User> ogrenci = bdb.UserSet.ToList();
foreach (var ogr in ogrenci)
{
if (ogr.Durum == null)
{
ogr.Durum = 0; bdb.SaveChanges();
}
if (ogr.Izin == null)
{
ogr.Izin = 1; bdb.SaveChanges();
}
}
}
}
}
excelgoster();
MessageBox.Show("Tablo Doldurma İşlemi Tamamlanmıştır.", "Tablo Doldurma");
}
private void dataGridView4_DoubleClick(object sender, EventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (dgv != null && dgv.SelectedRows.Count > 0)
{
DataGridViewRow row = dgv.SelectedRows[0];
if (row != null)
{
string username = row.Cells[1].Value.ToString();
using (var bdb = new BrowserContext(baglanti))
{
User ogrenci = bdb.UserSet.FirstOrDefault(o => o.username == username);
if (ogrenci == null)
{
return;
}
if (ogrenci.Izin == 0)
{
ogrenci.Izin = 1;
}
else
{
ogrenci.Izin = 0;
}
bdb.SaveChanges();
var list = bdb.UserSet.Select(s => new { s.OgrenciNo, s.username, s.AdSoyad, s.Sinif, s.Izin }).ToList();
dataGridView4.DataSource = list;
}
}
}
}
private void button1_Click(object sender, EventArgs e) //KULLANICI EKLE
{
using (var bdb = new BrowserContext(baglanti))
{
User ogrenci = bdb.UserSet.FirstOrDefault(o => o.username == textBox4.Text);
if (ogrenci == null)
{
var user = bdb.UserSet.Add(new User()
{
username = textBox4.Text,
pass = textBox5.Text,
AdSoyad = textBox3.Text,
Sinif = textBox1.Text,
OgrenciNo = textBox2.Text,
SonGuncelleme = DateTime.Now,
Izin = Convert.ToInt32(radioButton1.Checked),
Durum = 0
});
}
else
{
ogrenci.username = textBox4.Text;
ogrenci.pass = textBox5.Text;
ogrenci.AdSoyad = textBox3.Text;
ogrenci.Sinif = textBox1.Text;
ogrenci.OgrenciNo = textBox2.Text;
ogrenci.Izin = Convert.ToInt32(radioButton1.Checked);
}
bdb.SaveChanges();
var list = bdb.UserSet.Select(s => new { s.OgrenciNo, s.username, s.AdSoyad, s.Sinif, s.Izin }).ToList();
dataGridView2.DataSource = list;
}
}
private void timer1_Tick(object sender, EventArgs e)
{
labelsaat.Text = DateTime.Now.ToString("HH:mm");
labeltarih.Text = DateTime.Now.ToString("dd-MM-yyyy");
using (var bdb = new BrowserContext(baglanti))
{
var users = bdb.UserSet.Where(u => u.Sinif.Contains(textBox9.Text)).ToList();
if (users == null)
{
return;
}
foreach (var user in users)
{
TimeSpan ts = DateTime.Now.Subtract(user.SonGuncelleme);
if (ts.TotalSeconds > 6)
{
user.Durum = 0;
}
else
{
Panel panel = null;
try { panel = UserPanels.FirstOrDefault(p => p.Name == user.username); } catch (Exception) { }
if (panel == null)
{
return;
}
foreach (var item in panel.Controls)
{
if (item is RichTextBox)
{
try { ((RichTextBox)item).Text = bdb.BrowserLogSet.OrderByDescending(o => o.Tarih).FirstOrDefault(l => l.UserId == user.UserId).Adres; } catch (Exception) { }
}
else if (item is PictureBox)
{
Image image1 = null;
using (FileStream stream = new FileStream(user.Durum + ".jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
((PictureBox)item).Image = image1;
if (user.Izin == 0)
{
using (FileStream stream = new FileStream("kirmizi.jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
((PictureBox)item).Image = image1;
}
}
}
}
bdb.SaveChanges();
}
}
}
private void buttonKullaniciSil_Click(object sender, EventArgs e)
{
if (dataGridView2.SelectedRows[0].Cells[0].Value != null)
{
string seciliogrencino = dataGridView2.SelectedRows[0].Cells[0].Value.ToString();
DialogResult res = MessageBox.Show(seciliogrencino + " numaralı öğrenci bilgileri silinecektir.Onaylıyor musunuz?", "Kullanıcı Silme", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
using (var bdb = new BrowserContext(baglanti))
{
var user = bdb.UserSet.FirstOrDefault(u => u.OgrenciNo == seciliogrencino);
if (user != null)
{
bdb.UserSet.Remove(user); bdb.SaveChanges();
}
}
}
else
{
MessageBox.Show("İşlem İptal Edildi.", "İşlem İptal");
}
kullaniciGetir();
}
else
{
string seciliusername = dataGridView2.SelectedRows[0].Cells[1].Value.ToString();
DialogResult res = MessageBox.Show(seciliusername + " kullanıcı adına sahip öğrenci bilgileri silinecektir.Onaylıyor musunuz?", "Kullanıcı Silme", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
using (var bdb = new BrowserContext(baglanti))
{
var user = bdb.UserSet.FirstOrDefault(u => u.username == seciliusername);
if (user != null)
{
bdb.UserSet.Remove(user); bdb.SaveChanges();
}
}
}
else
{
MessageBox.Show("İşlem İptal Edildi.", "İşlem İptal");
}
kullaniciGetir();
}
}
private void button8_Click(object sender, EventArgs e) //KULLANICI GÜNCELLE
{
using (var bdb = new BrowserContext(baglanti))
{
int id = Convert.ToInt32(labelid.Text);
var ogrenci = bdb.UserSet.FirstOrDefault(u => u.UserId == id);
if (ogrenci == null)
{
return;
}
ogrenci.username = textBox4.Text;
ogrenci.pass = textBox5.Text;
ogrenci.AdSoyad = textBox3.Text;
ogrenci.Sinif = textBox1.Text;
ogrenci.OgrenciNo = textBox2.Text;
ogrenci.Izin = Convert.ToInt32(radioButton1.Checked);
bdb.SaveChanges();
var list = bdb.UserSet.Select(s => new { s.OgrenciNo, s.username, s.AdSoyad, s.Sinif, s.Izin }).ToList();
dataGridView2.DataSource = list;
}
}
