$Content = null;
            $EventsDetails = null;
            $ProgramsDetails = null;
            $CountChild = null;
            $Partner = null;
            $Advice = null;
            $LatestNews = DB::table('gh_latestnews')->where('LatestNewsID', $id)->first();
        } else {
            $EventsDetails = null;
            $ProgramsDetails = null;
            $Partner = null;
            $CountChild = null;
            $Advice = null;
            $LatestNews = null;

            $Content = DB::select('call sp_getContentFront(?,?,?,?,@CountChild)', array($LanguageID, $BranchID, $id, $ParentID));
            $CountChild = DB::select('select @CountChild as result ');
        }

        if (!empty($Content) || !empty($ProgramsDetails) || !empty($EventsDetails) || !empty($Partner) || !empty($Advice) || !empty($LatestNews)) {
            return view('front_end.pages.dynamic_page', compact('Content', 'EventsDetails', 'ProgramsDetails', 'Partner', 'CountChild', 'Advice', 'LatestNews'));
        } else {
            return redirect()->back()->with('error_code', 5);
        }
    }

    public function goto($branch, $isRedirectFromHome)
    {
        session(["se_branch" => $branch]);