示例#1
0
        public void GetAllStudentsBySchoolID(string _school_id, string studentfirstname)
        {
            JavaScriptSerializer serializer   = new JavaScriptSerializer();
            List <FoundStudents> liststudents = new List <FoundStudents>();

            objSchool.myDatabase.CreateConnection();
            objSchool.myDatabase.InitializeSQLCommandObject(objSchool.myDatabase.GetCurrentConnection, "select * from View_StudentGeneralInformation where school_id = '" + _school_id + "' and firstname like'" + studentfirstname + "%'");
            try
            {
                objSchool.myDatabase.OpenConnection();
                objSchool.myDatabase.obj_reader = objSchool.myDatabase.obj_sqlcommand.ExecuteReader();
                if (objSchool.myDatabase.obj_reader.HasRows)
                {
                    while (objSchool.myDatabase.obj_reader.Read())
                    {
                        FoundStudents student = new FoundStudents();
                        student.FirstName    = objSchool.myDatabase.obj_reader["firstname"].ToString();
                        student.LastName     = objSchool.myDatabase.obj_reader["lastname"].ToString();
                        student.Gender       = objSchool.myDatabase.obj_reader["Gender"].ToString();
                        student.photo        = objSchool.myDatabase.obj_reader["photo"].ToString();
                        student.PrimaryEmail = objSchool.myDatabase.obj_reader["primary_email"].ToString();
                        student.Address      = objSchool.myDatabase.obj_reader["address"].ToString();
                        student.SchoolID     = objSchool.myDatabase.obj_reader["school_id"].ToString();
                        student.AuthorizedID = objSchool.myDatabase.obj_reader["authorized_id"].ToString();
                        student.GeneralID    = objSchool.myDatabase.obj_reader["General_ID"].ToString();
                        student.Phone        = objSchool.myDatabase.obj_reader["phone"].ToString();
                        student.StudentID    = objSchool.myDatabase.obj_reader["Std_id"].ToString();
                        liststudents.Add(student);
                    }
                }
                else
                {
                    HttpContext.Current.Response.Write("No record found");
                }
            }
            catch { }
            finally
            {
                objSchool.myDatabase.CloseConnection();
                objSchool.myDatabase.obj_sqlcommand.Dispose();
            }
            HttpContext.Current.Response.Write(serializer.Serialize(liststudents));
        }
示例#2
0
        public void GetStudents(string _schoolID)
        {
            JavaScriptSerializer serializer  = new JavaScriptSerializer();
            List <FoundStudents> studentList = new List <FoundStudents>();

            objSchool.myDatabase.CreateConnection();
            objSchool.myDatabase.InitializeSQLCommandObject(objSchool.myDatabase.GetCurrentConnection, "select * from View_StudentGeneralInformation where school_id = '" + _schoolID + "'");
            try
            {
                objSchool.myDatabase.OpenConnection();
                objSchool.myDatabase.obj_reader = objSchool.myDatabase.obj_sqlcommand.ExecuteReader();
                if (objSchool.myDatabase.obj_reader.HasRows)
                {
                    while (objSchool.myDatabase.obj_reader.Read())
                    {
                        FoundStudents objstuStudents = new FoundStudents();
                        objstuStudents.StudentID = objSchool.myDatabase.obj_reader["Std_id"].ToString();
                        objstuStudents.FirstName = objSchool.myDatabase.obj_reader["firstname"].ToString();
                        objstuStudents.LastName  = objSchool.myDatabase.obj_reader["lastname"].ToString();
                        studentList.Add(objstuStudents);
                    }
                }
                else
                {
                    HttpContext.Current.Response.Write("No Record Found");
                }
            }
            catch (Exception exception)
            {
                HttpContext.Current.Response.Write(exception.ToString());
            }
            finally
            {
                objSchool.myDatabase.CloseConnection();
                objSchool.myDatabase.obj_reader.Dispose();
            }
            HttpContext.Current.Response.Write(serializer.Serialize(studentList));
        }