Beispiel #1
0
        public void Load(int ID)
        {
            HasData = false;
            OracleConnection.ClearAllPools();
            using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
            {
                con.Open();
                using (OracleCommand com = new OracleCommand("SELECT TB_PROJECT.*, (SELECT CATEGORY_NAME FROM TB_PROJECT_CATEGORY WHERE TB_PROJECT_CATEGORY.CATEGORY_ID = TB_PROJECT.CATEGORY_ID) CATEGORY_NAME FROM TB_PROJECT WHERE PRO_ID = " + ID, con))
                {
                    using (OracleDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            HasData = true;
                            int i = 1;
                            PRO_ID          = ID;
                            UOC_ID          = reader.GetInt32(i++);
                            CATEGORY_ID     = reader.GetInt32(i++);
                            PROJECT_NAME    = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            ADDRESS_PROJECT = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            if (reader.IsDBNull(i))
                            {
                                START_DATE = null;
                            }
                            else
                            {
                                START_DATE = reader.GetDateTime(i);
                            } ++i;
                            if (reader.IsDBNull(i))
                            {
                                END_DATE = null;
                            }
                            else
                            {
                                END_DATE = reader.GetDateTime(i);
                            } ++i;
                            EXPENSES           = reader.GetInt32(i++);
                            FUNDING            = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            CERTIFICATE        = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            SUMMARIZE_PROJECT  = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            RESULT_TEACHING    = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            RESULT_ACADEMIC    = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            DIFFICULTY_PROJECT = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            RESULT_PROJECT     = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            RESULT_RESEARCHING = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            RESULT_OTHER       = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            COUNSEL            = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            IMG_FILE           = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                            COUNTRY_ID         = reader.GetInt32(i++);
                            SUB_COUNTRY_ID     = reader.GetInt32(i++);
                            category_name      = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
                        }
                    }
                }

                uoc_staff = DatabaseManager.GetOUC_STAFF(uoc_id);
            }
        }
Beispiel #2
0
        public static List <UOC_STAFF> รหัสหัวหน้า(string citizenID)
        {
            List <UOC_STAFF> bossList = new List <UOC_STAFF>();

            OracleConnection.ClearAllPools();
            using (OracleConnection con = new OracleConnection(CONNECTION_STRING))
            {
                con.Open();
                int  workPositionID     = -1;
                int  adminPositionPower = 0;
                int  facultyID          = 0;
                int  divisionID         = 0;
                int  workDivisionID     = 0;
                int  adminPositionID    = 0;
                int  campusID           = 0;
                bool no_me  = false;
                bool cancel = false;
                using (OracleCommand com = new OracleCommand("SELECT PS_WORK_POS_ID, PS_FACULTY_ID, PS_DIVISION_ID, PS_WORK_DIVISION_ID, PS_ADMIN_POS_ID, PS_CAMPUS_ID FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + citizenID + "'", con))
                {
                    using (OracleDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            workPositionID = reader.GetInt32(0);
                            facultyID      = reader.GetInt32(1);
                            divisionID     = reader.GetInt32(2);

                            if (reader.IsDBNull(3))
                            {
                                workDivisionID = -1;
                            }
                            else
                            {
                                workDivisionID = reader.GetInt32(3);
                            }
                            adminPositionID = reader.GetInt32(4);
                            campusID        = reader.GetInt32(5);
                        }
                    }
                }
                using (OracleCommand com = new OracleCommand("SELECT ADMIN_POSITION_POWER FROM PS_PERSON, TB_ADMIN_POSITION WHERE PS_CITIZEN_ID = '" + citizenID + "' AND PS_ADMIN_POS_ID = ADMIN_POSITION_ID", con))
                {
                    using (OracleDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            adminPositionPower = reader.GetInt32(0);
                        }
                    }
                }
                int bossNodeType   = -1;
                int bossNodeTypeID = -1;
                if ((workPositionID == 10108 || workPositionID == 10077) && (adminPositionPower >= 3 || adminPositionPower == 0))
                { //อาจารย์
                    if (adminPositionPower == 0)
                    {
                        bossNodeType   = 3;
                        bossNodeTypeID = divisionID;
                    }
                    else if (adminPositionPower == 3)
                    {
                        bossNodeType   = 3;
                        bossNodeTypeID = divisionID;
                        no_me          = true;
                    }
                }
                else
                {
                    if (adminPositionPower == 2 && adminPositionID != 4)
                    {
                        bossNodeType   = 2;
                        bossNodeTypeID = facultyID;
                    }
                    else if (adminPositionID == 4)
                    { //คณบดี
                        bossNodeType   = 1;
                        bossNodeTypeID = campusID;
                    }
                    else if (adminPositionID == 2)
                    { //รองอธิการ
                        bossNodeType   = -1;
                        bossNodeTypeID = -1;
                    }
                    else if (adminPositionID == 1)
                    { //อธิการ
                        cancel = true;
                    }
                }
                if (cancel)
                {
                    return(null);
                }

                int?nextNodeID = null;
                while (true)
                {
                    string sql = "SELECT * FROM TB_BOSS_NODE WHERE BOSS_NODE_TYPE = " + bossNodeType + " AND BOSS_NODE_TYPE_ID = '" + bossNodeTypeID + "'";
                    if (bossNodeType == -1)
                    {
                        sql = "SELECT * FROM TB_BOSS_NODE WHERE BOSS_NODE_ID = 1";
                    }
                    if (nextNodeID != null)
                    {
                        sql = "SELECT * FROM TB_BOSS_NODE WHERE BOSS_NODE_ID = " + nextNodeID;
                    }
                    using (OracleCommand com = new OracleCommand(sql, con))
                    {
                        using (OracleDataReader reader = com.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                if (reader.IsDBNull(3))
                                {
                                    nextNodeID = null;
                                }
                                else
                                {
                                    nextNodeID = reader.GetInt32(3);
                                }

                                string    bossID = reader.GetString(6);
                                UOC_STAFF p      = GetOUC_STAFF(bossID);
                                if (no_me)
                                {
                                    no_me = false;
                                }
                                else
                                {
                                    bossList.Add(p);
                                }
                            }
                        }
                    }
                    if (nextNodeID == null)
                    {
                        break;
                    }
                }
            }
            return(bossList);
        }
Beispiel #3
0
        public static UOC_STAFF GetOUC_STAFF(string CITIZEN_ID)
        {
            OracleConnection.ClearAllPools();

            using (OracleConnection con = new OracleConnection(CONNECTION_STRING))
            {
                con.Open();
                using (OracleCommand com = new OracleCommand(

                           "SELECT UOC_ID," +
                           "CITIZEN_ID," +
                           "(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME," +
                           "STF_FNAME," +
                           "STF_LNAME," +
                           "(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME," +
                           "POSITION_WORK," +
                           "(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME," +
                           "(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME," +
                           "ST_LOGIN_ID," +
                           "PERSON_ROLE_ID" +
                           " FROM UOC_STAFF WHERE CITIZEN_ID = '" + CITIZEN_ID + "'", con))

                /*using (OracleCommand com = new OracleCommand(
                 *
                 * "SELECT UOC_ID," +
                 * "CITIZEN_ID," +
                 * "YEAR," +
                 * "UNIV_ID," +
                 * "(SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME," +
                 * "PREFIX_NAME," +
                 * "(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME," +
                 * "STF_FNAME," +
                 * "STF_LNAME," +
                 * "GENDER_ID," +
                 * "(SELECT GENDER_NAME FROM REF_GENDER WHERE REF_GENDER.GENDER_ID = UOC_STAFF.GENDER_ID) GENDER_NAME," +
                 * "BIRTHDAY," +
                 * "HOMEADD," +
                 * "MOO," +
                 * "STREET," +
                 * "SUB_DISTRICT_ID," +
                 * "(SELECT SUB_DISTRICT_NAME_TH FROM REF_SUB_DISTRICT WHERE REF_SUB_DISTRICT.SUB_DISTRICT_ID = UOC_STAFF.SUB_DISTRICT_ID) SUB_DISTRICT_NAME," +
                 * "DISTRICT_ID," +
                 * "(SELECT DISTRICT_NAME_TH FROM REF_DISTRICT WHERE REF_DISTRICT.DISTRICT_ID = UOC_STAFF.DISTRICT_ID) DISTRICT_NAME," +
                 * "PROVINCE_ID," +
                 * "(SELECT PROVINCE_NAME_TH FROM REF_PROVINCE WHERE REF_PROVINCE.PROVINCE_ID = UOC_STAFF.PROVINCE_ID) PROVINCE_NAME," +
                 * "TELEPHONE," +
                 * "ZIPCODE," +
                 * "NATION_ID," +
                 * "(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.NATION_ID) NATION_NAME," +
                 * "STAFFTYPE_ID," +
                 * "(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME," +
                 * "TIME_CONTACT_ID," +
                 * "(SELECT TIME_CONTACT_NAME FROM REF_TIME_CONTACT WHERE REF_TIME_CONTACT.TIME_CONTACT_ID = UOC_STAFF.TIME_CONTACT_ID) TIME_CONTACT_NAME," +
                 * "BUDGET_ID," +
                 * "(SELECT BUDGET_NAME FROM REF_BUDGET WHERE REF_BUDGET.BUDGET_ID = UOC_STAFF.BUDGET_ID) BUDGET_NAME," +
                 * "SUBSTAFFTYPE_ID," +
                 * "(SELECT SUBSTAFFTYPE_NAME FROM REF_SUBSTAFFTYPE WHERE REF_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = UOC_STAFF.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME," +
                 * "ADMIN_POSITION_ID," +
                 * "(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME," +
                 * "POSITION_ID," +
                 * "(SELECT POSITION_NAME_TH FROM REF_POSITION WHERE REF_POSITION.POSITION_ID = UOC_STAFF.POSITION_ID) POSITION_NAME," +
                 * "POSITION_WORK," +
                 * "DEPARTMENT_ID," +
                 * "(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME," +
                 * "DATE_INWORK," +
                 * "DATE_START_THIS_U," +
                 * "SPECIAL_NAME," +
                 * "TEACH_ISCED_ID," +
                 * "(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.TEACH_ISCED_ID) TEACH_ISCED_NAME," +
                 * "GRAD_LEV_ID," +
                 * "(SELECT LEV_NAME_TH FROM REF_LEV WHERE REF_LEV.LEV_ID = UOC_STAFF.GRAD_LEV_ID) GRAD_LEV_NAME," +
                 * "GRAD_CURR," +
                 * "GRAD_ISCED_ID," +
                 * "(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.GRAD_ISCED_ID) GRAD_ISCED_NAME," +
                 * "(SELECT PROGRAM_NAME FROM REF_PROGRAM WHERE REF_PROGRAM.PROGRAM_ID_NEW = UOC_STAFF.GRAD_PROG) GRAD_PROG," +
                 * "GRAD_UNIV," +
                 * "GRAD_COUNTRY_ID," +
                 * "(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME," +
                 * "DEFORM_ID," +
                 * "(SELECT DEFORM_NAME FROM REF_DEFORM WHERE REF_DEFORM.DEFORM_ID = UOC_STAFF.DEFORM_ID) DEFORM_NAME," +
                 * "SIT_NO," +
                 * "SALARY," +
                 * "POSITION_SALARY," +
                 * "RELIGION_ID," +
                 * "(SELECT RELIGION_NAME_TH FROM REF_RELIGION WHERE REF_RELIGION.RELIGION_ID = UOC_STAFF.RELIGION_ID) RELIGION_NAME_TH," +
                 * "MOVEMENT_TYPE_ID," +
                 * "(SELECT MOVEMENT_TYPE_NAME FROM REF_MOVEMENT_TYPE WHERE REF_MOVEMENT_TYPE.MOVEMENT_TYPE_ID = UOC_STAFF.MOVEMENT_TYPE_ID) MOVEMENT_TYPE_NAME," +
                 * "MOVEMENT_DATE," +
                 * "DECORATION," +
                 * "RESULT1," +
                 * "PERCENT_SALARY1," +
                 * "RESULT2," +
                 * "PERCENT_SALARY2," +
                 * "PASSWORD," +
                 * "ST_LOGIN_ID," +
                 * "(SELECT ST_LOGIN_NAME FROM TB_STATUS_LOGIN WHERE TB_STATUS_LOGIN.ST_LOGIN_ID = UOC_STAFF.ST_LOGIN_ID) ST_LOGIN_NAME," +
                 * "PERSON_ROLE_ID," +
                 * "(SELECT PERSON_ROLE_NAME FROM TB_PERSON_ROLE WHERE TB_PERSON_ROLE.PERSON_ROLE_ID = UOC_STAFF.PERSON_ROLE_ID) PERSON_ROLE_NAME," +
                 * "FATHER_NAME," +
                 * "FATHER_LNAME," +
                 * "MOTHER_NAME," +
                 * "MOTHER_LNAME," +
                 * "MOTHER_ONAME," +
                 * "COUPLE_NAME," +
                 * "COUPLE_LNAME," +
                 * "COUPLE_ONAME" +
                 * " FROM UOC_STAFF WHERE CITIZEN_ID = '" + CITIZEN_ID + "'", con))*/
                {
                    using (OracleDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            UOC_STAFF uoc_staff = new UOC_STAFF();
                            int       i         = 0;

                            uoc_staff.UOC_ID              = Convert.ToInt32(reader.GetValue(i++).ToString());
                            uoc_staff.CITIZEN_ID          = reader.GetValue(i++).ToString();
                            uoc_staff.PREFIX_NAME         = reader.GetValue(i++).ToString();
                            uoc_staff.STF_FNAME           = reader.GetValue(i++).ToString();
                            uoc_staff.STF_LNAME           = reader.GetValue(i++).ToString();
                            uoc_staff.STAFFTYPE_NAME      = reader.GetValue(i++).ToString();
                            uoc_staff.POSITION_NAME       = reader.GetValue(i++).ToString();
                            uoc_staff.ADMIN_POSITION_NAME = reader.GetValue(i++).ToString();
                            uoc_staff.DEPARTMENT_NAME     = reader.GetValue(i++).ToString();
                            uoc_staff.ST_LOGIN_ID         = reader.GetInt32(i++);
                            uoc_staff.PERSON_ROLE_ID      = reader.GetInt32(i++);

                            /* UOC_STAFF uoc_staff = new UOC_STAFF();
                             * int i = 0;
                             * uoc_staff.UOC_ID = Convert.ToInt32(reader.GetValue(i++).ToString());
                             * uoc_staff.CITIZEN_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.YEAR = reader.GetValue(i++).ToString();
                             * uoc_staff.UNIV_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.UNIV_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.PREFIX_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.PREFIX_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.STF_FNAME = reader.GetValue(i++).ToString();
                             * uoc_staff.STF_LNAME = reader.GetValue(i++).ToString();
                             * uoc_staff.GENDER_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.GENDER_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.BIRTHDAY = reader.IsDBNull(i++) ? "" : reader.GetValue(i++).ToString();
                             * uoc_staff.HOMEADD = reader.GetValue(i++).ToString();
                             * uoc_staff.MOO = reader.GetValue(i++).ToString();
                             * uoc_staff.STREET = reader.GetValue(i++).ToString();
                             * uoc_staff.SUB_DISTRICT_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.SUB_DISTRICT_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.DISTRICT_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.DISTRICT_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.PROVINCE_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.PROVINCE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.TELEPHONE = reader.GetValue(i++).ToString();
                             * uoc_staff.ZIPCODE = reader.GetValue(i++).ToString();
                             * uoc_staff.NATION_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.NATION_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.STAFFTYPE_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.STAFFTYPE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.TIME_CONTACT_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.TIME_CONTACT_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.BUDGET_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.BUDGET_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.SUBSTAFFTYPE_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.SUBSTAFFTYPE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.ADMIN_POSITION_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.ADMIN_POSITION_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.POSITION_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.POSITION_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.POSITION_WORK = reader.GetValue(i++).ToString();
                             * uoc_staff.DEPARTMENT_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.DEPARTMENT_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.DATE_INWORK = reader.IsDBNull(i++) ? "" : reader.GetValue(i++).ToString();
                             * uoc_staff.DATE_START_THIS_U = reader.IsDBNull(i++) ? "" : reader.GetValue(i++).ToString();
                             * uoc_staff.SPECIAL_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.TEACH_ISCED_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.TEACH_ISCED_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_LEV_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_LEV_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_CURR = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_ISCED_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_ISCED_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_PROG = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_UNIV = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_COUNTRY_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.GRAD_COUNTRY_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.DEFORM_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.DEFORM_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.SIT_NO = reader.GetValue(i++).ToString();
                             * uoc_staff.SALARY = reader.GetValue(i++).ToString();
                             * uoc_staff.POSITION_SALARY = reader.GetValue(i++).ToString();
                             * uoc_staff.RELIGION_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.RELIGION_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.MOVEMENT_TYPE_ID = reader.GetValue(i++).ToString();
                             * uoc_staff.MOVEMENT_TYPE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.MOVEMENT_DATE = reader.GetValue(i++).ToString();
                             * uoc_staff.DECORATION = reader.GetValue(i++).ToString();
                             * uoc_staff.RESULT1 = reader.GetValue(i++).ToString();
                             * uoc_staff.PERCENT_SALARY1 = reader.GetValue(i++).ToString();
                             * uoc_staff.RESULT2 = reader.GetValue(i++).ToString();
                             * uoc_staff.PERCENT_SALARY2 = reader.GetValue(i++).ToString();
                             * uoc_staff.PASSWORD = reader.GetValue(i++).ToString();
                             * uoc_staff.ST_LOGIN_ID = reader.GetInt32(i++);
                             * uoc_staff.ST_LOGIN_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.PERSON_ROLE_ID = reader.GetInt32(i++);
                             * uoc_staff.PERSON_ROLE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.FATHER_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.FATHER_LNAME = reader.GetValue(i++).ToString();
                             * uoc_staff.MOTHER_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.MOTHER_LNAME = reader.GetValue(i++).ToString();
                             * uoc_staff.MOTHER_ONAME = reader.GetValue(i++).ToString();
                             * uoc_staff.COUPLE_NAME = reader.GetValue(i++).ToString();
                             * uoc_staff.COUPLE_LNAME = reader.GetValue(i++).ToString();
                             * uoc_staff.COUPLE_ONAME = reader.GetValue(i++).ToString();
                             */
                            return(uoc_staff);
                        }
                    }
                }
            }
            return(null);
        }