public static List <Title> SearchForTitles(string searchText)
{
using (var ctx = new BooksEntities1())
{
List <Title> titleSearch = ctx.Titles.Where(t => t.Title1.Contains(searchText)).ToList();
return(titleSearch);
}
}
private void PopupateSearchAuthorsResultGridView()
{
using (var ctx = new BooksEntities1())
{
var authorsQuery = MyHelpers.SearchForAnAuthor(txtAuthorSearchText.Text);
authorsResultGridView.DataSource = authorsQuery;
authorsResultGridView.DataBind();
}
}
public static List <Author> SearchForAnAuthor(string searchText)
{
using (var ctx = new BooksEntities1())
{
List <Author> authorSearch =
ctx.Authors.Where(a => a.FirstName.Contains(searchText) || a.LastName.Contains(searchText)).ToList();
return(authorSearch);
}
}
public static List <Title> PopulateGridviewWithBooksFromASelectedAuthor(string id)
{
using (var ctx = new BooksEntities1())
{
ctx.Authors.Load();
var populateGridviewWithBooks = ctx.Authors.Local.Where(a => a.AuthorID == Convert.ToInt32(id)).First();
var bookQuery = populateGridviewWithBooks.Titles.OrderBy(t => t.Title1).ToList();
return(bookQuery);
}
}
public static Author AddAuthor(string firstName, string lastName, string country)
{
using (var ctx = new BooksEntities1())
{
Author newAuthor = new Author();
newAuthor.FirstName = firstName;
newAuthor.LastName = lastName;
newAuthor.CountryOfResidence = country;
ctx.Authors.Add(newAuthor);
ctx.SaveChanges();
return(newAuthor);
}
}
private void LoadDropDownMenu()
{
//Todo: Get all authors and bind them to the dropdown menu
using (var ctx = new BooksEntities1())
{
ctx.Authors.Load();
var authorsQuery = ctx.Authors.Local.OrderBy(a => a.LastName).ThenBy(a => a.FirstName).
Select(a => new
{
Name = a.LastName + "," + a.FirstName, a.AuthorID
});
authorsDropDownList.DataValueField = "AuthorID";
authorsDropDownList.DataTextField = "Name";
authorsDropDownList.DataSource = authorsQuery;
authorsDropDownList.DataBind();
}
}
