public ActionResult Create() { ViewBag.BiodataList = new SelectList(BiodataRepo.All(), "Id", "NPM"); ViewBag.CategoryList = new SelectList(CategoryRepo.All(), "Id", "Name"); ViewBag.BookList = new SelectList(BookRepo.ByCategory(0), "Id", "Judul"); return(PartialView("_Create", new PeminjamanViewModel())); }
private void btnAdd_Click(object sender, EventArgs e) { Book book = new Book(); book.Title = txtName.Text; book.ISBN = txtISBN.Text; book.Author = txtAuthor.Text; MemoryStream ms = new MemoryStream(); pboxImage.Image.Save(ms, ImageFormat.Jpeg); byte[] arr = new byte[ms.Length]; ms.Position = 0; ms.Read(arr, 0, arr.Length); book.Image = arr; book.IsRef = cbIsRef.Checked; book.AddedDate = DateTime.Today; book.AdminId = Dashboard._curr.UserId; using (BookRepo repo = new BookRepo()) { repo.Add(book); } MessageBox.Show("Book Added Successfully!"); }
public ICollection<Books> listBooks() { BookRepo BookRepo = new BookRepo(); IEnumerable<BOOK> books = BookRepo.getAll(); ICollection<Books> bookList = new List<Books>(); Books book = null; foreach (BOOK b2 in books) { book = new Books(); book.BOOK_ID = b2.BOOK_ID; book.BOOK_TITLE = b2.BOOK_TITLE; book.BOOK_DESC = b2.BOOK_DESC; book.USER_ID = b2.USER_ID; book.BOOK_AUTHOR = b2.BOOK_AUTHOR; book.BOOK_EDITION = b2.BOOK_EDITION; book.BOOK_PRICE = b2.BOOK_PRICE; book.BOOK_PUBLISHER = b2.BOOK_PUBLISHER; book.CATEGORY_ID = b2.CATEGORY_ID; book.CONDITION_ID = b2.CONDITION_ID; book.CREATED_TIMESTAMP = b2.CREATED_TIMESTAMP; bookList.Add(book); } BookRepo = null; return bookList; }
static void Main(string[] args) { PublisherRepo repo = new PublisherRepo(); BookRepo bookrep = new BookRepo(); List <Book> books = new List <Book>(); books = bookrep.GetTopNBooks(10); List <Publisher> pubs = new List <Publisher>(); pubs = repo.GetTopNPublisher(10); string output = JsonConvert.SerializeObject(books); string path = @"C:\Users\Bogdan\Desktop\Programare\Week9Tema2\w9tema2\json.txt"; File.WriteAllText(path, output); XmlSerializer ser = new XmlSerializer(typeof(List <Publisher>)); var fs = new FileStream(@" C:\Users\Bogdan\Desktop\Programare\Week9Tema2\w9tema2\ser.xml", FileMode.Create); ser.Serialize(fs, pubs); string output2 = JsonConvert.SerializeObject(pubs); string path2 = @"C:\Users\Bogdan\Desktop\Programare\Week9Tema2\w9tema2\json2.txt"; File.WriteAllText(path2, output2); Console.ReadLine(); }
public void bookSetup() { repo = new BookRepo(); testBook = new BOOK(); DateTime dt = DateTime.Now; long a = dt.Ticks; testBook = new BOOK(); testBook.BOOK_ID = 1; testBook.BOOK_TITLE = "Fundamentals of Human Resource Management"; testBook.BOOK_EDITION = 10; testBook.BOOK_DESC = "An intorduction to Human Resource Management"; testBook.BOOK_PUBLISHER = "New York"; testBook.BOOK_AUTHOR = "David A. Decenzo"; testBook.BOOK_PRICE = 25; testBook.CATEGORY_ID = 1; testBook.CONDITION_ID = 1; testBook.USER_ID = 1; testBook.CREATED_TIMESTAMP = BitConverter.GetBytes(a); repo.add(testBook); testBook = new BOOK(); testBook.BOOK_ID = 2; testBook.BOOK_TITLE = "Algebra"; testBook.BOOK_EDITION = 8; testBook.BOOK_DESC = "A Graphical approach to Algebra"; testBook.BOOK_PUBLISHER = "New York"; testBook.BOOK_AUTHOR = "Stephen P. Robbins"; testBook.BOOK_PRICE = 28; testBook.CATEGORY_ID = 1; testBook.CONDITION_ID = 1; testBook.USER_ID = 1; testBook.CREATED_TIMESTAMP = BitConverter.GetBytes(a); repo.add(testBook); }
public ActionResult Search(int?page) { var search = Session["search"]; var result = BookRepo.Search(search.ToString()); return(View(result.ToPagedList(page ?? 1, 5))); }
public BookController(BookRepo bookRepo, AuthorRepo authors, GenreRepo genres, IWebHostEnvironment webHostEnvironment) { _bookrepo = bookRepo; _authorRepo = authors; _genreRepo = genres; _webHostEnvironment = webHostEnvironment; }
private void btnInsert_Click(object sender, EventArgs e) { // Code that inserts Book //Book book = new Book(); //book.Title = txtTitle.Text; //book.Author = txtAuthor.Text; //book.Price = decimal.Parse(txtPrice.Text); //book.Description = txtDescription.Text; //book.CountryId = 1; //BookRepo repo = new BookRepo(); //repo.AddBook(book); //LoadBooks(); // Code that inserts Book and gives back inserted Id Book book = new Book(); book.Id = 0; book.Title = txtTitle.Text; book.Author = txtAuthor.Text; book.Price = decimal.Parse(txtPrice.Text); book.Description = txtDescription.Text; book.CountryId = 1; BookRepo repo = new BookRepo(); int value = repo.AddBookReturnId(book); MessageBox.Show(value.ToString()); LoadBooks(); }
private void LoadBooks() { BookRepo repo = new BookRepo(); this.grvBooks.DataSource = null; grvBooks.DataSource = repo.GetBooks(); }
public ActionResult Edit(int id) { var result = BookRepo.GetByID(id); ViewBag.Bikes = Context.BikeDetails.Where(b => b.Status == 0).ToList(); return(View(result.Data ?? new Book_Info())); }
private void btnDelete_Click(object sender, EventArgs e) { BookRepo repo = new BookRepo(); //repo.Delete(10); repo.DeleteBookById(21); }
public ActionResult Search(string search, int?page) { var result = BookRepo.Search(search); Session["search"] = search; ViewBag.Search = search; return(View(result.ToPagedList(page ?? 1, 5))); }
public BookDetails() { InitializeComponent(); _bookRepo = new BookRepo(); _typeBookRepo = new TypeBookRepo(_bookRepo); InitializeList(); RefreshInfo(); }
public RentBookController(IConfiguration configuration, RoleManager <IdentityRole> roleMgr, UserManager <AppUser> userMrg) { Configuration = configuration; BookMgr = new BookRepo(configuration); RentMgr = new RentBookRepo(configuration); roleManager = roleMgr; userManager = userMrg; }
public static List <Bookdto> GetBooks() { return(BookRepo.GetBooks() .Select(p => new Bookdto( p.Id, p.Title)) .ToList()); }
public void GetAllTest() { var bookRepo = new BookRepo(bookcontextmock.Object); var bookList = bookRepo.GetBookList(); Assert.AreEqual(4, books.Count()); Assert.AreNotEqual(5, books.Count()); }
public ActionResult Category(int id) { ViewBag.Category = CategoryRepo.GetAllForHome(); ViewBag.Book = BookRepo.GetAllBook(id); ViewBag.Message = CategoryRepo.GetCategoryName(id); return(View()); }
public void GetBookById_ReturnsCorrectBook() { var bookRepo = new BookRepo(connectionString); var book = bookRepo.GetBookById(99991); Assert.IsTrue(book != null && book.Id == 99991); }
public ActionResult Edit(int id) { // id => Variant Id BookViewModel model = BookRepo.ById(id); ViewBag.CategoryList = new SelectList(CategoryRepo.All(), "Id", "Name"); return(PartialView("_Edit", model)); }
public ActionResult Search(string search) { if (!String.IsNullOrEmpty(search)) { return(View(BookRepo.SearchAll(search))); } return(View()); }
private void button1_Click(object sender, EventArgs e) { BookRepo b = new BookRepo(); b.insertBookDetails(fileName, fileLoc, txtTitle.Text, txtEdition.Text, int.Parse(txtDate.Text), userId, txtAuthor.Text, int.Parse(txtPoints.Text)); MessageBox.Show("Done"); f.Show(); this.Hide(); }
private void CmbxCountry_SelectedIndexChanged(object sender, EventArgs e) { BookRepo repo = new BookRepo(); string value = CmbxCountry.SelectedValue.ToString(); var list = repo.GetAuthorsOfSelectedCountry((Convert.ToInt32(value))); lstAuthor.DisplayMember = "Author"; lstAuthor.DataSource = list; }
public Records() { InitializeComponent(); this.bk = new BookRepo(); List <BorrowRecords> listofRecords = bk.GetAllRecords(); RecordsTableDG.DataSource = listofRecords; }
public BookRemove() { InitializeComponent(); var bookRepo = new BookRepo(); _typeBook = new TypeBookRepo(bookRepo); _index = 0; SetData(); }
private void PopulateCountries() { BookRepo repo = new BookRepo(); CmbxCountry.DisplayMember = "Name"; CmbxCountry.ValueMember = "Id"; CmbxCountry.DataSource = repo.GetCountries(); LoadBooks(); }
public static Bookdto GetBooks(Guid id) { return(ConvertDto( BookRepo.GetBooks() .Where(p => p.Id == id) .Select(p => p) .FirstOrDefault() )); }
public void get_DetailAll_test() { IBookRepo BookData = new BookRepo(db); BookController obj = new BookController(BookData); var data = obj.Get(); var okResult = data as OkObjectResult; Assert.AreEqual(200, okResult.StatusCode); }
public void Delete_Test() { IBookRepo BookData = new BookRepo(db); BookController obj = new BookController(BookData); var data = obj.Delete(2); var okResult = data as OkObjectResult; Assert.AreEqual(200, okResult.StatusCode); }
private void LoadBooks() { BookRepo repo = new BookRepo(); grdBooks.DataSource = null; grdBooks.DataSource = repo.GetBooks(); // IList<Book> list = repo.GetBooks(); ////kan misschien handig zijn // List<Book> list = repo.GetBooks(); }
public ActionResult Delete(int id) { var result = BookRepo.Delete(id); if (result.HasError) { TempData["Error"] = result.Message; } return(RedirectToAction("List")); }
public ActionResult List(string key = "") { var result = BookRepo.GetAll(key); if (TempData["Error"] != null) { ViewBag.Error = TempData["Error"]; } return(View(result)); }
static void Main(string[] args) { var connection = ConnectionManager.GetConnection(); BookRepo bookRepo = new BookRepo(connection); List <Book> books = bookRepo.LoadAllBooks(); Serializer.SerializeJSon(books); Serializer.SerializeXML(books); }
public void setup() { bRepo = new BookRepo(); uRepo = new UserRepo(); userA = new USER { USER_FNAME = "Ermin", USER_LNAME = "Avdagic", USER_DISPLAYNAME = "Me", USER_EMAIL = "*****@*****.**", PASSWORD = "******", REPUTATION = 1, CREATED_TIMESTAMP = DateTime.Now }; uRepo.add(userA); bookA = new BOOK { USER_ID=333, BOOK_AUTHOR = "Me", BOOK_DESC = "About my life", BOOK_EDITION = 10, BOOK_PRICE = 20, BOOK_PUBLISHER = "IDK", BOOK_TITLE = "My Life", ISBN10 = 12345678910, ISBN13 = 12345678910111, CREATED_TIMESTAMP = DateTime.Now, CATEGORY_ID=1, CONDITION_ID=1 }; bRepo.add(bookA); uRepo.add(new USER { USER_FNAME = "Jon", USER_LNAME = "Smith", USER_EMAIL = "*****@*****.**", USER_DISPLAYNAME = "JonSmith", REPUTATION = 5, PASSWORD = "******", CREATED_TIMESTAMP = DateTime.Now }); }
public void setup() { bRepo = new BookRepo(); bRepo.add(new BOOK { USER_ID=333, CATEGORY_ID=1, BOOK_AUTHOR="Yoooo", BOOK_DESC="Mario", BOOK_EDITION=10, BOOK_PRICE=20, BOOK_PUBLISHER="KOKO", BOOK_TITLE="Mario and Luigi", ISBN10=12345678910, ISBN13=12345678910111, CREATED_TIMESTAMP=DateTime.Now, CONDITION_ID=1 }); }
public Books getBookById(int bookId) { BookRepo bookRepo = new BookRepo(); BOOK b3 = bookRepo.getById(new BOOK{BOOK_ID=bookId}); Books book = new Books(); book.BOOK_ID = b3.BOOK_ID; book.BOOK_TITLE = b3.BOOK_TITLE; book.BOOK_DESC = b3.BOOK_DESC; book.USER_ID = b3.USER_ID; book.BOOK_AUTHOR = b3.BOOK_AUTHOR; book.BOOK_EDITION = b3.BOOK_EDITION; book.BOOK_PRICE = b3.BOOK_PRICE; book.BOOK_PUBLISHER = b3.BOOK_PUBLISHER; book.CATEGORY_ID = b3.CATEGORY_ID; book.CONDITION_ID = b3.CONDITION_ID; book.CREATED_TIMESTAMP = b3.CREATED_TIMESTAMP; return book; }
public Books insertBooks(Books newBook) { Books book2add = newBook; BOOK u3 = new BOOK(); BookRepo bookRepo = new BookRepo(); u3.BOOK_TITLE = book2add.BOOK_TITLE; u3.BOOK_EDITION = book2add.BOOK_EDITION; u3.BOOK_DESC = book2add.BOOK_DESC; u3.BOOK_AUTHOR = book2add.BOOK_AUTHOR; u3.BOOK_PUBLISHER = book2add.BOOK_PUBLISHER; u3.BOOK_PRICE = book2add.BOOK_PRICE; u3.CATEGORY_ID = book2add.CATEGORY_ID; u3.CONDITION_ID = book2add.CONDITION_ID; u3.USER_ID = book2add.USER_ID; u3.CREATED_TIMESTAMP = DateTime.Now; bookRepo.add(u3); return book2add; }
public void bookSetup() { bookService = new BookService(); bRepo = new BookRepo(); uRepo = new UserRepo(); userA = new USER { USER_FNAME = "Cory", USER_LNAME = "Jenkings", PASSWORD = "******", USER_EMAIL = "*****@*****.**", USER_DISPLAYNAME = "C.J", CREATED_TIMESTAMP = DateTime.Now, REPUTATION = 509}; uRepo.add(userA); bookA = new BOOK { USER_ID=333, BOOK_PRICE = 20, BOOK_PUBLISHER = "idk", BOOK_TITLE = "my life", BOOK_AUTHOR = "Ermin", BOOK_EDITION = 10, BOOK_DESC = "A book with words and pictures", CREATED_TIMESTAMP = DateTime.Now, ISBN10 = 1111111111, ISBN13 = 1111111111111, CATEGORY_ID=1, CONDITION_ID=1 }; bRepo.add(bookA); }
public ICollection<Books> searchBookByTitle(string SearchString) { string searchText = SearchString; BookRepo BookRepo = new BookRepo(); IEnumerable<BOOK> books = BookRepo.query(s => s.BOOK_TITLE.Contains(searchText)); ICollection<Books> bookList = new List<Books>(); Books book = null; foreach (BOOK b1 in books) { book = new Books(); book.BOOK_ID = b1.BOOK_ID; book.BOOK_TITLE = b1.BOOK_TITLE; book.BOOK_DESC = b1.BOOK_DESC; book.USER_ID = b1.USER_ID; book.BOOK_AUTHOR = b1.BOOK_AUTHOR; book.BOOK_EDITION = b1.BOOK_EDITION; book.BOOK_PRICE = b1.BOOK_PRICE; book.BOOK_PUBLISHER = b1.BOOK_PUBLISHER; book.CATEGORY_ID = b1.CATEGORY_ID; book.CONDITION_ID = b1.CONDITION_ID; book.CREATED_TIMESTAMP = b1.CREATED_TIMESTAMP; bookList.Add(book); } return bookList; }
/* * books = book class * BOOK = Book Table */ public ICollection<Books> listBooksByUser(int userId) { BookRepo BookRepo = new BookRepo(); IEnumerable<BOOK> books = BookRepo.query(p => p.USER_ID == userId); ICollection<Books> bookList = new List<Books>(); Books book = null; foreach (BOOK b1 in books) { book = new Books(); book.BOOK_ID = b1.BOOK_ID; book.BOOK_TITLE = b1.BOOK_TITLE; book.BOOK_DESC = b1.BOOK_DESC; book.USER_ID = userId; book.BOOK_AUTHOR = b1.BOOK_AUTHOR; book.BOOK_EDITION = b1.BOOK_EDITION; book.BOOK_PRICE = b1.BOOK_PRICE; book.BOOK_PUBLISHER = b1.BOOK_PUBLISHER; book.CATEGORY_ID = b1.CATEGORY_ID; book.CONDITION_ID = b1.CONDITION_ID; book.CREATED_TIMESTAMP = b1.CREATED_TIMESTAMP; bookList.Add(book); } BookRepo = null; return bookList; }