private void btnDodajStudenta_Click(object sender, EventArgs e)
{
Tim odabraniTim = dgvTimovi.SelectedRows[0].DataBoundItem as Tim;
NoviStudent frmNoviTim = new NoviStudent(odabraniTim.Id);
frmNoviTim.ShowDialog();
}
private void btnIzmijeniTim_Click(object sender, EventArgs e)
{
if (dgvTimovi.SelectedRows.Count > 0)
{
Tim odabraniTim = dgvTimovi.SelectedRows[0].DataBoundItem as Tim;
NoviTim frmNoviTim = new NoviTim(odabraniTim);
frmNoviTim.ShowDialog();
OsvjeziTimove();
}
}
public NoviStudent()
{
InitializeComponent();
timovi = new List <Tim>();
timovi = Tim.DohvatiTimove();
foreach (Tim t in timovi)
{
cmbTim.Items.Add(t);
}
}
private void dgvTimovi_SelectionChanged(object sender, EventArgs e)
{
if (dgvTimovi.SelectedRows.Count > 0)
{
Tim odabraniTim = dgvTimovi.SelectedRows[0].DataBoundItem as Tim;
List <Student> lista = Student.DohvatiStudenteTima(odabraniTim.Id);
dgvStudenti.DataSource = lista;
}
}
private void btnObrisiTim_Click(object sender, EventArgs e)
{
if (dgvTimovi.SelectedRows.Count > 0)
{
foreach (DataGridViewRow row in dgvTimovi.SelectedRows)
{
Tim odabraniTim = row.DataBoundItem as Tim;
odabraniTim.MetodaBrisi();
}
}
OsvjeziTimove();
}
private void btnSpremi_Click(object sender, EventArgs e)
{
if (tim == null)
{
tim = new Tim();
}
tim.OznakaTima = txtOznakaTima.Text;
tim.NazivProjekta = txtNazivProjekta.Text;
tim.OpisProjekta = txtOpisProjekta.Text;
tim.Napomena = txtNapomena.Text;
tim.MetodaSpremi();
this.Close();
}
public static List <Tim> DohvatiTimove()
{
List <Tim> list = new List <Tim>();
string SQLUpit = "select * from Tim";
DbDataReader dr = DB.Instance.DohvatiDataReader(SQLUpit);
while (dr.Read())
{
Tim tim = new Tim(dr);
list.Add(tim);
}
dr.Close();
return(list);
}
public static List <Tim> DohvatiTimove()
{
List <Tim> lista = new List <Tim>();
string sqlUpit = "SELECT * FROM Tim";
DbDataReader dr = DB.Instance.DohvatiDataReader(sqlUpit);
while (dr.Read())
{
Tim tim = new Tim(dr);
lista.Add(tim);
}
dr.Close();
return(lista);
}
private void btnSpremi_Click(object sender, EventArgs e)
{
if (student == null)
{
student = new Student();
}
student.Ime = txtIme.Text;
student.Prezime = txtPrezime.Text;
student.Napomena = txtNapomena.Text;
student.Email = txtEmail.Text;
if (rbtnRedoviti.Checked)
{
student.Status = 'R';
}
else
{
student.Status = 'I';
}
if (rbtnModelA.Checked)
{
student.OdabraniModel = 'A';
}
else
{
student.OdabraniModel = 'B';
}
List <Tim> n = Tim.DohvatiTimove();
foreach (var item in n)
{
if (item.Id == int.Parse(cmbTim.SelectedItem.ToString()))
{
student.Tim = item;
}
}
student.Spremi();
this.Close();
}
private void btnSpremi_Click(object sender, EventArgs e)
{
if (tim == null)
{
tim = new Tim();
}
//tim.Id = int.Parse(txtId.Text.ToString());
tim.OznakaTima = txtOznakaTima.Text;
tim.NazivProjekta = txtNazivProjekta.Text;
tim.OpisProjekta = txtOpisProjekta.Text;
tim.Napomena = txtNapomena.Text;
tim.Spremi();
this.Close();
}
public Student(DbDataReader dr)
{
if (dr != null)
{
Id = int.Parse(dr["Id"].ToString());
Ime = dr["Ime"].ToString();
Prezime = dr["Prezime"].ToString();
Status = char.Parse(dr["Status"].ToString());
Email = dr["Email"].ToString();
Napomena = dr["Napomena"].ToString();
List <Tim> nova = Tim.DohvatiTimove();
foreach (var item in nova)
{
if (item.Id == int.Parse(dr["TimId"].ToString()))
{
Tim = item;
}
}
OdabraniModel = char.Parse(dr["OdabraniModel"].ToString());
}
}
public NoviTim(Tim odabraniTim)
{
InitializeComponent();
tim = odabraniTim;
}
private void OsvjeziTimove()
{
List <Tim> listaTimova = Tim.DohvatiTimove();
dgvTimovi.DataSource = listaTimova;
}
