/// <summary> /// 이미 아이디가 존재하는지를 체크하는 부분 /// </summary> /// <param name="list">회원정보 리스트</param> /// <returns>회원이 있는지 없는지를 bool값으로 리턴</returns> public bool CheckId() { count = 0; if (!databaseException.IsIdInMemberDB(id)) { Console.WriteLine("\n\n\t\t\tUsername already taken. Please try another one."); drawControlMember.PressAnyKey(); return(false); } return(true); }
/// <summary> /// 검색 기능을 담당하는 메소드 /// </summary> /// <param name="list"></param> public void DrawSearch() { bool exitFlag = true; while (exitFlag) { drawControlMember.SearchMenu(); id = Console.ReadLine(); Console.Clear(); switch (id) { case LibraryConstants.SearchWithName: SearchSub(LibraryConstants.SearchWithName); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where name = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithResidentNum: SearchSub(LibraryConstants.SearchWithResidentNum); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where residentNumber = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithId: SearchSub(LibraryConstants.SearchWithId); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where id = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithPassword: SearchSub(LibraryConstants.SearchWithPassword); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where password = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithAddress: SearchSub(LibraryConstants.SearchWithAddress); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where address = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithPhone: SearchSub(LibraryConstants.SearchWithPhone); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where phoneNumber = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithAge: SearchSub(LibraryConstants.SearchWithAge); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where age = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.ReturnBack: exitFlag = false; break; default: break; } } }