private void DeleteActor()
{
int actorId = Convert.ToInt32(txbActorId.Text);
actor actor = db.actors.FirstOrDefault(x => x.act_id == actorId);
if (actor == null)
{
MessageBox.Show("Actor không tồn tại, xoá không thành công");
}
else
{
try
{
db.actors.Remove(actor);
db.SaveChanges();
MessageBox.Show("Xoá thành công");
ReloadDataGird();
}
catch (Exception ex)
{
MessageBox.Show("Xoá không thành công");
}
}
}
public override ICollection <actor> getActors(HtmlNode victimDetailContent)
{
var dd = victimDetailContent.SelectNodes("//div[@class='dinfo'] //dd");
string[] actors = dd[1].InnerText.Trim().Split(',');
ICollection <actor> acts = new HashSet <actor>();
foreach (var actor in actors)
{
try {
string actorName = actor.Trim();
if (actorName == "")
{
continue;
}
var alias = UnicodeUtil.convertToAlias(actorName);
var newEntity = new actor()
{
name = actorName, alias = alias
};
if (actorExisted(actorName))
{
newEntity = findActorByName(actorName);
setModified(newEntity);
}
acts.Add(newEntity);
}
catch
{
continue;
}
}
return(acts);
}
public void AddActor()
{
if (txbActorFirstName.Text == "" ||
txbActorLastName.Text == "" ||
cbbActorGender.selectedValue == "")
{
MessageBox.Show("Thông tin chưa đủ");
}
try
{
actor actor = new actor();
actor.act_fname = txbActorFirstName.Text;
actor.act_lname = txbActorLastName.Text;
actor.act_gender = cbbActorGender.selectedValue;
actor.act_image = txbActorImage.Text;
db.actors.Add(actor);
db.SaveChanges();
MessageBox.Show("Thêm actor thành công");
ReloadDataGird();
}
catch (Exception ex)
{
MessageBox.Show("Thêm actor thất bại");
}
}
public ActionResult CommitShooter(actor a)
{
string query = "Update shooters.shooter set Middle = '" + a.Middle + "', birth = '" + a.birth + "', Death = '" + a.death + "' where First = '" + a.First + "' AND Last = '" + a.Last + "'";
QueryUtils.query(query);
return(RedirectToAction("EditShooter", new { first = a.First, last = a.Last }));
}
public void TestarIncluirFilmeAtor()
{
var filme = new film()
{
title = "A VOLTA DOS QUE N�O FORAM",
language_id = 1
};
var ator = new actor()
{
first_name = "FABIO",
last_name = "QUIRINO",
last_update = DateTime.Now
};
var film_actor = new film_actor()
{
actor = ator,
film = filme,
last_update = DateTime.Now
};
filme.films_actors = new List <film_actor>()
{
film_actor
};
new ServicoFilm().Incluir(filme);
Assert.IsTrue(true);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvActors.SelectedRows.Count > 0)
{
try
{
using (MovieDB context = new MovieDB())
{
DataGridViewRow row = dgvActors.SelectedRows[0];
actor actor = (actor)row.Tag;
if (MessageBox.Show("Are you sure you want to delete actor: " + actor.member_of_cast_and_crew.first_name + " " + actor.member_of_cast_and_crew.last_name + "?", "Warning", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
context.actors.Attach(actor);
actor.member_of_cast_and_crew.active = 0;
context.SaveChanges();
RefreshTableAndFilters();
DirectorsUcl.Instance.RefreshTableAndFilters();
MoviesUcl.Instance.RefreshTableAndFilters();
MessageBox.Show("Actor successfully deleted.", "Success", MessageBoxButtons.OK);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else
{
MessageBox.Show("You haven't chosen an actor.", "Warning", MessageBoxButtons.OK);
}
}
public void Delete(actor ator)
{
using (var db = new SakilaContext())
//Como não há concorrência nas modificações, não é necessário criar um contexto transacional.
//using (var transacao = db.Database.BeginTransaction())
{
try
{
db.films_actors.RemoveRange(ator.films_actors);
db.actors.Remove(ator);
db.SaveChanges();
//transacao.Commit();
}
catch
{
//transacao.Rollback();
//tratar exceção e gravar no log além de fechar a transação
throw;
}
/* finally
* {
* transacao.Dispose();
* };
*/ }
}
public async Task <IActionResult> Putactor([FromRoute] int id, [FromBody] actor actor)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != actor.id)
{
return(BadRequest());
}
_context.Entry(actor).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!actorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//Обновление указанного объекта ListView
public void UpdateItemInTable(ListViewItem item, actor a)
{
item.SubItems[0].Text = a.name;
item.SubItems[1].Text = a.birthday.HasValue ? a.birthday.Value.ToShortDateString() : null;
item.SubItems[2].Text = a.country;
item.SubItems[3].Text = a.description;
}
public override ICollection <actor> getActors(HtmlNode victimDetailContent)
{
var dd = victimDetailContent.SelectNodes("//ul[@class='meta-data'] //li");
string[] actors = convertNodesToArray(dd[dd.Count - 9].SelectNodes("./a"));
ICollection <actor> acts = new HashSet <actor>();
foreach (var actor in actors)
{
try {
string actorName = actor.Trim();
if (actorName == "")
{
continue;
}
var alias = UnicodeUtil.convertToAlias(actorName);
var newEntity = new actor()
{
name = actorName, alias = alias
};
if (actorExisted(actorName))
{
newEntity = findActorByName(actorName);
setModified(newEntity);
}
acts.Add(newEntity);
}
catch
{
continue;
}
}
return(acts);
}
public void Update(actor ator)
{
using (var db = new SakilaContext())
{
db.actors.Update(ator);
db.SaveChanges();
}
}
private actor GetActorFilmById(int id)
{
VerifyNullIntParameter(id);
var servicoAtor = new sakila.repositorio.servico.ServicoActor();
actor ator = servicoAtor.GetActorFilmById(id);
return(ator);
}
public ViewResult ConfirmDeleteActor(int id)
{
var servicoAtor = new sakila.repositorio.servico.ServicoActor();
actor ator = servicoAtor.GetActorFilmById(id);
return(View("Views/Actor/ConfirmDeleteActor.cshtml", ator));
}
public void Insert(actor ator)
{
using (var db = new SakilaContext())
{
db.actors.Add(ator);
db.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
actor actor = db.actors.Find(id);
db.actors.Remove(actor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void DeleteActor(int id)
{
actor actor = db.actors.Find(id);
db.actors.Attach(actor);
db.actors.Remove(actor);
db.SaveChanges();
}
public void AddActor(actor actor)
{
if (actor == null)
{
return;
}
db.actors.Add(actor);
db.SaveChanges();
}
//Поиск всех фильмов данного актёра
public List <film> GetFilmsForActors(DataContext ctx, actor a)
{
List <film> rez;
rez = (from contract in ctx.films_and_actors
where contract.actor_id == a.id
select contract.film).ToList();
return(rez);
}
public static actor Factory(TextBox txtId, TextBox txtNombre, TextBox txtApellido, TextBox txtEdad)
{
var nuevoActor = new actor();
nuevoActor.actor_id = Convert.ToInt32(txtId.Text);
nuevoActor.first_name = txtNombre.Text;
nuevoActor.last_name = txtApellido.Text;
return(nuevoActor);
}
public ActionResult Edit([Bind(Include = "Actor_Id,Actor_name,Sex,Date_Of_Birth,Bio")] actor actor)
{
if (ModelState.IsValid)
{
db.Entry(actor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(actor));
}
public ActionResult ViewShooterGuns(string first, string last)
{
actor _actor = TableUtils.queryToObject <actor>("SELECT * FROM shooters.shooter where first= '" + first + "' AND last = '" + last + "'");
List <gunPurchase> _list = TableUtils.queryToTable <gunPurchase>("SELECT * FROM shooters.gunPurchase where first= '" + first + "' AND last = '" + last + "'");
ShooterGP model = new ShooterGP();
model._actor = _actor;
model._guns = _list;
return(View(model));
}
public ActionResult Create([Bind(Include = "Actor_Id,Actor_name,Sex,Date_Of_Birth,Bio")] actor actor)
{
if (ModelState.IsValid)
{
db.actors.Add(actor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(actor));
}
public ActorForm(actor actor)
{
this.actor = actor;
InitializeComponent();
if (actor.id == 0)
{
return;
}
textBox_ActorFname.Text = actor.fname;
textBox_ActorLname.Text = actor.lname;
}
//Добавление актёра в БД. Возвращает id добавленного актёра, или -1 при ошибке
public int AddActorToDB(actor newActor)
{
if (AddObjectToDB("actor", newActor) == false)
{
return(-1);
}
else
{
return(newActor.id); //id обновилось при сохранении изменений в БД
}
}
public static ActorDTO Create(actor actor)
{
return(new ActorDTO
{
Id = actor.actor_id,
FirstName = actor.first_name,
LastName = actor.last_name,
Birthday = actor.birthday?.DateTime,
Movies = actor.movies?.Select(x => MovieDTO.Create(x)).ToList()
});
}
public actor ObterPorSobrenome(string sobrenome)
{
actor ator = null;
using (var db = new SakilaContext())
{
ator = db.actors.FirstOrDefault(x => x.last_name.Contains(sobrenome));
}
return(ator);
}
public actor GetById(int?primarykey)
{
actor ator = null;
using (var db = new SakilaContext())
{
ator = ObterPorId(db, primarykey.Value);
}
return(ator);
}
public async Task <IActionResult> Postactor([FromBody] actor actor)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.actors.Add(actor);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getactor", new { id = actor.id }, actor));
}
private void btn_AddActor_Click(object sender, EventArgs e)
{
actor actor = new actor();
ActorForm form = new ActorForm(actor);
var result = form.ShowDialog();
if (result == DialogResult.Cancel)
{
return;
}
_model.AddActor(form.getActor());
Refresh();
}
public ViewResult InsertActor(actor ator)
{
var servicoAtor = new sakila.repositorio.servico.ServicoActor();
ator.last_update = DateTime.Now;
servicoAtor.Insert(ator);
var atores = servicoAtor.Listar();
TempData["mensagem"] = "Ator Criado com Sucesso!";
return(View("Views/Actor/Index.cshtml", atores));
}
