//회원 검색 public MemberVO SearchMember(string searchType) { string searchID; switch (searchType) { case "editSearch": print.Search("정보를 편집할 회원의 아이디"); break; case "removeSearch": print.Search("삭제할 회원의 아이디"); break; case "justSearch": print.Search("검색할 회원의 아이디"); break; } searchID = Console.ReadLine(); MemberVO foundMember = dao.Select(searchID); if (searchType.Equals("justSearch")) { print.MemberInfo(foundMember); adminMenu.MemberManagementMenu(); } return(foundMember); }
public BookManagement(UserMenu userMenu, DAO dao, string logonID) { print = Print.GetInstance(); errorCheck = ErrorCheck.GetInstance(); this.userMenu = userMenu; this.dao = dao; bookList = new List <BookVO>(); this.logonID = logonID; logOnMember = dao.Select(logonID); }
//Insert statement public void Insert(MemberVO inputMember) { dataReader.Close(); sqlQuery = "insert into member values('" + inputMember.Id + "', '" + inputMember.Password + "', '" + inputMember.Name + "', '" + inputMember.Gender + "', '" + inputMember.PhoneNumber + "', '" + inputMember.Email + "', '" + inputMember.Address + "', '" + inputMember.RentBook + "', '" + inputMember.DueDate + "', '" + inputMember.ExtensionCount + "');"; SendQuery(sqlQuery); }
//Select statement public MemberVO Select(string id) { dataReader.Close(); sqlQuery = "select * from member where id='" + id + "';"; SendQuery(sqlQuery); dataReader.Read(); MemberVO selectedMember = new MemberVO(dataReader["id"].ToString(), dataReader["password"].ToString(), dataReader["name"].ToString(), dataReader["gender"].ToString(), dataReader["phoneNumber"].ToString(), dataReader["email"].ToString(), dataReader["address"].ToString(), dataReader["rentbook"].ToString(), dataReader["duedate"].ToString(), 3); return(selectedMember); }
public void DeleteMember(MemberVO inputMember) { Console.Clear(); Console.WriteLine("\n\n\t---------------------------------삭제할 회원 기존 정보--------------------------------"); Console.WriteLine("\n\t아이디 : {0}", inputMember.Id); Console.WriteLine("\t이름 : {0}", inputMember.Name); Console.WriteLine("\t성별 : {0}", inputMember.Gender); Console.WriteLine("\t핸드폰 번호 : {0}", inputMember.PhoneNumber); Console.WriteLine("\t이메일 : {0}", inputMember.Email); Console.WriteLine("\t주소 : {0}", inputMember.Address + "\n"); Console.WriteLine("\t--------------------------------------------------------------------------------------"); Console.Write("\n\n\t정말로 삭제하시겠습니까? (Y/N) : "); }
//회원정보 수정 public void EditMember() { MemberVO foundMember = SearchMember("editSearch"); foundMember = print.EditMember(foundMember); dao.Update("member", "phoneNumber", foundMember.PhoneNumber, "id", foundMember.Id); dao.Update("member", "address", foundMember.Address, "id", foundMember.Id); dao.Insert("관리자", "회원정보수정", foundMember.Name, DateTime.Now); print.CompleteMsg("회원 정보 수정 완료"); adminMenu.MemberManagementMenu(); return; }
public void MemberInfo(MemberVO inputMember) { Console.Clear(); Console.WriteLine("\n\n\t---------------------------------검색한 회원 기존 정보--------------------------------"); Console.WriteLine("\n\t아이디 : {0}", inputMember.Id); Console.WriteLine("\t학번 : {0}", inputMember.Name); Console.WriteLine("\t성별 : {0}", inputMember.Gender); Console.WriteLine("\t핸드폰 번호 : {0}", inputMember.PhoneNumber); Console.WriteLine("\t주소 : {0}", inputMember.Address); Console.WriteLine("\t현재 대출한 책 : {0}", inputMember.RentBook); Console.WriteLine("\t반납 예정일 : {0}", inputMember.DueDate + "\n"); Console.WriteLine("\t연장 가능횟수 : {0}", inputMember.ExtensionCount + "\n"); Console.WriteLine("\t--------------------------------------------------------------------------------------"); Console.Write("\n\n\t이전으로 돌아가려면 엔터..."); Console.ReadLine(); }
public MemberVO EditMember(MemberVO inputMember) { string phoneNumber, address; Console.Clear(); Console.WriteLine("\n\n\t---------------------------------수정할 회원 기존 정보--------------------------------"); Console.WriteLine("\n\t아이디 : {0}", inputMember.Id); Console.WriteLine("\t이름 : {0}", inputMember.Name); Console.WriteLine("\t성별 : {0}", inputMember.Gender); Console.WriteLine("\t핸드폰 번호 : {0}", inputMember.PhoneNumber); Console.WriteLine("\t이메일 주소 : {0}", inputMember.Email); Console.WriteLine("\t주소 : {0}", inputMember.Address + "\n"); Console.WriteLine("\t--------------------------------------------------------------------------------------"); Console.WriteLine("\n\n\t---------------------------------수정할 회원 정보 입력--------------------------------"); while (true) { Console.Write("\n\t핸드폰 번호 입력(010-1234-5678 형식) : "); phoneNumber = Console.ReadLine(); if (errorCheck.MemberPhone(phoneNumber) == false) { break; } FormErrorMsg("핸드폰 번호"); } while (true) { Console.Write("\n\n\t주소 입력(동/리까지 입력) : "); address = Console.ReadLine(); if (errorCheck.MemberAddress(address) == false) { break; } FormErrorMsg("주소"); } inputMember.PhoneNumber = phoneNumber; inputMember.Address = address; return(inputMember); }
//회원 정보 삭제 public void RemoveMember() { string confirm; MemberVO foundMember = SearchMember("removeSearch"); print.DeleteMember(foundMember); confirm = Console.ReadLine(); if (errorCheck.Confirm(confirm)) { print.MenuErrorMsg("Y/N오류"); adminMenu.MemberManagementMenu(); return; } dao.Delete("member", "id", foundMember.Id); dao.Insert("관리자", "회원삭제", foundMember.Name, DateTime.Now); print.CompleteMsg("회원 삭제 완료"); adminMenu.MemberManagementMenu(); return; }
public MemberVO RegisterMember() //while로 틀린 항목 다시 입력하게 { string id, password, name, gender, phoneNumber, email, address; Console.Clear(); while (true) { Console.Write("\n\n\t학번 입력 (6~8자리 이내) : "); id = Console.ReadLine(); if (errorCheck.MemberID(id) == false) { break; } FormErrorMsg("학번"); } while (true) { Console.Write("\n\n\t비밀번호 입력 (숫자만 4자리) : "); password = Console.ReadLine(); if (errorCheck.MemberPassword(password) == false)//미리 설정해둔 정규식에 맞으면 bool 타입 false 반환 { break; } FormErrorMsg("이름"); } while (true) { Console.Write("\n\n\t이름 입력 (4자리 이내) : "); name = Console.ReadLine(); if (errorCheck.MemberName(name) == false)//미리 설정해둔 정규식에 맞으면 bool 타입 false 반환 { break; } FormErrorMsg("이름"); } while (true) { Console.Write("\n\n\t성별 입력 (남자/여자): "); gender = Console.ReadLine(); if (errorCheck.MemberGender(gender) == false) { break; } FormErrorMsg("성별"); } while (true) { Console.Write("\n\n\t핸드폰 번호 입력(010-1234-5678 형식) : "); phoneNumber = Console.ReadLine(); if (errorCheck.MemberPhone(phoneNumber) == false) { break; } FormErrorMsg("핸드폰 번호"); } while (true) { Console.Write("\n\n\t이메일 입력 : "); email = Console.ReadLine(); if (errorCheck.MemberEmail(email) == false) { break; } FormErrorMsg("이메일"); } while (true) { Console.Write("\n\n\t주소 입력 : "); address = Console.ReadLine(); if (errorCheck.MemberAddress(address) == false) { break; } FormErrorMsg("주소"); } MemberVO newMember = new MemberVO(id, password, name, gender, phoneNumber, email, address, "없음", "없음", 2); return(newMember); }