//For browse Page //To list all books public static List <Book> ListAllBooks() { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.ToList <Book>()); } }
public static void CheckOut(string UName, int bookid, int quantity, float fprice) { int LastOrderID; int g; using (TransactionScope Ts = new TransactionScope()) { LastOrderID = GetLastOrderID() + 1; //To add order using (BookshopModel entities = new BookshopModel()) { OrderDetail order = new OrderDetail() { OrderID = LastOrderID, UserName = UName, BookID = bookid, Quantity = quantity, finalprice = (decimal)fprice, Totalprice = (decimal)(quantity * (decimal)fprice) }; entities.OrderDetails.Add(order); var q = from x in entities.Books where x.BookID == bookid select x; Book b = q.First(); g = (int)b.Stock; g = g - quantity; b.Stock = g; entities.SaveChanges(); } Transaction.Current.TransactionCompleted += new TransactionCompletedEventHandler(Current_TransactionCompleted); Ts.Complete(); } }
//For browse Page //To sort Booklist by Price descending public static List <Book> SortBooksByPriceDesc() { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.OrderByDescending(x => x.Price).ToList <Book>()); } }
public static List <OrderDetail> SortOrderID() { using (BookshopModel entities = new BookshopModel()) { return(entities.OrderDetails.OrderByDescending(x => x.OrderID).ToList <OrderDetail>()); } }
protected void Button1_Click(object sender, EventArgs e) { using (BookshopModel ctx = new BookshopModel()) { var q = ctx.Books.Where(x => x.Title.Contains(TextBox1.Text)); GridView1.DataSource = q.ToList <Book>(); GridView1.DataBind(); } }
//For CheckOut Page public static int GetLastOrderID() { using (BookshopModel entities = new BookshopModel()) { var q = SortOrderID(); OrderDetail b = q.First(); return(b.OrderID); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (BookshopModel b = new BookshopModel()) { GridView1.DataSource = b.Books.ToList <Book>(); GridView1.DataBind(); var q = b.Categories.Select(x => x.Name).ToList(); foreach (Category x in b.Categories) { DropDownList1.Items.Add(x.Name); } } } }
protected void GenerateGrid() { using (BookshopModel b = new BookshopModel()) { if (DropDownList1.SelectedValue != "0") { string category = DropDownList1.SelectedItem.Text.ToString(); var q = from x in b.Books where x.Category.Name == DropDownList1.SelectedValue.ToString() select x; GridView1.DataSource = q.ToList <Book>(); GridView1.DataBind(); } else { GridView1.DataSource = b.Books.ToList <Book>(); GridView1.DataBind(); } } }
// For View Details Page //To View Details (use selected book ID as input argument) public static List <Book> ListBookDetails(int BID) { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.Where(p => p.BookID == BID).ToList <Book>()); } }
//For browse Page //To sort Booklist by title ascending public static List <Book> SortBooksByTitle() { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.OrderBy(x => x.Title).ToList <Book>()); } }
//For browse Page //To search/list by CategoryName (use dropdown selected index) public static List <Book> SearchByCategory(int CID) { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.Where(p => p.CategoryID == (CID + 1)).ToList <Book>()); } }
//For browse Page //To search/list by required Author public static List <Book> SearchByBookAuthor(string name) { using (BookshopModel entities = new BookshopModel()) { return(entities.Books.Where(p => p.Author.Contains(name)).ToList <Book>()); } }
//To display Order details for Confirmation Page public static List <OrderDetail> DisplayOrder(int OID) { using (BookshopModel entities = new BookshopModel()) { return(entities.OrderDetails.Where(p => p.OrderID == OID).ToList <OrderDetail>()); } }