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();
}
}
public void detaygoster(object sender, EventArgs e)
{
int userid = Convert.ToInt32(((PictureBox)sender).Tag.ToString());
using (var bdb = new BrowserContext(baglanti))
{
var user = bdb.UserSet.FirstOrDefault(u => u.UserId == userid);
if (user == null)
{
return;
}
textBoxadsoyad.Text = user.AdSoyad;
textBoxkullaniciadi.Text = user.username;
textBoxogrencino.Text = user.OgrenciNo;
textBoxsinifi.Text = user.Sinif;
var list = bdb.BrowserLogSet.Where(b => b.UserId == user.UserId).OrderByDescending(o => o.Tarih).Select(s => new { s.Adres, s.Tarih }).ToList();
dataGridView1.DataSource = list;
}
}
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;
}
}
public void AnasayfaOlustur()
{
timer1.Stop();
while (flowLayoutPanel1.Controls.Count > 0)
{
foreach (Control control in flowLayoutPanel1.Controls)
{
flowLayoutPanel1.Controls.Remove(control);
control.Dispose();
}
}
using (var bdb = new BrowserContext(baglanti))
{
if (textBox10.Text == "")
{
var users = bdb.UserSet.Where(u => u.Sinif.Contains(textBox9.Text)).ToList();
UserPanels = new List <Panel>();
foreach (var user in users)
{
if (user.Durum == 1 || textBox9.Text != "" || textBox10.Text != "")
{
Panel puser = new Panel();
puser.Size = new Size(flowLayoutPanel1.Size.Width, 100);
puser.BackColor = Color.Transparent;
puser.Name = user.username;
PictureBox pc = new PictureBox();
pc.Size = new Size(120, 100);
pc.Location = new Point(0, 0);
pc.Tag = user.username;
pc.MouseDown += detaygoster;
pc.Tag = user.UserId;
pc.SizeMode = PictureBoxSizeMode.StretchImage;
Image image1 = null;
using (FileStream stream = new FileStream(user.Durum + ".jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
pc.Image = image1;
if (user.Izin == 0)
{
using (FileStream stream = new FileStream("kirmizi.jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
pc.Image = image1;
}
TextBox adtxt = new TextBox();
adtxt.ReadOnly = true;
adtxt.Location = new Point(130, 0);
try { adtxt.Text = user.AdSoyad; } catch (Exception) { }
adtxt.Tag = user.username;
adtxt.Font = new Font("Arial", 8.0f);
adtxt.Size = new Size(puser.Size.Width - 180, 20);
RichTextBox urltxt = new RichTextBox();
urltxt.ReadOnly = true;
urltxt.Location = new Point(130, 22);
try { urltxt.Text = bdb.BrowserLogSet.OrderByDescending(o => o.Tarih).FirstOrDefault(l => l.UserId == user.UserId).Adres; } catch (Exception) { }
urltxt.Tag = user.username;
urltxt.Font = new Font("Arial", 8.0f);
urltxt.Size = new Size(puser.Size.Width - 180, 78);
UserPanels.Add(puser);
puser.Controls.Add(pc);
puser.Controls.Add(adtxt);
puser.Controls.Add(urltxt);
flowLayoutPanel1.Controls.Add(puser);
}
}
}
else
{
var users = bdb.UserSet.Where(u => u.OgrenciNo == textBox10.Text).ToList();
UserPanels = new List <Panel>();
foreach (var user in users)
{
if (user.Durum == 1 || textBox9.Text != "" || textBox10.Text != "")
{
Panel puser = new Panel();
puser.Size = new Size(flowLayoutPanel1.Size.Width, 100);
puser.BackColor = Color.Transparent;
puser.Name = user.username;
PictureBox pc = new PictureBox();
pc.Size = new Size(120, 100);
pc.Location = new Point(0, 0);
pc.Tag = user.username;
pc.MouseDown += detaygoster;
pc.Tag = user.UserId;
pc.SizeMode = PictureBoxSizeMode.StretchImage;
Image image1 = null;
using (FileStream stream = new FileStream(user.Durum + ".jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
pc.Image = image1;
if (user.Izin == 0)
{
using (FileStream stream = new FileStream("kirmizi.jpg", FileMode.Open))
{ image1 = Image.FromStream(stream); }
pc.Image = image1;
}
TextBox adtxt = new TextBox();
adtxt.ReadOnly = true;
adtxt.Location = new Point(130, 0);
try { adtxt.Text = user.AdSoyad; } catch (Exception) { }
adtxt.Tag = user.username;
adtxt.Font = new Font("Arial", 8.0f);
adtxt.Size = new Size(puser.Size.Width - 180, 20);
RichTextBox urltxt = new RichTextBox();
urltxt.ReadOnly = true;
urltxt.Location = new Point(130, 22);
try { urltxt.Text = bdb.BrowserLogSet.OrderByDescending(o => o.Tarih).FirstOrDefault(l => l.UserId == user.UserId).Adres; } catch (Exception) { }
urltxt.Tag = user.username;
urltxt.Font = new Font("Arial", 8.0f);
urltxt.Size = new Size(puser.Size.Width - 180, 78);
UserPanels.Add(puser);
puser.Controls.Add(pc);
puser.Controls.Add(adtxt);
puser.Controls.Add(urltxt);
flowLayoutPanel1.Controls.Add(puser);
}
}
}
}
timer1.Start();
}
