public void Init()
{
AddAuthor(new Author()
{
FullName = "Gorge stafford"
});
AddAuthor(new Author()
{
FullName = "Gene Kim"
});
AddAuthor(new Author()
{
FullName = "Jez Humble"
});
AddAuthor(new Author()
{
FullName = "Nuddy man"
});
AddUser(new User()
{
Name = "Kostya"
});
AddUser(new User()
{
Name = "Chack"
});
AddUser(new User()
{
Name = "Jackie"
});
AddBook(new Book()
{
BookName = "The DevOps Handbook", Pages = 512
});
AddBook(new Book()
{
BookName = "Lean Enterprise", Pages = 256
});
AddBook(new Book()
{
BookName = "Very not interesting book", Pages = 2048
});
using (EntityModelContainer db = new EntityModelContainer()) {
Book book = db.BookSet.FirstOrDefault(b => b.BookName == "The DevOps Handbook");
book.Author.Add(db.AuthorSet.FirstOrDefault(a => a.FullName == "Gene Kim"));
book.Author.Add(db.AuthorSet.FirstOrDefault(a => a.FullName == "Jez Humble"));
book.UserId = db.UserSet.FirstOrDefault(u => u.Name == "Chack").Id;
book = db.BookSet.FirstOrDefault(b => b.BookName == "Lean Enterprise");
book.Author.Add(db.AuthorSet.FirstOrDefault(a => a.FullName == "Gene Kim"));
book.Author.Add(db.AuthorSet.FirstOrDefault(a => a.FullName == "Gorge stafford"));
book.UserId = db.UserSet.FirstOrDefault(u => u.Name == "Chack").Id;
book = db.BookSet.FirstOrDefault(b => b.BookName == "Very not interesting book");
book.Author.Add(db.AuthorSet.FirstOrDefault(a => a.FullName == "Nuddy man"));
db.SaveChanges();
}
}
public void PrintAllBook()
{
using (EntityModelContainer db = new EntityModelContainer())
{
foreach (Book book in db.BookSet)
{
Console.WriteLine(book.BookName);
}
}
}
public void PrintAllUsers()
{
using (EntityModelContainer db = new EntityModelContainer())
{
foreach (User user in db.UserSet)
{
Console.WriteLine(user.Name);
}
}
}
public void PrintAllAuthors()
{
using (EntityModelContainer db = new EntityModelContainer())
{
foreach (Author author in db.AuthorSet)
{
Console.WriteLine(author.FullName);
}
}
}
public Book GetBook(string bookName)
{
Book find = null;
using (EntityModelContainer db = new EntityModelContainer())
{
find = db.BookSet.FirstOrDefault(a => a.BookName == bookName);
}
return(find);
}
public User GetUser(string userName)
{
User find = null;
using (EntityModelContainer db = new EntityModelContainer())
{
find = db.UserSet.FirstOrDefault(a => a.Name == userName);
}
return(find);
}
public Author GetAuthor(string authorName)
{
Author find = null;
using (EntityModelContainer db = new EntityModelContainer())
{
find = db.AuthorSet.FirstOrDefault(a => a.FullName == authorName);
}
Console.WriteLine($"find author : {find.FullName} ");
return(find);
}
public void AddUser(User user)
{
using (EntityModelContainer db = new EntityModelContainer())
{
User a = db.UserSet.FirstOrDefault(au => au.Name == user.Name);
if (a == null)
{
db.UserSet.Add(user);
db.SaveChanges();
}
else
{
Console.WriteLine($"Author {user.Name} is exists");
}
}
}
public void AddBook(Book book)
{
using (EntityModelContainer db = new EntityModelContainer())
{
Book a = db.BookSet.FirstOrDefault(ent => ent.BookName == book.BookName);
if (a == null)
{
db.BookSet.Add(book);
db.SaveChanges();
}
else
{
Console.WriteLine($"Book {book.BookName} is exists");
}
}
}
public void AddAuthor(Author author)
{
using (EntityModelContainer db = new EntityModelContainer())
{
Author a = db.AuthorSet.FirstOrDefault(au => au.FullName == author.FullName);
if (a == null)
{
db.AuthorSet.Add(author);
db.SaveChanges();
Console.WriteLine($"added author : {author.FullName} ");
}
else
{
Console.WriteLine($"Author {author.FullName} is exists");
}
}
}
static void Main(string[] args)
{
Library lib = new Library();
lib.Init();
Console.WriteLine("\n1) Выведите список должников. \n");
using (EntityModelContainer db = new EntityModelContainer())
{
List <User> users = db.UserSet.ToList().Where(u => u.Book.Count != 0)?.ToList() ?? null;
foreach (User user in users)
{
Console.WriteLine(user.Name);
}
}
Console.WriteLine("\n2) Выведите список авторов книги №3 (по порядку из таблицы ‘Book’). \n");
using (EntityModelContainer db = new EntityModelContainer())
{
Book[] books = db.BookSet.ToArray();
foreach (Author author in books[2].Author)
{
Console.WriteLine(author.FullName);
}
}
Console.WriteLine("\n3) Выведите список книг, которые доступны в данный момент. \n");
using (EntityModelContainer db = new EntityModelContainer())
{
var books = db.BookSet.ToList().Where(b => b.UserId == null);
foreach (Book book in books)
{
Console.WriteLine(book.BookName);
}
}
Console.WriteLine("\n4) Вывести список книг, которые на руках у пользователя №2 \n");
using (EntityModelContainer db = new EntityModelContainer())
{
var boo = db.BookSet.ToList();
var books = db.BookSet.ToList().Where(b => b.User?.Name == "Chack");
foreach (Book book in books)
{
Console.WriteLine(book.BookName);
}
}
Console.WriteLine("\n5) Обнулите задолженности всех должников. \n");
using (EntityModelContainer db = new EntityModelContainer())
{
var books = db.BookSet.ToList().Where(b => b.UserId != null);
foreach (Book book in books)
{
book.UserId = null;
}
db.SaveChanges();
}
Console.WriteLine("\n1) Выведите список должников. \n");
using (EntityModelContainer db = new EntityModelContainer())
{
List <User> users = db.UserSet.ToList().Where(u => u.Book.Count != 0)?.ToList() ?? null;
foreach (User user in users)
{
Console.WriteLine(user.Name);
}
}
}
