public List <Category> CategoryChoice()
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
return(entities.Categories.ToList <Category>());
}
}
public static List <Discount> ListDiscount()
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
return(entities.Discounts.ToList <Discount>());
}
}
public List <Order> ManageOrder_ListOrdersBy(string name)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
return(entities.Orders.Where(p => p.UserName == name).ToList <Order>());
}
}
public List <Book> BookList()
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
return(entities.Books.ToList <Book>());
}
}
//public static void DeleteOrder(int orderID)
//{
// using (Model entities = new Model())
// {
// Order order = entities.Orders.Where(p => p.OrderID == orderID).First<Order>();
// entities.Orders.Remove(order);
// entities.SaveChanges();
// }
//}
public List <Cart> ListOrdersBy(string name)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
return(entities.Carts.Where(x => x.Username == name).ToList());
}
}
public int GetQuantity(int id)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
OrderDetail od = entities.OrderDetails.Where(o => o.OrderID == id).ToList <OrderDetail>()[0];
return((int)od.Quantity);
}
}
public string GetCategoryName(int id)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Category cat = entities.Categories.Where(c => c.CategoryID == id).ToList <Category>()[0];
return(cat.Name);
}
}
protected void Submit_Click(object sender, EventArgs e)
{
using (BookshopEntities1 bl = new BookshopEntities1())
{
//Discount ds = new global::Discount();
//ds.StartDate = StartMonth.TemplateContr
}
}
public void ManageOrder_DeleteOrder(int orderId)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Order order = entities.Orders.Where(p => p.OrderID == orderId).First <Order>();
entities.Orders.Remove(order);
entities.SaveChanges();
}
}
public void DeleteOrder(int bookID)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Book b = entities.Books.Where(p => p.BookID == bookID).First <Book>();
entities.Books.Remove(b);
entities.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
name = Context.User.Identity.Name;
context = new BookshopEntities1();
ISBN = Request.QueryString["ISBN"];
Title = Request.QueryString["Title"];
Price = Request.QueryString["Price"];
Stock = Request.QueryString["Stock"];
}
public void updateOrder(string username, int quantity)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Cart cart = entities.Carts.Where(p => p.Username == username).First <Cart>();
cart.Quantity = quantity;
entities.SaveChanges();
}
}
public static void DeleteDiscount(int discountId)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Discount discount = entities.Discounts.Where(p => p.discountID == discountId).First <Discount>();
entities.Discounts.Remove(discount);
entities.SaveChanges();
}
}
public void deleteOrder(int bookID)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Cart cart = entities.Carts.Where(p => p.BookID == bookID).First <Cart>();
entities.Carts.Remove(cart);
entities.SaveChanges();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int bookID = (int)GridView1.SelectedDataKey.Value;
using (BookshopEntities1 entities = new BookshopEntities1())
{
Cart cart = entities.Carts.Where(p => p.BookID == bookID).First <Cart>();
GridView1.DataSource = new Cart[] { cart };
GridView1.DataBind();
}
}
public void AddOrder(int bookID, int quantity, decimal price)
{
BookshopEntities1 bk = new BookshopEntities1();
Cart ct = new Cart();
ct.BookID = bookID;
ct.Quantity = quantity;
ct.Price = price;
bk.Carts.Add(ct);
bk.SaveChanges();
}
public void CalcVal(decimal Price, int Quantity)
{
try
{
BookshopEntities1 bk = new BookshopEntities1();
Label4.Text = bk.Carts.Where(x => x.Username == name).Sum(x => x.Price * x.Quantity).ToString();
}
catch
{
Console.WriteLine("Nothing in Cart!");
Label4.Text = "0";
}
}
public void UpdateBook(int bookID, string title, string categoryID, string ISBN, string author, string stock, string price)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Book b = entities.Books.Where(p => p.BookID == bookID).First <Book>();
b.Title = title;
b.CategoryID = Int32.Parse(categoryID);
b.ISBN = ISBN;
b.Author = author;
b.Stock = Int32.Parse(stock);
b.Price = Decimal.Parse(price);
entities.SaveChanges();
}
}
public static void AddDiscount(DateTime startDate, DateTime endDate, decimal Discount)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Discount discount = new Discount
{
StartDate = startDate,
EndDate = endDate,
Discount1 = Discount
};
entities.Discounts.Add(discount);
entities.SaveChanges();
}
}
//public static List<Book> BookChoice()
//{
// using (Model entities = new Model())
// {
// return entities.Books.ToList<Book>();
// }
//}
public void UpdateOrder(int orderID,
string userName, DateTime orderDate, decimal price)
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Order order = entities.Orders.Where(p => p.OrderID == orderID).First <Order>();
order.OrderID = orderID;
order.UserName = userName;
order.OrderDate = orderDate;
order.TotalPrice = price;
entities.SaveChanges();
}
}
//public static string GetBookName(int id)
//{
// using (Model entities = new Model())
// {
// Book books = entities.Books.Where(f => f.BookID == id).ToList<Book>()[0];
// return books.Title;
// }
//}
public void AddBook(
string title, int categoryID, string ISBN, string author, int stock, decimal price) // "AddBook METHOD IS NEW "- ALEX
{
using (BookshopEntities1 entities = new BookshopEntities1())
{
Book b = new Book();
b.Title = title;
b.CategoryID = categoryID;
b.ISBN = ISBN;
b.Author = author;
b.Stock = stock;
b.Price = price;
entities.Books.Add(b);
entities.SaveChanges();
}
}
public Boolean CheckUser(string username, string password)
{
using (BookshopEntities1 ctx = new BookshopEntities1())
{
if (ctx.Users.Where(x => x.UserName == username).Count() > 0)
{
if (ctx.Users.Where(x => x.UserName == username).First().Password == password)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
public Boolean CreateAccount(string username, string password, string email, string phone, string address)
{
using (BookshopEntities1 ctx = new BookshopEntities1())
{
if (ctx.Users.Where(x => x.UserName == username).Count() > 0)
{
return(false);
}
else
{
User user = new User();
user.UserName = username;
user.Password = password;
user.Email = email;
user.Phone = phone;
user.Address = address;
user.Role = "User";
ctx.Users.Add(user);
ctx.SaveChanges();
return(true);
}
}
}
