public static DataTable getCPARRequestFrom(string CACIId, string CAStage)
        {
            IQISSDBManager dbManager = new QISSDBManager();
            DataTable      dt        = new DataTable();

            try
            {
                dbManager.Open();
                IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 2);
                param[0] = dbManager.getparam("@CACIId", CACIId.ToString());
                param[1] = dbManager.getparam("@CAStage", CAStage.ToString());

                IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARInfo_getCPARRequestFrom", param);
                dt = dbManager.GetDataTable(cmd);

                return(dt);
            }
            catch (Exception ex)
            {
                return(dt);
            }
            finally
            {
                dt.Dispose();
                dbManager.Dispose();
            }
        }
        public static DataTable getAssignedWorkInformation(string CIId)
        {
            IQISSDBManager dbManager = new QISSDBManager();
            DataTable      dt        = new DataTable();

            try
            {
                dbManager.Open();
                IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 1);
                param[0] = dbManager.getparam("@CIId", CIId.ToString());

                IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARAction_get_AssignedWork", param);
                dt = dbManager.GetDataTable(cmd);

                return(dt);
            }
            catch (Exception ex)
            {
                return(dt);
            }
            finally
            {
                dt.Dispose();
                dbManager.Dispose();
            }
        }
        } //---END ADD---

        public static DataTable getAppReqCompStepCPAR(string CAAssignedTo, string CIBranchId, clsBOLGetAllCPARInformation obj)
        {
            IQISSDBManager dbManager = new QISSDBManager();
            DataTable      dt        = new DataTable();

            try
            {
                dbManager.Open();
                IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 6);
                param[0] = dbManager.getparam("@CAAssignedTo", CAAssignedTo.ToString());
                param[1] = dbManager.getparam("@CIBranchId", CIBranchId.ToString());
                param[2] = dbManager.getparam("@CICPARNo", obj.CICPARNo);
                param[3] = dbManager.getparam("@CIInitiator", obj.CIInitiator);
                param[4] = dbManager.getparam("@CIInitiateDate_start", obj.CIInitiateDate_start);
                param[5] = dbManager.getparam("@CIInitiateDate_end", obj.CIInitiateDate_end);

                IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARAction_APPRequest_CompStep", param);

                dt = dbManager.GetDataTable(cmd);
                return(dt);
            }
            catch (Exception ex)
            {
                return(dt);
            }
            finally
            {
                dbManager.Dispose();
                dt.Dispose();
            }
        }