public ActionResult Index()
{
ReaderRepository rep = new ReaderRepository(AppConfig.ConnectionString);
List <Reader> readers = rep.GetAll();
return(View(readers));
}
public ActionResult Edit(BookStatus model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
bool IsReader = false;
BookStatusRepository rep = new BookStatusRepository(AppConfig.ConnectionString);
ReaderRepository repo = new ReaderRepository(AppConfig.ConnectionString);
List <Reader> readers = repo.GetAll();
BookStatus bookStatus = new BookStatus();
for (int i = 0; i < readers.Count; i++)
{
if (readers[i].Id == model.ReaderId)
{
IsReader = true;
}
}
BookRepository repos = new BookRepository(AppConfig.ConnectionString);
bool IsTitle = false;
List <Book> books = repos.GetAll();
for (int i = 0; i < books.Count; i++)
{
if (books[i].Title == model.Title)
{
IsTitle = true;
}
}
if (IsTitle == true && IsReader == true)
{
bookStatus.Id = model.Id;
bookStatus.Title = model.Title;
bookStatus.ReaderId = model.ReaderId;
bookStatus.BorrowDate = model.BorrowDate;
bookStatus.ReturnDate = model.ReturnDate;
bookStatus.ReturnedDate = model.ReturnedDate;
rep.Save(bookStatus);
return(RedirectToAction("Index"));
}
else if (IsTitle == true && IsReader == false)
{
ViewBag.error = "No Reader with that Id !!!";
return(View());
}
else if (IsTitle == false && IsReader == true)
{
ViewBag.error = "No Book with that Title !!!";
return(View());
}
else
{
ViewBag.error = "Wrong Title and ReaderId !!!";
return(View());
}
}
List <Reader> GetReaders()
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderRepository readerRepository = new ReaderRepository(appContext);
return((List <Reader>)readerRepository.GetAll());
}
}
public ActionResult Index()
{
ReaderRepository repository = new ReaderRepository();
List <Reader> readers = repository.GetAll();
ReaderListViewModel model = new ReaderListViewModel();
model.Readers = readers;
return(View(model));
}
private List <SelectListItem> PopuateReadersList()
{
List <SelectListItem> result = new List <SelectListItem>();
ReaderRepository readerRepo = new ReaderRepository();
List <Reader> readers = readerRepo.GetAll();
foreach (Reader reader in readers)
{
SelectListItem item = new SelectListItem();
item.Value = reader.Id.ToString();
item.Text = $"{reader.firstName} {reader.lastName}";
result.Add(item);
}
return(result);
}
public MainViewController(DbContext dbContext)
{
booksRepo = new BookRepository(dbContext);
readersRepo = new ReaderRepository(dbContext);
authorsRepo = new AuthorRepository(dbContext);
CommandsHandler = new Dictionary <string, Func <MainViewArgs, object> >
{
#region booksCRUD
{
"get_books",
x =>
{
string res = "";
foreach (var book in booksRepo.GetAll())
{
res += (book.ToString() + "\n");
}
return(res);
}
},
{
"get_book",
x =>
{
return(booksRepo.Get(x.BookId).ToString());
}
},
{
"delete_book",
x =>
{
booksRepo.Remove(x.BookId);
return(okMessage);
}
},
{
"insert_book",
x =>
{
booksRepo.CreateOrUpdate(x.Book);
return(okMessage);
}
},
{
"update_book",
x =>
{
booksRepo.CreateOrUpdate(x.Book);
return(okMessage);
}
},
#endregion
#region booksAuthors
{
"AddAuthorToBook",
x =>
{
booksRepo.Get(x.BookId).Authors.Add(authorsRepo.Get(x.AuthorId));
return(okMessage);
}
},
{
"DeleteAuthorFromBook",
x =>
{
booksRepo.Get(x.BookId).Authors.Remove(authorsRepo.Get(x.AuthorId));
return(okMessage);
}
},
{
"GetAuthorsOfBook",
x =>
{
string res = "";
foreach (var author in booksRepo.Get(x.BookId).Authors)
{
res += (author.ToString() + "\n");
}
return(res);
}
},
#endregion
#region booksReaders
{
"AddReaderToBook",
x =>
{
booksRepo.Get(x.BookId).Readers.Add(readersRepo.Get(x.ReaderId));
return(okMessage);
}
},
{
"DeleteReaderFromBook",
x =>
{
booksRepo.Get(x.BookId).Readers.Remove(readersRepo.Get(x.ReaderId));
return(okMessage);
}
},
{
"GetReadersOfBook",
x =>
{
string res = "";
foreach (var reader in booksRepo.Get(x.BookId).Readers)
{
res += (reader.ToString() + "\n");
}
return(res);
}
},
#endregion
#region authorsCRUD
{
"get_authors",
x =>
{
string res = "";
foreach (var author in authorsRepo.GetAll())
{
res += (author.ToString() + "\n");
}
return(res);
}
},
{
"get_author",
x =>
{
return(authorsRepo.Get(x.AuthorId).ToString());
}
},
{
"delete_author",
x =>
{
authorsRepo.Remove(x.AuthorId);
return(okMessage);
}
},
{
"insert_author",
x =>
{
authorsRepo.CreateOrUpdate(x.Author);
return(okMessage);
}
},
{
"update_author",
x =>
{
authorsRepo.CreateOrUpdate(x.Author);
return(okMessage);
}
},
{
"get_authorsbooks",
x =>
{
string res = "";
foreach (var book in authorsRepo.Get(x.AuthorId).Books)
{
res += (book.ToString() + "\n");
}
return(res);
}
},
#endregion
#region readersCRUD
{
"get_readers",
x =>
{
string res = "";
foreach (var reader in readersRepo.GetAll())
{
res += (reader.ToString() + "\n");
}
return(res);
}
},
{
"get_reader",
x =>
{
return(readersRepo.Get(x.ReaderId).ToString());
}
},
{
"delete_reader",
x =>
{
readersRepo.Remove(x.ReaderId);
return(okMessage);
}
},
{
"insert_reader",
x =>
{
readersRepo.CreateOrUpdate(x.Reader);
return(okMessage);
}
},
{
"update_reader",
x =>
{
readersRepo.CreateOrUpdate(x.Reader);
return(okMessage);
}
},
{
"get_readersbooks",
x =>
{
string res = "";
foreach (var book in readersRepo.Get(x.ReaderId).Books)
{
res += (book.ToString() + "\n");
}
return(res);
}
},
#endregion
{
"add_random_authors",
x =>
{
return(GetBooLReturnMessage(authorsRepo.AddRandomAuthorsToDB(x.RandomCount)));
}
},
{
"search_books",
x =>
{
string res = "";
foreach (var book in booksRepo.SearchBooks(x.SearchBookParameters.title, x.SearchBookParameters.minPagesCount, x.SearchBookParameters.maxPagesCount))
{
res += (book.ToString() + "\n");
}
return(res);
}
},
{
"search_authors",
x =>
{
string res = "";
foreach (var author in authorsRepo.SearchAuthors(x.SearchAuthorParameters.Signature, x.SearchAuthorParameters.Name, x.SearchAuthorParameters.MinDate))
{
res += (author.ToString() + "\n");
}
return(res);
}
},
{
"search_readers",
x =>
{
string res = "";
foreach (var reader in readersRepo.SearchReaders(x.SearchReaderParameters.Favouritegenre, x.SearchReaderParameters.Name, x.SearchReaderParameters.Surname))
{
res += (reader.ToString() + "\n");
}
return(res);
}
},
};
}
