private void btnUredu_Click(object sender, EventArgs e)
{
using (var db = new EvidencijaStudenataEntities())
{ if (timZaIzmjenu == null)
{
Tim tim = new Tim
{
OznakaTima = txtOznakaTima.Text,
NazivProjekta = txtNazivProjekta.Text,
OpisProjekta = txtOpisProjekta.Text,
Napomena = txtNapomena.Text
};
db.Tim.Add(tim);
db.SaveChanges();
}
else
{
db.Tim.Attach(timZaIzmjenu);
timZaIzmjenu.OznakaTima = txtOznakaTima.Text;
timZaIzmjenu.NazivProjekta = txtNazivProjekta.Text;
timZaIzmjenu.OpisProjekta = txtOpisProjekta.Text;
timZaIzmjenu.Napomena = txtNapomena.Text;
db.SaveChanges();
} }
Close();
}
private void dgvTimovi_SelectionChanged(object sender, EventArgs e)
{
Tim selektrianiTim = timBindingSource.Current as Tim;
if (selektrianiTim != null)
{
PrikaziStudente(selektrianiTim);
int sum = 0;
for (int i = 0; i < dgvStudenti.Rows.Count; ++i)
{
sum += Convert.ToInt32(dgvStudenti.Rows[i].Cells[0].Value);
}
/*int total = dgvStudenti.Rows.Cast<DataGridViewRow>()
* .Min(t => Convert.ToInt32(t.Cells[0].Value));
*
* textBox1.Text = total.ToString();*/
using (var db = new EvidencijaStudenataEntities())
{
List <Student> prviTim = (from t in db.Student
where t.Status == "R".ToString()
select t).ToList <Student>();
/* BindingList<Student> lista =
* new BindingList<Student>(prviTim.Student.ToList<Student>());
*/
// dgvStudenti.DataSource = prviTim;
}
}
}
private void brnbrisitim_Click(object sender, EventArgs e)
{
Tim selektirnaiTim = timBindingSource.Current as Tim;
if (selektirnaiTim != null)
{
if (MessageBox.Show("DA li ste sigurni?", "Upozorenje!", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
using (var db = new EvidencijaStudenataEntities())
{
db.Tim.Attach(selektirnaiTim);
if (selektirnaiTim.Student.Count == 0)
{
db.Tim.Remove(selektirnaiTim);
db.SaveChanges();
}
else
{
MessageBox.Show("Nije moguće!");
}
}
PrikaziTimove();
}
}
}
private void PrikaziTimove()
{
BindingList <Tim> listaTimova = null;
using (var db = new EvidencijaStudenataEntities()) {
listaTimova = new BindingList <Tim>(db.Tim.ToList());
}
timBindingSource.DataSource = listaTimova;
}
private void btnUredu_Click(object sender, EventArgs e)
{
using (var db = new EvidencijaStudenataEntities())
{
db.Tim.Attach(selektiraniTim);
Student student = new Student {
Ime = txtIme.Text,
Prezime = txtPrezime.Text,
Status = txtStatus.Text,
OdabraniModel = txtOdabraniModel.Text,
Napomena = txtNapomena.Text,
Email = txtEmail.Text,
Tim = selektiraniTim
};
db.Student.Add(student);
db.SaveChanges();
}
Close();
}
private void PrikaziStudente(Tim tim)
{
List <Student> listaStudenata = null;
using (var db = new EvidencijaStudenataEntities())
{
db.Tim.Attach(tim);
listaStudenata = new
List <Student>(tim.Student.ToList <Student>());
listaStudenata = (from t in listaStudenata
where t.Status == "R".ToString()
&&
t.Ime.Contains("Igor")
select t).ToList <Student>();
List <int> total = (from t in listaStudenata
select t.Id).ToList <int>();
// double a = total.Average();
textBox1.Text = total.Count().ToString();
}
studentBindingSource.DataSource = listaStudenata;
}
