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