static void Main(string[] args)
{
//will always execute it?
using (var db = new MovieShopDBContext())
{
//var genres = db.Genres.ToList();
var movies = db.Movies.Where(m => m.Title.StartsWith("a")).ToList();
}
/*
* NLogBuilder.ConfigureNLog("nlog.config");
* try
* {
* var host = new WebHostBuilder()
* .UseKestrel()
* .UseContentRoot(Directory.GetCurrentDirectory())
* .UseIISIntegration()
* .UseNLog()
* .UseStartup<Startup>()
* .Build();
*
* host.Run();
* }
* finally
* {
* LogManager.Shutdown();
* }
*/
}
public List <T> Read()
{
using (var ctx = new MovieShopDBContext())
{
return(Read(ctx));
}
}
public T Read(int id)
{
using (var ctx = new MovieShopDBContext())
{
return(Read(ctx, id));
}
}
public T Create(T t)
{
using (var ctx = new MovieShopDBContext())
{
return(Create(ctx, t));
}
}
public T Update(T newObject)
{
using (var ctx = new MovieShopDBContext())
{
return(Update(ctx, newObject));
}
}
public override Order Create(MovieShopDBContext ctx, Order t)
{
ctx.Entry(t.Customer).State = EntityState.Unchanged;
ctx.Orders.Add(t);
ctx.SaveChanges();
return(t);
}
public override bool Delete(MovieShopDBContext ctx, int id)
{
Movie o = ctx.Movies.FirstOrDefault(x => x.Id == id);
ctx.Entry(o).State = EntityState.Deleted;
return(true);
}
public override bool Delete(MovieShopDBContext ctx, int id)
{
Customer o = ctx.Customer.FirstOrDefault(x => x.Id == id);
ctx.Entry(o).State = EntityState.Deleted;
ctx.SaveChanges();
return(true);
}
public bool Delete(int id)
{
using (var ctx = new MovieShopDBContext()) {
return(Delete(ctx, id));
}
}
public abstract T Update(MovieShopDBContext ctx, T t);
public abstract T Read(MovieShopDBContext ctx, int id);
public override Genre Update(MovieShopDBContext ctx, Genre t)
{
ctx.Entry(t).State = EntityState.Modified;
ctx.SaveChanges();
return(t);
}
public override Customer Read(MovieShopDBContext ctx, int id)
{
return(ctx.Customer.Include("Orders").FirstOrDefault(x => x.Id == id));
}
public override Movie Update(MovieShopDBContext ctx, Movie t)
{
ctx.Entry(t).State = EntityState.Modified;
return(t);
}
public override Movie Create(MovieShopDBContext ctx, Movie t)
{
ctx.Movies.Add(t);
ctx.SaveChanges();
return(t);
}
public override Movie Read(MovieShopDBContext ctx, int id)
{
return(ctx.Movies.Include("Genres").FirstOrDefault(x => x.Id == id));
}
public override List <Movie> Read(MovieShopDBContext ctx)
{
return(ctx.Movies.Include("Genres").ToList());;
}
public abstract bool Delete(MovieShopDBContext ctx, int id);
public override List <Customer> Read(MovieShopDBContext ctx)
{
return(ctx.Customer.Include("Orders").ToList());
}
public override Genre Create(MovieShopDBContext ctx, Genre t)
{
ctx.Genres.Add(t);
ctx.SaveChanges();
return(t);
}
public override Customer Create(MovieShopDBContext ctx, Customer t)
{
ctx.Customer.Add(t);
ctx.SaveChanges();
return(t);
}
public abstract List <T> Read(MovieShopDBContext ctx);
public override Customer Update(MovieShopDBContext ctx, Customer c)
{
ctx.Entry(c).State = EntityState.Modified;
ctx.SaveChanges();
return(c);
}
public override List <Order> Read(MovieShopDBContext ctx)
{
List <Order> orders = ctx.Orders.Include("Customer").Include("Movies").ToList();
return(orders);
}
