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