public void updateStock(int id, int newStock, decimal discount) { Book theBook = RetrieveByID(id); theBook.Stock = newStock; theBook.Discount = discount; context.SaveChanges(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int bookId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); var id = ctx.Books.Where(x => x.BookID == bookId).FirstOrDefault(); ctx.Books.Remove(id); ctx.SaveChanges(); BindGrid(); }
public static void AddCart(string userID, int bookID, int quantity) { CartDetail cart = new CartDetail(); cart.BookID = bookID; cart.UserID = userID; cart.BookQuant = quantity; Mybooks.CartDetails.Add(cart); Mybooks.SaveChanges(); }
public bool Checkout(string userID, string mailingAddress, DateTime orderDate, decimal totalPrice, ShoppingCart shoppingCart) { using (BookshopEntities context = new BookshopEntities()) { //Create Order Order order = new Order(); int userIDHolder; bool validUserID = Int32.TryParse(userID, out userIDHolder); order.MailingAddress = mailingAddress; order.OrderDate = orderDate; order.TotalPrice = Convert.ToDouble(totalPrice); if (validUserID) { try { order.UserID = userIDHolder; context.Orders.Add(order); context.SaveChanges(); //Create OrderDetails from CartItems foreach (CartItem item in shoppingCart.Cart) { OrderDetail orderDetail = new OrderDetail(); orderDetail.BookID = Convert.ToInt16(item.BookID); orderDetail.Quantity = Convert.ToInt16(item.Quantity); orderDetail.UnitPrice = Convert.ToDouble(item.UnitPrice); orderDetail.SubtotalPrice = Convert.ToDouble(item.SubTotal); context.OrderDetails.Add(orderDetail); } context.SaveChanges(); //Clear ShoppingCart shoppingCart.Clear(); return(true); } catch (Exception e) { return(false); } } else { return(false); } } }
public int BuyCart(List <Book> list, string usernm, Guid id, double price) // need to change { BookshopEntities context = new BookshopEntities(); IssueTran tran = new IssueTran(); tran.UserId = id; tran.DateTimePurchased = DateTime.Now; tran.TotalPrice = Decimal.Parse(price.ToString()); context.IssueTrans.Add(tran); foreach (Book b in list) { IssueTransBookList transbook = new IssueTransBookList(); transbook.TransactionID = tran.TransactionID; transbook.BookID = b.BookID; transbook.Quantity = b.Stock; context.IssueTransBookLists.Add(transbook); Book xe = context.Books.Where(x => x.BookID == transbook.BookID).First(); if (xe.Stock < b.Stock) { return(-1); } xe.Stock -= b.Stock; } context.SaveChanges(); return(tran.TransactionID); }
public bool AddBook(string title, string cat, string isbn, string author, int stock, decimal price) { be = new BookshopEntities(); book = new Book(); category = new Category(); try { book.Title = title; book.ISBN = isbn; book.Author = author; book.Stock = stock; book.Price = price; var c = be.Categories.Where(x => x.CategoryName == cat).Select(x => x.CategoryID).First(); book.CategoryID = c; be.Books.Add(book); be.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { try { GridViewRow row = bListView.Rows[e.RowIndex]; int BookID = Convert.ToInt32(bListView.DataKeys[e.RowIndex].Values[0]); string stock = (row.FindControl("TextBox4") as TextBox).Text; string price = (row.FindControl("TextBox5") as TextBox).Text; string discount = (row.FindControl("TextBox6") as TextBox).Text; using (BookshopEntities entities = new BookshopEntities()) { Book b = entities.Books.Where(x => x.BookID == BookID).First(); b.Stock = Convert.ToInt32(stock); b.Price = Convert.ToDecimal(price); b.Discount = Convert.ToInt32(discount); entities.SaveChanges(); bListView.EditIndex = -1; bListView.DataSource = entities.Books.Where(p => p.BookID == BookID).ToList <Book>(); bListView.DataBind(); } } catch (Exception eer) { Console.WriteLine(eer.Message); } }
public bool RegisterUser(string user, string password) { using (BookshopEntities context = new BookshopEntities()) { if (user != null && password != null) { if (context.Users.Where(x => x.UserName == user).Count() == 0) { //Verify that user is not currently taken User u = new User(); u.UserName = user; u.Password = password; u.UserType = "Customer"; context.Users.Add(u); context.SaveChanges(); return(true); } else { return(false); } } else { return(false); } } }
public static void UpdateBook(Book b) { using (BookshopEntities m = new BookshopEntities()) { m.Entry(b).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); } }
public static void InsertBook(Book b) { using (BookshopEntities m = new BookshopEntities()) { m.Books.Add(b); m.SaveChanges(); } }
public static void UpdateQuant(string title, int bookQuant, string userID) { using (BookshopEntities context = new BookshopEntities()) { CartDetail cd = context.CartDetails.Where(cdetail => cdetail.Book.Title == title && cdetail.UserID == userID).First(); cd.BookQuant = bookQuant; context.SaveChanges(); } }
public static void DeleteCartItem(string title, string userID) { using (BookshopEntities context = new BookshopEntities()) { CartDetail cd = context.CartDetails.Where(cdetail => cdetail.Book.Title == title && cdetail.UserID == userID).First(); context.CartDetails.Remove(cd); context.SaveChanges(); } }
public static void DeleteBook(int bookId) { using (BookshopEntities entities = new BookshopEntities()) { Book book = entities.Books.Where(b => b.BookID == bookId).First <Book>(); entities.Books.Remove(book); entities.SaveChanges(); } }
public void Update(WCFBook b) { Book book = context.Books.Where(x => x.BookID == b.BookID).First(); book.CategoryID = b.CategoryID; book.Author = b.Author; book.ISBN = b.ISBN; book.Price = b.Price; book.Stock = b.Stock; book.Title = b.Title; context.SaveChanges(); }
public static void UpdateBook(int bookId, string stock, string price, string discount) { using (BookshopEntities entities = new BookshopEntities()) { Book book = entities.Books.Where(p => p.BookID == bookId).First <Book>(); book.Stock = Int32.Parse(stock); book.Price = Decimal.Parse(price); book.Discount = Decimal.Parse(discount); entities.SaveChanges(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { Page.Validate("Submit"); if (Page.IsValid) { int id = Convert.ToInt32(tbxBookID.Text); var updateBook = ctx.Books.SingleOrDefault(x => x.BookID == id); if (updateBook != null) { updateBook.BookID = int.Parse(tbxBookID.Text); updateBook.CategoryID = int.Parse(ddlBookCategory.SelectedValue); updateBook.ISBN = tbxISBN.Text; updateBook.Price = Convert.ToDecimal(tbxPrice.Text); updateBook.Stock = int.Parse(tbxStock.Text); updateBook.Title = tbxBookTitle.Text; updateBook.Author = tbxAuthor.Text; } ctx.Books.AddOrUpdate(updateBook); ctx.SaveChanges(); Response.Redirect("BookSummaries.aspx"); } }
public static bool MakeOrder(string userID, string realUserID) { try { using (BookshopEntities context = new BookshopEntities()) { Order o = new Order(); o.UserID = realUserID; o.OrderDate = DateTime.Today; //Cart c = context.Carts.Where(cart => cart.UserID == userID).First(); List <CartDetail> cdList = context.CartDetails.Where(cdetail => cdetail.UserID == userID).ToList(); foreach (CartDetail cd in cdList) { OrderDetail od = new OrderDetail(); od.Order = o; od.BookID = (int)cd.BookID; od.Quantity = (int)cd.BookQuant; context.OrderDetails.Add(od); Book b = context.Books.Where(book => book.BookID == cd.BookID).First(); b.Stock = b.Stock - (int)cd.BookQuant; context.SaveChanges(); } context.CartDetails.RemoveRange(cdList); context.SaveChanges(); //context.Carts.Remove(c); //context.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public bool DeleteBook(string isbn) { try { be = new BookshopEntities(); Book b = be.Books.Where(x => x.ISBN == isbn).First(); be.Books.Remove(b); be.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public void minusStock(CartList cl) { BookshopEntities bookshop = new BookshopEntities(); List <Cart> cart = cl.getCl(); for (int i = 0; i < cart.Count; i++) { Cart c = cart[i]; Book b = bookshop.Books.Find(c.b.BookID); int bookstock = 1; bookstock = b.Stock - 1; b.Stock = bookstock; bookshop.SaveChanges(); } }
public static void AddBook(string title, string isbn, string categoryName, string author, int stock, decimal price, decimal discount) { using (BookshopEntities entities = new BookshopEntities()) { Book book = new Book { Title = title, ISBN = isbn, CategoryID = getCategoryID(categoryName), Author = author, Stock = stock, Price = price, Discount = discount }; entities.Books.Add(book); entities.SaveChanges(); } }
protected void creBkBtn_Click(object sender, EventArgs e) { int number; double dou; bool result = Int32.TryParse(catIDTB.Text, out number); bool result2 = Int32.TryParse(isbnTB.Text, out number); bool result3 = Int32.TryParse(stockTB.Text, out number); bool result4 = Double.TryParse(priceTB.Text, out dou); bool result5 = Int32.TryParse(discountTB.Text, out number); if (result && result2 && result3 && result4 && result5 == true) { BookshopEntities bInsert = new BookshopEntities(); Book c = new Book(); c.Title = bkTitleTB.Text; c.CategoryID = Convert.ToInt32(catIDTB.Text); c.ISBN = isbnTB.Text; c.Author = authorTB.Text; c.Stock = Convert.ToInt32(stockTB.Text); c.Price = Convert.ToDecimal(priceTB.Text); c.Discount = Convert.ToInt32(discountTB.Text); bInsert.Books.Add(c); bInsert.SaveChanges(); Session.Add("newisbn", isbnTB.Text); } else { Session.Add("newisbn", ""); } if (Session["newisbn"] != null && Session["newisbn"].ToString() != "") { Label11.Text = Session["newisbn"].ToString() + " Has been added successfully"; } else { Label11.Text = ""; } }
public void UpdateBook(string isbn, string bookCategory, string title, string author, string price, string stock) { using (BookshopEntities context = new BookshopEntities()) { Book b = context.Books.Where(x => x.ISBN == isbn).First(); b.CategoryID = context.Categories.Where(x => x.CategoryName == bookCategory).Select(y => y.CategoryID).First(); b.Title = title; b.Author = author; decimal newPrice; bool validPrice = Decimal.TryParse(price, out newPrice); int newStock; bool validStock = Int32.TryParse(stock, out newStock); if (validPrice && validStock) { b.Price = newPrice; b.Stock = newStock; context.SaveChanges(); } } }