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;
}
