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