private void borrow_event_Click(object sender, RoutedEventArgs e)
{
if (flag == Book_state.From) // 대여 ( DB 소유자 변경 )
{
if (Data.login_state) // 로그인시에만 대여 가능
{
string query = $"UPDATE `book_l`.`books` SET `Rental_User_ID`='{Data.user.user_id}' WHERE `Book_ID`={now_book};"; // 책 소유자 변경
//string query_userhistory = $"UPDATE `book_l`.`books` SET `Rental_User_ID`='{Data.user.user_id}' WHERE `Book_ID`={now_book};"; // 유저 로그 수정
string query_bookhistory = $"INSERT INTO `book_l`.`books_history` (`Book_ID`, `User_ID`, `Book_Name`,`User_Name` ) VALUES ('{now_book}', '{Data.user.user_id}', '{lblname.Content}', '{Data.user.user_name}');"; // 책 로그 추가
Data.DB_con.write_query(query + query_bookhistory);
MessageBox.Show("대여 되었습니다.");
this.Dispatcher.Invoke(DispatcherPriority.Normal, (ThisDelegate) delegate()
{
//메세지 박스 출력 (완료) 후 화면갱신
Book_img.Source = new BitmapImage();
borrow_event.IsEnabled = false;
lblname.Content = "";
lblgenre.Content = "";
lblauthor.Content = "";
lblstate.Content = "";
});
}
else
{
Login_View login_View = new Login_View();
login_View.ShowDialog();
if (login_View.DialogResult == true)
{
Data.login_state = true; // 로그인
}
}
}
else // 반남 ( DB 소유자 -> 1 )
{
string date = System.DateTime.Now.ToString("yyyy-MM-dd");
string query = $"UPDATE `book_l`.`books` SET `Rental_User_ID`='1' WHERE `Book_ID`={now_book};"; // 0 - 로그인 유저(비로그인 생각) 1- 책id
string query_book = $"UPDATE `book_l`.`books_history` SET `Return_Date`='{date}' WHERE `Book_ID`={now_book} and `Return_Date` IS NULL LIMIT 1"; // 가장 최근 책 대여 return 날짜 설정 ( 책은 한번에 한권 대여 )
Data.DB_con.write_query(query + query_book);
MessageBox.Show("반납 되었습니다.");
this.Dispatcher.Invoke(DispatcherPriority.Normal, (ThisDelegate) delegate()
{
//메세지 박스 출력 (완료) 후 화면갱신
Book_img.Source = new BitmapImage();
borrow_event.IsEnabled = false;
lblname.Content = "";
lblgenre.Content = "";
lblauthor.Content = "";
lblstate.Content = "";
});
}
}
private void login_click(object sender, RoutedEventArgs e)
{
if (Data.login_state)
{
if (MessageBox.Show("로그아웃 하시겠습니까?", "메세지", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
}
else
{
return;
}
user_name_info.Content = "";
user_address_info.Content = "";
user_email_info.Content = "";
user_note_info.Content = "";
user_image.Source = new BitmapImage();
user_image.Stretch = Stretch.Uniform;
Data.login_state = false;
user_btn.Content = "LogIn";
Set_btn.Visibility = Visibility.Hidden;
}
else
{
Login_View login_View = new Login_View();
login_View.ShowDialog();
if (login_View.DialogResult == true)
{
user_name_info.Content = Data.user.user_name;
user_address_info.Content = Data.user.user_address;
user_email_info.Content = Data.user.user_email;
user_note_info.Content = Data.user.user_note;
//MessageBox.Show(System.Environment.CurrentDirectory + @"\User\" + Data.user.user_image);
try
{
user_image.Source = new BitmapImage(new Uri(System.Environment.CurrentDirectory + @"\User\" + Data.user.user_image));
}
catch
{
user_image.Source = new BitmapImage(new Uri(@"Resource\User_default.png", UriKind.Relative)); // 이미지 찾기 실패시 기본 이미지 표시
}
user_image.Stretch = Stretch.Uniform;
Data.login_state = true;
user_btn.Content = "LogOut";
if (Data.user.user_level == "1")
{
Set_btn.Visibility = Visibility.Visible; // 운영자 계정일때만 Visible
}
}
}
}