DB::table('vendor_managements')->where('vendor_code', $vendor_code)->update(array('state'=> $state_namne));