public GenreService()
{
data = new FilmDB();
Mapper.Reset();
Mapper.Initialize(cfg =>
{
cfg.CreateMap <genre, BizGenre>().ForMember(c => c.Genre, g => g.MapFrom(m => m.Genre1));
cfg.CreateMap <BizGenre, genre>().ForMember(c => c.Genre1, g => g.MapFrom(m => m.Genre));
});
}
private void dtgActors_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
crearActorViewModel((ActorDB)dtgActors.SelectedItem);
btnDelete.IsEnabled = dtgActors.SelectedItem != null;
if (dtgActors.SelectedItem != null)
{
ActorDB a = (ActorDB)dtgActors.SelectedItem;
ObservableCollection <FilmDB> films = FilmDB.getFilms(a.Actor_id);
dtgFilms.ItemsSource = films;
}
}
//IDbSet<films> dbSet;
public FilmService()
{
data = new FilmDB();
Mapper.Reset();
Mapper.Initialize(cfg =>
{
cfg.CreateMap <films, BizFilm>().ForMember(f => f.Genre, sd => sd.MapFrom(d => d.genre));
cfg.CreateMap <BizFilm, films>().ForMember(f => f.genre, sd => sd.MapFrom(d => d.Genre));
cfg.CreateMap <genre, BizGenre>().ForMember(c => c.Genre, g => g.MapFrom(m => m.Genre1));
cfg.CreateMap <BizGenre, genre>().ForMember(c => c.Genre1, g => g.MapFrom(m => m.Genre));
});
}
public int AddFilm(List <sys_film> entrys)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO dbo.sys_film \n");
sql.Append(" ( link, title, txt,fromurl,[level],imdb,douban ) \n");
sql.Append(" select @link, \n");
sql.Append(" @title, \n");
sql.Append(" @txt,@fromurl,@level,@imdb,@douban WHERE NOT EXISTS (SELECT * FROM sys_film WHERE link=@link) \n");
using (FilmDB db = new FilmDB())
{
return(db.FilmConn.Execute(sql.ToString(), entrys));
}
}
public Film(FilmDB filmDB)
{
int ID;
Int32.TryParse(filmDB.id, out ID);
FilmID = ID;
NazivFilma = filmDB.NazivFilma;
GodinaFilma = filmDB.GodinaFilma;
ZanrFilma = filmDB.ZanrFilma;
Reziser = filmDB.Reziser;
Glumci = filmDB.Glumci;
VrijemeTrajanja = filmDB.VrijemeTrajanja;
Cijena = filmDB.Cijena;
Sinopsis = filmDB.Sinopsis;
BrojOcjena = filmDB.BrojOcjena;
ProsjekOcjena = filmDB.ProsjekOcjena;
}
public async void DodajFilm(Object poster)
{
if (!isValidAzuriranjeFilmova())
{
return;
}
int godinaFilma;
int vrijemeTrajanja;
double cijenaFilma;
Int32.TryParse(AzuriranjeFilmovaGodinaFilma, out godinaFilma);
Int32.TryParse(AzuriranjeFilmovaVrijemeTrajanja, out vrijemeTrajanja);
double.TryParse(AzuriranjeFilmovaCijena, out cijenaFilma);
Film film = new Film(AzuriranjeFilmovaNazivFilma, godinaFilma, AzuriranjeFilmovaZanrFilma, AzuriranjeFilmovaReziser, AzuriranjeFilmovaGlumci, vrijemeTrajanja, cijenaFilma, AzuriranjeFilmovaSinopsis, AzuriranjeFilmovaPoster);
bool exists = false;
foreach (Film movie in videoteka.ListaFilmova)
{
if (movie.NazivFilma == AzuriranjeFilmovaNazivFilma && movie.GodinaFilma.ToString() == godinaFilma.ToString())
{
exists = true;
break;
}
}
if (!exists)
{
videoteka.ListaFilmova.Add(film);
FilmDB filmDB = new FilmDB(film);
try
{
await filmTabela.InsertAsync(filmDB);
await(new MessageDialog("Uspješno ste dodali film")).ShowAsync();
}
catch (Exception e) { await(new MessageDialog("Nije se povezalo dobro")).ShowAsync(); }
AzuriranjeFilmovaOtvori(poster);
OcistiAzuriranjeFilmova();
}
else
{
await(new MessageDialog("Film vec postoji")).ShowAsync();
}
}
public UnitOfWork(string conectionString)
{
context = new FilmDB(conectionString);
}
public DirectorRepository(FilmDB context) : base(context)
{
}
public GenreRepository(FilmDB context) : base(context)
{
}
public FilmRepository(FilmDB context) : base(context)
{
}
public GeneralRepository(FilmDB context)
{
this.context = context;
dbSet = context.Set <T>();
}
