public ExamPaper GetNextPrevQuestion(int pageIndex, int pageSize, int userId)
{
QuestionViewEntities questionViewEntities = new QuestionViewEntities();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetNextQuestion", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.Add(new SqlParameter("@QuestionCount", SqlDbType.Int));
cmd.Parameters[2].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@UserId", userId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
int questCount = (int)(cmd.Parameters[2].Value);
con.Close();
ExamPaper examPaper = new ExamPaper();
examPaper = CreateDataSet(ds);
examPaper.PageSize = pageSize;
examPaper.PageIndex = pageIndex;
return(examPaper);
}
public ActionResult SaveOrUpdate(QuestionViewEntities questionEntities)
{
QuestionBL teacherBl = new QuestionBL();
int recordAffected = teacherBl.SaveOrUpdate(questionEntities);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
//private static List<T> ConvertDataTable<T>(DataTable dt)
//{
// List<T> data = new List<T>();
// foreach (DataRow row in dt.Rows)
// {
// T item = GetItem<T>(row);
// data.Add(item);
// }
// return data;
//}
//private static T GetItem<T>(DataRow dr)
//{
// Type temp = typeof(T);
// T obj = Activator.CreateInstance<T>();
// foreach (DataColumn column in dr.Table.Columns)
// {
// foreach (PropertyInfo pro in temp.GetProperties())
// {
// if (pro.Name == column.ColumnName)
// pro.SetValue(obj, dr[column.ColumnName], null);
// else
// continue;
// }
// }
// return obj;
//}
public int SaveOrUpdate(QuestionViewEntities questionEntities)
{
DataTable atable = CreateTable();
if (questionEntities.AnswerEntities != null)
{
foreach (AnswerEntities item in questionEntities.AnswerEntities)
{
atable.Rows.Add(item.AnswerText, Convert.ToInt32(item.IsRightAnswer));
}
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdateQuestion", con);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(questionEntities.QuestionEntities.Id.ToString()) || (questionEntities.QuestionEntities.Id == 0))
{
cmd.Parameters.AddWithValue("@Id", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Id", questionEntities.QuestionEntities.Id);
}
cmd.Parameters.AddWithValue("@QuestionText", questionEntities.QuestionEntities.QuestionText);
cmd.Parameters.AddWithValue("@TopicId", questionEntities.QuestionEntities.TopicId);
//if (!String.IsNullOrEmpty(questionEntities.ImagePath))
//{
// cmd.Parameters.AddWithValue("@ImagePath", questionEntities.ImagePath);
//}
//else
//{
// cmd.Parameters.AddWithValue("@ImagePath", DBNull.Value);
//}
cmd.Parameters.AddWithValue("@Marks", questionEntities.QuestionEntities.Marks);
cmd.Parameters.AddWithValue("@AnswerList", atable);
cmd.Parameters[4].SqlDbType = SqlDbType.Structured;
int recordsAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordsAffected);
}
public void GetQuestionPaper(int questionCount, int userId)
{
QuestionViewEntities questionViewEntities = new QuestionViewEntities();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetQuestion", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QuestionCount", questionCount);
cmd.Parameters.AddWithValue("@UserId", userId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
//ExamPaper examPaper = new ExamPaper();
//examPaper = CreateDataSet(ds);
//return examPaper;
}
public int SaveOrUpdate(QuestionViewEntities questionEntities)
{
QuestionDAL topicDAL = new QuestionDAL();
return(topicDAL.SaveOrUpdate(questionEntities));
}
