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(); }