private void FillData(string filter, int userID) { TradingDAO tradingDAO = new TradingDAO(); BookDAO bookDAO = new BookDAO(); UserDAO userDAO = new UserDAO(); if (filter == "Pending") { tradings = tradingDAO.GetPendingBorrowing(userID, page); totalPages = tradingDAO.getPages("PendingBR", userID); } else if (filter == "Borrowing") { tradings = tradingDAO.GetBorrowing(userID, page); totalPages = tradingDAO.getPages("Borrowing", userID); } else if (filter == "Completed") { tradings = tradingDAO.GetCompletedBorrow(userID, page); totalPages = tradingDAO.getPages("Borrowing", userID); } foreach (Trading t in tradings) { books.Add(bookDAO.GetById(t.BookID)); users.Add(userDAO.GetById(t.LenderID)); } }
public ActionResult Edit(int id) { BookDAO bookDAO = new BookDAO(); Book book = bookDAO.FetchOne(id); return(View("Create", book)); }
//BookManagementEntities db = new BookManagementEntities(); // // GET: /Home/ public ActionResult Index(string searchkey, int?page) { BookDAO book = new BookDAO(); ViewBag.SearchString = searchkey; return(View(book.ListBook(searchkey, page ?? 1, 12))); }
protected void Page_Load(object sender, EventArgs e) { // set title for page Page.Title = "Search result - BookShare"; if (!IsPostBack) { // check query search is null or not thing then redirect to home page if (Request.QueryString["query"] == null || Request.QueryString["query"].Trim() == "") { Response.Redirect("Home.aspx"); } listQuery.Add("All"); listQuery.Add("Title"); listQuery.Add("Author"); listQuery.Add("ISBN"); string query = Request.QueryString["query"]; filter = Request.QueryString["filter"] == null ? "All" : Request.QueryString["filter"]; page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]); BookDAO bookDAO = new BookDAO(); books = bookDAO.searchBook(query, filter, page).ToList(); totalPage = bookDAO.getPages(filter, query); // } }
public async Task <IActionResult> PutBook(Guid id, BookDAO book) { if (id != book.BookID) { return(BadRequest()); } try { _service.Update(book); } catch (DbUpdateConcurrencyException) { if (!BookExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void readFromTxtFile(string name) { var context = new DiseaseEntities1(); BookDAO bookDAO = new BookDAO(context); Regex regex = new Regex(@"(.+?) (.+?) (.+?) (.+?) (.+?)"); using (StreamReader fs = new StreamReader(name)) { //for (int i = 0; i < 1000; i++) //{ while (!fs.EndOfStream) { List <string> infoTemp = new List <string>(); string temp = fs.ReadLine(); string[] result = regex.Split(temp); foreach (var item in result) { if (item.Length > 0) { infoTemp.Add(item); } } bookDAO.Save(new Book { Title = infoTemp[0], IdAuthor = Int32.Parse(infoTemp[1]), Pages = Int32.Parse(infoTemp[2]), Price = Int32.Parse(infoTemp[3]), IdPublisher = Int32.Parse(infoTemp[4]) }); } } }
public static DataTable getDataTableBooksLoading(int _h) { DataTable dataTable = new DataTable(); var context = new DiseaseEntities1(); BookDAO bookDAO = new BookDAO(context); Book[] book = context.Books.ToArray(); dataTable.Columns.Add("Id"); dataTable.Columns.Add("Title"); dataTable.Columns.Add("LastName"); dataTable.Columns.Add("FirstName"); dataTable.Columns.Add("Pages"); dataTable.Columns.Add("Price"); dataTable.Columns.Add("Publisher"); for (int i = 0; i < book.Length; i += _h) { DataRow row = dataTable.NewRow(); row[0] = book[i].Id; row[1] = book[i].Title; row[2] = book[i].Author.LastName; row[3] = book[i].Author.FirstName; row[4] = book[i].Pages; row[5] = book[i].Price; row[6] = book[i].Publisher.PublisherName; dataTable.Rows.Add(row); } return(dataTable); }
private void btnMuon_Click(object sender, EventArgs e) { btnMuon.Enabled = false; btnTra.Enabled = true; btnGiaHan.Enabled = true; panel3.Enabled = true; PhieuMuonDAO pm = new PhieuMuonDAO(); string maphieumuon = txtCTMaPhieuMuon.Text; string madg = (cbMaDGMuon.SelectedItem as DocGia).MaDG; DateTime ngaymuon = dateTimeCTMuonMuon.Value; DateTime ngaytra = dateTimeCTTraMuon.Value; string manhanvien = LoginAccount.MaNhanVien; int trangthai = 0; string masach = (cbMaSachMuon.SelectedItem as Book).MaSach; int soluong = (int)numSLMuon.Value; BookDAO book = new BookDAO(); if (book.CheckBookNumberByMaSach(masach) < soluong) { MessageBox.Show("Sách không đủ"); } else { if (pm.InsertPhieuMuon(maphieumuon, madg, ngaymuon, ngaytra, manhanvien, trangthai, masach, soluong)) { MessageBox.Show("Thêm Thành công"); ShowMuon(); } else { MessageBox.Show("Có lỗi khi thêm"); } } }
void addMaSachToCB() { BookDAO book = new BookDAO(); cbMaSachMuon.DataSource = book.GetListBook(); cbMaSachMuon.DisplayMember = "MaSach"; }
public ActionResult Delete(int id) { var dao = new BookDAO(); dao.handleDelete(id); return(RedirectToAction("Management")); }
public ActionResult Edit(Book book, FormCollection formcollection) { if (Session["UserName"] == null) { return(RedirectToAction("Login", "AccountAdmin")); } string imageURL = null; try { imageURL = formcollection["txtImageURL"].ToString(); } catch { imageURL = "/Content/images/Image.jpg"; } if (ModelState.IsValid) { var dao = new BookDAO(); var rs = dao.Update(book, imageURL); db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ImageBoolID = new SelectList(db.Images, "ImageBoolID", "ImageBoolID", book.ImageBoolID); //ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "Name", book.Authors.First().AuthorID); //ViewBag.PublisherID = new SelectList(db.Publishers, "PublisherID", "Name", book.PublisherID); ViewBag.AuthorID = new SelectList(db.Authors.Where(x => x.isDeleted == false), "AuthorID", "Name"); ViewBag.CategoryID = new SelectList(db.Categories.Where(x => x.isDeleted == false), "CategoryID", "Name"); ViewBag.PublisherID = new SelectList(db.Publishers.Where(x => x.isDeleted == false), "PublisherID", "Name"); return(View(book)); }
public ActionResult Insert(BOOK entity) { var dao = new BookDAO(); dao.handleInsert(entity); return(RedirectToAction("Management")); }
public ActionResult Update(int id) { var dao = new BookDAO(); var ob = dao.getBookById(id); return(View(ob)); }
// // GET: /Books/ public ActionResult Management() { var dao = new BookDAO(); var model = dao.getAllBooks(); return(View(model)); }
public ActionResult Edit(Book book, FormCollection formcollection) { string imageURL = null; try { imageURL = formcollection["txtImageURL"].ToString(); } catch { imageURL = "/Content/images/Image.jpg"; } if (ModelState.IsValid) { var dao = new BookDAO(); var rs = dao.Update(book, imageURL); db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ImageBoolID = new SelectList(db.ImageBools, "ImageBoolID", "ImageBoolID", book.ImageBoolID); ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "Name", book.Authors.First().AuthorID); ViewBag.PublisherID = new SelectList(db.Publishers, "PublisherID", "Name", book.PublisherID); return(View(book)); }
public ActionResult UpdateBook(int id, HttpPostedFileBase file) { setViewBagForBook(); Book book = new BookDAO().getBookById(id); List <int> list = new List <int>(); var bookView = new BookViewModel(); foreach (var item in book.Authors) { list.Add(item.ID); } bookView.SelectedValuesAuthor = list.ToArray(); bookView.Name = book.Name; bookView.Alias = book.Alias; bookView.Category = book.CategoryID; bookView.Content = book.Content; bookView.Price = book.Price; bookView.BookCover = book.BookCover; bookView.NumberPages = book.NumberPages; bookView.Publisher = book.PublisherID; bookView.PublicationDate = book.PublicationDate; bookView.Size = book.Size; bookView.Quanlity = book.Quanlity; bookView.Image = book.Image; return(View(bookView)); }
protected void Page_Load(object sender, EventArgs e) { // get total number of users UserDAO userDao = new UserDAO(); UserNum = userDao.GetRowCount(); // get total pending books BookDAO bookDao = new BookDAO(); TotalPendings = bookDao.GetRowCountBookByStatus(Book.STATUS_PENDING); TotalAccepted = bookDao.GetRowCountBookByStatus(Book.STATUS_ACCEPTED); // get number of lastest avaible tradings TradingDAO tradingDao = new TradingDAO(5); N_LastestAvailableTradings = tradingDao.Get_N_BookNumByStatus(tradingNum, Trading.STATUS_AVAILABLE); // get list of Lastest Tradings LastestCompletedTradings = tradingDao.GetTradingByCommand("select top 5 * from Trading order by (completedTime) desc"); foreach (Trading trading in LastestCompletedTradings) { Lenders.Add(userDao.GetById(trading.LenderID)); Borrowers.Add(userDao.GetById(trading.BorrowerID)); Books.Add(bookDao.GetById(trading.BookID)); } // set status }
public JsonResult loadData(string searchText, string statusSelect, int page, int pageSize = 3) { BookDAO bookDAO = new BookDAO(); IEnumerable <BookViewModel> model; if (!string.IsNullOrEmpty(searchText)) { model = bookDAO.getListBookBySearchText(searchText); } else { model = bookDAO.getListBook(); } if (!string.IsNullOrEmpty(statusSelect)) { var status = bool.Parse(statusSelect); model = model.Where(x => x.Status == status); } var totalRow = model.Count(); //model = model.OrderByDescending(x => x.CreatedDate).Skip((page - 1) * pageSize).Take(pageSize); return(Json(new { data = model, totalRow = totalRow, status = true }, JsonRequestBehavior.AllowGet)); }
public static DataTable getDataTableBooks(string word) { DataTable dataTable = new DataTable(); var context = new DiseaseEntities1(); BookDAO bookDAO = new BookDAO(context); Book[] book = context.Books.ToArray(); List <Book> books = bookDAO.FindListInAuthorLastName(word, book); dataTable.Columns.Add("Id"); dataTable.Columns.Add("Title"); dataTable.Columns.Add("LastName"); dataTable.Columns.Add("Pages"); dataTable.Columns.Add("Price"); dataTable.Columns.Add("Publisher"); foreach (var item in books) { DataRow row = dataTable.NewRow(); row[0] = item.Id; row[1] = item.Title; row[2] = item.Author.LastName; row[3] = item.Pages; row[4] = item.Price; row[5] = item.Publisher.PublisherName; dataTable.Rows.Add(row); } return(dataTable); }
private void btnCategoryUpdateExecute_Click(object sender, EventArgs e) { if (txtAfter.Text.Trim() == "") { MessageBox.Show("카테고리를 입력해주세요."); return; } if (MessageBox.Show("정말 카테고리를 수정하시겠습니까?", "카테고리 수정", MessageBoxButtons.YesNo) == DialogResult.Yes) { BookDAO bookDAO = BookDAO.getInstance(); if (txtAfter.Text.Trim() != null) { if (bookDAO.updateCategory(txtBefore.Text, replaceAll(txtAfter.Text))) { MessageBox.Show("수정 완료"); form.categoryListShow(); Hide(); } else { MessageBox.Show("수정 실패"); } } else { MessageBox.Show("수정할 카테고리 명을 입력해주세요."); } } }
private void View() { DataTable dt = BookDAO.GetDataTable(); dv = new DataView(dt); dataGridView1.DataSource = dv; }
/// <summary> /// This calls on the dao to get the results depending on the mode we are currently in /// </summary> /// <param name="mode"></param> /// <param name="value"></param> public void Search(Constants.SearchMode mode, string value) { MainForm main = (MainForm)this.ParentForm.MdiParent; BookDAO dao = new BookDAO(main.CurrentDatabase.FullName); this.gridBooks.DataSource = dao.SearchBooks(_mode, mode, value).Tables[0]; }
protected void btnChkCondition_Click(object sender, EventArgs e) { if (txtBookNumber.Text == null || txtBookNumber.Text.Equals("")) { lblError.Text = "Book Number is not allow to be null"; txtBookNumber.Focus(); } else if (DAO.checkInt(txtBookNumber.Text) == false) { lblError.Text = "Book Number is numberic"; txtBookNumber.Focus(); } else { DataView dv = new DataView(BookDAO.GetDataTableBook()); dv.RowFilter = "bookNumber = " + txtBookNumber.Text; if (dv.Count != 0) //book exist { int availableCopy = CopyDAO.getAvailableCopy(int.Parse(txtBookNumber.Text)); //số lượng bản copy A if (availableCopy > 0) { lblError.Text = "This book having " + availableCopy + " copies available, you can borrow them"; } else { lblError.Text = ""; btnReserve.Enabled = true; } } else { lblError.Text = "Oops! this book number is not exist!"; } } }
public ActionResult Detail(String Url) { var dao = new BookDAO(); var book = dao.getBookByUrl(Url); return(View(book)); }
public ActionResult Details(int id) { BookDAO bookDAO = new BookDAO(); Book book = bookDAO.FetchOne(id); return(View("Details", book)); }
private void btnPublisherUpdateExecute_Click(object sender, EventArgs e) { if (txtAfter.Text.Trim() == "") { MessageBox.Show("출판사를 입력해주세요."); return; } if (MessageBox.Show("정말 출판사를 수정하시겠습니까?", "출판사 수정", MessageBoxButtons.YesNo) == DialogResult.Yes) { BookDAO bookDAO = BookDAO.getInstance(); if (txtAfter.Text.Trim() != null) { if (bookDAO.updatePublisher(txtBefore.Text, replaceAll(txtAfter.Text))) { MessageBox.Show("출판사 수정 성공"); bookAdmin.selectPublisherList(); Hide(); Dispose(); } else { MessageBox.Show("출판사 수정 실패"); } } else { MessageBox.Show("수정할 카테고리 명을 입력해주세요."); } } }
public ActionResult ListBookByAuthor(int authorID, int?page) { BookDAO _book = new BookDAO(); Session.Add("AUTHOR_ID", authorID); return(View(_book.GetByAuthor(authorID, page ?? 1, 12))); }
public async Task <ActionResult> Create(Book book, FormCollection formcollection) { string imageURL = null; try { imageURL = formcollection["txtImageURL"].ToString(); } catch { imageURL = "/Content/images/Image.jpg"; } if (ModelState.IsValid) { var dao = new BookDAO(); var rs = dao.Insert(book, imageURL); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.ImageBoolID = new SelectList(db.ImageBools, "ImageBoolID", "ImageBoolID", book.ImageBoolID); //ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "Name", book.Authors.First().AuthorID); ViewBag.PublisherID = new SelectList(db.Publishers, "PublisherID", "Name", book.PublisherID); return(View(book)); }
// GET: Detail public ActionResult Index() { string id_raw = Request.QueryString["bookid"]; if (id_raw == null) { id_raw = Session["id"].ToString(); } int id = Int32.Parse(id_raw); Session.Remove("id"); commentDAO cbd = new commentDAO(); List <comment> comments = cbd.getbyBook(id); List <author> authors = new AuthorDAO().getAuthorByBookID(id); categoryDAO cd = new categoryDAO(); BookDAO db = new BookDAO(); int count = comments.Count; dynamic dy = new ExpandoObject(); dy.book = db.getOne(id); ViewData["count"] = count; dy.cates = cd.getAll(); dy.comments = comments; dy.authors = authors; if (Session["user"] != null) { account a = (account)Session["user"]; new historyDAO().addHistory(a.username, id); } return(View(dy)); }
public ActionResult Category(int cateid) { var category = new CategoryDAO().ViewDetail(cateid); ViewBag.Category = category; /* int totalRecord = 0;*/ var model = new BookDAO().ListByCategoryId(cateid /*ref totalRecord, /*page, pageSize*/); /* ViewBag.Total = totalRecord; *//* ViewBag.Page = page;*//* * * int maxPage = 5; * int totalPage = 0; * * totalPage = (int)Math.Ceiling((double)(totalRecord / pageSize)); * ViewBag.TotalPage = totalPage; * ViewBag.MaxPage = maxPage; * ViewBag.First = 1; * ViewBag.Last = totalPage; * ViewBag.Next = page + 1; * ViewBag.Prev = page - 1; * */ return(View(model)); }
public static BookDAO GetBookDAO() { if (BookDAO == null) { BookSqlCeDAOImpl bookDAOImpl = new BookSqlCeDAOImpl(); bookDAOImpl.dbContext = DBContextProvider.getDBContext(); BookDAO = bookDAOImpl; } return BookDAO; }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); //setup IMemberDAO memberDAO = new MemberDAO(new MemberHelper()); IBookDAO bookDAO = new BookDAO(new BookHelper()); ILoanDAO loanDAO = new LoanDAO(new LoanHelper()); IMember mem = memberDAO.AddMember("John", "Smith", "*****@*****.**", "02 622 94753"); IBook book1 = bookDAO.AddBook("Robert Heinlein", "Space Cadet", "HEI 3.645"); IBook book2 = bookDAO.AddBook("Charles Stross", "The Laundry Files", "STR 7.593"); IBook book3 = bookDAO.AddBook("James Cambias", "A Darkling Sea", "CAM 5.657"); IBook book4 = bookDAO.AddBook("John Steinbeck", "Cannery Row", "STE 9.531"); IBook book5 = bookDAO.AddBook("Terry Pratchett", "Raising Steam", "PRA 1.739"); IBook book6 = bookDAO.AddBook("Vernor Vinge", "Fire Upon the Deep", "VIN 8.927"); /* IBook b = bookDAO.GetBookByID(1); b = bookDAO.GetBookByID(2); b = bookDAO.GetBookByID(3); b = bookDAO.GetBookByID(4); DateTime borrowDate = DateTime.Now; TimeSpan loanPeriod = new TimeSpan(LoanConstants.LOAN_PERIOD, 0, 0, 0); DateTime dueDate = borrowDate.Add(loanPeriod); loanDAO.CreateNewPendingList(mem); loanDAO.CreatePendingLoan(mem, book1, borrowDate, dueDate); loanDAO.CreatePendingLoan(mem, book2, borrowDate, dueDate); loanDAO.CreatePendingLoan(mem, book3, borrowDate, dueDate); loanDAO.CreatePendingLoan(mem, book4, borrowDate, dueDate); loanDAO.CreatePendingLoan(mem, book5, borrowDate, dueDate); loanDAO.CommitPendingLoans(mem); DateTime checkDate = dueDate.Add(new TimeSpan(1, 0, 0, 0)); loanDAO.UpdateOverDueStatus(checkDate); mem.AddFine(10.00f); */ BorrowBookUI gui = new BorrowBookUI(); BorrowBookCTL ctl = new BorrowBookCTL(bookDAO, memberDAO,loanDAO, gui); ctl.Initialise(); Application.Run(gui); }
public LibraryController() { BookDAO = BookDAOFactory.GetBookDAO(); AuthorDAO = AuthorDAOFactory.GetAuthorDAO(); GenreDAO = GenreDAOFactory.GetGenreDAO(); }
public EditBooksController() { BookDAO = BookDAOFactory.GetBookDAO(); AuthorDAO = AuthorDAOFactory.GetAuthorDAO(); GenreDAO = GenreDAOFactory.GetGenreDAO(); }