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