public static IEnumerable<Textbook> getAllTextbooks() { List<Textbook> allTextbooks = new List<Textbook>(); try { DataAccessLayer DAL = new DataAccessLayer(); DataTable dt = DAL.select("", "TextBooks"); foreach (DataRow row in dt.Rows) { string isbn = Convert.ToString(row["ISBN"]); string title = Convert.ToString(row["BookTitle"]); string author = Convert.ToString(row["Author"]); string bookImageURL = Convert.ToString(row["BookImageURL"]); int courseID = Convert.ToInt32(row["CourseID"]); string courseName = CourseInfoHandler.getCourseName(courseID); int storePrice = Convert.ToInt32(row["StorePrice"]); Textbook textbook = new Textbook(isbn, title, author, courseName, bookImageURL, storePrice); allTextbooks.Add(textbook); } } catch (Exception ex) { Console.Write("ERROR: An error occured in retrieving all textbooks --- " + ex.Message); } return allTextbooks; }
public static Textbook getTextbook(int textbookID) { Textbook textbook = null; try { DataAccessLayer DAL = new DataAccessLayer(); DataTable dt = DAL.select(String.Format("TextBookID = '{0}'", textbookID), "TextBooks"); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; string isbn = Convert.ToString(row["ISBN"]); string title = Convert.ToString(row["BookTitle"]); string author = Convert.ToString(row["Author"]); string bookImageURL = Convert.ToString(row["BookImageURL"]); int courseID = Convert.ToInt32(row["CourseID"]); string courseName = CourseInfoHandler.getCourseName(courseID); int storePrice = Convert.ToInt32(row["StorePrice"]); textbook = new Textbook(isbn, title, author, courseName, bookImageURL, storePrice); } } catch (Exception ex) { Console.Write("ERROR: An error occured in retrieving the textbook --- " + ex.Message); } return textbook; }
public static int insert(Textbook newBook) { int id = -1; try { DataAccessLayer DAL = new DataAccessLayer(); DataTable dt = DAL.select(String.Format("ISBN = '{0}'", newBook.ISBN), "TextBooks"); if (dt == null || dt.Rows.Count == 0) { int courseID = CourseInfoHandler.getCourseID(newBook.CourseName); Dictionary<string, string> textbook = new Dictionary<string, string>(); textbook.Add("ISBN", newBook.ISBN); textbook.Add("BookTitle", newBook.Title); textbook.Add("Author", newBook.Author); textbook.Add("CourseID", courseID.ToString()); textbook.Add("BookImageURL", newBook.BookImageURL); textbook.Add("StorePrice", Convert.ToString(newBook.StorePrice)); textbook.Add("IsActive", "1"); textbook.Add("IsDeleted", "0"); textbook.Add("CreatedDate", Convert.ToString(DateTime.Now)); textbook.Add("ModifiedDate", Convert.ToString(DateTime.Now)); id = DAL.insert(textbook, "TextBooks"); } } catch (Exception ex) { Console.Write("ERROR: An error occured in adding a new textbook --- " + ex.Message); } return id; }
public static IEnumerable<Textbook> getTextbooksByCourse(string courseName) { List<Textbook> textbooks = new List<Textbook>(); try { int[] courseIDs = CourseInfoHandler.getCourseIDs(courseName); foreach (int courseID in courseIDs) { DataAccessLayer DAL = new DataAccessLayer(); DataTable dt = DAL.select(String.Format("CourseID = '{0}'", courseID), "TextBooks"); foreach (DataRow row in dt.Rows) { string isbn = Convert.ToString(row["ISBN"]); string title = Convert.ToString(row["BookTitle"]); string author = Convert.ToString(row["Author"]); string bookImageURL = Convert.ToString(row["BookImageURL"]); string full_courseName = CourseInfoHandler.getCourseName(courseID); int storePrice = Convert.ToInt32(row["StorePrice"]); Textbook textbook = new Textbook(isbn, title, author, full_courseName, bookImageURL, storePrice); textbooks.Add(textbook); } } } catch (Exception ex) { Console.Write("ERROR: An error occured in retrieving textbooks by course name --- " + ex.Message); } return textbooks; }
public ActionResult SaveBook(string isbn, string title, string author, string course, string bookImageURL, bool isBuy, int price, string condition, string email, bool IsNegotiable) { int courseID = CourseInfoHandler.getCourseID(course); if (courseID == -1) { // TODO: Implement description for each course CourseInfo newCourse = new CourseInfo(course, String.Empty); CourseInfoHandler.insert(newCourse); } Textbook newBook = new Textbook(isbn, title, author, course, bookImageURL, price); int bookId = TextbookHandler.insert(newBook); string accesstoken = Convert.ToString(Session["AccessToken"]); UserProfile profile = AccountHandler.getUserProfile_Facebook(UserProfileUtil.getFacebookID(accesstoken)); if (bookId >= 0) { return SavePost(profile.ProfileID, newBook.CourseName, newBook.Title, isBuy, price, condition, email, IsNegotiable); } else { return Json("Failed to insert textbook: " + newBook.Title); } }