public static void SaveFilmItemMember(MovieContext _ctx, FilmItem filmItem, Person person, int partType, string character)
{
FilmItemCredits fic = new FilmItemCredits
{
FilmItem = filmItem,
Person = person,
Character = character,
PartType = (PartType)partType
};
_ctx.FilmItemCredits.Add(fic);
_ctx.SaveChanges();
}
public static void EditFilmItemCredit(MovieContext _ctx, FilmItemCredits filmItemCredit, int partType, string character)
{
character = (partType == 1 && !string.IsNullOrWhiteSpace(character) ? character : null);
var personAlreadyCreditedInDepartment = _ctx.FilmItemCredits.Where(p => p.Person == filmItemCredit.Person)
.Where(f => f.FilmItem == filmItemCredit.FilmItem)
.Where(fic => fic.PartType == (PartType)partType)
.Where(fp => fp.Id != filmItemCredit.Id)
.FirstOrDefault();
_ctx.FilmItemCredits.Attach(filmItemCredit);
if (personAlreadyCreditedInDepartment == null)
{
filmItemCredit.Character = character;
filmItemCredit.PartType = (PartType)partType;
filmItemCredit.UpdatedAt = DateTime.Now;
}
_ctx.SaveChanges();
}
