private void button1_Click(object sender, EventArgs e)
{
WorkHorse W = new WorkHorse();
string LS = textBox1.Text + "," + textBox2.Text + "," + textBox3.Text + "," + textBox4.Text + "," + textBox5.Text + "," + textBox6.Text;
W.Add(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text);/*
*
* string UserQuery = "INSERT INTO Questions (Subject, Question, CorrectAnswer, AnswerA, AnswerB, AnswerC) Values (@Subject, @Question, @CorrectAnswer, @AnswerA, @AnswerB, @AnswerC)";//Adding Into Our Database To Add To The Likes
* SqlConnection UserConnect = new SqlConnection(ConfigurationManager.ConnectionStrings["CsData"].ConnectionString);
* SqlCommand UserCmd = new SqlCommand(UserQuery, UserConnect); //Our Query To Execute
*
* UserCmd.Parameters.AddWithValue("@Subject", textBox1.Text); //Adds It To Check
* UserCmd.Parameters.AddWithValue("@Question", textBox2.Text); //Adds It To Check
* UserCmd.Parameters.AddWithValue("@CorrectAnswer", textBox3.Text); //Adds It To Check
* UserCmd.Parameters.AddWithValue("@AnswerA", textBox4.Text); //Adds It To Check
* UserCmd.Parameters.AddWithValue("@AnswerB", textBox5.Text); //Adds It To Check
* UserCmd.Parameters.AddWithValue("@AnswerC", textBox6.Text); //Adds It To Check
*
* UserConnect.Open(); //Opens Our Connection
* UserCmd.ExecuteNonQuery(); //Execute Our Query
* UserConnect.Close(); //Close Our Connection
* textBox2.Clear();
* textBox3.Clear();
* textBox4.Clear();
* textBox5.Clear();
* textBox6.Clear();*/
}
public GetResults(int Type, int Score, string GID, int PID)
{
InitializeComponent();
int Swap = 0;
System.Threading.Thread.Sleep(5000);
WorkHorse W = new WorkHorse();
Random Ran = new Random();
if (Type == 1)
{
if (PID == 1)
{
Swap = 2;
string OP = W.GetResults(GID, Swap);
int OS = Convert.ToInt32(OP);
LblP1S.Text = "Your score: " + Score.ToString();
LblP2S.Text = "Opponent's score: " + OP;
if (Score > OS)
{
LblWinner.Text = "You won!";
}
else if (OS > Score)
{
LblWinner.Text = "You lost!";
}
else
{
LblWinner.Text = "You drew!";
}
}
else if (PID == 2)
{
Swap = 1;
string OP = W.GetResults(GID, Swap);
int OS = Convert.ToInt32(OP);
LblP1S.Text = "Your score: " + Score.ToString();
LblP2S.Text = "Opponent's score: " + OP;
if (Score > OS)
{
LblWinner.Text = "You won!";
}
else if (OS > Score)
{
LblWinner.Text = "You lost!";
}
else
{
LblWinner.Text = "You drew!";
}
}
}
if (Type == 2)
{
int Comp = Ran.Next(0, 10);
LblP1S.Text = "Your score: " + Score.ToString();
LblP2S.Text = "Computer's score: " + Comp;
if (Score > Comp)
{
LblWinner.Text = "You won!";
}
else if (Comp > Score)
{
LblWinner.Text = "You lost!";
}
else
{
LblWinner.Text = "You drew!";
}
}
}