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>(); }