public List <Questioneries> GET_QNS_COUNT(string courseid)
{
List <Questioneries> Qn = new List <Questioneries>();
try
{
SqlCommand cmd = new SqlCommand("GET_QNS_COUNT", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CID", courseid);
//DataTable dt = new DataTable();
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Questioneries Qn1;
while (dr.Read())
{
Qn1 = new Questioneries();
Qn1.Qnscount = dr["QNS"] != null ? dr["QNS"].ToString() : "";
Qn.Add(Qn1);
}
dr.Close();
return(Qn);
}
catch (Exception ch)
{
return(Qn);
}
finally
{
conn.Close();
}
}
public List <Questioneries> GEET_QUESTIONS_BASEDONCOURSEID(string cid)
{
List <Questioneries> qnlist = new List <Questioneries>();
try
{
SqlCommand cmd = new SqlCommand("GEET_QUESTIONS_BASEDONCOURSEID", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CID", cid);
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Questioneries qnlist1;
while (dr.Read())
{
qnlist1 = new Questioneries();
qnlist1.MMarks = dr["MARKS"] != null ? dr["MARKS"].ToString() : "";
qnlist1.QUESTION = dr["QUESTION"] != null ? dr["QUESTION"].ToString() : "";
qnlist1.OP1 = dr["A"] != null ? dr["A"].ToString() : "";
qnlist1.OP2 = dr["B"] != null ? dr["B"].ToString() : "";
qnlist1.OP3 = dr["C"] != null ? dr["C"].ToString() : "";
qnlist1.OP4 = dr["D"] != null ? dr["D"].ToString() : "";
qnlist1.ANSWER = dr["ANSWER"] != null ? dr["ANSWER"].ToString() : "";
qnlist.Add(qnlist1);
}
return(qnlist);
}
catch (Exception ch)
{
return(qnlist);
}
finally
{
conn.Close();
}
}
public Outputclass Update_QUESTIONs(Questioneries qns)
{
Outputclass outputclass = new Outputclass();
try
{
SqlCommand cmd = new SqlCommand("UPDATE_QUESIONARIES", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QID", qns.QUESTIONID);
cmd.Parameters.AddWithValue("@QUESTION", qns.QUESTION);
cmd.Parameters.AddWithValue("@MARKS", qns.MMarks);
cmd.Parameters.AddWithValue("@A", qns.OP1);
cmd.Parameters.AddWithValue("@B", qns.OP2);
cmd.Parameters.AddWithValue("@C", qns.OP3);
cmd.Parameters.AddWithValue("@D", qns.OP4);
cmd.Parameters.AddWithValue("@ANSWER", qns.ANSWER);
Connection();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
outputclass.Count = i;
}
return(outputclass);
}
catch (Exception ex)
{
outputclass.Msg = ex.ToString();
return(outputclass);
}
finally
{
conn.Close();
}
}
public List <Questioneries> Questio_data(string coid)
{
List <Questioneries> qnslist = new List <Questioneries>();
try
{
SqlCommand cmd = new SqlCommand("GET_QUESTIONERIES", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Courseid", coid);
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Questioneries qnslist1;
while (dr.Read())
{
qnslist1 = new Questioneries();
qnslist1.COURSEID = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0;
qnslist1.QUESTIONID = dr["QUESTIONID"] != null?Convert.ToInt32(dr["QUESTIONID"]) : 0;
qnslist1.QUESTION = dr["QUESTION"] != null ? dr["QUESTION"].ToString() : "";
//qnslist1.TYPE = dr["TYPE"] != null ? dr["TYPE"].ToString() : "";
qnslist1.OP1 = dr["A"] != null ? dr["A"].ToString() : "";
qnslist1.OP2 = dr["B"] != null ? dr["B"].ToString() : "";
qnslist1.OP3 = dr["C"] != null ? dr["C"].ToString() : "";
qnslist1.OP4 = dr["D"] != null ? dr["D"].ToString() : "";
qnslist1.MMarks = dr["MARKS"] != null ? dr["MARKS"].ToString() : "";
qnslist1.ANSWER = dr["ANSWER"] != null ? dr["ANSWER"].ToString() : "";
qnslist.Add(qnslist1);
}
return(qnslist);
}
catch (Exception ch)
{
return(qnslist);
}
finally
{
conn.Close();
}
}
public Questioneries Get_databasedonqid(string Qid)
{
Questioneries Qn1 = new Questioneries();
try
{
SqlCommand cmd = new SqlCommand("GETDATA_BASEDONQID", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QID", Qid);
DataTable dt = new DataTable();
Connection();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Qn1.QUESTION = dr["QUESTION"] != null ? dr["QUESTION"].ToString() : "";
Qn1.ANSWER = dr["ANSWER"] != null ? dr["ANSWER"].ToString() : "";
Qn1.OP1 = dr["A"] != null ? dr["A"].ToString() : "";
Qn1.OP2 = dr["B"] != null ? dr["B"].ToString() : "";
Qn1.OP3 = dr["C"] != null ? dr["C"].ToString() : "";
Qn1.OP4 = dr["D"] != null ? dr["D"].ToString() : "";
Qn1.MMarks = dr["MARKS"] != null ? dr["MARKS"].ToString() : "";
//Qn.Add(Qn1);
}
return(Qn1);
}
catch (Exception ex)
{
return(null);
}
finally
{
conn.Close();
}
}
