private void btnSave_Click(object sender, EventArgs e)
{
model.Id_druz = System.Convert.ToInt32(txtCol1.Text.Trim());
model.Imie_pilk = txtCol2.Text.Trim();
model.Nazwisko_pilk = txtCol3.Text.Trim();
model.Nazwa_druz_pilk = txtCol4.Text.Trim();
model.Wiek_pilk = System.Convert.ToInt32(txtCol5.Text.Trim());
model.Ilosc_meczy_pilk = System.Convert.ToInt32(txtCol6.Text.Trim());
model.Ilosc_strzelonych_goli_pilk = System.Convert.ToInt32(txtCol7.Text.Trim());
model.Ilosc_wpuszczonych_goli_pilk = System.Convert.ToInt32(txtCol8.Text.Trim());
model.Specjalizacja = txtCol9.Text.Trim();
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_pilkarze == 0) //Insert
{
db.PILKARZE.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Id_druz = System.Convert.ToInt32(txtCol1.Text.Trim());
model.DRU_Id_druz = System.Convert.ToInt32(txtCol2.Text.Trim());
model.Data = DateTime.Parse(txtCol3.Text.Trim());
model.Godzina = TimeSpan.Parse(txtCol4.Text.Trim());
model.Miejsce = txtCol5.Text.Trim();
model.Wynik_gospo = System.Convert.ToInt32(txtCol6.Text.Trim());
model.Wynik_gosc = System.Convert.ToInt32(txtCol7.Text.Trim());
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_gospo == 0) //Insert
{
db.SPOTKANIA.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Id_gospo = System.Convert.ToInt32(txtCol1.Text.Trim());
model.Id_gosc = System.Convert.ToInt32(txtCol2.Text.Trim());
model.Imie_sed = txtCol3.Text.Trim();
model.Nazwisko_sed = txtCol4.Text.Trim();
model.Wiek_sed = System.Convert.ToInt32(txtCol5.Text.Trim());
model.Ilosc_wydanych_kartek = System.Convert.ToInt32(txtCol6.Text.Trim());
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_sed == 0) //Insert
{
db.SEDZIOWIE.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Id_pilkarze = System.Convert.ToInt32(txtCol1.Text.Trim());
model.Id_sed = System.Convert.ToInt32(txtCol2.Text.Trim());
model.Id_gospo = System.Convert.ToInt32(txtCol3.Text.Trim());
model.Id_gosc = System.Convert.ToInt32(txtCol4.Text.Trim());
model.Rodzaj_kartki = System.Convert.ToInt32(txtCol5.Text.Trim());
model.Nazwa_sed = txtCol6.Text.Trim();
model.Nazwa_pilk = txtCol7.Text.Trim();
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_pilkarze == 0) //Insert
{
db.KARTKI.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
void PopulateDataGridView()
{
datGrid.AutoGenerateColumns = false;
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
datGrid.DataSource = db.DRUZYNY.ToList <DRUZYNY>();
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_druz = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_druz"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.DRUZYNY.Where(x => x.Id_druz == model.Id_druz).FirstOrDefault();
txtCol1.Text = model.Nazwa_druz;
txtCol2.Text = model.Wlasciciel;
txtCol3.Text = model.Siedziba;
txtCol4.Text = System.Convert.ToString(model.Ilosc_rozegranych_meczy);
txtCol5.Text = System.Convert.ToString(model.Punkty);
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_Strzelec = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_Strzelec"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.BRAMKI.Where(x => x.Id_Strzelec == model.Id_Strzelec).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_gospo);
txtCol2.Text = System.Convert.ToString(model.Id_gosc);
txtCol3.Text = System.Convert.ToString(model.Id_pilkarze);
txtCol4.Text = System.Convert.ToString(model.PIL_Id_pilkarze);
txtCol5.Text = System.Convert.ToString(model.Czas_bramki);
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_tren = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_tren"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.TRENERZY.Where(x => x.Id_tren == model.Id_tren).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_druz);
txtCol2.Text = model.Imie_tren;
txtCol3.Text = model.Nazwisko_tren;
txtCol4.Text = model.Nazwa_druz_tren;
txtCol5.Text = System.Convert.ToString(model.Wiek_tren);
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Na pewno chcesz usunąć ten rekord?", "Usunięcie rekordu", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
var entry = db.Entry(model);
if (entry.State == EntityState.Detached)
{
db.DRUZYNY.Attach(model);
}
db.DRUZYNY.Remove(model);
db.SaveChanges();
PopulateDataGridView();
clear();
MessageBox.Show("Usunięto pomyślnie");
}
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_sed = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_sed"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.SEDZIOWIE.Where(x => x.Id_sed == model.Id_sed).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_gospo);
txtCol2.Text = System.Convert.ToString(model.Id_gosc);
txtCol3.Text = model.Imie_sed;
txtCol4.Text = model.Nazwisko_sed;
txtCol5.Text = System.Convert.ToString(model.Wiek_sed);
txtCol6.Text = System.Convert.ToString(model.Ilosc_wydanych_kartek);
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_gospo = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_gospo"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.SPOTKANIA.Where(x => x.Id_gospo == model.Id_gospo).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_druz);
txtCol2.Text = System.Convert.ToString(model.DRU_Id_druz);
txtCol3.Text = System.Convert.ToString(model.Data);
txtCol4.Text = System.Convert.ToString(model.Godzina);
txtCol5.Text = model.Miejsce;
txtCol6.Text = System.Convert.ToString(model.Wynik_gospo);
txtCol7.Text = System.Convert.ToString(model.Wynik_gosc);
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_kartki = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_kartki"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.KARTKI.Where(x => x.Id_kartki == model.Id_kartki).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_pilkarze);
txtCol2.Text = System.Convert.ToString(model.Id_sed);
txtCol3.Text = System.Convert.ToString(model.Id_gospo);
txtCol4.Text = System.Convert.ToString(model.Id_gosc);
txtCol5.Text = System.Convert.ToString(model.Rodzaj_kartki);
txtCol6.Text = model.Nazwa_sed;
txtCol7.Text = model.Nazwa_pilk;
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void datGrid_DoubleClick(object sender, EventArgs e)
{
if (datGrid.CurrentRow.Index != -1)
{
model.Id_pilkarze = Convert.ToInt32(datGrid.CurrentRow.Cells["Id_pilkarze"].Value);
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
model = db.PILKARZE.Where(x => x.Id_pilkarze == model.Id_pilkarze).FirstOrDefault();
txtCol1.Text = System.Convert.ToString(model.Id_druz);
txtCol2.Text = model.Imie_pilk;
txtCol3.Text = model.Nazwisko_pilk;
txtCol4.Text = model.Nazwa_druz_pilk;
txtCol5.Text = System.Convert.ToString(model.Wiek_pilk);
txtCol6.Text = System.Convert.ToString(model.Ilosc_meczy_pilk);
txtCol7.Text = System.Convert.ToString(model.Ilosc_strzelonych_goli_pilk);
txtCol8.Text = System.Convert.ToString(model.Ilosc_wpuszczonych_goli_pilk);
txtCol9.Text = model.Specjalizacja;
}
btnSave.Text = "Update";
btnDel.Enabled = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Nazwa_druz = txtCol1.Text.Trim();
model.Wlasciciel = txtCol2.Text.Trim();
model.Siedziba = txtCol3.Text.Trim();
model.Ilosc_rozegranych_meczy = System.Convert.ToInt32(txtCol4.Text.Trim());
model.Punkty = System.Convert.ToInt32(txtCol5.Text.Trim());
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_druz == 0) //Insert
{
db.DRUZYNY.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Id_gospo = System.Convert.ToInt32(txtCol1.Text.Trim());
model.Id_gosc = System.Convert.ToInt32(txtCol2.Text.Trim());
model.Id_pilkarze = System.Convert.ToInt32(txtCol3.Text.Trim());
model.PIL_Id_pilkarze = System.Convert.ToInt32(txtCol4.Text.Trim());
model.Czas_bramki = TimeSpan.Parse(txtCol5.Text.Trim());
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_Strzelec == 0) //Insert
{
db.BRAMKI.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
private void btnSave_Click(object sender, EventArgs e)
{
model.Id_druz = System.Convert.ToInt32(txtCol1.Text.Trim());
model.Imie_tren = txtCol2.Text.Trim();
model.Nazwisko_tren = txtCol3.Text.Trim();
model.Nazwa_druz_tren = txtCol4.Text.Trim();
model.Wiek_tren = System.Convert.ToInt32(txtCol5.Text.Trim());
using (EkstraklasaEntities db = new EkstraklasaEntities())
{
if (model.Id_tren == 0) //Insert
{
db.TRENERZY.Add(model);
}
else //Update
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
clear();
PopulateDataGridView();
MessageBox.Show("Sukces");
}
