//삭제 버튼 클릭
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);
}
}
