private void Button_Click_1(object sender, RoutedEventArgs e)
{
RemoveRow(this.id.Text);
MessageBox.Show("Row has been removed successfully");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
//admin.Get_Synonyms.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
admin.wrap.Children.Remove(this);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
this.Close();
if (CheckUser(Login.Text, Password.Text.GetHashCode().ToString()))
{
AdminPanel admin = new AdminPanel();
admin.ShowDialog();
}
else
{
MessageBox.Show("Wrong credentials inserted");
}
}
private void RemoveRow(string id)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"DELETE FROM Answers WHERE Answer_ID=@id"
, conn);
cmd.Parameters.AddWithValue("@id", Convert.ToInt32(id));
SqlDataReader dr = cmd.ExecuteReader();
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Answers.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
private void AddTpc(object sender, RoutedEventArgs e)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"INSERT INTO Topics VALUES ( @topic )"
, conn);
cmd.Parameters.AddWithValue("@topic", this.topic.Text);
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Successfully added");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Topics.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
public void SaveTopic(string id, string topic)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"UPDATE Topics SET Topic = @topic WHERE ID=@id"
, conn);
cmd.Parameters.AddWithValue("@id", Convert.ToInt32(id));
cmd.Parameters.AddWithValue("@topic", topic);
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Row has been successfully changed");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Topics.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
public void SaveAns(string id, string ans, string altans)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"UPDATE Answers SET AnswerText = @ans, AlterAnswer1=@altans WHERE Answer_ID=@id"
, conn);
cmd.Parameters.AddWithValue("@id", Convert.ToInt32(id));
cmd.Parameters.AddWithValue("@ans", ans);
cmd.Parameters.AddWithValue("@altans", altans);
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Row has been successfully changed");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Answers.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
public void SaveSyns(string id, string word, string syns)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"UPDATE Synonyms SET Word = @word, Synonyms=@syn WHERE Id=@id"
, conn);
cmd.Parameters.AddWithValue("@id", Convert.ToInt32(id));
cmd.Parameters.AddWithValue("@word", word);
cmd.Parameters.AddWithValue("@syn", syns);
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Row has been successfully changed");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Synonyms.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
private void AddAns(object sender, RoutedEventArgs e)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"INSERT INTO Questions(QuestionText, Answer_ID, Topic_ID) VALUES ( @quest, @ans_id, @q_id)"
, conn);
cmd.Parameters.AddWithValue("@quest", this.question.Text);
cmd.Parameters.AddWithValue("@ans_id", Convert.ToInt32(this.answer_id.Text));
cmd.Parameters.AddWithValue("@q_id", Convert.ToInt32(this.topic_id.Text));
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Successfully added");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Questions.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
public void SaveQuestion(string id, string quest, string answer_id, string topic_id)
{
using (SqlConnection conn = new SqlConnection(Fill.cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"UPDATE Questions SET QuestionText = @quest, Answer_ID=@ans_id, Topic_ID=@t_id WHERE Question_ID=@id"
, conn);
cmd.Parameters.AddWithValue("@id", Convert.ToInt32(id));
cmd.Parameters.AddWithValue("@quest", quest);
cmd.Parameters.AddWithValue("@ans_id", Convert.ToInt32(answer_id));
cmd.Parameters.AddWithValue("@t_id", Convert.ToInt32(topic_id));
SqlDataReader dr = cmd.ExecuteReader();
MessageBox.Show("Row has been successfully changed");
AdminPanel admin = Application.Current.Windows.OfType <AdminPanel>().FirstOrDefault();
admin.Get_Questions.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
}
