DBModel

public List<LmsDisposal> GetAllList()
        {
            var staf_pk = @LoginUser.GetLogin().STAF_FK;

            string get_apply_staf = @"SELECT
                                  D.ID,
                                  D.REF_NO,
                                  D.TKH_MOHON,
                                  D.PEMOHON_FK,
                                  D.PEMOHON_PTJ,
                                  D.STATUS_FK,
                                  D.STATUS_AKTIF,
                                  D.LAB_ID,
                                  D.C_ID,
                                  D.JENIS_MOHON,
                                  D.RADIS_REF_ID,
                                  D.KOS_LUPUS,
                                  A.STATUS_FK,
                                  S.STATUS_NAME
                                FROM
                                  LMS_DISPOSAL D
                                LEFT JOIN RMCDEV.RMC_APPROVAL_APP A ON A.APP_ID = D.REF_NO AND A.STATUS_AKTIF='Y'
                                LEFT JOIN RMCDEV.RMC_STATUS S ON S.STATUS_PK = A.STATUS_FK
                                WHERE
                                  D.STATUS_AKTIF = 'Y'
                                  AND D.PEMOHON_FK = '"+ staf_pk + "'"+
                                "ORDER BY D.REF_NO";

            DataTable dt = new DataTable();

            //dt = CF.getOracleDT(query);
            dt = RISCF.getOracleDT(get_apply_staf);

            List<LmsDisposal> DisposalList = new List<LmsDisposal>();
            int s = dt.Rows.Count;
            Int32 bil = 1;

            for (int i = 0; i < s; i++)
            {
                Int32 d0 = System.Convert.ToInt32(dt.Rows[i][0]);           //    ID LMS_DISPOSAL
                string d1 = System.Convert.ToString(dt.Rows[i][1]);         //    REF_NO DISPOSAL
                DateTime d2 = System.Convert.ToDateTime(dt.Rows[i][2]);     //    TKH_MOHON DISPOSAL
                string tkh = d2.ToShortDateString();
                Int32 d3 = System.Convert.ToInt32(dt.Rows[i][3]);           //    PEMOHON_FK - STAF_PK
                string d4 = System.Convert.ToString(dt.Rows[i][4]);         //    PEMOHON_PTJ
                int d5 = System.Convert.ToInt32(dt.Rows[i][5]);             //    STATUS_FK //DRAF OR SUBMIT
                string d6 = System.Convert.ToString(dt.Rows[i][6]);         //    STATUS_AKTIF
                int d13 = System.Convert.ToInt32(dt.Rows[i][8]);            //    C_ID
                int d14 = System.Convert.ToInt32(dt.Rows[i][9]);            //    JENIS_MOHON
                string d15 = System.Convert.ToString(dt.Rows[i][13]);        //    DISPOSAL APPROVAL - STATUS NAME (NULL IS DRAF)


                CARIAN_STAFF detail_pemohon = new CARIAN_STAFF(); //BAHAN BUANGAN / LUPUS
                user_access UserActionBtn = new user_access();
                //user user_detail = new user();
                List<LmsDisposalDetail> list_detail = new List<LmsDisposalDetail>(); //BAHAN BUANGAN / LUPUS
                List<LmsDisposalHazard> list_hazad = new List<LmsDisposalHazard>(); //KATEGORI HAZAD

                string d7 = "";                                             //STRING_NAMA_PEMOHON
                int d8 = 0;                                                 //BAHAN BUANGAN / LUPUS
                string d9 = "";                                             //KATEGORI HAZAD
                string d10 = "";                                            //KATEGORI SISA
                string d11 = "";                                            //STRING TYPE CATEGORY


                // STATUS DISPOSAL
                if (d15 == "")
                {
                    d15 = "DRAF";
                }

                // STATUS DISPOSAL
                bool access_delete = true;
                if (d5 >= 96)
                {
                    access_delete = false;
                }

                if (d3 > 0)    // GET NAMA PEMOHON
                {
                    detail_pemohon = GetNamaPemohon(d3);
                    d7 = detail_pemohon.NO_PEKERJA +" - "+detail_pemohon.NAMA;
                    d8 = detail_pemohon.NO_PEKERJA2;
                    UserActionBtn.DISPOSAL_ID = d0;
                    UserActionBtn.DISPOSAL_REF_NO = d1;
                    UserActionBtn.STATUS_NAME = d15;
                    if (d15 == "DRAF" || d15 == "RETURN")
                    {
                        UserActionBtn.CAN_UPDATE = true;
                    }

                }
                if (d0 > 0)    // GET DETAIL & SISA
                {
                    list_detail = GetDisposalDetailNSisa(d0);
                }

                if (d0 > 0)    // GET HAZARD
                {
                    string condition = " WHERE DD.DISPOSAL_ID ='" + d0 + "'";
                    list_hazad = GetDisposalHazard(condition);
                }

                DisposalList.Add(new LmsDisposal
                {
                    BIL = bil,
                    //LMS_DISPOSAL
                    ID = d0,
                    REF_NO = d1,
                    TKH_MOHON = d2,
                    PEMOHON_FK = d3,
                    PEMOHON_PTJ = d4,
                    STATUS_FK = d5,
                    STATUS_AKTIF = d6,
                    NAME = d7,
                    STRING_TKH_MOHON = tkh,
                    STRING_STATUS = d15,
                    BTN_ACTION = UserActionBtn,

                    //LMS_DISPOSAL_DETAIL
                    DISPO_DETAIL = list_detail,


                    //LMS_DISPOSAL_HAZARD
                    DISPO_HAZARD = list_hazad,


                });
                bil++;
            }

            return DisposalList;
        }