public DataTable GetRecentAssignmentList(dalCommon objCommonpara, int noofRow)
{
DataTable dt;
string SQLQuery = "SELECT DISTINCT TOP " + noofRow + " Convert(VARCHAR,Date,103) as Date,MAM.AssignmentID,ISnull(SubjectName,'')As SubjectName, " +
" ISNULL(AssignmentTitle,'') as AssigntmentTitle,substring(Assignment,1,70) AS Assignment,2 as Priority,UserName,EAssignmentPath, " +
" ISnull(MAD.ExamSubjectID,0)As ExamSubjectID ,VideoLinkPath ,substring(CAST(Date as varchar),1,3) as Month,DATE AS Date1 from MTAssignmentDetails MAD " +
" INNER JOIN MTAssignmentMaster MAM ON MAM.AssignmentID=MAD.AssignmentID INNER JOIN SIStudentYearWiseDetails SYD ON SYD.ClassID=MAD.ClassID " +
" AND SYD.SectionID=MAD.SectionID AND (SYD.StudentID=MAD.StudEmpID OR MAD.StudEmpID=0) " +
" INNER JOIN MTUsermaster UM on UM.UID=MAD.EntryUSerID Left join AssignmentSubjectMaster ESM on ESM.SubjectID=MAD.ExamSubjectID and " +
" ESM.AcaStart=" + objCommonpara.AcaStart + " Where SYD.StudentID=" + objCommonpara.StudEmp + " AND SYD.AcaStart=" + objCommonpara.AcaStart + " and MAM.AcaStart=" + objCommonpara.AcaStart + " " +
" and MAM.SchoolID=" + objCommonpara.SchoolId + " and AssignmentType='H' order by Date1 Desc ";
try
{
dt = objCCWeb.BindDataTable(SQLQuery);
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
}
}
protected void CountDiaryRemarkval()
{
DataTable dt = new DataTable();
dt = ObjccWeb.BindDataTable("exec SP_Assignment 1512,2014,1,'H','','',''");
CountDiaryRemark = dt.Rows.Count;
}
public DataTable GetDiaryDetails(dalCommon objCommon, int flagid, string sFromDate, string sToDate)
{
try
{
DataTable dt = new DataTable();
dt = objCCWeb.BindDataTable("Exec Sp_PLPersonalDairy " + objCommon.SchoolId + "," + flagid + ",'" + sFromDate + "','" + sToDate + "'");
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable GetEmailData(dalCommon objCommon, string iMailType)
{
try
{
DataTable dt = new DataTable();
dt = objCCWeb.BindDataTable(" Exec SpMessageBind " + objCommon.UID + ",'" + iMailType + "'");
return(dt);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
objCCWeb = null;
}
}