Пример #1
0
        public DataTable absentTeachersWed()
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLReader = new readXML();

                query = XMLReader.readXMLtxt("absentTeachers", "~/DATA/XML/substituteXML.xml");
                query = query.Replace("@from", "17");
                query = query.Replace("@to", "24");
                query = query.Replace("@a", "21");
                query = query.Replace("@b", "24");
                query = query.Replace("@c", "17");
                query = query.Replace("@d", "20");


                dt = srv.Search(query);
            }
            catch (Exception e)
            {
                throw e;
            }
            return(dt);
        }
Пример #2
0
        public DataTable findTechrTTMon(substituteCLZ obj)
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLReader = new readXML();

                query = XMLReader.readXMLtxt("presentTchsTT", "~/DATA/XML/substituteXML.xml");
                query = query.Replace("@from", "1");
                query = query.Replace("@to", "8");
                query = query.Replace("@a", "1");
                query = query.Replace("@b", "4");
                query = query.Replace("@c", "5");
                query = query.Replace("@d", "8");
                query = query.Replace("@e", obj.present_teacher);

                dt = srv.Search(query);//return the techer_id,class_id,slot_id,subject_type_name,subject_code and leave_category_id
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }
Пример #3
0
        public DataTable findTechrTTFri(substituteCLZ obj)
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLReader = new readXML();
                //query = readXML("presentTchsTT");
                query = XMLReader.readXMLtxt("presentTchsTT", "~/DATA/XML/substituteXML.xml");
                query = query.Replace("@from", "33");
                query = query.Replace("@to", "40");
                query = query.Replace("@a", "33");
                query = query.Replace("@b", "36");
                query = query.Replace("@c", "37");
                query = query.Replace("@d", "40");
                query = query.Replace("@e", obj.present_teacher);
                dt    = srv.Search(query);
            }
            catch (Exception exc)
            {
                throw exc;
            }
            return(dt);
        }
Пример #4
0
        public DataTable distinctPresntFri()
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLReader = new readXML();

                query = XMLReader.readXMLtxt("distictpresentTchrs", "~/DATA/XML/substituteXML.xml");
                query = query.Replace("@from", "33");
                query = query.Replace("@to", "40");
                query = query.Replace("@a", "33");
                query = query.Replace("@b", "36");
                query = query.Replace("@c", "37");
                query = query.Replace("@d", "40");

                dt = srv.Search(query);
            }
            catch (Exception exc)
            {
                throw exc;
            }
            return(dt);
        }
Пример #5
0
        public DataTable distinctPresntMon()
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLReader = new readXML();

                query = XMLReader.readXMLtxt("distictpresentTchrs", "~/DATA/XML/substituteXML.xml");
                query = query.Replace("@from", "1");
                query = query.Replace("@to", "8");
                query = query.Replace("@a", "1");
                query = query.Replace("@b", "4");
                query = query.Replace("@c", "5");
                query = query.Replace("@d", "8");


                dt = srv.Search(query);//return the teacher_id of present teachers
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }
        // should be in leave app list
        public DataTable loadLeavesToVPrincipal()
        {
            srv       = new smss_web_service_app();
            XMLreader = new readXML();
            DataTable dt;
            string    query;

            try
            {
                query = XMLreader.readXMLtxt("loadRequestedLeavesToVPrincipal", "~/DATA/XML/LeaveXML.xml");
                dt    = srv.Search(query);
                return(dt);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        // should be in leave app list
        public DataTable loadTeacherLeaves(string teacherId)
        {
            srv       = new smss_web_service_app();
            XMLreader = new readXML();
            DataTable dt;
            string    query;

            try
            {
                query = XMLreader.readXMLtxt("loadTeacherRequestedLeaves", "~/DATA/XML/LeaveXML.xml");
                query = query.Replace("@teacherID", teacherId);

                dt = srv.Search(query);
                return(dt);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #8
0
        //handle dataflow between database for sending mails
        public DataTable loadReceiverMailAndPassword(userCLZ objUser)
        {
            string query = "";

            try
            {
                srv       = new smss_web_service_app();
                XMLreader = new readXML();
                query     = XMLreader.readXMLtxt("getReceiverMailAndPassword", "~/DATA/XML/homeXML.xml");

                query = query.Replace("@username", objUser.user_name);

                dt = srv.Search(query);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }