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