public int Insert(tblAssignPaperResult obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Insert Into tblAssignPaperResult (QPID,AssignToID,IsCompleted,Marks) values (" + obj.QPID + "," + obj.AssignToID + ",0,'')";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public int UpdFlagMarks(tblAssignPaperResult obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Update tblAssignPaperResult set IsCompleted = 1 , Marks = '" + obj.Marks + "' where QPID = " + obj.QPID + " and AssignToID = " + obj.AssignToID + "";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public DataTable GetQuestionList(tblAssignPaperResult Obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "select a.* , b.PaperType , c.* from tblQuestionPaperDetails a left join tblQuestionPaperMst b";
sql += " on a.QPID = b.QPID left join tblQuesBankDetails c on a.QdID = c.QdID where a.QPID = " + Obj.QPID + "";
SqlDataAdapter adp = new SqlDataAdapter(sql, cnnstr);
DataTable dt = new DataTable();
adp.Fill(dt);
cnnstr.Close();
return(dt);
}
public DataTable GetStudentReportforStud(tblAssignPaperResult obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "select a.* ,b.Name,b.Email,c.* from tblAssignPaperResult a ";
sql += " left join tblUser b on a.AssignToID = b.ID ";
sql += " left join tblQuestionPaperMst c on a.QPID = c.QPID where a.AssignToID = " + obj.AssignToID + " ";
SqlDataAdapter adp = new SqlDataAdapter(sql, cnnstr);
DataTable dt = new DataTable();
adp.Fill(dt);
cnnstr.Close();
return(dt);
}
