private int InsertIntoPaperDetails(PaperDetailsModal paperDetails) { int noOfRowsAffected = 0; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand command = new SqlCommand("spInsertPaperDetails", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@SessionId", paperDetails.SessionId); command.Parameters.AddWithValue("@SemesterId", paperDetails.SemesterId); command.Parameters.AddWithValue("@CourseId", paperDetails.CourseId); command.Parameters.AddWithValue("@PaperName", paperDetails.PaperName); command.Parameters.AddWithValue("@TeacherId", paperDetails.TeacherId); command.Parameters.AddWithValue("@NoOfQuestions", paperDetails.NoOfQuestions); command.Parameters.AddWithValue("@TimeAllowed", paperDetails.TimeAllowed); command.Parameters.AddWithValue("@Active", paperDetails.Active); command.Parameters.AddWithValue("@Password", paperDetails.Password); command.Parameters.AddWithValue("@TotalMarks", paperDetails.TotalMarks); try { noOfRowsAffected = command.ExecuteNonQuery(); } catch (SqlException ex) { if (ex.Number == 2627) { return(0); } } } return(noOfRowsAffected); }
public int Insert(PaperDetailsModal paperDetails) { InsertIntoPaperDetails(paperDetails); int paperId = GetPaperIdForQuestions(paperDetails.SessionId, paperDetails.SemesterId, paperDetails.PaperName); InsertSections(paperDetails.Sections, paperId); InsertQuestionAndChoices(paperDetails.listOfQuestions, paperId); return(1); }
public int GeneratePaper(PaperDetailsModal paperDetial) { InsertIntoPaperDetails(paperDetial); List <PaperQuestionModal> listOfQuestions = GetQuestionsFromDBByQuestionId(paperDetial.QuestionList); int paperId = GetPaperIdForQuestions(paperDetial.SessionId, paperDetial.SemesterId, paperDetial.PaperName); InsertSections(paperDetial.Sections, paperId); listOfQuestions = UpdateListWithOptions(listOfQuestions); InsertQuestionAndChoices(listOfQuestions, paperId); return(1); }
public JsonResult GeneratePaper(PaperDetailsModal paperDetail) { return(Json(_databaseConnection.GeneratePaper(paperDetail))); }