Beispiel #1
0
        public string GetData(List <ComponentKey> keys, int currentIndex, int pageSize)
        {
            Component    c  = (Component)_component;
            ClientServer cs = new ClientServer(this.ClientID);
            Server       s  = cs.GetServer();
            var          dm = new Tz.Net.DataManager(this.Component.TableID, s.ServerID, this.ClientID);

            System.Data.DataTable dt = new System.Data.DataTable();
            //var tb = new Tz.Net.Entity.Table(s.ServerID,this.Component.TableID,this.ClientID);
            dt = dm.GetData(currentIndex, pageSize);
            int totalCount = dm.GetDataCount();
            var dtjson     = dt.ToJSON();

            return("{data:" + dtjson + ",total:" + totalCount + "}");
        }
        public static string GetStudentListBySchoolTeacherAndClass(int schoolID, int teacherPage, int classId)
        {
            if (schoolID < 0) return null;
            DataTable studentListBySchoolTeacherAndClass = new DataTable();

            using (SqlConnection conn = new SqlConnection(AppSettings.ConnectionString))
            {
                conn.Open();

                SqlCommand cmd = new SqlCommand
                {
                    CommandType = CommandType.StoredProcedure,
                    CommandText = "E3_GetStudentListBySchoolIdTeacherIdAndClassId",
                    Connection = conn
                };

                cmd.Parameters.Add(new SqlParameter { ParameterName = "School", Value = schoolID });
                cmd.Parameters.Add(new SqlParameter { ParameterName = "TeacherPage", Value = teacherPage });
                cmd.Parameters.Add(new SqlParameter { ParameterName = "ClassId", Value = classId });

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                da.Fill(studentListBySchoolTeacherAndClass);
            }
            return studentListBySchoolTeacherAndClass.ToJSON(false);
        }
        public static string GetClassListBySchoolAndTeacher(int schoolId, int teacherId)
        {
            if (schoolId < 0) return null;
            DataTable classListBySchoolAndTeacher = new DataTable();

            using (SqlConnection conn = new SqlConnection(AppSettings.ConnectionString))
            {
                conn.Open();

                SqlCommand cmd = new SqlCommand
                {
                    CommandType = CommandType.StoredProcedure,
                    CommandText = "E3_GetCVTEClassesForSchoolTeacherForCTR",
                    Connection = conn
                };

                cmd.Parameters.Add(new SqlParameter { ParameterName = "SchoolId", Value = schoolId });
                cmd.Parameters.Add(new SqlParameter { ParameterName = "TeacherId", Value = teacherId });

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                da.Fill(classListBySchoolAndTeacher);
            }
            return classListBySchoolAndTeacher.Rows.Count <= 0 ? null : classListBySchoolAndTeacher.ToJSON(false);
        }
        public static string GetTeacherListForSchool(int schoolID)
        {
            if (schoolID < 0) return null;
            DataTable teacherListForSchool = new DataTable();

            //set teacher dropdown to the current user if they are a teacher
            if (_loggedOnUserRoleName != null && _loggedOnUserRoleName.Equals("Teacher", StringComparison.InvariantCultureIgnoreCase))
            {
                if (!string.IsNullOrEmpty(_loggedOnUser.UserFullName) || !string.IsNullOrEmpty(_loggedOnUser.Page.ToString()))
                {
                    return "[{\"TeacherName\":\"" + _loggedOnUser.UserFullName + "\",\"TeacherPage\":\"" + _loggedOnUser.Page + "\"}]";
                }

                return teacherListForSchool.ToJSON(false); //user was a teacher but SessionObject.LoggedInUser object had null values (return new 'empty' datatable')
            }

            using (SqlConnection conn = new SqlConnection(AppSettings.ConnectionString))
            {
                conn.Open();

                SqlCommand cmd = new SqlCommand
                {
                    CommandType = CommandType.StoredProcedure,
                    CommandText = "E3_GetTeacherListBySchoolId",
                    Connection = conn
                };

                cmd.Parameters.Add(new SqlParameter { ParameterName = "School", Value = schoolID });

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                da.Fill(teacherListForSchool);
            }
            return teacherListForSchool.ToJSON(false);
        }
        public static string GetStudentListBySchoolTeacherAndClass(int schoolID, int teacherPage, int classId)
        {
            if (schoolID < 0) return null;
            DataTable studentListBySchoolTeacherAndClass = new DataTable();
            Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
            studentListBySchoolTeacherAndClass = oCTR.GetStudentListBySchoolTeacherAndClass(schoolID, teacherPage, classId);

            return studentListBySchoolTeacherAndClass.ToJSON(false);
        }
        public static string GetClassListBySchoolAndTeacher(int schoolId, int teacherId)
        {
            // DataTable classListBySchoolAndTeacher = new DataTable();
            // CompetencyTrackingReportPage obj=new CompetencyTrackingReportPage();
            // if (_loggedOnUserRoleName.ToLower() == Convert.ToString(RolePortal.Teacher).ToLower())
            // {
            //     classListBySchoolAndTeacher = obj.GetClassesForTeacherOnly();                          
            // }
            // else
            // { 
            // if (schoolId < 0) return null;          
            // Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
            // classListBySchoolAndTeacher = oCTR.GetClassListBySchoolAndTeacher(schoolId, teacherId);

            //}
            // return classListBySchoolAndTeacher.Rows.Count <= 0 ? null : classListBySchoolAndTeacher.ToJSON(false);
            if (schoolId < 0) return null;
            DataTable classListBySchoolAndTeacher = new DataTable();

            //using (SqlConnection conn = new SqlConnection(AppSettings.ConnectionString))
            //{
            //    conn.Open();

            //    SqlCommand cmd = new SqlCommand
            //    {
            //        CommandType = CommandType.StoredProcedure,
            //        CommandText = "E3_GetCVTEClassesForSchoolTeacherForCTR",
            //        Connection = conn
            //    };

            //    cmd.Parameters.Add(new SqlParameter { ParameterName = "SchoolId", Value = schoolId });
            //    cmd.Parameters.Add(new SqlParameter { ParameterName = "TeacherId", Value = teacherId });

            //    SqlDataAdapter da = new SqlDataAdapter(cmd);

            //    da.Fill(classListBySchoolAndTeacher);
            //}
            var clsssList = Thinkgate.Base.Classes.Class.GetClassesForTeacher(teacherId, 0);
            clsssList = clsssList.Where(x => x.SchoolID == schoolId).ToList();
            classListBySchoolAndTeacher.Columns.Add("FriendlyName");
            classListBySchoolAndTeacher.Columns.Add("ID");

            foreach (var s in clsssList)
            {
                classListBySchoolAndTeacher.Rows.Add(s.FriendlyName, s.ID);
            }




            return classListBySchoolAndTeacher.Rows.Count <= 0 ? null : classListBySchoolAndTeacher.ToJSON(false);
        }
        public static string GetTeacherListForSchool(int schoolID)
        {
            if (schoolID < 0) return null;
            DataTable teacherListForSchool = new DataTable();

            //set teacher dropdown to the current user if they are a teacher
            if (_loggedOnUserRoleName != null && _loggedOnUserRoleName.Equals("Teacher", StringComparison.InvariantCultureIgnoreCase))
            {
                if (!string.IsNullOrEmpty(_loggedOnUser.UserFullName) || !string.IsNullOrEmpty(_loggedOnUser.Page.ToString()))
                {
                    return "[{\"TeacherName\":\"" + _loggedOnUser.UserFullName + "\",\"TeacherPage\":\"" + _loggedOnUser.Page + "\"}]";
                }

                return teacherListForSchool.ToJSON(false); //user was a teacher but SessionObject.LoggedInUser object had null values (return new 'empty' datatable')
            }
            Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
            teacherListForSchool = oCTR.GetTeacherListBySchool(schoolID);

            return teacherListForSchool.ToJSON(false);
        }
        public static string GetCompetencyList()
        {
            string[] StrResourcesToShowOnTile;
            string ResourceToShow = string.Empty;
            ResourceToShow = "Thinkgate.CompetencyList";
            DataSet resourcesToShow = KenticoHelper.GetTileMapLookupDataSet(ResourceToShow);

            StrResourcesToShowOnTile = resourcesToShow.Tables[0]
                .AsEnumerable()
                .OrderBy(p => p["ItemOrder"].ToString())
                .Select(s => s.Field<string>("KenticoDocumentTypeToShow"))
                .ToArray();

            KenticoHelper kHelper = new KenticoHelper();
            List<UserNodeList> nodeList = kHelper.GetCompetencyList(StrResourcesToShowOnTile);

            CompetencyTrackingReportPage trackingPage = new CompetencyTrackingReportPage();
            nodeList = trackingPage.FilterByStandard(nodeList);

            var result = (from t in nodeList
                          select new { t.NodeId, t.FriendlyName }).ToArray();

            DataTable dtNodeList = new DataTable();
            dtNodeList.Columns.Add(
                new DataColumn()
                {
                    DataType = System.Type.GetType("System.String"),
                    ColumnName = "DocumentId"
                }
            );
            dtNodeList.Columns.Add(
               new DataColumn()
               {
                   DataType = System.Type.GetType("System.String"),
                   ColumnName = "FriendlyName"
               }
           );

            foreach (var element in result)
            {
                var row = dtNodeList.NewRow();
                row["DocumentId"] = element.NodeId.ToString();
                row["FriendlyName"] = element.FriendlyName.ToString();
                dtNodeList.Rows.Add(row);
            }
            return dtNodeList.ToJSON(false);
        }