private static void AddMember()
{
var context = new BookClubContext();
string firstName = "";
string lastName = "";
string exit = "Continue";
DateTime birthDate = new DateTime(0);
while (exit != "exit" && exit != "EXIT")
{
Console.WriteLine("Please enter your firstname");
firstName = Console.ReadLine();
Console.WriteLine("Please enter your lastname");
lastName = Console.ReadLine();
Console.WriteLine("Please enter your Birthdate yyyy,mm,dd");
birthDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Write exit to stop input of new Members");
exit = Console.ReadLine();
var member = new Member {
FirstName = firstName, LastName = lastName, RegistrationDate = DateTime.Now, BirthDate = birthDate
};
context.Add(member);
context.SaveChanges();
}
}
private async static void FindBookByTitleAsync(string title)
{
var context = new BookClubContext();
var book = await context.Books.FirstOrDefaultAsync(a => a.Title.StartsWith(title));
Console.WriteLine("Bokinformation: {0} ISBN {1} ", book.Title, book.ISBN);
}
private static void AddReservedBook()
{
var context = new BookClubContext();
string firstName = "Morgan";
string lastName = "Berglund";
string bookTitle = "Djunglebook";
var member = context.Members.FirstOrDefault(a => a.FirstName.StartsWith(firstName) && a.LastName.StartsWith(lastName));
var book = context.Books.FirstOrDefault(b => b.Title.StartsWith(bookTitle));
if (member.FirstName != null && book.Title != null)
{
var borroweBook = new BorrowedBook {
MemberId = member.Id, BookId = book.Id
};
context.Add(borroweBook);
context.SaveChanges();
Console.WriteLine("Member {0} {1} loaned the book {2}", member.FirstName, member.LastName, book.Title);
}
else
{
Console.WriteLine("Book or member not found.");
}
}
private static void DeleteMember()
{
var context = new BookClubContext();
var member = context.Members.Find(1);
context.Members.Remove(member);
context.SaveChanges();
}
public AppController(
IMailService mailService,
BookClubContext context,
IBookClubRepository repo)
{
_context = context;
_mailService = mailService;
_repository = repo;
}
private static void AddPublisher()
{
var context = new BookClubContext();
var publisher = new Publisher {
CompanyName = "William Collins", PublishDate = new DateTime(2013)
};
context.Add(publisher);
context.SaveChanges();
}
private static void AddCategory()
{
var context = new BookClubContext();
var category = new BookCategory {
Name = "Fiction"
};
context.Add(category);
context.SaveChanges();
}
private static void AddAuthor()
{
var context = new BookClubContext();
var author = new Author {
FirstName = "Lewis", LastName = "Carol", BirthDate = new DateTime(1832, 01, 27), Nationality = "United Kingdom"
};
context.Add(author);
context.SaveChanges();
}
//RawSQL
private static void AddBook()
{
var context = new BookClubContext();
int authorId = 1;
long isbn = 123123141214;
string title = "Djunglebook";
int publisherId = 1;
context.Database.ExecuteSqlCommand($"INSERT INTO Books (AuthorId,ISBN,PublisherId,Title) VALUES({authorId},{isbn},{publisherId},{title})");
}
private static void AddBookNotRaw()
{
var context = new BookClubContext();
string title = "";
long isbn = 0;
int authorId = 0;
int publisherId = 0;
var book = new Book {
Title = title, ISBN = isbn, AuthorId = authorId, PublisherId = publisherId
};
}
public GroupMembersController(
BookClubContext ctx,
IBookClubRepository repository,
ILogger <BooksController> logger,
IMapper mapper,
UserManager <Member> userManager)
{
_ctx = ctx;
_repository = repository;
_logger = logger;
_mapper = mapper;
_userManager = userManager;
}
private static void FindBookByAuthorRaw(string name)
{
var context = new BookClubContext();
var author = context.Authors
.FromSql("SELECT Authors.Id, FirstName, LastName, BirthDate, Nationality FROM dbo.Authors " +
"WHERE Authors.FirstName LIKE '" + @name + "%'")
.ToList();
foreach (var a in author)
{
Console.WriteLine("Author: {0} {1} Born {2}", a.FirstName, a.LastName, a.Nationality, a.BirthDate);
}
}
private static void FindMember(string firstName, string lastName)
{
var context = new BookClubContext();
try
{
var member = context.Members.FirstOrDefault(a => a.FirstName.StartsWith(firstName) && a.LastName.StartsWith(lastName));
Console.WriteLine("Member found name: {0} {1} \n Birthdate: {2} \n member since: {3} ", member.FirstName, member.LastName, member.BirthDate, member.RegistrationDate);
}
catch (NullReferenceException)
{
Console.WriteLine("Member not found.");
}
}
public AccountController(UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, BookClubContext db)
{
_db = db;
_userManager = userManager;
_signInManager = signInManager;
}
public CommentsController(BookClubContext context)
{
_context = context;
}
public BooksController(BookClubContext context)
{
_context = context;
}
public AuthorsController(BookClubContext db)
{
_db = db;
}
public BookDataService()
{
Context = new BookClubContext();
Context.PropertyChanged += ContextPropertyChanged;
}
public GenresController(BookClubContext db)
{
_db = db;
}
public BooksController(BookClubContext db)
{
_db = db;
}
public HomeController(BookClubContext db)
{
_db = db;
}
public BookDataService()
{
Context = new BookClubContext();
Context.PropertyChanged += ContextPropertyChanged;
}
