public static GameBoard Play(Student student)
{
List <Courses> courses;
MongoClientConn database = new MongoClientConn("Courses"); //Create an instance of our DB
courses = database.GetAll <Courses>("Courses");
Random rand = new Random();
Courses course = courses[rand.Next(0, courses.Count)];
List <Trivia> questions = new List <Trivia>();
for (int i = 0; i < courses.Count; i++)
{
if (String.Equals(courses[i].CourseName, course.CourseName, StringComparison.Ordinal))
{
Console.WriteLine("Question added: " + courses[i].courseQuestions);
questions.Add(courses[i].courseQuestions);
}
}
GameBoard game = new GameBoard(1, course, questions, student)
{
Dock = DockStyle.Fill, TopLevel = false, TopMost = true
};
game.FormBorderStyle = FormBorderStyle.None;
return(game);
}
public static Boolean AddCourse(AddTrivia trivia, ref string message)
{
MongoClientConn database = new MongoClientConn("Courses");
if (trivia.AddCourseBox.Text == null || trivia.AddCourseBox.Text == "")
{
message = "Must input some text, and Item must not exist";
return(false);
}
else
{
Courses newCourse = new Courses
{
CourseName = trivia.AddCourseBox.Text
};
database.InsertRecord("Courses", newCourse);
if (trivia.CoursesList.Items.Contains(newCourse.CourseName))
{
//checkedListBox1.Items.Remove(newCourse.CourseName)
}
else
{
trivia.CoursesList.Items.Add(newCourse.CourseName);
}
trivia.AddCourseBox.Clear();
return(true);
}
}
public static void LoadHelper(CourseGrid courseGrid)
{
MongoClientConn database = new MongoClientConn("Courses"); //Create an instance of our DB
courseGrid.courses = database.GetAll <Courses>("Courses"); //Grab all the courses from the DB
List <string> duplicateList = new List <string>();
if (courseGrid.courses != null)
{
for (int i = 0; i < courseGrid.courses.Count; i++)
{
Console.WriteLine(courseGrid.courses[i].CourseName);
if (duplicateList.Contains(courseGrid.courses[i].CourseName))
{
Console.WriteLine("Preventing Duplicates");
}
else
{
var courseName = new string[] { courseGrid.courses[i].CourseName };
var lvi = new ListViewItem(courseName);
duplicateList.Add(courseGrid.courses[i].CourseName);
lvi.Tag = courseGrid.courses[i];
lvi.Checked = false;
courseGrid.listViewCourses.Items.Add(lvi);
}
}
}
duplicateList.Clear();
courseGrid.Controls.Add(courseGrid.listViewCourses);
}
public static bool Register(Register register, ref string message)
{
Boolean isGood = false;
string dummy = register.EmailBox.Text;
//Check email for vaild address
if (dummy == null || dummy == "")
{
message = "All Fields Must be Completed, and Passwords must match";
return(false);
}
else
{
try
{
var eMailValidator = new System.Net.Mail.MailAddress(register.EmailBox.Text);
isGood = true;
}
catch (FormatException ex)
{
message = "All Fields Must be Completed, and Passwords must match";
return(false);
}
}
//Check for blank textBoxes
if (register.EmailBox.Text == "" || register.firstNameBox.Text == "" || register.LastNameBox1.Text == "" || register.passBox.Text == "" || register.TeacherCodeBox.Text == "" || register.PasswordBox2.Text == "" || register.UserNameLabel.Text == "" && register.passBox.ToString().Length != register.PasswordBox2.ToString().Length)
{
message = "All Fields Must be Completed, and Passwords must match";
return(false);
}
//if its good, create a new student from textbox inputs
else
{
MongoClientConn database = new MongoClientConn("Student");
Student newStudent = new Student
{
Email = register.EmailBox.Text,
FirstName = register.firstNameBox.Text,
LastName = register.LastNameBox1.Text,
UserName = register.UserNameBox.Text,
PassWord = register.passBox.Text,
TeacherCode = Convert.ToInt32(register.TeacherCodeBox.Text),
};
//Add the new student record into the database
database.InsertRecord("Student", newStudent);
//return true then restart.
message = "Successfully Registered";
return(true);
}
}
public NewGame(MainLayout main, Student student)
{
this.student = student;
this.main = main;
questions = new List <Trivia>();
courseList = new List <Courses>();
MongoClientConn database = new MongoClientConn("Courses");
courseList = database.LoadRecords <Courses>("Courses");
numPlayers = 0;
InitializeComponent();
}
public static Boolean CheckIfValid(string username, string password, ref Student refStudent)
{
MongoClientConn database = new MongoClientConn("Student");
List <Student> students = database.LoadRecords <Student>("Student");
foreach (var student in students)
{
if (username == student.UserName && password == student.PassWord)
{
refStudent = student;
return(true);
}
}
return(false);
}
private void AddTrivia_Load(object sender, EventArgs e)
{
MongoClientConn database = new MongoClientConn("Courses");
List <Courses> courses = database.GetAll <Courses>("Courses");
for (int i = 0; i < courses.Count(); i++)
{
if (CoursesList.Items.Contains(courses[i].CourseName))
{
Console.WriteLine("Preventing duplicates. ");
}
else
{
CoursesList.Items.Add(courses[i].CourseName);
}
}
}
public static void SelectCourse(AddTrivia trivia)
{
string courseName = "";
trivia.SelectedCourseBox.Items.Clear();
foreach (string result in trivia.CoursesList.CheckedItems)
{
trivia.SelectedCourseBox.Items.Add(result);
courseName = result.ToString();
Console.WriteLine("CourseName: ");
Console.WriteLine(courseName);
}
trivia.dataGridView1.Rows.Clear();
MongoClientConn database = new MongoClientConn("Courses");
var recs = database.LoadRecords <Courses>("Courses");
Console.WriteLine(recs);
foreach (var rec in recs)
{
Console.WriteLine($"{ rec.CourseName}");
if (rec.courseQuestions != null && rec.CourseName == courseName)
{
courseName = rec.CourseName;
string thisQuestion = rec.courseQuestions.Question;
string Answer1 = rec.courseQuestions.Answer1;
string Answer2 = rec.courseQuestions.Answer2;
string Answer3 = rec.courseQuestions.Answer3;
string Answer4 = rec.courseQuestions.Answer4;
int selAnswer = rec.courseQuestions.selAnswer;
string[] Row2 = new[] { courseName, thisQuestion, Answer1, Answer2, Answer3, Answer4, selAnswer.ToString() };
Console.WriteLine(rec.courseQuestions.Answer1 + " : " + rec.courseQuestions.Answer2);
trivia.dataGridView1.Rows.Add(Row2);
}
}
}
public static Boolean DeleteCourse(AddTrivia trivia, ref string message)
{
Console.WriteLine("Hello ");
Console.WriteLine(trivia.CoursesList.SelectedIndex.ToString());
MongoClientConn database = new MongoClientConn("Courses");
var records = database.LoadRecords <Courses>("Courses");
foreach (var result in records)
{
Console.WriteLine("Course ID: " + result.Id);
Console.WriteLine("Course Name: " + result.CourseName);
if (result.CourseName.ToString() == trivia.CoursesList.SelectedItem.ToString() && result.CourseName != null)
{
message = "Deleted! " + "\n" + "Result ID: " + result.Id.ToString() + "\n" + "Course Name: " + result.CourseName + "\n" + "All Records Deleted, Course Removed.";
database.DeleteRecord <Courses>("Courses", result.Id);
trivia.dataGridView1.Rows.Clear();
}
}
//Remove the item from displayed listboxes
trivia.SelectedCourseBox.Items.Clear();
trivia.CoursesList.Items.Remove(trivia.CoursesList.SelectedItem.ToString());
return(true);
}
public static Boolean AddQuestion(AddTrivia trivia, ref string message)
{
//make listbox selected item be selected for database if user does not click
trivia.SelectedCourseBox.SelectedIndex = 0;
Console.WriteLine(trivia.SelectedCourseBox.SelectedIndex.ToString());
//Set the answer to the selected CheckedBox
if (trivia.checkBox1.Checked)
{
trivia.answerNum = 1;
}
if (trivia.checkBox2.Checked)
{
trivia.answerNum = 2;
}
if (trivia.checkBox3.Checked)
{
trivia.answerNum = 3;
}
if (trivia.checkBox4.Checked)
{
trivia.answerNum = 4;
}
//clear the datagridview
trivia.dataGridView1.Rows.Clear();
//Make sure all textboxes contain information
if (trivia.QuestionBox.Text != null && trivia.QuestionBox.Text != "" &&
trivia.Answer1Box.Text != null && trivia.Answer1Box.Text != "" &&
trivia.Answer2Box.Text != null && trivia.Answer2Box.Text != "" &&
trivia.Answer3Box.Text != null && trivia.Answer3Box.Text != "" &&
trivia.Answer4Box.Text != null && trivia.Answer4Box.Text != "" &&
trivia.checkedBox != false)
{
//OPEN a connection to MongoDB, se
MongoClientConn database = new MongoClientConn("Courses");
//Set values for the Model
Courses newCourse = new Courses
{
CourseName = trivia.SelectedCourseBox.SelectedItem.ToString(),
courseQuestions = new Trivia
{
Question = trivia.QuestionBox.Text,
Answer1 = trivia.Answer1Box.Text,
Answer2 = trivia.Answer2Box.Text,
Answer3 = trivia.Answer3Box.Text,
Answer4 = trivia.Answer4Box.Text,
selAnswer = trivia.answerNum,
isAnswer = trivia.checkedBox
}
};
//Local form Variables
string thisQuestion = trivia.QuestionBox.Text;
string Answer1 = trivia.Answer1Box.Text;
string Answer2 = trivia.Answer2Box.Text;
string Answer3 = trivia.Answer3Box.Text;
string Answer4 = trivia.Answer4Box.Text;
int selAnswer = trivia.answerNum;
Boolean isAnswer = trivia.checkedBox;
//Add to the Database
database.InsertRecord("Courses", newCourse);
//Verify The selected answer is right on the command Line
Console.WriteLine("This is Selected Answers Checkmark: ");
Console.WriteLine(selAnswer);
//Layout the Datagrid, add the question to the view
AddTrivia.CourseQuestions.Add(thisQuestion);
var recs = database.LoadRecords <Courses>("Courses");
foreach (var rec in recs)
{
Console.WriteLine($"{ rec.CourseName}");
if (rec.courseQuestions != null && rec.CourseName == trivia.SelectedCourseBox.SelectedItem.ToString())
{
string courseName = rec.CourseName;
thisQuestion = rec.courseQuestions.Question;
Answer1 = rec.courseQuestions.Answer1;
Answer2 = rec.courseQuestions.Answer2;
Answer3 = rec.courseQuestions.Answer3;
Answer4 = rec.courseQuestions.Answer4;
selAnswer = rec.courseQuestions.selAnswer;
string[] Row2 = new[] { courseName, thisQuestion, Answer1, Answer2, Answer3, Answer4, selAnswer.ToString() };
Console.WriteLine(rec.courseQuestions.Answer1 + " : " + rec.courseQuestions.Answer2);
trivia.dataGridView1.Rows.Add(Row2);
}
}
//Clear textboxes
trivia.QuestionBox.Clear();
trivia.Answer1Box.Clear();
trivia.Answer2Box.Clear();
trivia.Answer3Box.Clear();
trivia.Answer4Box.Clear();
//Clear checkedBoxes
trivia.checkBox1.Checked = false;
trivia.checkBox2.Checked = false;
trivia.checkBox3.Checked = false;
trivia.checkBox4.Checked = false;
return(true);
}
else
{
message = "All Questions Fields must be complete before submission!";
return(false);
}
}
