public async Task AddBooksAsync(BooksDTO books ) { var mappedBooks = _mapper.Map <Books>(books); await _uof.BooksRepository.AddAsync(mappedBooks); }
private void FindButton(object sender, RoutedEventArgs e) { BooksDTO book = (BooksDTO)dataGrid.SelectedItem; _bookListViewModel.Update(CategoryBox.Text, TitleBox.Text); dataGrid.Items.Refresh(); }
public void AddBook(string t, int id) { BasketDal dal2 = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); using (SqlConnection conn = new SqlConnection(connStr)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); comm.CommandText = $"select * from Books where Title = '{t}'"; SqlDataReader reader = comm.ExecuteReader(); BooksDTO Book = new BooksDTO(); while (reader.Read()) { Book.BookID = (int)reader["BookID"]; Book.Author = reader["Autor"].ToString(); Book.Price = (Decimal)reader["Price"]; } conn.Close(); BasketDTO m = new BasketDTO { Title = t, UserID = id, BookID = Book.BookID, StatusID = 3, Author = Book.Author, Price = Book.Price, Amount = 1, Date = DateTime.Now }; m = dal2.CreateBasket(m); } }
public dynamic AddBook(BooksDTO NewBook) { try { var Book = new BooksBO(); Book.Name = NewBook.Name; Book.NumPages = NewBook.NumPages; Book.PublicDate = NewBook.PublicDate.ToUniversalTime(); Book.Authors = new List <BusinessObjects.Authors.AuthorsBO>(); Book.Authors = NewBook.Authors.Select(x => new BusinessObjects.Authors.AuthorsBO() { AuthorName = x.AuthorName }).ToList(); var Data = base.AddBook(Book); if (Data != null) { return(Data); } else { return("Invalid Data"); } } catch (Exception ex) { return("Invalid"); } }
public static int enterdatainissuebooks(BooksDTO dTO, string user) { string query = string.Format(@"INSERT INTO dbo.issuebook(MemberName,BookName,AuthorName,Category,issueDAte,BookReturn,ReturnDAte) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')" , user, dTO.BookName, dTO.BookAuthor, dTO.BooKCategory, DateTime.Now.ToString(), 0, "No Return"); using (DBHelper helper = new DBHelper()) { var count = helper.ExecuteQuery(query); return(count); } }
public async Task <ActionResult> Post([FromBody] BooksDTO entity) { try { return(Ok(await _booksService.Add(entity))); } catch (Exception ex) { return(BadRequest(new { message = ex.Message })); } }
public static int addnewbooks(BooksDTO dTO) { string query = string.Format(@"INSERT INTO dbo.Books(Name,AuthorName,ISBN,PublishDAte,Category,DOE) VALUES('{0}','{1}','{2}','{3}','{4}','{5}')" , dTO.BookName, dTO.BookAuthor, dTO.BookISBN, dTO.BookPublishdate, dTO.BooKCategory, DateTime.Now.ToString()); using (DBHelper helper = new DBHelper()) { var count = helper.ExecuteQuery(query); return(count); } }
public async Task <ActionResult> Put([FromBody] BooksDTO value) { try { await _booksService.Update(value); return(Ok()); } catch (Exception ex) { return(BadRequest(new { message = ex.Message })); } }
public BooksDTO GetAllBook() { var result = context.Books.ToList(); BooksDTO booksDTO = new BooksDTO() { bookList = new List <BookDTO>() }; foreach (Book book in result) { booksDTO.bookList.Add(mapper.Map <BookDTO>(book)); } booksDTO.bookList = booksDTO.bookList.OrderBy(p => p.LastNameAuthor).ToList(); return(booksDTO); }
public int BD(string titl) { using (SqlConnection conn = new SqlConnection(this.connStr)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); comm.CommandText = $"select * from Books where Titl='{titl}' "; SqlDataReader reader = comm.ExecuteReader(); BooksDTO books = new BooksDTO(); books.BookID = (int)reader["BookID"]; conn.Close(); return(books.BookID); } }
public static int issuebooks(int id, string user) { string query = string.Format(@"Select ID,Name,AuthorName,PublishDAte,Category from dbo.Books where ID={0}", id); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(query); BooksDTO dTO = new BooksDTO(); while (reader.Read()) { dTO.BookName = reader.GetString(reader.GetOrdinal("Name")); dTO.BookAuthor = reader.GetString(reader.GetOrdinal("AuthorName")); dTO.BooKCategory = reader.GetString(reader.GetOrdinal("Category")); string MemberName = user; var v = LMS.DAL.issuebooksDAO.enterdatainissuebooks(dTO, MemberName); return(v); } } return(0); }
public async Task PlaceBooksAsync(BooksDTO books, LockerDTO cRoom) { var room = await _uof.LockerRepository.GetByIdAsync(cRoom.Id); if (room == null) { throw new Exception("Clear"); } var mappedBooks = _mapper.Map <Books>(books); if ((string)books.Theme != (string)cRoom.Theme) { throw new Exception("Wrong"); } room.Bookses.Add(mappedBooks); await _uof.LockerRepository.UpdateAsync(room); }
public IHttpActionResult GetAll(int StartIndex = 0, int NumberOfBooks = 3) { // var books = context.Books.Where(c => c.ApprovalStatus == Status.Approved).ToList().Skip(StartIndex).Take(NumberOfBooks).ToList(); //books = books.Skip(StartIndex).Take(NumberOfBooks); List <Book> books = context.Books.Where(c => c.ApprovalStatus == Status.Approved).OrderBy(c => c.ID).Skip(StartIndex).Take(NumberOfBooks).ToList(); List <BooksDTO> booksDTO = new List <BooksDTO>(); for (int i = 0; i < books.Count; i++) { BooksDTO book = new BooksDTO(); book.ID = books[i].ID; book.PublisherName = books[i].Author; book.Author = books[i].BookPublisher.IfNotNull(c => c.User.LName + " " + c.User.LName); book.Title = books[i].Title; book.Category = books[i].Category; book.Price = books[i].Price; book.ISBN = books[i].ISBN; book.Year = books[i].PublicationYear.ToString(); booksDTO.Add(book); } return(Ok <List <BooksDTO> >(booksDTO)); }
public async Task <BooksDTO> GetBooks(int ids) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://kitsu.io"); var response = await client.GetAsync("/api/edge/anime/" + ids); if (response.IsSuccessStatusCode) { string s = await response.Content.ReadAsStringAsync(); var books = JsonConvert.DeserializeObject <BooksDTO>(s); return(books); } else { BooksDTO book = new BooksDTO(); return(book); } } }
//шукає книги за назвою в межах певної категорії public List <BooksDTO> Find(string text, string category) { using (SqlConnection conn = new SqlConnection(this.connStr)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); comm.CommandText = "select * from Books where Title Like '%" + text + $"%' and Category='{category}'"; SqlDataReader reader = comm.ExecuteReader(); List <BooksDTO> Books = new List <BooksDTO>(); while (reader.Read()) { BooksDTO books = new BooksDTO(); books.BookID = (int)reader["BookID"]; books.Title = reader["Title"].ToString(); books.Author = reader["Author"].ToString(); books.Price = (Decimal)reader["Price"]; Books.Add(books); } conn.Close(); return(Books); } }
public async Task <IHttpActionResult> PutBook(BooksDTO book) { await booksManager.Update <books, BooksDTO>(book, b => b.id); return(Ok()); }
public async Task <IHttpActionResult> PostBook(BooksDTO book) { return(Json(await booksManager.Add <books, BooksDTO>(book, (db, dto) => dto.id = db.id))); }
public static void Menu() { int id = Login(); //int id = 1; Console.WriteLine("Do you want to:\n 1-See all books \n " + "2-See your basket\n" + "3-Add a book to the basket\n" + "4-Go out\n"); var x = Console.ReadLine(); switch (x) { case "1": //можна побачити посортований за назвою список книг певної категорії,або знайти за назвою певну книгу CategoriesDal dal = new CategoriesDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); Console.WriteLine("Please,choose a category"); foreach (var categories in dal.GetAllCategories()) { Console.WriteLine($"{categories.Category}"); } string c = Console.ReadLine(); string connStr = ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString; BooksDal dal3 = new BooksDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); foreach (var book in dal3.Sort(c)) { Console.WriteLine($"{book.Title}\t{book.Author}\t{book.Price}"); } Console.WriteLine("Do you want to find smth?yes/no"); string s = Console.ReadLine(); if (s == "yes") { Console.WriteLine("Write the title of the book:"); string ti = Console.ReadLine(); foreach (var book in dal3.Find(ti, c)) { Console.WriteLine($"{book.Title}\t{book.Author}\t{book.Price}"); } } Menu(); break; case "2": Customer.GetBasket(id); Console.WriteLine("Do you want to buy books from basket?yes/no"); string s1 = Console.ReadLine(); if (s1 == "yes") { Customer.UpdateStatus(id, 1); } Console.WriteLine("Do you want to order shipping?yes/no"); string s2 = Console.ReadLine(); if (s2 == "yes") { Customer.UpdateStatus(id, 2); } Menu(); break; case "3": BasketDal dal2 = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); Console.WriteLine("Write a name of the wished book"); string t = Console.ReadLine(); Console.WriteLine("Write necessary amount:"); int a = Convert.ToInt32(Console.ReadLine()); string connStr2 = ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString; using (SqlConnection conn = new SqlConnection(connStr2)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); comm.CommandText = $"select * from Books where Title = '{t}'"; SqlDataReader reader = comm.ExecuteReader(); BooksDTO Book = new BooksDTO(); while (reader.Read()) { Book.BookID = (int)reader["BookID"]; Book.Author = reader["Autor"].ToString(); Book.Price = (Decimal)reader["Price"]; } conn.Close(); BasketDTO m = new BasketDTO { Title = t, UserID = id, BookID = Book.BookID, StatusID = 3, Author = Book.Author, Price = Book.Price, Amount = a, Date = DateTime.Now }; m = dal2.CreateBasket(m); } Menu(); break; case "4": Console.WriteLine("Bye:("); Thread.Sleep(1000); System.Environment.Exit(20); break; } }
public static int addnewbooks(BooksDTO dTO) { return(LMS.DAL.BooksDAO.addnewbooks(dTO)); }