public BookVO RegisterBook() { string name; string author; string publisher; string count; Console.Clear(); while (true) { Console.Write("\n\n\t도서 제목 입력(16자이내) : "); name = Console.ReadLine(); if (errorCheck.BookName(name) == false) { break; } FormErrorMsg("도서제목"); } while (true) { Console.Write("\n\n\t저자 입력(10자이내) : "); author = Console.ReadLine(); if (errorCheck.BookAuthor(author) == false) { break; } FormErrorMsg("저자"); } while (true) { Console.Write("\n\n\t출판사 입력(8자이내) : "); publisher = Console.ReadLine(); if (errorCheck.BookName(publisher) == false) { break; } FormErrorMsg("출판사명"); } while (true) { Console.Write("\n\n\t수량 입력(숫자만 입력) : "); count = Console.ReadLine(); if (errorCheck.BookCount(count) == false) { break; } FormErrorMsg("수량"); } BookVO newBook = new BookVO(name, author, publisher, int.Parse(count)); return(newBook); }
public BookVO SearchBook(string searchType, string searchBy) { string searchName; string searchAuthor; string searchPublisher; if (searchBy.Equals("도서명")) { switch (searchType) { case "editSearch": print.Search("편집할 책 이름"); break; case "removeSearch": print.Search("삭제할 책의 이름"); break; case "justSearch": print.Search("검색할 책 이름"); break; case "rentBook": print.Search("대여할 책 이름"); break; } searchName = Console.ReadLine(); if (errorCheck.BookName(searchName)) { print.FormErrorMsg("도서제목"); menu.BookManagementMenu(); } sqlQuery = "select * from book where name='" + searchName + "';"; } else if (searchBy.Equals("출판사명")) { switch (searchType) { case "editSearch": print.Search("편집할 책 출판사명"); break; case "removeSearch": print.Search("삭제할 책의 출판사명"); break; case "justSearch": print.Search("검색할 책 출판사명"); break; case "rentBook": print.Search("대여할 책 출판사명"); break; } searchPublisher = Console.ReadLine(); if (errorCheck.BookPublisher(searchPublisher)) { print.FormErrorMsg("출판사명"); menu.BookManagementMenu(); } sqlQuery = "select * from book where publisher='" + searchPublisher + "';"; } else if (searchBy.Equals("저자명")) { switch (searchType) { case "editSearch": print.Search("편집할 책 저자명"); break; case "removeSearch": print.Search("삭제할 책의 저자명"); break; case "justSearch": print.Search("검색할 책 저자명"); break; case "rentBook": print.Search("대여할 책 저자명"); break; } searchAuthor = Console.ReadLine(); if (errorCheck.BookAuthor("저자명")) { print.FormErrorMsg("저자명"); menu.BookManagementMenu(); } sqlQuery = "select * from book where author='" + searchAuthor + "';"; } SendQuery(); dataReader.Read(); if (errorCheck.IsValidBook(dataReader) == false) //검색 에러 { CloseDB(); print.ErrorMsg("존재하는 도서 찾기"); if (searchType.Equals("justSearch")) { menu.BookManagementMenu(); } return(null); } BookVO foundBook = new BookVO(dataReader["name"].ToString(), dataReader["author"].ToString(), dataReader["publisher"].ToString(), int.Parse(dataReader["count"].ToString())); if (searchType.Equals("justSearch")) { print.BookInfo(foundBook); menu.BookSearchMenu(); } CloseDB(); return(foundBook); }