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