private void RefreshDataGrid()
{
string query = "SELECT ID, NAME, AUTH, PASSWORD FROM TB_MEMBERS";
using (DataTable dt = DBSqlite.GetSelectData(query))
{
if (dt.Rows.Count > 0)
{
MemberCollection.Clear();
foreach (DataRow dr in dt.Rows)
{
members user = new members()
{
IsSelect = false,
ID = dr["ID"].ToString(),
NAME = dr["NAME"].ToString(),
AUTH = dr["AUTH"].ToString(),
PASSWORD = dr["PASSWORD"].ToString()
};
MemberCollection.Add(user);
}
}
}
}
private void GetQuestion()
{
string query = "SELECT QUESTION_ID, QUESTION_USER_ID, QUESTION_TEXT, ROW_INDEX FROM TB_USER_QUESTION";
using (DataTable dt = DBSqlite.GetSelectData(query))
{
if (dt.Rows.Count > 0)
{
QuestionCollection.Clear();
foreach (DataRow dr in dt.Rows)
{
question Question = new question()
{
QUESTION_ID = dr["QUESTION_ID"].ToString(),
QUESTION_USER_ID = dr["QUESTION_USER_ID"].ToString(),
QUESTION_TEXT = dr["QUESTION_TEXT"].ToString(),
ROW_INDEX = (int)dr["ROW_INDEX"]
};
QuestionCollection.Add(Question);
}
}
}
}
//유저 아이디 판별
private bool ConfirmUserID(members newUser)
{
string query = "SELECT ID FROM TB_MEMBERS WHERE ID = '" + newUser.ID + "'";
using (DataTable dt = DBSqlite.GetSelectData(query))
{
if (dt.Rows.Count <= 0)
{
return(true);
}
}
return(false);
}
private void ComboBoxBinding()
{
Members = new ObservableCollection <members>();
string qeury = "SELECT ID, NAME FROM TB_MEMBERS";
using (DataTable dt = DBSqlite.GetSelectData(qeury))
{
foreach (DataRow dr in dt.Rows)
{
Members.Add(new members()
{
ID = dr["ID"].ToString(), NAME = dr["NAME"].ToString()
});
}
}
}
private bool LoginConfirmation(string userID, string userPassWord)
{
string query = "SELECT * from TB_MEMBERS WHERE ID = '" + userID + "' AND PASSWORD = '******'";
using (DataTable dt = DBSqlite.GetSelectData(query))
{
if (dt.Rows.Count > 0)
{
Application.Current.Resources["id"] = userID;
return(true);
}
else
{
return(false);
}
}
}
