public void UpdateCategory(Model.Category category, int categoryId) { var tableCategory = context.Categorys.Find(categoryId); tableCategory.name = category.Name; tableCategory.category_id = category.CategoryId; context.SaveChanges(); }
public void UpdateActor(Model.Actor actor, int actorId) { var dbActor = context.Actors.Find(actorId); dbActor.last_name = actor.LastName; dbActor.first_name = actor.FirstName; context.SaveChanges(); }
public void AddActor(Model.Actor actor) { context.Actors.Add(new Table.Actor { first_name = actor.FirstName, last_name = actor.LastName }); context.SaveChanges(); }
public void AddCategory(Model.Category category) { context.Categorys.Add(category.Map()); }
public void UpdateFilm(Model.Film film) { var tableFilm = context.Films .Where(dbFilm => dbFilm.title.Equals(film.Title)).FirstOrDefault(); if (tableFilm == null) return; tableFilm.length = film.Length != 0 ? film.Length : tableFilm.length; tableFilm.release_year = film.ReleaseYear != 0 ? film.ReleaseYear : tableFilm.release_year; tableFilm.description = !string.IsNullOrEmpty(film.Description) ? film.Description : tableFilm.description; context.SaveChanges(); }
public void AddFilm(Model.Film film) { context.Films.Add(film.Map()); context.SaveChanges(); }