//삭제 버튼 클릭 private void ButtonClickDelete() { List <members> selectedItems = MemberCollection.Where(x => x.IsSelect == true).ToList(); string showMassage = "선택 하신 " + selectedItems.Count.ToString() + " 건 의 데이터를 지우시겠습니까?"; if (MessageBox.Show(showMassage, "삭제", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { foreach (members user in selectedItems) { string deleteQuery = "DELETE FROM TB_MEMBERS where ID = '" + user.ID + "'"; string errorMassage; DBSqlite.QueryExecute(deleteQuery, out errorMassage); if (!string.IsNullOrEmpty(errorMassage)) { MessageBox.Show(errorMassage); return; } } } }
//적용 버튼 클릭 private void ButtonClickApply() { List <members> users = MemberCollection.ToList(); string showMassage = users.Count.ToString() + " 건 의 데이터를 업데이트 하시겠습니까?"; if (MessageBox.Show(showMassage, "적용", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { foreach (members user in users) { string deleteQuery = "UPDATE TB_MEMBERS " + "SET NAME = '" + user.NAME + "', AUTH = '" + user.AUTH + "', PASSWORD = '******' " + "WHERE ID = '" + user.ID + "'"; string errorMassage; DBSqlite.QueryExecute(deleteQuery, out errorMassage); if (!string.IsNullOrEmpty(errorMassage)) { MessageBox.Show(errorMassage); return; } } } MessageBox.Show("업데이트 완료"); }
//데이터 입력 private void InsertUser(members newUser) { string query = "INSERT INTO TB_MEMBERS(ID, NAME, AUTH, PASSWORD) " + "VALUES ('" + newUser.ID + "','" + newUser.NAME + "','" + newUser.AUTH + "','" + newUser.PASSWORD + "')"; string errMsg; if (DBSqlite.QueryExecute(query, out errMsg)) { if (MessageBox.Show("가입이 완료되었습니다.", "완료", MessageBoxButton.OK) == MessageBoxResult.OK) { joinWindow.Close(); } } if (!string.IsNullOrEmpty(errMsg)) { MessageBox.Show(errMsg); } }