public ActionResult GetBooksByIds(string bookids) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var bookidArray = bookids.Split(',').Select(_=> int.Parse(_)).ToArray(); var query = data.Books.Where(book => bookidArray.Contains(book.ID)).Select(_ => new { categoryId = _.CategoryId, bookid = _.ID, bookname = _.Name, categoryname = _.Category.Name, imagename = _.ImageName, bookprice = _.Price, }); var result = query.ToList(); return Json(new { success = true, results = result }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult Register(string username, string password) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var user = data.Users.SingleOrDefault(_ => _.Username == username); if (user == null) { user = new User { Username = username, Password = password }; data.Users.InsertOnSubmit(user); data.SubmitChanges(); return Json(new { results = new { userid = user.ID }, success = true }, JsonRequestBehavior.AllowGet); } else { return Json(new { success = false, reason = "userexists" }, JsonRequestBehavior.AllowGet); } } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult GetBooks(int? categoryid, int? pageindex, int? pagesize) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var query = data.Books.Select(_ => new { categoryId = _.CategoryId, bookid = _.ID, bookname = _.Name, categoryname = _.Category.Name, imagename = _.ImageName, bookprice = _.Price, bookdesc = _.Description }); if (categoryid != null) query = query.Where(_ => _.categoryId == categoryid.Value); if (pageindex != null) query = query.Skip(pagesize.Value * pageindex.Value); if (pagesize != null) query = query.Take(pagesize.Value); var result = query.ToList(); return Json(new { success = true, results = result }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult SubmitViewLogs(int userid, string bookids, string times) { Thread.Sleep(1000); var items = new List<ViewLogParm>(); var bookidArray = bookids.Split(',').Select(a => int.Parse(a)).ToList(); var timeArray = times.Split(',').Select(a => DateTime.Parse(a)).ToList(); for (int i = 0; i < bookidArray.Count; i++) { items.Add(new ViewLogParm { bookid = bookidArray[i], time = timeArray[i] }); } using (BookStoreDataContext data = new BookStoreDataContext()) { data.ViewLogs.InsertAllOnSubmit(items.Select(_ => new ViewLog { BookId = _.bookid, Time = _.time, UserId = userid }).ToList()); data.SubmitChanges(); return Json(new { success = true }, JsonRequestBehavior.AllowGet); } }
public ActionResult SubmitOrder(int userid, string bookids, string qtys) { try { var items = new List<OrderItemParm>(); var bookidArray = bookids.Split(',').Select(a=> int.Parse(a)).ToList(); var qtyArray = qtys.Split(',').Select(a => int.Parse(a)).ToList(); for (int i = 0; i < bookidArray.Count; i++) { items.Add(new OrderItemParm { bookid = bookidArray[i], qty = qtyArray[i] }); } using (BookStoreDataContext data = new BookStoreDataContext()) { var user = data.Users.SingleOrDefault(_ => _.ID == userid); if (user != null) { var order = new Order { Time = DateTime.Now, UserId = userid, }; foreach (var bookid in bookidArray) { var book = data.Books.SingleOrDefault(b => b.ID == bookid); if (book != null) { var oi = new OrderItem { BookId = bookid, Price = book.Price, Qty = items.Single(a => a.bookid == bookid).qty, }; oi.TotalPrice = oi.Price * oi.Qty; order.OrderItems.Add(oi); } } order.TotalPrice = order.OrderItems.Sum(_ => _.TotalPrice); data.Orders.InsertOnSubmit(order); data.SubmitChanges(); return Json(new { results = new { orderid = order.ID }, success = true }, JsonRequestBehavior.AllowGet); } else return Json(new { success = false, reason = "usernotexists" }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult Login(string username, string password) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var user = data.Users.SingleOrDefault(_ => _.Username == username && _.Password == password); if (user != null) { return Json(new { results = new { userid = user.ID }, success = true }, JsonRequestBehavior.AllowGet); } else { return Json(new { success = false, reason = "authfailed" }, JsonRequestBehavior.AllowGet); } } } catch(Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult GetBookCategories() { try { using (BookStoreDataContext data = new BookStoreDataContext()) { return Json(new { success = true, results = data.Categories.Select(_ => new { id = _.ID, name = _.Name, }).ToList() }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult ChangePassword(int id, string password) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var user = data.Users.SingleOrDefault(_ => _.ID == id); if (user != null) { user.Password = password; data.SubmitChanges(); return Json(new { success = true }, JsonRequestBehavior.AllowGet); } else { return Json(new { success = false, reason = "usernotexists" }, JsonRequestBehavior.AllowGet); } } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }
public ActionResult GetOrders(int userid) { try { using (BookStoreDataContext data = new BookStoreDataContext()) { var user = data.Users.SingleOrDefault(_ => _.ID == userid); if (user != null) { return Json(new { results = data.Orders.Where(o=>o.UserId == userid).Select(_ => new { orderid = _.ID, totalprice = _.TotalPrice, time = _.Time, orderitems = _.OrderItems.Select(__ => new { bookid = __.BookId, bookname = data.Books.SingleOrDefault(b => b.ID == __.BookId).Name, price = __.Price, totalprice = __.TotalPrice, qty = __.Qty }).ToList(), }).OrderByDescending(_ => _.time).ToList() , success = true }, JsonRequestBehavior.AllowGet); } else return Json(new { success = false, reason = "usernotexists" }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { success = false, reason = "servererror" }, JsonRequestBehavior.AllowGet); } }