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 List <Book> GetBooksByTitle(string title)
{
using (BookshopEntities context = new BookshopEntities())
{
return(context.Books.Where(book => book.Title.Contains(title)).ToList <Book>());
}
}
private List <String> getCategories()
{
using (BookshopEntities entities = new BookshopEntities())
{
return(entities.Categories.Select(c => c.Name).ToList <String>());
}
}
//01 homepage methods
public List <Book> GetAllBooks()
{
using (BookshopEntities context = new BookshopEntities())
{
return(context.Books.ToList <Book>());
}
}
private string getPrice(int bookid)
{
using (BookshopEntities entities = new BookshopEntities())
{
return(entities.Books.Where(b => b.BookID == bookid).Select(s => s.Price).First().ToString());
}
}
public List <Book> GetBooksByCategoryID(int categoryID)
{
using (BookshopEntities context = new BookshopEntities())
{
return(context.Books.Where(book => book.CategoryID == categoryID).ToList <Book>());
}
}
public static List <Book> ListBooks()
{
using (BookshopEntities m = new BookshopEntities())
{
return(m.Books.ToList());
}
}
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);
}
}
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);
}
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);
}
}
protected void bkTitleSBtn_Click(object sender, EventArgs e)
{
BookshopEntities ent = new BookshopEntities();
bListView.DataSource = ent.Books.Where(x => x.Title.Contains(bkTitleSearchB.Text)).ToList();
bListView.DataBind();
}
public List <string> GetCategoryList()
{
using (BookshopEntities context = new BookshopEntities())
{
List <string> catList = context.Categories.Select(x => x.CategoryName).ToList();
return(catList);
}
}
public static void InsertBook(Book b)
{
using (BookshopEntities m = new BookshopEntities())
{
m.Books.Add(b);
m.SaveChanges();
}
}
public static void UpdateBook(Book b)
{
using (BookshopEntities m = new BookshopEntities())
{
m.Entry(b).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
}
}
public User GetUserByUserName(string userName)
{
using (BookshopEntities context = new BookshopEntities())
{
User user = context.Users.Where(x => x.UserName == userName).First();
return(user);
}
}
public static DataTable ListBooksAll()
{
using (BookshopEntities entities = new BookshopEntities())
{
//return entities.Books.Where(p => p.Username == name).ToList<Order>();
return(ConvertListToDataTable(entities.Books.ToList <Book>()));
}
}
public static List <Book> ListBook()
{
using (BookshopEntities b = new BookshopEntities())
{
Console.Write(b.Books.Select <Book, string>(isbn => isbn.ISBN).ToList <string>()[0]);
return(b.Books.ToList <Book>());
}
}
public static DataTable ListBooksByISBN(string isbn)
{
using (BookshopEntities entities = new BookshopEntities())
{
//return entities.Books.Where(p => p.Username == name).ToList<Order>();
return(ConvertListToDataTable(entities.Books.Where(b => b.ISBN.Contains(isbn.Trim())).ToList <Book>()));
}
}
public List <Book> FetchBookList(List <int> selectedBooksNo)
{
List <Book> cartBookList = new List <Book>();
BookshopEntities context = new BookshopEntities();
cartBookList = context.Books.Where(x => selectedBooksNo.Contains(x.BookID)).ToList();
return(cartBookList);
}
public static List <Book> ListBooksBy(string name)
{
using (BookshopEntities entities = new BookshopEntities())
{
//return entities.Books.Where(p => p.Username == name).ToList<Order>();
return(entities.Books.ToList <Book>());
}
}
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();
}
}
protected void ButBuy_Click(object sender, EventArgs e)
{
BookshopEntities context = new BookshopEntities();
string username = User.Identity.Name;
Guid userid = context.aspnet_Users.Where(x => x.UserName == username).First().UserId;
try
{
try
{
int noofbooks = (int)Session["count"];
List <int> selectedbooks = new List <int>();
for (int i = 0; i < noofbooks; i++)
{
selectedbooks.Add(Convert.ToInt32(Session["BookNo" + i.ToString()]));
}
//List<Book> bookListFromCat = (List<Book>)Session["???"]; //check which data type is the info coming from
// BookshopEntities context = new BookshopEntities();
cartBookList = context.Books.Where(x => selectedbooks.Contains(x.BookID)).ToList();
foreach (Book bc in cartBookList)
{
bc.Stock = 0;
foreach (int i in selectedbooks)
{
if (i == bc.BookID)
{
bc.Stock++;
}
}
}
}
catch (NullReferenceException nue)
{ }
ViewCartLogic vcl = new ViewCartLogic();
int tid = vcl.BuyCart(cartBookList, username, userid, vcl.CountPrice(cartBookList));
if (tid == -1)
{
Response.Redirect("/Team13BookShop/Customer/ErrorPage.aspx", false);
Session["count"] = 0;
return;
}
Session.Add("tranid", tid);
}
catch (Exception ex)
{ }
Session["count"] = 0;
Response.Redirect("/Team13BookShop/Customer/Transaction.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (GridViewCartDetails == null)
{
ButBuy.Enabled = false;
}
if (!IsPostBack)
{
string username = User.Identity.Name;
if (!String.IsNullOrEmpty(username))
{
ButLogin.Visible = false;
ButBuy.Enabled = true;
}
try
{
int noofbooks = (int)Session["count"];
List <int> selectedbooks = new List <int>();
for (int i = 0; i < noofbooks; i++)
{
selectedbooks.Add((int)Session["BookNo" + i.ToString()]);
}
BookshopEntities context = new BookshopEntities();
cartBookList = context.Books.Where(x => selectedbooks.Contains(x.BookID)).ToList();
foreach (Book bc in cartBookList)
{
bc.Stock = 0;
foreach (int i in selectedbooks)
{
if (i == bc.BookID)
{
bc.Stock++;
}
}
}
}
catch (NullReferenceException nue)
{
LabErrorMsg.Text = String.Format("You currently do not have any cart items. Please continue shopping!");
}
//for finding datasource from Session State
GridViewCartDetails.DataSource = cartBookList.ToList <Book>();
GridViewCartDetails.DataBind();
ViewCartLogic vcl = new ViewCartLogic();
LabSummaryCart.Text = String.Format("You have {0} items for a total of {1:c} in your cart.", vcl.CountCart(cartBookList), vcl.CountPrice(cartBookList));
LabTotalPrice.Text = vcl.CountPrice(cartBookList).ToString();
}
}
public static Category GetCategory(int catId)
{
using (BookshopEntities category = new BookshopEntities())
{
Category catgry = (from ct in category.Categories
where ct.CategoryID == catId
select ct).First();
return(catgry);
}
}
public static Book GetBookDetails(string id)
{
using (BookshopEntities bookEntity = new BookshopEntities())
{
Book book = (from bk in bookEntity.Books
where bk.ISBN == id
select bk).First();
return(book);
}
}
public static DataTable ListBooksByCategory(string category)
{
int id = getCategoryID(category);
using (BookshopEntities entities = new BookshopEntities())
{
//return entities.Books.Where(p => p.Username == name).ToList<Order>();
return(ConvertListToDataTable(entities.Books.Where(b => b.CategoryID == id).ToList <Book>()));
}
}
protected void OnRowCancelingEdit(object sender, EventArgs e)
{
bListView.EditIndex = -1;
using (BookshopEntities entities = new BookshopEntities())
{
bListView.DataSource = new BookshopEntities().Books.ToList();
bListView.DataBind();
}
}
public static Book GetBook(string id)
{
int bookId = Int32.Parse(id);
using (BookshopEntities m = new BookshopEntities())
{
return(m.Books.Where
(p => p.BookID == bookId).ToList <Book>()[0]);
}
}
static void Main()
{
var db = new BookshopEntities();
var books = db.Books
.Take(3)
.ToList();
foreach (var b in books)
{
Console.WriteLine(b.Title);
}
}
