private async void prikaziFilmove(object parametar) { if (OdabranaKolekcija != null) { using (var db = new FilmDbContext()) { if (MojiFilmoviIzKolekcije.Count() != 0) { MojiFilmoviIzKolekcije.Clear(); } foreach (Film k in db.Filmovi) { if (k.KolekcijaId == OdabranaKolekcija.KolekcijaId) { MojiFilmoviIzKolekcije.Add(k); } } } } else { var dialog11 = new MessageDialog("Niste oznacili kolekciju."); await dialog11.ShowAsync(); } }
private async void izbrisiFilm(object parametar) { int kolekcijaID = OdabraniFilm.KolekcijaId; if (OdabraniFilm != null) { using (var db = new FilmDbContext()) { db.Filmovi.Remove(db.Filmovi.Where(x => x.FilmId == OdabraniFilm.FilmId).FirstOrDefault()); db.SaveChanges(); } using (var db = new FilmDbContext()) { MojiFilmoviIzKolekcije.Clear(); foreach (Film k in db.Filmovi) { if (k.KolekcijaId == kolekcijaID) { MojiFilmoviIzKolekcije.Add(k); } } } } else { var dialog = new MessageDialog("Niste odabrali film."); await dialog.ShowAsync(); } }
public override void OnAuthorization(AuthorizationContext filterContext) { LazyInitializer.EnsureInitialized(ref mRoles, ref mIsInitialized, ref mInitializerLock, () => { mRoles = new List <Role>(); FilmDbContext db = new FilmDbContext(); mRoles = db.Roles.ToList(); StringBuilder tmpSB = new StringBuilder(); tmpSB.Append(','); HashSet <string> tmpSet = new HashSet <string>(); foreach (Role role in mRoles) { string[] tmpStrArr = role.Description.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string PStr in tmpStrArr) { if (!tmpSet.Contains(PStr)) { tmpSB.Append(PStr + ","); tmpSet.Add(PStr); } } } mAllPermission = tmpSB.ToString(); return(mRoles); }); mControllerName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName; mActionName = filterContext.ActionDescriptor.ActionName; base.OnAuthorization(filterContext); }
private async void dodajFilm(object parametar) { if (OdabraniFilm != null && OdabranaKolekcija != null) { using (var db = new FilmDbContext()) { int max = -1; foreach (Film k in db.Filmovi) { if (k.FilmId > max) { max = k.FilmId; } } max++; Film novi = new Film(max); novi = OdabraniFilm; novi.FilmId = max; novi.KolekcijaId = OdabranaKolekcija.KolekcijaId; novi.KorisnikId = Korisnik.KorisnikId; db.Filmovi.Add(novi); db.SaveChanges(); } var dialog = new MessageDialog("Film uspjesno sacuvan"); await dialog.ShowAsync(); } else { var dialog = new MessageDialog("Oznacite film ili kolekciju."); await dialog.ShowAsync(); } }
/// <summary> /// Initializes the singleton application object. This is the first line of authored code /// executed, and as such is the logical equivalent of main() or WinMain(). /// </summary> public App() { this.InitializeComponent(); this.Suspending += OnSuspending; using (var db = new KolekcijaDbContext()) { db.Database.ApplyMigrations(); DefaultPodaci.Initialize(db); } using (var db = new FilmDbContext()) { db.Database.ApplyMigrations(); DefaultPodaci.Initialize(db); } using (var db = new KorisnikDbContext()) { db.Database.ApplyMigrations(); DefaultPodaci.Initialize(db); } using (var db = new OcjenaDbContext()) { db.Database.ApplyMigrations(); DefaultPodaci.Initialize(db); } }
private void NewActor() { using (var db = new FilmDbContext(_connectionName)) { var actor = _view.GetNewActor(); db.Actors.Add(actor); db.SaveChanges(); } }
private void NewFilm() { var newFilm = _view.GetNewFilmInfo(); using (var db = new FilmDbContext(_connectionName)) { db.Films.Add(newFilm); db.SaveChanges(); _view.WriteFilmList(db.Films.ToList()); } }
public void EfToSchemaTest() { using (var dbContext = new FilmDbContext("dbUpTestDb")) { var comparer = new CompareEfSql(); var status = comparer.CompareEfWithDb(dbContext); Assert.True(status.IsValid, status.GetAllErrors()); Assert.False(status.HasWarnings, string.Join("\n", status.Warnings)); } }
public void EFGeneratedToSqlTest() { using (var dbContext = new FilmDbContext()) { var comparer = new CompareSqlSql(); var status = comparer.CompareEfGeneratedSqlToSql(dbContext, "dbUpTestDb"); Assert.True(status.IsValid, status.GetAllErrors()); Assert.False(status.HasWarnings, string.Join("\n", status.Warnings)); } }
private void ViewFilmRating() { using (var db = new FilmDbContext(_connectionName)) { var films = db.Films.ToList(); var filmChoice = _view.GetFilmChoice(films); var ratings = db.FilmRatings.Where(x => x.FilmId == filmChoice.FilmId).ToList(); _view.WriteFilmRatings(filmChoice, ratings); } }
private void AddActorToFilm() { using (var db = new FilmDbContext(_connectionName)) { var actor = _view.GetActorChoice(db.Actors.ToList()); var film = _view.GetFilmChoice(db.Films.ToList()); film.Actors.Add(actor); db.SaveChanges(); } }
public void SqlToSqlTest() { using (var dbContext = new FilmDbContext("efTestDb")) { dbContext.Database.Delete(); dbContext.Database.CreateIfNotExists(); var comparer = new CompareSqlSql(); var status = comparer.CompareSqlToSql("efTestDb", "FilmDb"); Assert.True(status.IsValid, status.GetAllErrors()); Assert.False(status.HasWarnings, string.Join("\n", status.Warnings)); } }
private void NewFilmRating() { using (var db = new FilmDbContext(_connectionName)) { var films = db.Films.ToList(); var filmChoice = _view.GetFilmChoice(films); var filmRating = _view.GetNewFilmRating(); filmRating.Film = filmChoice; db.FilmRatings.Add(filmRating); db.SaveChanges(); } }
private void UpdateFilm() { using (var db = new FilmDbContext(_connectionName)) { var films = db.Films.ToList(); var filmChoice = _view.GetFilmChoice(films); var newFilmInfo = _view.GetNewFilmInfo(); filmChoice.Name = newFilmInfo.Name; filmChoice.Description = newFilmInfo.Description; filmChoice.Genre = newFilmInfo.Genre; db.SaveChanges(); } }
private void button2_Click(object sender, RoutedEventArgs e) { OdabraniFilm = (Film)listBox1.SelectedItem; if (OdabraniFilm != null) { Film novi = new Film(); using (var db = new FilmDbContext()) { novi = db.Filmovi.Where(x => x.FilmId == OdabraniFilm.FilmId).FirstOrDefault(); } nazivLabela.Text = novi.Naziv; opisLabela.Text = novi.Opis; ocjenaLabela.Text = "Ocjena: " + OdabraniFilm.ProsjecnaOcjena.ToString(); //godinaLabela.Text = OdabraniFilm.god; } }
private async void izbrisiKolekciju(object parametar) { if (OdabranaKolekcija != null)// && OdabranaKolekcija.Naziv!="") { using (var db = new FilmDbContext()) { for (int i = 0; i < MojiFilmoviIzKolekcije.Count; i++) { db.Filmovi.Remove(db.Filmovi.Where(x => x.KolekcijaId == OdabranaKolekcija.KolekcijaId).FirstOrDefault()); } db.SaveChanges(); } MojiFilmoviIzKolekcije.Clear(); using (var db = new KolekcijaDbContext()) { db.Kolekcije.Remove(db.Kolekcije.Where(x => x.KorisnikId == korisnik.KorisnikId && x.KolekcijaId == OdabranaKolekcija.KolekcijaId).FirstOrDefault()); db.SaveChanges(); MojeKolekcije.Clear(); foreach (Kolekcija k in db.Kolekcije) { if (k.KorisnikId == korisnik.KorisnikId) { MojeKolekcije.Add(k); } } } var dialog1 = new MessageDialog("Kolekcija uspješno obrisana."); await dialog1.ShowAsync(); } else { var dialog1 = new MessageDialog("Niste oznacili kolekciju."); await dialog1.ShowAsync(); } }
public UnitOfWork(FilmDbContext databaseContext) { _databaseContext = databaseContext; }
public HomeController(ILogger <HomeController> logger, FilmDbContext con) { _logger = logger; context = con; }
public FilmRepository(FilmDbContext _db) { this.db = _db; }
public FilmsController(FilmDbContext context) { _context = context; }
public Repository(FilmDbContext context) { Context = context; }