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();
}
}
}