private void dodajBtn_Click(object sender, EventArgs e) { using (filmdbEntities context = new filmdbEntities()) { BindingManagerBase bm = null; bm = allFilmsGrid.BindingContext[allFilmsGrid.DataSource, allFilmsGrid.DataMember]; DataRow findRow = ((DataRowView)bm.Current).Row; int rowIndex = dataSet1.Tables["Film"].Rows.IndexOf(findRow); try { int id = filmTableAdapter.GetData().ElementAt(rowIndex).film_id; Film toAdd = context.Film.FirstOrDefault(k => k.film_id == id); Aktor a = context.Aktor.FirstOrDefault(k => k.aktor_id == Aktorzy.aktorId); if (!a.Film.Contains(toAdd)) { a.Film.Add(toAdd); context.SaveChanges(); aktorsFilmGrid.DataSource = a.Film.ToList(); } else { MessageBox.Show("Ten aktor już jest w tym filmie"); } } catch (System.ArgumentOutOfRangeException ex) { MessageBox.Show(ex.Message); } } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Imie,Nazwisko")] Aktor aktor) { if (id != aktor.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(aktor); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AktorExists(aktor.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(aktor)); }
public ActionResult DeleteConfirmed(int id) { Aktor aktor = db.Aktor.Find(id); db.Aktor.Remove(aktor); db.SaveChanges(); return(RedirectToAction("Index")); }
public void AktorSil(Aktor Sil) { using (IbmdDB db = new IbmdDB()) { db.Aktor.Remove(Sil); db.SaveChanges(); } }
public void AktorKaydet(Aktor Kaydet) { using (IbmdDB db = new IbmdDB()) { db.Aktor.Add(Kaydet); db.SaveChanges(); } }
public ActionResult Edit([Bind(Include = "ID,Imie,Nazwisko")] Aktor aktor) { if (ModelState.IsValid) { db.Entry(aktor).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aktor)); }
public async Task <IActionResult> Create([Bind("Id,Imie,Nazwisko")] Aktor aktor) { if (ModelState.IsValid) { _context.Add(aktor); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(aktor)); }
public ActionResult Create([Bind(Include = "ID,Imie,Nazwisko")] Aktor aktor) { if (ModelState.IsValid) { db.Aktor.Add(aktor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aktor)); }
private void FilmyAktora_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'dataSet1.Film' table. You can move, or remove it, as needed. //this.filmTableAdapter.Fill(this.dataSet1.Film); using (filmdbEntities context = new filmdbEntities()) { Aktor a = context.Aktor.FirstOrDefault(k => k.aktor_id == Aktorzy.aktorId); aktorsFilmGrid.DataSource = a.Film.ToList(); } this.filmTableAdapter.Fill(this.dataSet1.Film); }
// GET: Aktorzy/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Aktor aktor = db.Aktor.Find(id); if (aktor == null) { return(HttpNotFound()); } return(View(aktor)); }
private void usunBtn_Click(object sender, EventArgs e) { using (filmdbEntities context = new filmdbEntities()) { Film toDelete = null; for (int index = 0; index < aktorsFilmGrid.SelectedRows.Count; index++) { var selectedRow = aktorsFilmGrid.SelectedRows[index]; toDelete = context.Film.Attach((Film)selectedRow.DataBoundItem); } Aktor a = context.Aktor.FirstOrDefault(k => k.aktor_id == Aktorzy.aktorId); a.Film.Remove(toDelete); context.SaveChanges(); aktorsFilmGrid.DataSource = a.Film.ToList(); } }
private void usunBtn_Click(object sender, EventArgs e) { using (filmdbEntities context = new filmdbEntities()) { Aktor toDelete = null; for (int index = 0; index < actorsInFilm.SelectedRows.Count; index++) { var selectedRow = actorsInFilm.SelectedRows[index]; toDelete = context.Aktor.Attach((Aktor)selectedRow.DataBoundItem); } Film a = context.Film.FirstOrDefault(k => k.film_id == Filmy.filmId); a.Aktor.Remove(toDelete); context.SaveChanges(); actorsInFilm.DataSource = a.Aktor.ToList(); } }
protected void btnGuncelle_Click(object sender, EventArgs e) { using (IbmdDB db = new IbmdDB()) { try { var bul = db.Film.Where(p => p.Adi == txtAd.Text).FirstOrDefault(); if (bul.Adi == txtAd.Text) { Response.Redirect("Filmler.aspx?ID=" + bul.FilmID); } } catch { Film Ekle = new Film(); Ekle.Adi = txtAd.Text; Ekle.FilmAfisi = txtTel.Text; var bul1 = db.FilmTuru.Where(p => p.FilminTuru == FilmTuru.SelectedValue).FirstOrDefault(); Ekle.FilmTuruID = bul1.FilmTuruID; Ekle.Konusu = Konu.Text; Ekle.YapimYili = txtSoyad.Text; try { var bul2 = db.Yonetmen.Where(p => p.YonetmenIsmi == Yonetmensecim.Text).FirstOrDefault(); if (bul2.YonetmenIsmi == Yonetmensecim.Text) { Ekle.YonetmenID = bul2.YonetmenID; } } catch { using (IbmdDB db2 = new IbmdDB()) { Yonetmen yeni = new Yonetmen(); yeni.YonetmenIsmi = Yonetmensecim.Text; db2.Yonetmen.Add(yeni); db2.SaveChanges(); } var bul3 = db.Yonetmen.Where(p => p.YonetmenIsmi == Yonetmensecim.Text).FirstOrDefault(); Ekle.YonetmenID = bul3.YonetmenID; } db.Film.Add(Ekle); db.SaveChanges(); using (IbmdDB db3 = new IbmdDB()) { var bul4 = db.Film.Where(p => p.Adi == txtAd.Text).FirstOrDefault(); Aktor yeni = new Aktor(); yeni.AktorAdi = Oyuncu1ri.Text; yeni.AktorDogumTarihi = Odo.Text; yeni.FilmID = bul4.FilmID; db3.Aktor.Add(yeni); db3.SaveChanges(); } using (IbmdDB db4 = new IbmdDB()) { var bul4 = db.Film.Where(p => p.Adi == txtAd.Text).FirstOrDefault(); Aktor yeni = new Aktor(); yeni.AktorAdi = Oyuncu2ri.Text; yeni.AktorDogumTarihi = odo2.Text; yeni.FilmID = bul4.FilmID; db4.Aktor.Add(yeni); db4.SaveChanges(); } Response.Redirect("Filmler.aspx"); } } }