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