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