protected void btnDelete_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
// Query the database for the rows to be deleted.
var queryResults =
from course in db.Courses
where course.CourseID == Convert.ToInt16(cboCourseID.SelectedValue)
select course;
foreach (var detail in queryResults)
{
db.Courses.DeleteOnSubmit(detail);
}
try
{
db.SubmitChanges();
LabelError.Text = "record deleted";
}
catch (Exception exc)
{
LabelError.Text = exc.Message;
// Provide for exceptions.
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
int quizID;
quizID = Convert.ToInt16(DropDownListQuizID.SelectedValue);
// Query the database for the row to be updated.
var query =
from quiz in db.Quizs
where quiz.QuizID == quizID
select quiz;
// Execute the query, and change the column values
// you want to change.
foreach (Quiz quiz in query)
{
quiz.Title = txtTitle.Text;
quiz.CourseName = DropDownListCourse.SelectedItem.ToString();
quiz.CourseID = Convert.ToInt16(DropDownListCourse.SelectedValue);
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
LabelMessage.Text = "updated successfully";
LabelMessage.ForeColor = System.Drawing.Color.Green;
}
catch (Exception exc)
{
LabelMessage.Text = exc.ToString();
// Provide for exceptions.
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
// Query the database for the rows to be deleted.
var queryResults = from quiz in db.Quizs
where quiz.QuizID == Convert.ToInt16(DropDownListQuizID.SelectedValue)
select quiz;
foreach (var detail in queryResults)
{
db.Quizs.DeleteOnSubmit(detail);
}
try
{
db.SubmitChanges();
LabelMessage.Text = "record deleted";
LabelMessage.ForeColor = System.Drawing.Color.Green;
}
catch (Exception exc)
{
LabelMessage.Text = exc.Message;
// Provide for exceptions.
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
int CourseID;
CourseID = Convert.ToInt16(cboCourseID.SelectedValue);
// Query the database for the row to be updated.
var query =
from course in db.Courses
where course.CourseID == CourseID
select course;
// Execute the query, and change the column values
// you want to change.
foreach (Course crs in query)
{
crs.CourseName = txtName.Text;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
LabelError.Text = "updated successfully";
}
catch (Exception exc)
{
LabelError.Text = exc.ToString();
// Provide for exceptions.
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
Course course = new Course
{
CourseName = txtName.Text
};
db.Courses.InsertOnSubmit(course);
try
{
db.SubmitChanges();
LabelError.Text = "record saved successfully";
}
catch (Exception exc)
{
LabelError.Text = exc.ToString();
}
}
private void ShowQuestionDetailsAndBindToControls()
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
var queryResults = (from ques in db.Questions
where ques.QuestionID == Convert.ToInt16(DropDownListQuestionID.SelectedValue)
select ques).ToList();
if (queryResults.Any())
{
txtTitle.Text = queryResults.Select(q => q.Title).First();
txtAnswer1.Text = queryResults.Select(q => q.Answer1).First();
txtAnswer2.Text = queryResults.Select(q => q.Answer2).First();
txtAnswer3.Text = queryResults.Select(q => q.Answer3).First();
txtAnswer4.Text = queryResults.Select(q => q.Answer4).First();
DropDownListCorrectAnswer.Text = queryResults.Select(q => q.CorrectAnswer).First();
txtAnswerExplanation.Text = queryResults.Select(q => q.AnswerExplanation).First();
txtQuestionOrder.Text = queryResults.Select(q => q.QuestionOrder).First().ToString();
// DropDownListQuiz.Text = queryResults.Select(q => q.QuizID).ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
Quiz quiz = new Quiz
{
Title = txtTitle.Text,
CourseID = Convert.ToInt16(DropDownListCourse.SelectedValue),
CourseName = DropDownListCourse.SelectedItem.ToString()
};
db.Quizs.InsertOnSubmit(quiz);
try
{
db.SubmitChanges();
LabelMessage.Text = "record saved successfully";
LabelMessage.ForeColor = System.Drawing.Color.Green;
}
catch (Exception exc)
{
LabelMessage.Text = exc.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
//check if question title already exists or not
var queryResults = from ques in db.Questions
where ques.Title == txtTitle.Text
select ques;
if (queryResults.Any())
{
LabelError.Text = "this question already exists : " + txtTitle.Text;
return;
}
Question question = new Question
{
Title = txtTitle.Text,
Answer1 = txtAnswer1.Text,
Answer2 = txtAnswer2.Text,
Answer3 = txtAnswer3.Text,
Answer4 = txtAnswer4.Text,
CorrectAnswer = DropDownListCorrectAnswer.SelectedItem.ToString(),
AnswerExplanation = txtAnswerExplanation.Text,
QuestionOrder = Convert.ToByte(txtQuestionOrder.Text),
QuizID = Convert.ToInt16(DropDownListQuiz.SelectedValue)
};
db.Questions.InsertOnSubmit(question);
try
{
db.SubmitChanges();
LabelError.Text = "record saved successfully";
}
catch (Exception exc)
{
LabelError.Text = exc.Message;
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
DataClassesOnlineQuizDataContext db = new DataClassesOnlineQuizDataContext();
// Query the database for the row to be updated.
var query =
from ques in db.Questions
where ques.QuestionID == Convert.ToInt16(DropDownListQuestionID.SelectedValue)
select ques;
// Execute the query, and change the column values
// you want to change.
foreach (Question q in query)
{
q.Title = txtTitle.Text;
q.QuestionOrder = Convert.ToByte(txtQuestionOrder.Text);
q.QuizID = Convert.ToInt16(DropDownListQuiz.SelectedValue);
q.Answer1 = txtAnswer1.Text;
q.Answer2 = txtAnswer2.Text;
q.Answer3 = txtAnswer3.Text;
q.Answer4 = txtAnswer4.Text;
q.CorrectAnswer = DropDownListCorrectAnswer.SelectedItem.ToString();
q.AnswerExplanation = txtAnswerExplanation.Text;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
LabelError.Text = "record updated successfully!";
}
catch (Exception exc)
{
LabelError.Text = exc.Message;
}
}
