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; } }