private void updateUser(object sender, EventArgs e)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
dBUser.updateUserInfo(userId, userNameTextBox.Text.ToString(), phoneTextBox.Text.ToString());
sendUpdateUserSuccessMessage();
this.Close();
}
protected override void WndProc(ref Message m)
{
try
{
switch (m.Msg)
{
case WM_USERDATA:
DBUtils.DBUser dBUser = new DBUtils.DBUser();
dBUser.userDataGridViewConnect(dataGridView1);
//COPYDATASTRUCT cds = (COPYDATASTRUCT)m.GetLParam(typeof(COPYDATASTRUCT));
//byte[] buff = System.Text.Encoding.Default.GetBytes(cds.lpData);
//COPYDATASTRUCT cs = new COPYDATASTRUCT();
//cs.dwData = new IntPtr(0);
//cs.cbData = buff.Length;
//cs.lpData = cds.lpData;
// 다시 보낼 Form2의 windows 헨들을 가져 온다.
//IntPtr hwnd = FindWindow(null, "Form2");
//SendMessage(hwnd, WM_COPYDATA, IntPtr.Zero, ref cs);
break;
default:
base.WndProc(ref m);
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void insertNewUser(object sender, EventArgs e)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
string name = textBox1.Text.ToString();
string phone = textBox2.Text.ToString();
dBUser.insertUser(dataGridView1, name, phone);
sendInsertUserSuccessMessage();
}
private void getUserInfo(int id)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
Models.User user = dBUser.getUserInfo(id);
//MessageBox.Show(user.name);
userNameTextBox.Text = user.name;
userPhoneTextBox.Text = user.phone;
}
private void searchButtonClick(object sender, EventArgs e)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
string searchWord = searchWordTextBox.Text.ToString();
int comboIndex = userSearchCombo.SelectedIndex;
List <Models.User> searchedUserList = dBUser.searchUser(comboIndex, searchWord);
var bindingSearchedList = new BindingList <Models.User>(searchedUserList);
dataGridView1.DataSource = bindingSearchedList;
}
public void returnBook(DataGridView bookDataGridView, DataGridView userDataGridView, int bookId, int userId, string bookIsbn)
{
checkBorrowed(bookId);
if (isBorrowed == 0)
{
MessageBox.Show("대여중이지 않은 도서는 반납할수 없습니다.");
return;
}
connection = new MySqlConnection("server=localhost;user id=root;password=root1234;persistsecurityinfo=True;port=3306;database=lib;SslMode=none");
string bookReturnQuery = "UPDATE books SET userId = null, userName = null, isBorrowed = 0, borrowedAt = null, returnedAt = null WHERE id = @bookId";
MySqlCommand bookCmd = new MySqlCommand(bookReturnQuery, connection);
bookCmd.Parameters.AddWithValue("@bookId", bookId);
string userReturnQuery = "UPDATE users SET borrowedNumber = borrowedNumber - 1 WHERE id = @userId";
MySqlCommand userCmd = new MySqlCommand(userReturnQuery, connection);
userCmd.Parameters.AddWithValue("@userId", userId);
string historyReturnQuery = "UPDATE history SET returnedAt = @returnedAt WHERE userId = @userId AND bookIsbn = @bookIsbn";
MySqlCommand historyCmd = new MySqlCommand(historyReturnQuery, connection);
historyCmd.Parameters.AddWithValue("@returnedAt", DateTime.Now);
historyCmd.Parameters.AddWithValue("@userId", userId);
historyCmd.Parameters.AddWithValue("@bookIsbn", bookIsbn);
try
{
connection.Open();
bookCmd.ExecuteNonQuery();
userCmd.ExecuteNonQuery();
historyCmd.ExecuteNonQuery();
DBBook dBBook = new DBBook();
DBUser dBUser = new DBUser();
dBBook.bookDataGridViewConnect(bookDataGridView);
dBUser.userDataGridViewConnect(userDataGridView);
} catch (Exception exception)
{
MessageBox.Show("반납하는데 실패.");
} finally
{
if (connection != null)
{
connection.Close();
}
}
}
public Form1()
{
InitializeComponent();
Text = "도서관 관리";
DBUtils.DBUser dBUser = new DBUtils.DBUser();
DBUtils.DBBook dBBook = new DBUtils.DBBook();
// 라벨 설정
//label5.Text = DataManager.Books.Count.ToString();
label5.Text = dBBook.getBookCount().ToString();
label6.Text = dBUser.getUserCount().ToString();
label7.Text = DataManager.Books.Where((x) => x.isBorrowed).Count().ToString();
label8.Text = DataManager.Books.Where((x) =>
{
return(x.isBorrowed && x.BorrowedAt.AddDays(7) > DateTime.Now);
}).Count().ToString();
// 데이터 그리드 설정
//dataGridView1.DataSource = DataManager.Books;
dBBook.bookDataGridViewConnect(dataGridView1);
dataGridView1.ReadOnly = true;
//dataGridView2.DataSource = DataManager.Users;
dBUser.userDataGridViewConnect(dataGridView2);
dataGridView2.ReadOnly = true;
dataGridView1.CurrentCellChanged += DataGridView1_CurrentCellChanged;
dataGridView2.CurrentCellChanged += DataGridView2_CurrentCellChanged;
// 버튼 이벤트 설정
//button1.Click += Button1_Click;
button1.Click += borrowButtonClick;
//button2.Click += Button2_Click;
button2.Click += returnBook;
// 대여 및 반납기록 클릭 이벤트
대여및반납기록ToolStripMenuItem.Click += ShowHistoryForm;
}
public Form3()
{
InitializeComponent();
Text = "사용자 관리";
// 데이터 그리드 설정
//dataGridView1.DataSource = DataManager.Users;
DBUtils.DBUser dBUser = new DBUtils.DBUser();
dBUser.userDataGridViewConnect(dataGridView1);
dataGridView1.CurrentCellChanged += DataGridView1_CurrentCellChanged;
dataGridView1.ReadOnly = true;
// 버튼 설정
button1.Click += insertNewUser;
//button1.Click += (sender, e) =>
//{
//// 추가 버튼
//try
// {
// if (DataManager.Users.Exists((x) => x.Id == int.Parse(textBox1.Text)))
// {
// MessageBox.Show("사용자 ID가 겹칩니다");
// }
// else
// {
// User user = new User()
// {
// Id = int.Parse(textBox1.Text),
// Name = textBox2.Text
// };
// DataManager.Users.Add(user);
// dataGridView1.DataSource = null;
// dataGridView1.DataSource = DataManager.Users;
// DataManager.Save();
// }
// }
// catch (Exception exception)
// {
// }
//};
//button2.Click += (sender, e) =>
//{
//// 수정 버튼
//try
// {
// User user = DataManager.Users.Single((x) => x.Id == int.Parse(textBox1.Text));
// user.Name = textBox2.Text;
// dataGridView1.DataSource = null;
// dataGridView1.DataSource = DataManager.Users;
// }
// catch (Exception exception)
// {
// MessageBox.Show("존재하지 않는 사용자입니다");
// }
//};
button2.Click += updateButtonClick;
button3.Click += removeSelectedUser;
//button3.Click += (sender, e) =>
//{
//// 수정 버튼
//try
// {
// User user = DataManager.Users.Single((x) => x.Id == int.Parse(textBox1.Text));
// DataManager.Users.Remove(user);
// dataGridView1.DataSource = null;
// dataGridView1.DataSource = DataManager.Users;
// DataManager.Save();
// }
// catch (Exception exception)
// {
// MessageBox.Show("존재하지 않는 사용자입니다");
// }
//};
userSearchCombo.Items.Add("이름");
userSearchCombo.Items.Add("휴대폰 번호");
userSearchCombo.SelectedIndex = 0;
searchButton.Click += searchButtonClick;
searchAllButton.Click += searchAll;
}
private void searchAll(object sender, EventArgs e)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
dBUser.userDataGridViewConnect(dataGridView1);
}
private void removeSelectedUser(object sender, EventArgs e)
{
DBUtils.DBUser dBUser = new DBUtils.DBUser();
dBUser.removeSelectedUser(dataGridView1, id);
sendRemoveUserSuccessMessage();
}
