Beispiel #1
0
        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
            {
            }
        }
Beispiel #2
0
 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;
     }
 }
Beispiel #3
0
        public SqlDataReader GetFeeDetails(dalCommon objCommonPara)
        {
            SqlDataReader sqlDR;
            string        SQLQuery = "EXEC [SpFeeSummary]  " + objCommonPara.SchoolId + "," + objCommonPara.AcaStart + "," + objCommonPara.StudEmp + ",4,0";

            try
            {
                sqlDR = objCCWeb.BindReader(SQLQuery);
                return(sqlDR);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }
Beispiel #4
0
        public SqlDataReader LogoutSessionStore(dalCommon objCommonPara)
        {
            CCWeb         objCCWeb = new CCWeb();
            SqlDataReader sqlDR;
            string        SQLQuery = "UPDATE MDUserLoginDetails SET LoggedOutTime=GETDATE() WHERE LoggedOutTime IS NULL AND  SessionDetails='" + objCommonPara.Userlogin.ToString().Replace("'", "''") + "'";

            try
            {
                sqlDR = objCCWeb.BindReader(SQLQuery);
                return(sqlDR);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }
Beispiel #5
0
        public SqlDataReader GetEventList(dalCommon objCommonPara)
        {
            SqlDataReader sqlDR;
            string        SQLQuery = "SELECT EventSubject,ED.EventTime,EM.EventDate,Convert(varchar,EventDate,103) AS Date,substring(CAST(EventDate as varchar),1,3)  as Month,Venue,Discription FROM EventMaster EM INNER JOIN EventDetail ED ON EM.EventID=ED.EventID WHERE EM.EventID IN(Select EventID from EventClassDetail ED INNER JOIN SIStudentYearWiseDetailS SYD ON SYD.ClassID=ED.ClassID AND SYD.SectionID=ED.SectionID Where StudentID=" + objCommonPara.StudEmp + ")" +
                                     "AND EventDate>=(select AcaStartDate from MTAcademicSessionMaster Where Acastart=" + objCommonPara.AcaStart + ")AND EventDate <=(select AcaEndDate from MTAcademicSessionMaster Where Acastart=" + objCommonPara.AcaStart + ") " +
                                     "AND (EventSubject<>'' OR Venue<> '' OR EventSubject<>'') ORDER BY  EventDate DESC";

            try
            {
                sqlDR = objCCWeb.BindReader(SQLQuery);
                return(sqlDR);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }
Beispiel #6
0
        public int GetSectionID(dalCommon objCommonPara)
        {
            CCWeb  objCCWeb  = new CCWeb();
            int    SectionID = 0;
            string SQLQuery  = "Select SectionID From SistudentyearwiseDetails where StudentID=" + objCommonPara.StudEmp + " and AcaStart=" + objCommonPara.AcaStart + "";

            try
            {
                SectionID = objCCWeb.ReturnNumericValue(SQLQuery);

                return(SectionID);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }
Beispiel #7
0
        public DataSet GetTop5UnreadMail(dalCommon objCommonPara, string eMailType)
        {
            CCWeb   ObjccWeb = new CCWeb();
            DataSet ds       = new DataSet();

            try
            {
                string Query = " Exec SpMessageBind  " + objCommonPara.UID + ",'UR'";
                ds = ObjccWeb.BindDataSet(Query);
                return(ds);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                ds            = null;
                objCommonPara = null;
                ObjccWeb      = null;
            }
        }
Beispiel #8
0
        public SqlDataReader GetNewsAndEventList(dalCommon objCommonPara)
        {
            SqlDataReader sqlDR;

            string SQLQuery = "SELECT DISTINCT MD.MessageID,ISNULL(MessageTitle,'') AS MessageTitle, Message AS Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate" +
                              " from MTMessageMaster MM INNER JOIN MDMessageDetails MD ON MD.MessageID=MM.MessageID " +
                              " WHERE (StudentID=" + objCommonPara.StudEmp + " AND UserType='S') OR UserType='A' AND MessageStatus='Y' AND  '" + objCommonPara.strDate + "' between MessageDate  And MessageTillDate  AND SchoolID=" + objCommonPara.SchoolId + " ORDER BY MessageDate desc";

            try
            {
                sqlDR = objCCWeb.BindReader(SQLQuery);

                return(sqlDR);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }
Beispiel #9
0
        public SqlDataReader GetStudentProfile(dalCommon objCommonPara)
        {
            SqlDataReader sqlDR;
            //string SQLQuery = "Select SIM.StudentID , FirstName+' '+MiddleName+' '+LastName As Name,COnvert(varchar,DateOfBirth,103) As DateOfBirth,ClassName1+' '+SectionNAme1 from SIStudentMaster SIM inner join " +
            //                    " SistudentYearwiseDetails SYD on SYD.StudentID=SIM.StudentID inner join MtClassMaster CM on SYD.ClassID=CM.ClassID inner join MTSectionMaster SM on SYD.SectionID=SM.SectionID " +
            //                    " Where SIM.StudentID=" + objCommonPara.StudEmp + " and SYD.AcaStart=" + objCommonPara.AcaStart + "";

            string SQLQuery = "EXEC[spFILLStudentData] " + objCommonPara.StudEmp + "," + objCommonPara.AcaStart + "";

            try
            {
                sqlDR = objCCWeb.BindReader(SQLQuery);

                return(sqlDR);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objCCWeb = null;
            }
        }