public static Book GetBookbyISBN(string ISBN) { using (BooksDB entities = new BooksDB()) { return(entities.Books.Where(x => x.ISBN == ISBN).FirstOrDefault()); //todo } }
public static Category GetCategorybyID(int CateogryID) { using (BooksDB entities = new BooksDB()) { return(entities.Categories.Where(x => x.CategoryID == CateogryID).FirstOrDefault()); //todo } }
public static Book GetBookbyID(int BookID) { using (BooksDB entities = new BooksDB()) { return(entities.Books.Where(x => x.BookID == BookID).FirstOrDefault()); //todo } }
public static List <Book> GetBooks() { using (BooksDB entities = new BooksDB()) { return(entities.Books.Take(4).ToList <Book>()); //todo } }
public static List <Category> GetAllCategories() { using (BooksDB entities = new BooksDB()) { return(entities.Categories.ToList <Category>()); //todo } }
public static List <Book> GetAllBooks() { using (BooksDB entities = new BooksDB()) { return(entities.Books.ToList <Book>()); } }
public static List <OrderHeader> GetUserOrders() { using (BooksDB entities = new BooksDB()) { MembershipUser user = Membership.GetUser(); Guid UserID = (Guid)user.ProviderUserKey; string userid = UserID.ToString(); //todo return(entities.OrderHeaders.Where(x => x.UserID == userid).ToList <OrderHeader>()); //todo } }
public static List <Book> SearchBookByName(string name) { string searchName = name.Replace(" ", "").ToLower(); List <Book> searchResult = new List <Book>(); using (BooksDB entities = new BooksDB()) { searchResult = entities.Books.Where(x => x.Title.Contains(name)).ToList <Book>(); } return(searchResult); }
public static double GetBookPrice(int BookID) { double price = 0; try { using (BooksDB entities = new BooksDB()) { price = (double)entities.Books.Where(d => d.BookID == BookID).Select(x => x.Price).FirstOrDefault(); } return(price); } catch { return(0); } }
public static double GetDiscountPercent(int BookID) { double discount = 0; try { using (BooksDB entities = new BooksDB()) { discount = (double)entities.Discounts.Where(d => d.BookID == BookID).Select(x => x.DiscountPercent).FirstOrDefault(); } return(discount); } catch { return(0); } }
public static int GetDiscountID(int BookID) { int discountid = -1; try { using (BooksDB entities = new BooksDB()) { discountid = entities.Discounts.Where(d => d.BookID == BookID).Select(x => x.DiscountID).FirstOrDefault(); } return(discountid); } catch { return(-1); } }
public static void UpdateBook(Book book) { BooksDB bdb = new BooksDB(); Book b = bdb.Books.Where(x => x.BookID == book.BookID).First(); b.Title = book.Title; b.Price = book.Price; b.Stock = book.Stock; b.Author = book.Author; b.BookID = book.BookID; b.CategoryID = book.CategoryID; b.ISBN = book.ISBN; //b.Title = b.Title.Replace(s, title); bdb.SaveChanges(); }
protected void btnPay_Click(object sender, EventArgs e) { OrderHeader order = new OrderHeader(); order.OrderDate = DateTime.Today; order.Total = (decimal)total; MembershipUser user = Membership.GetUser(); Guid UserID = (Guid)user.ProviderUserKey; order.UserID = UserID.ToString(); //order.UserID = ""; //todo order.Address = txtAddress.Text; order.Email = txtEmail.Text; order.PostalCode = Convert.ToInt32(txtPostCode.Text); order.Name = txtName.Text; using (BooksDB entities = new BooksDB()) { entities.OrderHeaders.Add(order); entities.SaveChanges(); foreach (OrderDetail orddet in lstOD) { OrderDetail odet = new OrderDetail(); odet.Qty = orddet.Qty; odet.UnitPrice = orddet.UnitPrice; odet.NetPrice = orddet.NetPrice; odet.BookID = orddet.BookID; odet.DiscountID = orddet.DiscountID; odet.OrderID = order.OrderID; entities.OrderDetails.Add(odet); Book b = new Book(); b = entities.Books.Where(x => x.BookID == odet.BookID).FirstOrDefault(); //todo b.Stock -= odet.Qty; entities.SaveChanges(); } } Session["cart_items"] = null; Response.Redirect("ConfirmOrder.aspx?orderid=" + order.OrderID); }
public static void AddOrder(OrderHeader o, List <OrderDetail> od) { using (BooksDB entities = new BooksDB()) { entities.OrderHeaders.Add(o); entities.SaveChanges(); foreach (OrderDetail orddet in od) { OrderDetail odet = new OrderDetail(); odet.Qty = orddet.Qty; odet.UnitPrice = orddet.UnitPrice; odet.NetPrice = orddet.NetPrice; odet.BookID = orddet.BookID; odet.DiscountID = orddet.DiscountID; odet.OrderID = o.OrderID; entities.OrderDetails.Add(odet); } entities.SaveChanges(); } }