public void searchMembers(string nameOrId, string searchWord)
{
Console.Clear();
conn = new MySqlConnection(strConn); // conncet MySQL
conn.Open();
ShareClass.getShareClass().getDisplay().membershipBar();
String sql = "select * from member where " + nameOrId + " like '" + searchWord + "%" + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
memberid = reader["memberid"].ToString();
password = reader["password"].ToString();
name = reader["name"].ToString();
birth = reader["birth"].ToString();
if (name.Contains(searchWord) || memberid.Contains(searchWord))
{
Console.SetCursorPosition(8, count);
Console.Write(memberid);
Console.SetCursorPosition(28, count);
Console.Write(password);
Console.SetCursorPosition(48, count);
Console.Write(name);
Console.SetCursorPosition(70, count);
Console.Write(birth);
count += 2;
ShareClass.getShareClass().getException().goBack("membersearch");
}
}
reader.Close();
conn.Close();
}
public void memberAllSearchOfDB() //DB 내 저장한 데이터들 모두 출력
{
Console.Clear();
conn = new MySqlConnection(strConn);
conn.Open();
String sql = "select * from member;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
ShareClass.getShareClass().getDisplay().membershipBar();
while (reader.Read())
{
memberid = reader["memberid"].ToString();
password = reader["password"].ToString();
name = reader["name"].ToString();
birth = reader["birth"].ToString();
Console.SetCursorPosition(8, count);
Console.Write(memberid);
Console.SetCursorPosition(28, count);
Console.Write(password);
Console.SetCursorPosition(48, count);
Console.Write(name);
Console.SetCursorPosition(70, count);
Console.Write(birth);
count += 2;
}
reader.Close();
conn.Close();
}
public int rentCount(string userid) //뭘 빌렸는지 개수를 세서 대출 제한을 둘 수 있게 한다
{
Console.Clear();
conn = new MySqlConnection(strConn);
conn.Open();
String sql = "select * from rent where memberid ='" + userid + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
ShareClass.getShareClass().getDisplay().rentBookBar();
while (reader.Read())
{
id = reader["memberid"].ToString();
no = reader["no"].ToString();
title = reader["bookname"].ToString();
rentDay = reader["rentday"].ToString();
returnDay = reader["returnday"].ToString();
cnt++;
}
reader.Close();
conn.Close();
return(cnt);
}
public bool checkRentBookNo(string bookNo) //rent 테이블 내 데이터들을 비교해서 빌린 책 넘버가 맞는지 확인
{
conn = new MySqlConnection(strConn);
bool isMatchNo = false;
conn.Open();
string sql = "select * from rent where memberid ='" + ShareClass.getShareClass().getLoginId() + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string memberid = reader["memberid"].ToString();
string no = reader["no"].ToString();
string bookName = reader["bookname"].ToString();
if (ShareClass.getShareClass().getLoginId() == memberid)
{
if (bookNo == no)
{
isMatchNo = true;
break;
}
else
{
isMatchNo = false;
}
}
}
reader.Close();
conn.Close();
return(isMatchNo);
}
public static ShareClass getShareClass()
{
if (shareclass == null)
{
shareclass = new ShareClass();
}
return(shareclass);
}
public void loginUsingDB(string input, string input2)
{
conn = new MySqlConnection(strConn); // conncet MySQL
bool login = true;
conn.Open();
String sql = "select * from member;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
memberid = reader["memberid"].ToString();
password = reader["password"].ToString();
name = reader["name"].ToString();
if (input == memberid)
{
if (input2 == password)
{
Console.Clear();
saveMemberID(memberid);
login = true;
Console.WriteLine("\n\n\t\t" + name + "님 로그인되셨습니다."); //로그인 성공! 로그인시 뜨는 화면으로 들어간다
Thread.Sleep(800);
ShareClass.getShareClass().getMenu().menuOnLogin();
break;
}
else
{
Console.WriteLine("\n\n\t 비밀번호 오류");
Thread.Sleep(800);
ShareClass.getShareClass().getLogin().login(); //다시한번 로그인 창
}
}
else
{
login = false;
}
}
if (login.Equals(false))
{
Console.WriteLine("\n\n\t 아이디가 존재하지 않습니다");
Thread.Sleep(800);
ShareClass.getShareClass().getMenu().mainMenu();
}
reader.Close();
conn.Close();
}
public void rentSearch(string userid, string message) //뭘 빌렸는지 로그인 한 본인 아이디에 관해서 출력
{
Console.Clear();
conn = new MySqlConnection(strConn);
conn.Open();
String sql = "select * from rent where memberid ='" + userid + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
ShareClass.getShareClass().getDisplay().rentBookBar();
while (reader.Read())
{
id = reader["memberid"].ToString();
no = reader["no"].ToString();
title = reader["bookname"].ToString();
rentDay = reader["rentday"].ToString();
returnDay = reader["returnday"].ToString();
Console.SetCursorPosition(8, count);
Console.Write(id);
Console.SetCursorPosition(30, count);
Console.Write(no);
Console.SetCursorPosition(40, count);
Console.Write(title);
Console.SetCursorPosition(68, count);
Console.Write(rentDay);
Console.SetCursorPosition(95, count);
Console.Write(returnDay);
count += 2; cnt++;
}
if (cnt == 0)
{
Console.Clear();
Console.WriteLine("\n\t\t {0} 책이 없습니다", message); Thread.Sleep(800);
}
reader.Close();
conn.Close();
}
public void addRentTable(string bookNo, string bookTitle) //대출 시 rent 테이블에 들어갈 데이터 추가 쿼리문
{
conn = new MySqlConnection(strConn);
conn.Open();
string sql = "insert into rent values('" + ShareClass.getShareClass().getLoginId() + "','" + bookNo + "','" + bookTitle + "','" + DateTime.Now + "','" + DateTime.Now.AddDays(7) + "' ); ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
if (cmd.ExecuteNonQuery() == 1)
{
Console.Clear();
Console.WriteLine("\n\n\n\n");
Console.WriteLine("\t\t" + bookTitle + " 대여되셨습니다.");
Thread.Sleep(1000);
}
else
{
Console.Clear();
Console.WriteLine("Database Error!!");
Thread.Sleep(1000);
}
conn.Close();
}
internal void saveMemberID(string userId)
{
ShareClass.getShareClass().setLoginId(userId);
}
