/// <summary> /// 이미 아이디가 존재하는지를 체크하는 부분 /// </summary> /// <param name="list">회원정보 리스트</param> /// <returns>회원이 있는지 없는지를 bool값으로 리턴</returns> public bool CheckId() { if (!dBExceptionHandler.IsIdInMemberDB(id)) { Console.WriteLine("\n\n\t\t\tUsername already taken. Please try another one."); printAboutControlMembers.PressAnyKey(); return(false); } return(true); }
/// <summary> /// 검색 기능을 담당하는 메소드 /// </summary> /// <param name="list"></param> public void PrintSearch() { bool exitFlag = true; while (exitFlag) { printAboutControlMembers.SearchMenu(); id = Console.ReadLine(); Console.Clear(); switch (id) { case LibraryConstants.SEARCH_WITH_NAME: SearchSub(LibraryConstants.SEARCH_WITH_NAME); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where name like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_RESIDENT_NUMBER: SearchSub(LibraryConstants.SEARCH_WITH_RESIDENT_NUMBER); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where residentNumber like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_ID: SearchSub(LibraryConstants.SEARCH_WITH_ID); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where id like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_PASSWORD: SearchSub(LibraryConstants.SEARCH_WITH_PASSWORD); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where password like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_ADDRESS: SearchSub(LibraryConstants.SEARCH_WITH_ADDRESS); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where address like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_PHONE: SearchSub(LibraryConstants.SEARCH_WITH_PHONE); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where phoneNumber like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.SEARCH_WITH_AGE: SearchSub(LibraryConstants.SEARCH_WITH_AGE); if (search.Equals("0")) { return; } printAboutControlMembers.Category(); logDAO.AddLog(DateTime.Now, search, "회원 검색"); memberDAO.SearchWithQuary("select * from member where age like \"%" + search + "%\""); printAboutControlMembers.PressAnyKey(); break; case LibraryConstants.RETURN_BACK: exitFlag = false; return; default: break; } } }