//возвращаем лист id фильмов с id актёров
private List <Films_Actors> GetFilmActors(Film obj)
{
List <Films_Actors> tmpList = new List <Films_Actors>();
int lastId = GetLastId();
foreach (var item in obj.ActorsList)
{
Films_Actors tmpFA = new Films_Actors();
tmpFA.Id_Film = lastId;
tmpFA.Id_Actors = item.Id;
tmpFA.Index_List = (obj.ActorsList as List <Actor>).FindIndex(s => string.Equals(s.Name, item.Name, StringComparison.CurrentCultureIgnoreCase));
tmpList.Add(tmpFA);
}
return(tmpList);
}
//обновление связанных строчек с фильмом в таблице Films_Actors
private void UpdateFilms_Actors(Film obj)
{
DeleteFilms_Actors("Id", obj.Id);
using (ISession session = Singleton.Instance.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
int i = 0;
foreach (var item in obj.ActorsList)
{
Films_Actors tmpFG = new Films_Actors()
{
Id_Film = obj.Id,
Id_Actors = item.Id,
Index_List = i
};
session.Save(tmpFG);
i++;
}
transaction.Commit();
}
}
}
