public function editbdo($id)
 {
     $pagetitle = 'Assign to other BDO';
     $bdo_list = Project::selectbdo_list();
     $bdo = DB::table('projects')->select(DB::raw('concat(users.first_name, " " ,users.last_name) as bdo_name, projects.id, projects.bdo_id'))->join('users', 'users.id', '=', 'projects.bdo_id')->where('projects.id', $id)->first();
     return View::make('projects.updatebdo', compact('pagetitle', 'bdo', 'bdo_list'));
 }