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_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_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");
}
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 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");
}