public static List <Book> ListBooksBy()
{
using (MyBooks entities = new MyBooks())
{
return(entities.Books.ToList <Book>());
}
}
public static Book getBookByID(int bookID)
{
using (MyBooks entities = new MyBooks())
{
return(entities.Books.Where
(x => x.BookID == bookID).ToList <Book>()[0]);
}
}
public static void DeleteBooks(string title)
{
using (MyBooks entities = new MyBooks())
{
Book book = entities.Books.Where(z => z.Title == title).First <Book>();
entities.Books.Remove(book);
entities.SaveChanges();
}
}
protected void AllBooksBtn_Click(object sender, EventArgs e)
{
using (MyBooks mb = new MyBooks())
{
var q = from x in mb.Books select x;
DataList1.DataSource = q.ToList();
DataList1.DataBind();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int bookID = (int)GridView1.SelectedDataKey.Value;
using (MyBooks entities = new MyBooks())
{
Book book = entities.Books.Where(x => x.BookID == bookID).First <Book>();
DetailsView1.DataSource = new Book[] { book };
DetailsView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (MyBooks mb = new MyBooks())
{
DataList1.DataSource = mb.Books.ToList <Book>();
DataList1.DataBind();
}
}
}
public static void EditInventory(int bookID, string title, int categoryID, string isbn, string author, int stock, decimal price)
{
using (MyBooks entities = new MyBooks())
{
Book book = entities.Books.Where(x => x.BookID == bookID).First <Book>();
book.Title = title;
book.CategoryID = categoryID;
book.ISBN = isbn;
book.Author = author;
book.Stock = stock;
book.Price = price;
entities.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
selectedID = (int)Session["id"];
if (!IsPostBack)
{
ViewState["qty"] = 1;
}
//txQty.Controls[0].Dispose();
qty = (int)ViewState["qty"];
context = new MyBooks();
selectedBook = context.Books.Where(b => b.BookID.Equals(selectedID)).First();
cat = new Category();
cat = context.Categories.Where(c => c.CategoryID.Equals(selectedBook.CategoryID)).First();
display(selectedBook);
bookList = (List <Book>)Session["cart"];
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
using (MyBooks mb = new MyBooks())
{
if (DetailsDL.Text != null && SearchTxt.Text != null && CategoryDL.SelectedValue != null)
{
switch (DetailsDL.SelectedItem.ToString())
{
case "Author":
catid = mb.Categories.Where(x => x.Name == CategoryDL.SelectedValue).Select(x => x.CategoryID).First();
var q = from x in mb.Books where x.Author.Contains(SearchTxt.Text) && x.CategoryID == catid select x;
if (q.Count() != 0)
{
DataList1.DataSource = q.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
case "Title":
catid = mb.Categories.Where(x => x.Name == CategoryDL.SelectedValue).Select(x => x.CategoryID).First();
var q1 = from x in mb.Books where x.Title.Contains(SearchTxt.Text) && x.CategoryID == catid select x;
if (q1.Count() != 0)
{
DataList1.DataSource = q1.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
case "ISBN":
catid = mb.Categories.Where(x => x.Name == CategoryDL.SelectedValue).Select(x => x.CategoryID).First();
var q2 = from x in mb.Books where x.ISBN == (SearchTxt.Text) && x.CategoryID == catid select x;
if (q2.Count() != 0)
{
DataList1.DataSource = q2.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
default:
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
break;
}
}
else if (DetailsDL.SelectedValue != null && SearchTxt.Text == null && CategoryDL.SelectedValue != null)
{
switch (CategoryDL.SelectedItem.ToString())
{
case "children":
catid = mb.Categories.Select(x => x.CategoryID).First();
var q1 = from x in mb.Books where x.CategoryID == catid select x;
if (q1.Count() != 0)
{
DataList1.DataSource = q1.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
case "technical":
catid = mb.Categories.Select(x => x.CategoryID).First();
var q = from x in mb.Books where x.CategoryID == catid select x;
if (q.Count() != 0)
{
DataList1.DataSource = q.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
case "finance":
catid = mb.Categories.Select(x => x.CategoryID).First();
var q2 = from x in mb.Books where x.CategoryID == catid select x;
if (q2.Count() != 0)
{
DataList1.DataSource = q2.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
case "non-fiction":
catid = mb.Categories.Select(x => x.CategoryID).First();
var q3 = from x in mb.Books where x.CategoryID == catid select x;
if (q3.Count() != 0)
{
DataList1.DataSource = q3.ToList();
DataList1.DataBind();
}
else
{
Response.Write("<script>confirm('Record Does Not Exist !!')</script>");
}
break;
}
}
}
}