protected void borrowBtn_Click(object sender, EventArgs e) { //Get data of the current trading string index = Request.Params["pointerId"].ToString(); int indexOfTrading = int.Parse(index); //Get id of trading Trading currentChosen = tradings[indexOfTrading]; int tradingId = currentChosen.Id; /*Update borrower*/ //Get id of borrower = current user in sessionId int borrowerId = user.Id; //Change tradingStatus to pending currentChosen.TradingStatus = 1; //Update borrowerId currentChosen.BorrowerID = borrowerId; //Update in database TradingDAO tradingDAO = new TradingDAO(); tradingDAO.Update(tradingId, currentChosen); //Reload page Server.Transfer("BookDetail.aspx"); }
protected void uploadBtn_Click(object sender, EventArgs e) { User user = (User)Session["currentUser"]; int tradingID = -1; int bookID = -1; if (user != null) { BookDAO bookDAO = new BookDAO(); Book book = bookDAO.getByISBN(isbn.Text.Trim()); if (book == null) { string filename = uploadBookCover(); bookID = bookDAO.CreateBook(title.Value.Trim(), author.Value.Trim(), isbn.Text.Trim(), language.Value.Trim(), description.Value.Trim(), filename, user.Id, int.Parse(cate.SelectedItem.Value)); } else { bookID = book.Id; } if (bookID != -1) { TradingDAO tradingDAO = new TradingDAO(); tradingID = tradingDAO.CreateNewTrading(condition.Value.Trim(), bookID, user.Id); uploadTradingImage(tradingID); } Response.Redirect(string.Format("BookDetail.aspx?id={0}", bookID)); } }
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)); } }
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 }
static void Main(string[] args) { int input = 1; TradingDAO tr = new TradingDAO(); Trading a = new Trading(); a.idOwner = 1; a.idBook = 46; Console.WriteLine(tr.rejectTrading(3)); Console.ReadKey(); }
public bool doActionTrading(string method, int idTrading) { TradingDAO tradingdao = new TradingDAO(); switch (method) { case "Delete": //Delete return(tradingdao.deleteTradingBook(idTrading)); case "Accept": //Accept return(tradingdao.acceptTrading(idTrading)); case "Reject": //Reject return(tradingdao.rejectTrading(idTrading)); case "Complete": //Complete return(tradingdao.completeTrading(idTrading)); } return(false); }
protected void Page_Load(object sender, EventArgs e) { // set title for page Page.Title = "Book Details - BookShare"; if (Request.QueryString["id"] == null || Session["currentUser"] == null) { Server.Transfer("ErrorPage.aspx"); } else { user = (User)Session["currentUser"]; idBook = int.Parse(Request.QueryString["id"]); BookDAO bookDAO = new BookDAO(); //Get book by id book = bookDAO.GetById(idBook); //Get all lenders for this book TradingDAO tradingDAO = new TradingDAO(); int tradingStatus = 0; //Get all available trading tradings = tradingDAO.getAllTradingOfOneBookPaging(idBook, user.Id, tradingStatus); //Get all lenders according to tradings lenders = new List <User>(); UserDAO userDAO = new UserDAO(); foreach (Trading t in tradings) { User u = userDAO.GetById(t.LenderID); lenders.Add(u); } //Get all traded images foreach (Trading t in tradings) { tradingDAO = new TradingDAO(); List <string> tradedImages = new List <string>(); tradedImages = tradingDAO.getAllTradedImages(t.Id); t.TradedImages = tradedImages; } } }
protected void Page_Load(object sender, EventArgs e) { // set title for page Page.Title = "Borrowing - BookShare"; User user = (User)Session["currentUser"]; if (user == null) { Response.Redirect("Login.aspx"); } listQuery.Add("Pending"); listQuery.Add("Borrowing"); listQuery.Add("Completed"); filter = Request.QueryString["filter"] == null ? "Pending" : Request.QueryString["filter"]; page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]); int id = Request.QueryString["id"] == null ? -1 : int.Parse(Request.QueryString["id"]); int point = Request.QueryString["point"] == null ? -1 : int.Parse(Request.QueryString["point"]); FillData(filter, user.Id); if (id != -1) { lenderID = users[id].Id; myModal.Visible = true; info.InnerHtml = "Trading no: " + (id + 1) + "<br/>Lender: " + users[id].FullName + "<br/>"; trading.InnerText = tradings[id].Id + ""; } if (point != -1) { int tradingID = int.Parse(Request.QueryString["trading"]); TradingDAO tradingDAO = new TradingDAO(); tradingDAO.UpdateLenderRatePoint(tradingID, point); Response.Redirect("Borrowing.aspx?filter=Completed"); } }
private void FillData(string filter, int userID) { TradingDAO tradingDAO = new TradingDAO(); BookDAO bookDAO = new BookDAO(); UserDAO userDAO = new UserDAO(); if (filter == "Available") { tradings = tradingDAO.GetAvailableLending(userID, page); totalPages = tradingDAO.getPages("AvailableLending", userID); } else if (filter == "Pending") { tradings = tradingDAO.GetPendingLending(userID, page); totalPages = tradingDAO.getPages("PendingLending", userID); } else if (filter == "Lending") { tradings = tradingDAO.GetLending(userID, page); totalPages = tradingDAO.getPages("Lending", userID); } else if (filter == "Completed") { tradings = tradingDAO.GetCompletedLending(userID, page); totalPages = tradingDAO.getPages("CompletedLending", userID); } foreach (Trading t in tradings) { books.Add(bookDAO.GetById(t.BookID)); if (filter != "Available") { borrowers.Add(userDAO.GetById(t.BorrowerID)); } } }
public bool doBorrowBook(int idTrading, int idUser) { TradingDAO tradingdao = new TradingDAO(); return(tradingdao.requestTrading(idTrading, idUser)); }
protected void Page_Load(object sender, EventArgs e) { // set title for page Page.Title = "Lending - BookShare"; if (Session["currentUser"] == null) { Server.Transfer("ErrorPage.aspx"); } else { User user = (User)Session["currentUser"]; listQuery.Add("Available"); listQuery.Add("Pending"); listQuery.Add("Lending"); listQuery.Add("Completed"); filter = Request.QueryString["filter"] == null ? "Pending" : Request.QueryString["filter"]; page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]); int id = Request.QueryString["id"] == null ? -1 : int.Parse(Request.QueryString["id"]); int point = Request.QueryString["point"] == null ? -1 : int.Parse(Request.QueryString["point"]); //Check if page is reload and there is some deletion action if (filter == "Delete") { int tradingID = int.Parse(Request.QueryString["deleteID"]); DeleteTrading(tradingID); Response.Redirect("Lending.aspx?filter=Available"); } else if (filter == "Approve") { //Check if page is reload and there is some aprroval action int tradingID = int.Parse(Request.QueryString["approveID"]); ApproveTrading(tradingID); Response.Redirect("Lending.aspx?filter=Pending"); } else if (filter == "Complete") { //Check if page is reload and there is some complete action int tradingID = int.Parse(Request.QueryString["completeID"]); CompleteTrading(tradingID); Response.Redirect("Lending.aspx?filter=Completed"); } FillData(filter, user.Id); if (id != -1) { borrowerId = borrowers[id].Id; myModal.Visible = true; info.InnerHtml = "Trading no: " + (id + 1) + "<br/>Borrower: " + borrowers[id].FullName + "<br/>"; trading.InnerText = tradings[id].Id + ""; } if (point != -1) { int tradingID = int.Parse(Request.QueryString["trading"]); TradingDAO tradingDAO = new TradingDAO(); tradingDAO.UpdateBorrowerRatePoint(tradingID, point); Response.Redirect("Lending.aspx?filter=Completed"); } } }
private void CompleteTrading(int tradingID) { TradingDAO tradingDAO = new TradingDAO(); tradingDAO.CompleteLending(tradingID); }
private void ApproveTrading(int tradingID) { TradingDAO tradingDAO = new TradingDAO(); tradingDAO.ApproveLending(tradingID); }