public static void UpdateEntity <T>(T entity) where T : class
{
using (var ctx = new MediaContext())
{
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public static void DeleteBookByID(int id)
{
using (var ctx = new MediaContext())
{
var bookToRemove = from x in ctx.Books where x.BookID == id select x;
ctx.Books.Remove(bookToRemove.FirstOrDefault());
}
}
public static void Insert <T>(T entity) where T : class
{
using (var ctx = new MediaContext())
{
ctx.Set <T>().Add(entity);
ctx.SaveChanges();
}
}
public static void QueryPapers(MediaContext context)
{
Console.WriteLine("_____________Papers_____________");
foreach (var paper in context.Papers)
{
Console.WriteLine($"'{paper.Name}' - {paper.Author} ({paper.Type})");
}
Console.WriteLine("___________________");
}
public static void RemoveEntity <T>(T entity) where T : class
{
using (var ctx = new MediaContext())
{
DbSet <T> dbSet = ctx.Set <T>();
dbSet.Remove(entity);
ctx.SaveChanges();
}
}
public static void QueryBooks(MediaContext context)
{
Console.WriteLine("_____________Books_____________");
foreach (var book in context.Books)
{
Console.WriteLine($"'{book.Name}' - {book.Author} ({book.Genre}, {book.Pages})");
}
Console.WriteLine("___________________");
}
public static Book GetBookByName(string name)
{
using (var ctx = new MediaContext())
{
var result = from b in ctx.Books
where b.BookName == name
select b;
return(result.First());
}
}
public static List <T> GetAll <T>(T entity) where T : class
{
List <T> result = new List <T>();
using (var ctx = new MediaContext())
{
DbSet <T> dbSet = ctx.Set <T>();
var entities = from x in dbSet select x;
result.AddRange(entities);
}
return(result);
}
public static void QueryMovies(MediaContext context)
{
Console.WriteLine("_____________Movies_____________");
foreach (var movie in context.Movies)
{
Console.WriteLine($"'{movie.Name}' - {movie.Director} ({movie.LengthMinutes})");
//foreach (KeyValuePair<string,string> kvp in movie.Top3Actors)
//{
// Console.WriteLine(kvp.Key+" "+kvp.Value);
//}
}
Console.WriteLine("___________________");
}
public static void InsertPaper(string author, string name, PaperType type)
{
var paper = new Paper()
{
Author = author,
Type = type,
Name = name,
};
MediaContext context = new MediaContext();
context.Papers.Add(paper);
context.SaveChanges();
}
public static void InsertBook(string author, string genre, string name, int pages)
{
var book = new Book()
{
Author = author,
Genre = genre,
Name = name,
Pages = pages,
};
MediaContext context = new MediaContext();
context.Books.Add(book);
context.SaveChanges();
}
private static void RemoveMovies(string moviename)
{
//will remove all movies that matche the parameter name
MediaContext context = new MediaContext();
IEnumerable <Movie> moviesToRemove = context.Movies.Where(m => m.Name == moviename);
if (moviesToRemove.Count() == 0)
{
Console.WriteLine("Movie " + moviename + " not present in database");
}
else
{
context.Movies.RemoveRange(moviesToRemove);
context.SaveChanges();
}
}
private static void RemovePaper(string papername)
{
//will only remove first instance of paper found that matches the parameter name
MediaContext context = new MediaContext();
Paper paperToRemove = context.Papers.Where(p => p.Name == papername).FirstOrDefault();
if (paperToRemove == null)
{
Console.WriteLine("Paper " + papername + " not present in database");
}
else
{
context.Papers.Remove(paperToRemove);
context.SaveChanges();
}
}
public static void InsertMovie(string director, string genre, string name, int lengthMinutes)
{
var movie = new Movie()
{
Director = director,
Genre = genre,
Name = name,
LengthMinutes = lengthMinutes,
//top3actors dictionary not supported by EF
};
MediaContext context = new MediaContext();
context.Movies.Add(movie);
context.SaveChanges();
}
private static void RemoveBooks(string bookname)
{
//will remove all books that matche the parameter name
MediaContext context = new MediaContext();
IEnumerable <Book> booksToRemove = context.Books.Where(b => b.Name == bookname);
if (booksToRemove.Count() == 0)
{
Console.WriteLine("Book " + bookname + " not present in database");
}
else
{
Console.WriteLine("Book(s) with name " + bookname + " successfully removed");
context.Books.RemoveRange(booksToRemove);
context.SaveChanges();
}
}
static void Main(string[] args)
{
MediaContext mc = new MediaContext();
mc.Books.Add(new Book()
{
Name = "I am Ivan", Author = "ivan prgomet", Genre = "Drama", Pages = 560
});
mc.Movies.Add(new Movie()
{
Name = "Don't Breathe",
Top3Actors = new Dictionary <string, string>
{
{ "Stephen Lang", "The Blind Man" },
{ "Jane Levy", "Rocky" },
{ "Dylan Minnette", "Alex" },
}
});
mc.Papers.Add(new Paper()
{
Type = PaperType.Essay, Author = "Ralph Waldo Emerson", Name = "Fate"
});
//mc.SaveChanges();
//CRUD
//InsertBook("authordemo", "action", "title", 999);
//InsertMovie("ivano prgometo", "action", "some cool title", 120);
//InsertPaper("ivan emeroson", "life", PaperType.Essay);
//RemoveBooks("title");
//RemoveMovies("some cool title");
//RemovePaper("life");
QueryBooks(mc);
QueryMovies(mc);
QueryPapers(mc);
}
